Exalytics OBIEE 11g: Error "ORA-01450: Maximum Key Length (6398) Exceeded On CREATE INDEX" While Trying to Create RCU Schemas on A 12c Database (12.1.0.2)

(Doc ID 2413171.1)

Last updated on JUNE 24, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and later
Oracle Exalytics Software - Version 1.0.0.5.0 and later
Linux x86-64

Symptoms

While trying to create new OBIEE 11.1.1.9 RCU schemas on a 12c Database (12.1.0.2) it fails with error:

2018-06-07 12:54:28.104 rcu:Extracting Statement from File Name: '\\deltedata\userdata\Y0BX\PRV-Y0BX\Downloads\rcu_home\\rcu\integration\\dacx\scripts\oracle\create_tables.sql'Line Number: 1947
2018-06-07 12:54:28.104 rcu:Extracted SQL Statement: [CREATE INDEX W_ETL_DEFN_PRM_M4 ON W_ETL_DEFN_PRM(ETL_DEFN_WID, VALUE)
]
2018-06-07 12:54:28.104 rcu:Statement Type: 'DDL Statement'
JDBC SQLException - ErrorCode: 1450SQLState:72000 Message: ORA-01450: maximum key length (6398) exceeded

 

Tried the solution suggested in <Note 1483760.1>  -OBIEE 11g: Error: "ORA-01450: maximum key length (6398) exceeded File:D.....\cremdsinds.sql" When Running RCU Installation , database already has a 'BYTE' value for the nls_length_semantics.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms