Error in creating Report Snapshot database schema.: java.sql.SQLException: Identity Manager startup fails with ORA-01450: maximum key length (6398) exceeded.

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal

Issue/Introduction

Error in creating Report Snapshot database schema.: java.sql.SQLException: ORA-01450: maximum key length (6398) exceeded...

The error occurs during initial IM startup following an installation:

2018-10-19 09:47:09,686 ERROR [ims.tmt.CreateDatabaseSchema] (MSC service thread 1-6) Error in creating Report Snapshot database schema.: java.sql.SQLException: ORA-01450: maximum key length (6398) exceeded...
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) [ojdbc8.jar:]....
.... java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71]
Caused by: Error : 1450, Position : 46, Sql = CREATE INDEX imrAccountTemplateRel_index_1 ON imrAccountTemplateRel (imr_reportid, imr_name,imr_templatedn,imr_endpointtype), OriginalSql = CREATE INDEX imrAccountTemplateRel_index_1 ON imrAccountTemplateRel (imr_reportid, imr_name,imr_templatedn,imr_endpointtype), Error Msg = ORA-01450: maximum key length (6398) exceeded at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) [ojdbc8.jar:]...
 

Environment

Release:
Component: IDSVA

Cause

The problem is with the maximum index key length allowed by the Oracle database. There is an Oracle setting (see resolution below) that needs to be modified.

Resolution

1) Delete objects from object store Database
2) On the Oracle DB, set NLS_DATABASE_PARAMETER to BYTE
3) Restart Oracle Database Services
4) Start IM Application.

The DB Objects will be recreated as expected during bootstrap startup sequence.

Please contact your Oracle DBA for further assistance with the above database parameter change.