Oracle Error on IDM Startup about "could not get metadata for the table event12_5:ORA-00942".

book

Article ID: 52611

calendar_today

Updated On:

Products

DIRECTORY CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On SINGLE SIGN ON - LEGACY CA Data Protection (DataMinder) CA User Activity Reporting

Issue/Introduction

Description:

Upon startup of the IDM 12.5 server, see error upon startup:

ERROR [ims.tmt.persistence] PersistenceProvider: Thread-15:
readTableMetaData: could not get metadata for the table event12_5: ORA-00942:
table or view does not exist java.sql.SQLSyntaxErrorException: ORA-00942:
table or view does not exist

Solution:

This is due to missing table/metadata for the table event12_5n and other similar task persistence related tables. The installer builds the table as "EVENT12_5" and though Oracle is case insensitive, IDM cannot read the information or thinks some metadata is missing.

Workaround:

  1. Run the idm_db_oracle_delete.sql script in \IAM Suite\Identity Manager\tools\db\taskpersistence\oracle9i to remove all task persistence related tables and information. Use this regardless of whether you are on Oracle 9/10/11.

  2. Then run the idm_db_oracle.sql script to re-create the task persistence tables as the same schema owner you specified during the IDM installation.

  3. Restart application server - errors will disappear in startup-sequence.

Environment

Release:
Component: IDMGR