FNRCG0014E: GCD_DATABASE_UNAVAILABLE

 A020D310 ENG  FNRCG0014E - ERROR method name: getInstance principal name: Administrator Global Transaction: true User Transaction: false Exception Info: The GCD database is currently not available. A file-based, read-only image of the GCD will be used in its place. All update operations will be disallowed until database availability has been restored.

com.filenet.api.exception.EngineRuntimeException: FNRCG0014E: GCD_DATABASE_UNAVAILABLE: The GCD database is currently not available. A file-based, read-only image of the GCD will be used in its place. All update operations will be disallowed until database availability has been restored.

solved: there are two duplicated datasource name.

FNRCS0005E: SECURITY_INVALID_CREDENTIALS: Access to the Content Engine was not allowed...

com.ibm.ecm.struts.actions.p8.P8LogonAction.createP8Connection()
com.filenet.api.exception.EngineRuntimeException: FNRCS0005E: SECURITY_INVALID_CREDENTIALS: Access to the Content Engine was not allowed because the Content Engine API library or the Web Service Interface (WSI) Listener could not find the required security context information. Expected credentials were not found in the security context.

Solution:

• On the client side WAS instance, set a Java property: -DFileNet.WSI.AutoDetectLTPAToken=true
• On the server side WAS instance, set a Java property: -Dcom.filenet.authentication.token.userid=sso:ltpa

FileUploadException during starting ContentEngine on Websphere

Exception during starting ContentEngine:

[9/16/15 14:35:34:899 CDT] 0000004b WarBasedAxisC E org.apache.axis2.deployment.WarBasedAxisConfigurator <init> org.apache.commons.fileupload.FileUploadException
                                 org.apache.axis2.deployment.DeploymentException: org.apache.commons.fileupload.FileUploadException
        at org.apache.axis2.deployment.AxisConfigBuilder.processMessageBuilders(AxisConfigBuilder.java:774)
        at org.apache.axis2.deployment.AxisConfigBuilder.populateConfig(AxisConfigBuilder.java:234)
        at org.apache.axis2.deployment.DeploymentEngine.populateAxisConfiguration(DeploymentEngine.java:859)
        at org.apache.axis2.deployment.WarBasedAxisConfigurator.<init>(WarBasedAxisConfigurator.java:156)
        at org.apache.axis2.transport.http.AxisServlet.initConfigContext(AxisServlet.java:569)
        at org.apache.axis2.transport.http.AxisServlet.init(AxisServlet.java:457)
        at com.ibm.ws.webcontainer.servlet.ServletWrapper.init(ServletWrapper.java:342)
        at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.init(ServletWrapperImpl.java:168)
        at com.ibm.ws.webcontainer.servlet.ServletWrapper.loadOnStartupCheck(ServletWrapper.java:1366)
        at com.ibm.ws.webcontainer.webapp.WebApp.doLoadOnStartupActions(WebApp.java:627)
        at com.ibm.ws.webcontainer.webapp.WebApp.commonInitializationFinally(WebApp.java:593)
        at com.ibm.ws.webcontainer.webapp.WebAppImpl.initialize(WebAppImpl.java:422)
        at com.ibm.ws.webcontainer.webapp.WebGroupImpl.addWebApplication(WebGroupImpl.java:88)
        at com.ibm.ws.webcontainer.VirtualHostImpl.addWebApplication(VirtualHostImpl.java:169)
        at com.ibm.ws.webcontainer.WSWebContainer.addWebApp(WSWebContainer.java:749)
        at com.ibm.ws.webcontainer.WSWebContainer.addWebApplication(WSWebContainer.java:634)
        at com.ibm.ws.webcontainer.component.WebContainerImpl.install(WebContainerImpl.java:426)
        at com.ibm.ws.webcontainer.component.WebContainerImpl.start(WebContainerImpl.java:718)
        at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:1177)
        at com.ibm.ws.runtime.component.DeployedApplicationImpl.fireDeployedObjectStart(DeployedApplicationImpl.java:1370)
        at com.ibm.ws.runtime.component.DeployedModuleImpl.start(DeployedModuleImpl.java:639)
        at com.ibm.ws.runtime.component.DeployedApplicationImpl.start(DeployedApplicationImpl.java:968)
        at com.ibm.ws.runtime.component.ApplicationMgrImpl.startApplication(ApplicationMgrImpl.java:776)
        at com.ibm.ws.runtime.component.ApplicationMgrImpl$5.run(ApplicationMgrImpl.java:2195)
        at com.ibm.ws.security.auth.ContextManagerImpl.runAs(ContextManagerImpl.java:5477)
        at com.ibm.ws.security.auth.ContextManagerImpl.runAsSystem(ContextManagerImpl.java:5603)
        at com.ibm.ws.security.core.SecurityContext.runAsSystem(SecurityContext.java:255)
        at com.ibm.ws.runtime.component.ApplicationMgrImpl.start(ApplicationMgrImpl.java:2200)
        at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:435)
        at com.ibm.ws.runtime.component.CompositionUnitImpl.start(CompositionUnitImpl.java:123)
        at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.start(CompositionUnitMgrImpl.java:378)
        at com.ibm.ws.runtime.component.CompositionUnitMgrImpl.access$500(CompositionUnitMgrImpl.java:126)
        at com.ibm.ws.runtime.component.CompositionUnitMgrImpl$CUInitializer.run(CompositionUnitMgrImpl.java:984)
        at com.ibm.wsspi.runtime.component.WsComponentImpl$_AsynchInitializer.run(WsComponentImpl.java:502)
        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1881)
Caused by: java.lang.NoClassDefFoundError: org.apache.commons.fileupload.FileUploadException
        at java.lang.J9VMInternals.verifyImpl(Native Method)
        at java.lang.J9VMInternals.verify(J9VMInternals.java:93)
        at java.lang.J9VMInternals.initialize(J9VMInternals.java:170)
        at java.lang.J9VMInternals.newInstanceImpl(Native Method)
        at java.lang.Class.newInstance(Class.java:1600)
        at org.apache.axis2.deployment.DescriptionBuilder.processMessageBuilders(DescriptionBuilder.java:230)
        at org.apache.axis2.deployment.AxisConfigBuilder.processMessageBuilders(AxisConfigBuilder.java:771)
        ... 34 more
Caused by: java.lang.ClassNotFoundException: org.apache.commons.fileupload.FileUploadException
        at org.eclipse.osgi.internal.loader.BundleLoader.findClassInternal(BundleLoader.java:506)
        at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:422)
        at org.eclipse.osgi.internal.loader.BundleLoader.findClass(BundleLoader.java:410)
        at org.eclipse.osgi.internal.baseadaptor.DefaultClassLoader.loadClass(DefaultClassLoader.java:107)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:690)

Solution is to change class load order:  applications>><appname>> " Class loading and update detection "

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.

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