IBM Content Navigator (ICN)

Desktop Cannot be Found Error in IBM ICN Integrated Environment IBM FileNet P8

November 15, 2018

There was an issue reported today when IBM Content Navigator (ICN) integrated with IBM FileNet P8 was running smoothly than suddenly when tried to open any of ICN desktops; icm, admin, icmadmin there was a window appears where it was mentioned that,

the desktop cannot be found. Ask your system administration to review web application server log file for information about why the desktop cannot be found.

Even though, navigator application was running absolutely fine in WAS administration console.  Below is the problem screenshot:

ibm-filenet-p8-icn-desktop-found

Diagnosing the problem

From the ICN SystemOut.log, the following exception is happening after opening url of Admin/icm/icmadmin/ier desktops:

[11/15/18 11:21:27:171 PKT] 000000ec SystemOut O [11/15/18 11:21:27:171 PKT] 000000ec SystemOut O CIWEB Error: [ ] null.processCleanup() There was a SQL configuration error. org.apache.commons.configuration.event.ConfigurationErrorEvent[source=com.ibm.ecm.configuration.DatabaseConfiguration@d92c6d5c]
[11/15/18 11:21:27:171 PKT] 000000ec SystemOut O [11/15/18 11:21:27:171 PKT] 000000ec SystemOut O CIWEB Error: [ ] com.ibm.ecm.configuration.DatabaseConfiguration.getProperty() key = settings.navigator.default
java.sql.SQLException: ORA-28001: the password has expired
DSRA0010E: SQL State = 99999, Error Code = 28,001
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:382)
at oracle.jdbc.driver.T4CTTIfun.processError(T4CTTIfun.java:600)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:445)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:380)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOAUTH(T4CTTIoauthenticate.java:760)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:401)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:546)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:236)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:32)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:521)
at oracle.jdbc.pool.OracleDataSource.getPhysicalConnection(OracleDataSource.java:280)
at oracle.jdbc.pool.OracleDataSource.getConnection(OracleDataSource.java:207)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPhysicalConnection(OracleConnectionPoolDataSource.java:139)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:88)
at oracle.jdbc.pool.OracleConnectionPoolDataSource.getPooledConnection(OracleConnectionPoolDataSource.java:70)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper$1.run(InternalGenericDataStoreHelper.java:1366)
at com.ibm.ws.security.util.AccessController.doPrivileged(AccessController.java:118)
at com.ibm.ws.rsadapter.spi.InternalGenericDataStoreHelper.getPooledConnection(InternalGenericDataStoreHelper.java:1385)
at com.ibm.ws.rsadapter.spi.WSRdbDataSource.getPooledConnection(WSRdbDataSource.java:2154)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.getConnection(WSManagedConnectionFactoryImpl.java:1802)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1572)
at com.ibm.ws.rsadapter.spi.WSManagedConnectionFactoryImpl.createManagedConnection(WSManagedConnectionFactoryImpl.java:1128)
at com.ibm.ejs.j2c.FreePool.createManagedConnectionWithMCWrapper(FreePool.java:2168)
at com.ibm.ejs.j2c.FreePool.createOrWaitForConnection(FreePool.java:1838)
at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:3835)
at com.ibm.ejs.j2c.PoolManager.reserve(PoolManager.java:3111)
at com.ibm.ejs.j2c.ConnectionManager.allocateMCWrapper(ConnectionManager.java:1548)
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java:1031)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:646)
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java:613)
at org.apache.commons.configuration.DatabaseConfiguration.getConnection(DatabaseConfiguration.java:632)
at com.ibm.ecm.configuration.DatabaseConfiguration._getProperty(DatabaseConfiguration.java:821)
at com.ibm.ecm.configuration.DatabaseConfiguration.getProperty(DatabaseConfiguration.java:788)
at org.apache.commons.configuration.AbstractConfiguration.getStringArray(AbstractConfiguration.java:1081)
at org.apache.commons.configuration.AbstractConfiguration.getProperties(AbstractConfiguration.java:607)
at org.apache.commons.configuration.AbstractConfiguration.getProperties(AbstractConfiguration.java:584)
at com.ibm.ecm.configuration.ConfigurationObject.load(ConfigurationObject.java:245)
at com.ibm.ecm.configuration.SettingsConfig.load(SettingsConfig.java:226)
at com.ibm.ecm.configuration.ConfigurationObject.<init>(ConfigurationObject.java:105)
at com.ibm.ecm.configuration.SettingsConfig.<init>(SettingsConfig.java:194)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:83)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:57)
at java.lang.reflect.Constructor.newInstance(Constructor.java:437)
at com.ibm.ecm.configuration.Config._getConfiguration(Config.java:1445)
at com.ibm.ecm.configuration.Config.getConfiguration(Config.java:1498)
at com.ibm.ecm.configuration.Config.getSettingsConfig(Config.java:529)
at com.ibm.ecm.configuration.Config.getSettingsConfig(Config.java:509)
at com.ibm.ecm.configuration.ConfigWrapper.getSettingsConfig(ConfigWrapper.java:723)
at com.ibm.ecm.configuration.ApplicationConfig.getSettingsConfig(ApplicationConfig.java:638)
at com.ibm.ecm.configuration.LoggingConfigThread.run(LoggingConfigThread.java:70)

Environment:

WAS 8.5.x

ICN 3.0.x

ICM 5.3.x

Oracle 11g

Solution:

This problem occurred when icn schema password expired or user locked.

  • Stop IBM FileNet P8 services.
  • Unlock icn schema by performing following:

SELECT username, account_status FROM DBA_USERS;

ALTER profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;
ALTER profile DEFAULT limit PASSWORD_LIFE_TIME unlimited;

ALTER USER ICN_USER ACCOUNT UNLOCK IDENTIFIED BY password;

  • Start services and try to connect to icn desktops again. It will work fine.

You Might Also Like

1 Comment

  • Reply Kandi Fann June 8, 2019 at 6:29 pm

    Heya, I’m for the first time here. I came across this board and I find It really useful & it helped me out a lot. I hope to give something back and help others like you helped me.

  • Leave a Reply

    error

    Subscribe