dead lock in CPE

 6C7A764B ASYN FNRCE0019E - ERROR Failed updating next retry date {5827F21B-B08B-4205-99FB-D607333DA467}

com.filenet.api.exception.EngineRuntimeException: FNRCE0019E: E_DEADLOCK_ERROR: The operation could not be completed due to a deadlock error. A retry might be appropriate. ObjectStore: "OS1", SQL: ""UPDATE dbo.QueueItem SET epoch_id = epoch_id + 1, modify_date = ?, next_retry_date = GetUTCDate() + DateAdd(s,30,0), lease_expiry_date = NULL WHERE object_id = ?" In-bindings: (2015-04-02,{5827F21B-B08B-4205-99FB-D607333DA467})"

at com.filenet.engine.dbpersist.DBMSSQLContext.throwEngineException(DBMSSQLContext.java:355)

at 

ICN Sync duplicated key exception

Caused by: org.springframework.dao.DataIntegrityViolationException: StatementCallback; SQL [MERGE INTO navigator.wPIo0ATdivsta1h_MANIFEST AS TS USING (VALUES('EC18F932-7155-CE06-8760-4C7E89100000')) AS DAT(OBJECTID) ON TS.OBJECTID = DAT.OBJECTID WHEN NOT MATCHED THEN INSERT (OBJECTID, SUBSCRIPTIONID, ISCONTAINER) VALUES (DAT.OBJECTID, '106295c1-3e59-4124-9074-52fe7dd9517d', 0);]; Violation of UNIQUE KEY constraint 'M_wPIo0ATdivsta1h_I2'. Cannot insert duplicate key in object 'navigator.wPIo0ATdivsta1h_MANIFEST'. The duplicate key value is (EC18F932-7155-CE06-8760-4C7E89100000).; nested exception is com.ibm.websphere.ce.cm.DuplicateKeyException: Violation of UNIQUE KEY constraint 'M_wPIo0ATdivsta1h_I2'. Cannot insert duplicate key in object 'navigator.wPIo0ATdivsta1h_MANIFEST'. The duplicate key value is (EC18F932-7155-CE06-8760-4C7E89100000).

at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228)

at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)

at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:407)

at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:522)

at com.ibm.ecm.sync.core.db.spring.BaseSpringDAO.createRepositoryObjectWithCallerTransaction(BaseSpringDAO.java:108)

at com.ibm.ecm.sync.core.db.spring.RepositorySpringDAO.registerRepositoryObjectWithSameRegistrationsAsParent(RepositorySpringDAO.java:530)

at com.ibm.ecm.sync.api.RepositoryController.procesNotification(RepositoryController.java:333)

... 31 more

Caused by: com.ibm.websphere.ce.cm.DuplicateKeyException: Violation of UNIQUE KEY constraint 'M_wPIo0ATdivsta1h_I2'. Cannot insert duplicate key in object 'navigator.wPIo0ATdivsta1h_MANIFEST'. The duplicate key value is (EC18F932-7155-CE06-8760-4C7E89100000).

at sun.reflect.GeneratedConstructorAccessor37.newInstance(Unknown Source) 

ICN Sync time out

TH0002        [ERROR] Exception occurred during sync object registration. java.lang.RuntimeException: java.net.SocketTimeoutException: Read timed out

java.lang.RuntimeException: Exception occurred during sync object registration. java.lang.RuntimeException: java.net.SocketTimeoutException: Read timed out

Manually update CPE engine url for ICN

Run below sql on ICN db:

update SYNCREPOSMAPPINGset CONNECTIONINFO='iiop://CPE_IP:CPE_PORT/FileNet/Engine' where id=<realID>

Content uploads to a Database Storage Area fail after a Content Platform Engine 5.2.1 upgrade ( IBM DB2 database).

com.ibm.CORBA.iiop.ClientDelegate@fa9f8bf7 invoke:830 PopManager ORBRas[default] Received SystemException  org.omg.CORBA.UNKNOWN:
>> SERVER (id=79349024, host=hqpsice2.hqpsidcdom.com) TRACE START:
>>    java.rmi.RemoteException: ; nested exception is:
com.filenet.api.exception.EngineRuntimeException: FNRCC0036E: CONTENT_DCA_FAILED_INSERT: The content element could not be inserted.
>> at com.filenet.engine.content.DatabaseContentArea.copyElementToInbound(DatabaseContentArea.java:2034)

Caused by: com.filenet.api.exception.EngineRuntimeException: FNRCD0009E: DB_ERROR: The database access failed with the following error: ErrorCode 0, Message 'DSRA1300E: Feature is not implemented: PreparedStatement.setBinaryStream' ObjectStore: "OSname"
at com.filenet.engine.dbpersist.DBDB2Context.throwEngineException(DBDB2Context.java:730)
at com.filenet.engine.dbpersist.DBContext.throwEngineException(DBContext.java:1277)
at com.filenet.engine.dbpersist.DBStatementBase.setBinding(DBStatementBase.java:640)
at com.filenet.engine.dbpersist.DBStatementBase.buildSingleExecution(DBStatementBase.java:526)
at com.filenet.engine.dbpersist.DBStatementBase.execute(DBStatementBase.java:271)
at com.filenet.engine.content.DatabaseContentArea.copyElementToInbound(DatabaseContentArea.java:2027)
... 23 more
Caused by: java.sql.SQLFeatureNotSupportedException: DSRA1300E: Feature is not implemented: PreparedStatement.setBinaryStream
at com.ibm.ws.rsadapter.AdapterUtil.notSupportedX(AdapterUtil.java:1462)
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setBinaryStream(WSJdbcPreparedStatement.java:1426)
at com.filenet.engine.dbpersist.DBStatementBase.setBinding(DBStatementBase.java:624)
... 26 more
Caused by: java.lang.AbstractMethodError: java/sql/PreparedStatement.setBinaryStream(ILjava/io/InputStream;)V
at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.setBinaryStream(WSJdbcPreparedStatement.java:1410)
... 27 more
}

This behavior occurs if as part of the upgrade the IBM DB2 JDBC driver was not also upgraded from Type 3 to Type 4. Content Platform Engine 5.2.1 only supports the DB2 JDBC Type 4 driver.

http://www-01.ibm.com/support/docview.wss?uid=swg21692413

Error when CPE 521 use CSS520

2015-01-23T16:59:04.784 0D6E50EC CBR  FNRCE0000E - ERROR 0 -327122417 [CSECascadeCollection] [isCollectionExist] Failed to check existance of index OS1_Document_20150123165904_6BA84D17C5B345889253D195EED93232
2015-01-23T16:59:04.784 0D6E50EC CBR  FNRCB0035W - WARN Could not create index:OS1_Document_20150123165904_6BA84D17C5B345889253D195EED93232 path:/data/CSSIndexArea \ncom.filenet.api.exception.EngineRuntimeException: FNRCB0035E: CBR_TS_ACCESSING_INDEX_FAILED: An IBM Content Search Services server could not access the OS1_Document_20150123165904_6BA84D17C5B345889253D195EED93232 index or the directory that contains the index. Message was: IQQD0027E This action type is not supported.\n at com.filenet.engine.cbrspi.cssimpl.CSECascadeCollection.isCollectionExist(CSECascadeCollection.java:226)\n

have to upgrade CSS to 521

ava.lang.ClassCastException

From ICN desktop configuration to select repository under workflow tab, got this error:

[1/23/15 14:59:42:909 PST] 000000ac ServletWrappe I com.ibm.ws.webcontainer.servlet.ServletWrapper init SRVE0242I: [navigator] [/navigator] [/error.jsp]: Initialization successful.

[1/23/15 15:00:18:751 PST] 000000ac SystemOut     O CIWEB Error: [Administrator @ 192.168.1.1] com.ibm.ecm.util.p8.P8Workflow.getVWSession()

java.lang.ClassCastException:

>> SERVER (id=3d2e6dfb, host=ce) TRACE START:

>>    java.lang.ClassCastException: [B incompatible with java.lang.String

>>         at filenet.vw.server.rpc._EJSRemote0SLPESENDAPIRPC_7f999854_Tie.sendCommandBytes(_EJSRemote0SLPESENDAPIRPC_7f999854_Tie.java:100)

>>         at filenet.vw.server.rpc._EJSRemote0SLPESENDAPIRPC_7f999854_Tie._invoke(_EJSRemote0SLPESENDAPIRPC_7f999854_Tie.java)

>>         at com.ibm.CORBA.iiop.ServerDelegate.dispatchInvokeHandler(ServerDelegate.java:669)

>>         at com.ibm.CORBA.iiop.ServerDelegate.dispatch(ServerDelegate.java:523)

>>         at com.ibm.rmi.iiop.ORB.process(ORB.java:523)

>>         at com.ibm.CORBA.iiop.ORB.process(ORB.java:1575)

>>         at com.ibm.rmi.iiop.Connection.doRequestWork(Connection.java:3039)

>>         at com.ibm.rmi.iiop.Connection.doWork(Connection.java:2922)

>>         at com.ibm.rmi.iiop.WorkUnitImpl.doWork(WorkUnitImpl.java:64)

>>         at com.ibm.ws.giop.threadpool.WorkQueueElement.dispatch(WorkQueueElement.java:165)

>>         at com.ibm.ws.giop.filter.GiopFilterChain.processMessage(GiopFilterChain.java:203)

>>         at com.ibm.ws.giop.threadpool.PooledThread.handleRequest(PooledThread.java:81)

>>         at com.ibm.ws.giop.threadpool.PooledThread.run(PooledThread.java:102)

>>         at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1862)

>> SERVER (id=3d2e6dfb, host=ce) TRACE END.

at filenet.pe.ejb.client.PEEJBSession.executeRPC(PEEJBSession.java:861)

at filenet.pe.ejb.client.PEEJBSession.fetchStaticConfigInfo(PEEJBSession.java:3317)

at filenet.pe.ejb.client.PEEJBSession.getIsolatedRegion(PEEJBSession.java:958)

at filenet.pe.ejb.client.PEEJBSession.setClientLocale(PEEJBSession.java:2787)

at filenet.vw.api.VWSession.setClientLocale(VWSession.java:5

The reason is the ICN client jar files are not synchronize with CPE server, so just use configuration manager to download the latest jar files and re-build navigator ear and re-deploy it.