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.

Failed to login PE workflow system configuration management on WAS8

When right click "workflow system " from ACCE, got above error.  On websphere 8x , there are a few configurations need to do http://www-01.ibm.com/support/knowledgecenter/SSNW2F_5.2.1/com.ibm.p8.install.doc/p8pup728.htm?lang=en-us

Failed to upgrade PE from 520 to 521

RPCHandler PEServer.init DB=OSDS [Error] FNRPE1210001000E Database upgrade failed; Exception: Database error.  See chained exception
; Cannot execute statement, msecs=, SQL: "CREATE UNIQUE INDEX DB2INST1.VW_IND6 ON DB2INST1.VWLog1_113 (F_WorkFlowNumber, F_EventType, F_TimeStamp, F_SeqNumber)"
at filenet.jpe.database.DbDesc.MapDB2Error(DbDesc.java:1288)
at filenet.jpe.database.DbDesc.ConvertError(DbDesc.java:1132)
at filenet.jpe.database.DbStatement.convertError(DbStatement.java:221)
at filenet.jpe.database.DbStatement.execute(DbStatement.java:142)
at filenet.jpe.rpc.appserver.PEEngineServlet$ServerStartupThread.run(PEEngineServlet.java:120)
Caused by: com.ibm.db2.jcc.am.SqlException: DB2 SQL Error: SQLCODE=-954, SQLSTATE=57011, SQLERRMC=null, DRIVER=3.65.77
at com.ibm.db2.jcc.am.cd.a(cd.java:701)
at com.ibm.db2.jcc.am.cd.a(cd.java:60)

Manually run the sql , then found the application heap size was not enough, so just increase application heap size as:
db2 update db cfg for OSDB using APPLHEAPSZ 256000

Failed to same repository on ICN navigator

Notice:

Log as :
[1/22/15 14:32:20:963 PST] 000000ac SystemOut     O CIWEB Error: [Administrator @ 192.168.1.125] com.ibm.ecm.struts.actions.admin.p8.P8AddOnAction.updateAccessPermissions()
com.filenet.api.exception.EngineRuntimeException: FNRCE0002E: E_BAD_CLASSID: Class "StoredSearch" not found. errorStack={
at com.filenet.engine.metadatacache.MetadataCacheBase.determineBadClassRetry(MetadataCacheBase.java:243)
at com.filenet.engine.metadatacache.MetadataCacheBase.getClassInfo(MetadataCacheBase.java:194)

so the reason is "storedsearch" addon missing. Go to ACCE to add it.

Initialize PE region by command

• copy sample properties file from <P8_Install>/tools/PE/samples/PEInitD.properties.sample, and rename to PEInitD.properties. Edit the file with correct configuraion:

DBConnectionName=<database connection name>
DataSourceName=<data source name>
XADataSourceName=<XA data source name>
#SiteName=<site name (optional)>

#------------------------------------------------------------------------------
# Security group names
#
SysAdminGroup=<administrators group>
SysConfigGroup=<configuration group>

#------------------------------------------------------------------------------
# General system information
#
# examples:
#   date/time mask: mm/dd/yyyy hh\:tt\:ss
#   default locale: en_US
#
DateTimeMask=<date/time mask>
DefaultLocale=<locale language code and (optional) country code>

#------------------------------------------------------------------------------
# Tablespace/Filegroup Information
# Specify the tablespace or filegroup names in your database.  A value for
# pe_data is required.  Other values may be required or optional depending on
# your database type.  To specify values for pe_index or pe_blob, be sure to
# remove the preceding comment character '#'.
#
pe_data=<data tablespace>
#pe_index=<index tablespace>
#pe_blob=<blob tablespace (DB2 only)>

#------------------------------------------------------------------------------
# Region Information
# Note: the connection point name will be specified on the command line.
#
RegionDisplayName=<isolated region display name>
IsolatedRegionNumber=<isolated region number>
DBSchemaName=<database schema name>
EnableRegionForBackup=<true/false>

#------------------------------------------------------------------------------
# (optional) Specify the tablespace or filegroup names to be used by the region.
# To specify values for these items, be sure to remove the preceding comment
# character '#'.
#
#region_data=<data tablespace>
#region_index=<index tablespace>
#region_blob=<blob tablespace (DB2 only)>

• run command : ./peinit <ConnectionPointName> -D PEInitD.properties