Technote (troubleshooting)
Problem(Abstract)
PBCM Security table has no entries causing user to display no application data
Symptom
No PBCM user was able to display Realms or other data in the GUI.
Cause
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.
=====================================
icosuser@server$ /opt/pbcm/bin/utils/refreshSecurityTables.sh
> /opt/pbcm/logs/securitySync.log
java.sql.SQLException: ORA-00001: unique constraint
(PBCMUSER.SYS_C008343) violated
********* Constraint is unique UserID ****************************
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:12
5)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
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.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.