My Oracle Support Banner

RefreshGroupSpaceCache On Portal Roles > 100 Users Returns NPEs And Does Not Sync Webcenter Schema/WCP GUI (Doc ID 2773724.1)

Last updated on JULY 24, 2023

Applies to:

Oracle WebCenter Portal - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

When trying to refreshGroupSpaceCache() on some Portal Role that has over 100 users, users will disappear from the WCP GUI/WebCenter DB schema the moment they add another user with the same role and call the refreshGroupSpaceCache(). When they reduce role-user back to 100 and execute refreshGroupSpaceCache(), the WCP GUI/WebCenter DB schema see 100 users and things look "OK".

Every time refreshGroupSpaceCache() is executed with more than 100 users in a portal role, there is an NPE in the WCP Diagnostic Log:

[WC_Spaces] [WARNING] [] [oracle.webcenter.spaces.internal.repository.SpaceRepositoryUtils] [tid: [ACTIVE].ExecuteThread: '22' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: <USERID>] [ecid: <ECID>,0] [APP: webcenter] [partition-name: DOMAIN] [tenant-name: GLOBAL] Failed to refresh identities for group space:<PORTAL_NAME> due to error = java.lang.NullPointerException

 

Steps to replicate the issue:


1. Create 100+ users for testing in AN external LDAP like OID.

2. Create a portal and make 100 users (as participant) as the members of this newly created portal.

3. Execute the sql command:

select s.SPACE_GUID,
   decode(is_group,'N','User','Group') Member_Type,
   u.USER_ID GROUP_USER_NAME,
   u.space_role ROLE
from dev_webcenter.WC_SPACE_HEADER s, dev_webcenter.WC_SPACE_USR_DETAIL u
where s.space_guid = 's1936cfc8_6d6e_48d3_a07c_9e20a1b0f684'
and u.SPACE_ID = s.SPACE_ID
order by Member_Type, USER_ID;

It shows all the users including newly added users.

4. Refresh the cache using the below command:

refreshGroupSpaceCache(appName='webcenter', server= 'WC_Portal',spaceNames='<PORTAL_NAME>',syncMode=1,updateType='all', cleanCache=0)

Able to see all 100 users.

5. Execute the below OPSS wlst command to cross verify the users:

listAppRoleMembers(appStripe="webcenter",appRoleName= "s1936cfc8_6d6e_48d3_a07c_9e20a1b0f684#-#Participant")

It shows all the users.

6. Add another user to the newly created portal and assign participant role to the user.

7. Able to see all the 101 users in Portal UI excluding moderator in the roles page.

8. Restart the portal server and it shows all the users in roles and Portal members list.

9. Refresh the cache again using the below command:

10.refreshGroupSpaceCache(appName='webcenter', server= 'WC_Portal',spaceNames='<PORTAL_NAME>',syncMode=1,updateType='all', cleanCache=0)

It shows only one user in the Portal (Moderator and participant users are not shown).

11. Query the Portal table using the below query and able to see only one user (Moderator):

select s.SPACE_GUID,
   decode(is_group,'N','User','Group') Member_Type,
   u.USER_ID GROUP_USER_NAME,
   u.space_role ROLE
from dev_webcenter.WC_SPACE_HEADER s, dev_webcenter.WC_SPACE_USR_DETAIL u
where s.space_guid = 's1936cfc8_6d6e_48d3_a07c_9e20a1b0f684'
and u.SPACE_ID = s.SPACE_ID
order by Member_Type, USER_ID;

12. At the same time, users are able to login to Portal which are already added as participants.


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.