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.
Major
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,