2902136 - Unique constraint PK_CLIENT_METRICS_1_1 violated after application database restoration

After restoring a system from a backup, users get an exception on trying to access the application.

Exception Jar Message & SystemErr.log File Output:

Root Message: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (<SCHEMA_PREFIX>_PPMS.PK_CLIENT_METRICS_1_1) violated

com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (<SCHEMA_PREFIX>_PPMS.PK_CLIENT_METRICS_1_1) violated

Message: Could not insert

ibClosed = false
ClientMetricsId = 0
CurrentJobTitle = null
CurrentJobTitleId = 0
CurrentRole = null
CurrentRoleId = null
ClientScreenId = null
CompanyId = null
MachineId = null
ConnectStart = **********
ConnectEnd = null
CurrentSessionTime = null
ClientSessionStateId = null
ClientName = **********
WebServerName = **********
AppServerName = null
ConnectAs = User
LastAccessTime = null
AuthenticationMessage =
AdminAuthenticated = false
Authenticated = true
CsbHandle = com.ibm.ws.ejb.portable.HandleImpl@11ad11ad
HttpSession = **********
ibLogEnabled = false
DIALOG = authenticate
USERLOGIN = **********
LOGINTYPE = User
APPNAME = LCM
Y = 0
X = 0
PASSWORD = ********** UserInfoImpl( com.camilion.userdirectory.UserInfoImpl@24af24afisLoginName = **********,ioUserData = UserDataImpl{isTitle='', isFirstName='**********', isLastName='**********', isJobTitle='**********', isAddress='null', isDepartment='null', isDivision='', isEmail='', isManagerLoginId='uid=**********,ou=people,dc=cna,dc=com', isManagerName='', isPasswordExpired=false, isResetPassword=false, isErrorMessage='null', isUserLoginId='**********'},ioSessionProperties = {},MachineId = null,igCompanyId= null,ConnectStart = null,ConnectEnd = null,ioLastAccessedTime = **********,isCookie = null,ibLogEnabled = false,ibClosed = true,igUserId = **********,isSchemeID = **********,isHomePageObjectId = ,isClientPageObjectId = **********,profile = ,)

Could not create client metrics information

Java Stack Trace

UserMessage: Could not insert

Could not create client metrics information

440 oracle.jdbc.driver.T4CTTIoer processError T4CTTIoer.java
396 oracle.jdbc.driver.T4CTTIoer processError T4CTTIoer.java
837 oracle.jdbc.driver.T4C8Oall processError T4C8Oall.java
445 oracle.jdbc.driver.T4CTTIfun receive T4CTTIfun.java
191 oracle.jdbc.driver.T4CTTIfun doRPC T4CTTIfun.java
523 oracle.jdbc.driver.T4C8Oall doOALL T4C8Oall.java
207 oracle.jdbc.driver.T4CPreparedStatement doOall8 T4CPreparedStatement.java
1010 oracle.jdbc.driver.T4CPreparedStatement executeForRows T4CPreparedStatement.java
1315 oracle.jdbc.driver.OracleStatement doExecuteWithTimeout OracleStatement.java
3576 oracle.jdbc.driver.OraclePreparedStatement executeInternal OraclePreparedStatement.java
3657 oracle.jdbc.driver.OraclePreparedStatement executeUpdate OraclePreparedStatement.java


SystemErr.log File Excerpt:

SystemErr R com.ibm.websphere.ce.cm.DuplicateKeyException: ORA-00001: unique constraint (<SCHEMA_PREFIX>_PPMS.PK_CLIENT_METRICS_1_1) violated
SystemErr R
SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
SystemErr R at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:56)
SystemErr R at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:39)
SystemErr R at java.lang.reflect.Constructor.newInstance(Constructor.java:527)
SystemErr R at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapExceptionHelper(GenericDataStoreHelper.java:620)
SystemErr R at com.ibm.websphere.rsadapter.GenericDataStoreHelper.mapException(GenericDataStoreHelper.java:682)
SystemErr R at com.ibm.ws.rsadapter.AdapterUtil.mapException(AdapterUtil.java:2112)
SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcUtil.mapException(WSJdbcUtil.java:1047)
SystemErr R at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:808)
SystemErr R at com.camilion.userclient.clientsession.ClientSessionState.insert(ClientSessionState.java:872)
SystemErr R at com.camilion.servlet.SessionBindingListener.valueBound(SessionBindingListener.java:51)

Read more...

• ProductAuthority AuthoritySuite
• ProductAuthority Designer
• ProductAuthority Lifecycle Manager
• ProductAuthority Product Configurator
• ProductAuthority Product Explorer
• SAP Product Lifecycle Management for Insurance
• SAP Product and Quotation Management for Insurance

SAP Product Lifecycle Management for Insurance 7.0 ; SAP Product Lifecycle Management for Insurance 7.1 ; SAP Product Lifecycle Management for Insurance 7.2 ; SAP Product Lifecycle Management for Insurance 7.3 ; SAP Product and Quotation Management for Insurance 2.0 ; SAP Product and Quotation Management for Insurance 3.0 ; SAP Product and Quotation Management for Insurance 4.0

FS-PRO, FS-QUO, PA, ProductAuthority, LCM, PE, AS, PC, Product Catalog , KBA , FS-PRO , Product Management Insurance , FS-QUO , Quotation Management Insurance , Problem