PBCM user is unable to use GUI

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:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Netcool Configuration Manager

Software version:

6.3.0

Operating system(s):

Linux, Solaris

Software edition:

All Editions

Reference #:

1615237

Modified date:

2012-11-14

Translate my page

Machine Translation

Content navigation