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
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: