Database errors SQLCODE=-803, SQLSTATE=23505 12.1 Web Viewer

Products

• Output Management Web Viewer

Issue/Introduction

Getting database errors in production.

Call: INSERT INTO userobj (UKEY, LNAME, TITLE, DESCIPTION, USERID, OWNERROLEID, FNAME, OWNERRPATH) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
 bind => [506433, , , , g4yw7, 3, , 3.]
Query: InsertObjectQuery([email protected])
javax.persistence.RollbackException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.1.1.v20100817-r8050): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: com.ibm.db2.jcc.am.SqlIntegrityConstraintViolationException: DB2 SQL Error: SQLCODE=-803, SQLSTATE=23505, SQLERRMC=IXRU1HQQ;0000001E1E, DRIVER=4.22.29
Error Code: -803

 

 

Cause

The database is corrupted. This might have occurred when the FIRST user to logon to Web Viewer  was NOT the ADMIN defined in wvprofile. properties.

 

Environment

Release : 12.1

Component : CA OUTPUT MANAGEMENT WEB VIEWER FOR ALL PLATFORMS

Resolution

Errors occur when trying to add a user to the database and the user is already there.  Role is missing.

Contact Broadcom support for assistance.