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

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(com.ca.erm.webviewer.entity.User@7ba41)
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

Output Management Web Viewer 12.1

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.

Additional Information

CR24-NL