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

[Edxavier Robert]

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. 

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 Active Group Members or Group Members. That's basic the issue, because those fields are empty I am getting the error message. 

 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.  

[Sudhanshu Talw1]

If this is the case, I suggest you to use flow designer to run once & it will resolve you problem. Trigger:schedulea based

Step 1: look up group records to be updated S

2: for each group

2.1 lookup group member records in the sysuser_grp table on the basis of group name

2.2 for each member 2.3 perform operation which you want//make them active or anything.

But I will suggest you a simple idea what I HAVE IMPLEMENETED THAT I have also implemented this what I did I add the manager of the group as group member. As a manager , he should be an active member that will not arise these kind of scenario if there are no active members in the group.at least he will be there as an active member & your catalog will not display this kind of message.

Mark it heplful/correct.

Thanks

Sudhanshu

[Edxavier Robert]

Hi @Sudhanshu Talwar , 

But that would automatically update the count every time a group member is added or removed?  

As I mention in PROD is working fine, but not sure why in DEV or QA not.

[Sudhanshu Talw1]

Hi @Edxavier Roberto 

then simply write a script lookup all records from sysuser_grp table & check the status of each member whether it is actually active/inactive & get your count.

Thanks

Sudhanshu

[Edxavier Robert · Accepted solution]

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