PBCM Security table has no entries causing user to display no application data
No PBCM user was able to display Realms or other data in the GUI.
Caused by a duplicate active user created on R-Series USERS table. the
duplicate records are both active on type field. Removing one of the 2
duplicate 'active' users corrected this issue.
Diagnosing the problem
The script refreshSecurityTables.sh failed to update the PBCM security
table, which is used to check user access to the Realms in PBCM. This
table was empty so no users were allowed to do anything.
java.sql.SQLException: ORA-00001: unique constraint
********* Constraint is unique UserID ****************************
Resolving the problem
Find duplicate user in the R-Series application and delete -- Look for identical UserID and Type = active. Once found then delete all duplicates except 1. Only 1 UserID per Type=Active
After removing duplicate entries the rerun refreshSecurityTables.sh to populate the Security table.