Fields that Reference is Search or Table or TableDirect are displayed blank or <Number of ID> sometimes

Description

Hi, All.
I am Hideaki Hagiwara in Japan.

Sometimes fields of Search or Table or TableDirect are displayed blank or <Number of ID> .

I think that cache management of MLookupFactory is need to improve.

Reproduce(For Example):

Role "ABC" can access Org "ABC" only.
Role "XYZ" can access Org "XYZ" only

User "Hideaki" have the two roles(Role "ABC" and Role "XYZ").

Step1:Initially User "Hideaki" login with Role "ABC". and open Sales Order Window. no problem.
Step2:Next "Hideaki" Change Role to "XYZ". and open Sales Order Window again. Then, some Fields are displayed number of <ID> or blank.
Please see attachment Image Step2-Problem.png.

This problem can recover when execute cache reset process
I think this problem is caused by cache management of MLookupFactory.

In IDEMPIERE-2672,AD_User_ID was added as one of the cache(s_cacheRefTable) key at MLookupFactory.
I think We may need to add AD_Role_ID as one of the cache key too.

But, I am afraid of to become big cache when many user access at same time.
It is difficult for me to judge what improvement is correct.

I made patch that was add AD_Role_ID as one of the cache key.
I am happy if you consider with me this problem.

Related (I think):IDEMPIERE-2672,

Environment

None

Assignee

萩原秀明

Reporter

萩原秀明

Labels

Tested By

None

Components

Affects versions

Priority

Major
Configure