Symptom
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...
Environment
- 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
Product
Keywords
FS-PRO, FS-QUO, PA, ProductAuthority, LCM, PE, AS, PC, Product Catalog , KBA , FS-PRO , Product Management Insurance , FS-QUO , Quotation Management Insurance , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.