In Table sys_user_group.list the field for Active Group Member and Active Member are empty ( group member count not updated)

Edxavier Robert
Mega Sage

Hi Community, 

I hope you can give me directions on this. My issue is on my DEV and QA environment, when were having issues creating access request thru the service catalog. The error message says that we can't submit  the access request because the group is empty. 

find_real_file.png

We have this issue with multiple groups ( its a long list). In all of this groups are members on it, but we found that those groups did not have a count in the find_real_file.png

 My question would be, how I can get those field updated automatically ( Active Group Members or Group Members) with count of the Group Members. The weird thing is that our PROD Instance is fine, it just DEV and QA. 
 
I verify the LDAP connection and its ok. 
I check if there's any Business Rule, but  I couldn't find any
I compare side by side PROD with DEV and QA and I couldn't find differences. 
 
Table: sys_user_group.list
I want the Total number of active members to match the actual number of members assigned to a group but its not calculating.
 
Any advice would be appreciate.  
1 ACCEPTED SOLUTION

Edxavier Robert
Mega Sage

I was able to resolved by creating a scheduled job to update the field. 

View solution in original post

5 REPLIES 5

manoj kumar
Kilo Explorer

I have a question on the assignment group in which while I am typing network or database it's showing invalid reference may I know why?