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

 

 

Environment

Release : 12.1

Component : CA OUTPUT MANAGEMENT WEB VIEWER FOR ALL PLATFORMS

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.

 

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.