IBM Support

Invalid database repository definition in VMM configuration prevents WebSphere Portal from starting

Troubleshooting


Problem

If the VMM configuration contains an invalid database repository definition and if security is configured as a federated repository, IBM WebSphere Portal will not start.

Symptom


Sample output from the SystemOut.log:

UserRegistryI E   SECJ0331E: The registry implementation file com.ibm.ws.wim.registry.WIMUserRegistry cannot be initialized because of the following exception com.ibm.websphere.wim.exception.WIMSystemException: CWWIM1999E An exception occurred during processing: CWWIM1999E An exception occurred during processing: null

    at
com.ibm.ws.wim.adapter.db.DBPropertyCache.init(DBPropertyCache.java:467)
...
Caused by: com.ibm.websphere.wim.exception.WIMSystemException: CWWIM1999E An exception occurred during processing: null
    at
com.ibm.ws.wim.dao.AbstractDAO.getDirectAccessConnection(AbstractDAO.java:348)
...
Caused by: java.lang.reflect.InvocationTargetException
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
...
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied
    at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
...

Cause

This problem has been observed when the wp-create-db task fails and the invalid database repository definition is not removed from the wimconfig.xml file. The failed startup can be associated with a variety of SQL-related exceptions.

Resolving The Problem


Verify the database repository definitions in the <wp_profile>/config/cells/<cell name>/wim/config/wimconfig.xml file.

If a database repository definition was added as a result of a failed wp-create-db task, remove it, synchronize the security configuration if clustered, and restart WebSphere Portal. The results of the wp-create-db tasks can be found in the <wp_profile>/ConfigEngine/log/ConfigTrace.log

Back up the wimconfig.xml file before editing it. Database repository definitions in wimconfig.xml are of the following form:
<config:repositories xsi:type="config:DatabaseRepositoryType" adapterClassName="com.ibm.ws.wim.adapter.db.DBAdapter" id=... />

[{"Product":{"code":"SSHRKX","label":"WebSphere Portal"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"6.1","Edition":"","Line of Business":{"code":"LOB31","label":"WCE Watson Marketing and Commerce"}}]

Document Information

Modified date:
03 December 2021

UID

swg21381287

Page Feedback