OPSS - Upgrading From ODI 12.1.3 To 12.2.1 Fails With ORA-01450 : maximum key length (6398) exceeded (Doc ID 2124187.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Platform Security for Java - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

Upgrading  ODI 12.1.3 to 12.2.1,   seeing the issue on OPSS side

Caused by: java.sql.SQLException: ORA-01450: maximum key length (6398) exceeded

 Error observed:

[2016-02-19T10:43:35.162+01:00] [RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [tid: 69] [ecid: eafffefc-666b-4753-9cc2-13f8fb407754-00000002,0] SQLException: ORA-01450: maximum key length (6398) exceeded[[

]]
[2016-02-19T10:43:35.162+01:00] [RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [tid: 69] [ecid: eafffefc-666b-4753-9cc2-13f8fb407754-00000002,0] [[
java.sql.SQLException: ORA-01450: maximum key length (6398) exceeded

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:5195)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1546)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.runSqlStatement(JDBCEngine.java:1268)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(JDBCEngine.java:930)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:948)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:924)
at oracle.sysman.assistants.common.dbutil.jdbc.OracleDDLStatement.execute(ANSISQLStatementType.java:709)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1781)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1684)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1594)
at oracle.ias.update.plugin.UpgradeJDBCEngine.execute(UpgradeJDBCEngine.java:177)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:1807)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScriptAsDBA(UpgradePlugin.java:1679)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScriptAsDBA(UpgradePlugin.java:1705)
at oracle.security.opss.update.plugin.RDBMSOpssSchemaUpgradePlugin.upgradeOpssDBSchema(RDBMSOpssSchemaUpgradePlugin.java:220)
at oracle.security.opss.update.plugin.RDBMSOpssSchemaUpgradePlugin.upgrade(RDBMSOpssSchemaUpgradePlugin.java:153)
at oracle.security.opss.update.plugin.OpssSchemaUpgradePlugin.upgrade(OpssSchemaUpgradePlugin.java:159)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:733)
at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:708)
at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:705)
at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:349)
at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1030)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

]]
[2016-02-19T10:43:35.164+01:00] [RCU] [ERROR] [] [upgrade.RCU.jdbcEngine] [tid: 69] [ecid: eafffefc-666b-4753-9cc2-13f8fb407754-00000002,0] Error encountered executing SQL statement FileName: '/u04/odi/odi_12.2.1/oracle_common/common/sql/opss/scripts/oracle/opss_upgrade_121300_122100.sql' LineNumber: '50' Script log file: /u04/odi/odi_12.2.1/oracle_common/upgrade/logs/ua2016-02-19-10-31-24AM.out
[2016-02-19T10:43:35.164+01:00] [OPSS] [ERROR] [] [upgrade.OPSS.OPSS_SCHEMA_PLUGIN] [tid: 69] [ecid: eafffefc-666b-4753-9cc2-13f8fb407754-00000002,0] UPGAST-00221: unexpected error upgrading schema
[2016-02-19T10:43:35.165+01:00] [OPSS] [ERROR] [] [upgrade.OPSS.OPSS_SCHEMA_PLUGIN] [tid: 69] [ecid: eafffefc-666b-4753-9cc2-13f8fb407754-00000002,0] [[
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLException: ORA-01450: maximum key length (6398) exceeded

at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.onException(JDBCEngine.java:1032)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:996)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:924)
at oracle.sysman.assistants.common.dbutil.jdbc.OracleDDLStatement.execute(ANSISQLStatementType.java:709)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1781)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1684)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1594)
at oracle.ias.update.plugin.UpgradeJDBCEngine.execute(UpgradeJDBCEngine.java:177)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScript(UpgradePlugin.java:1807)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScriptAsDBA(UpgradePlugin.java:1679)
at oracle.ias.update.plugin.UpgradePlugin.executeJDBCEngineScriptAsDBA(UpgradePlugin.java:1705)
at oracle.security.opss.update.plugin.RDBMSOpssSchemaUpgradePlugin.upgradeOpssDBSchema(RDBMSOpssSchemaUpgradePlugin.java:220)
at oracle.security.opss.update.plugin.RDBMSOpssSchemaUpgradePlugin.upgrade(RDBMSOpssSchemaUpgradePlugin.java:153)
at oracle.security.opss.update.plugin.OpssSchemaUpgradePlugin.upgrade(OpssSchemaUpgradePlugin.java:159)
at oracle.ias.update.plugin.Plugin.upgrade(Plugin.java:733)
at oracle.ias.update.plan.PlanStep.upgrade(PlanStep.java:708)
at oracle.ias.update.PhaseProcessor$UpgradeProcessor.runStepPhase(PhaseProcessor.java:705)
at oracle.ias.update.PhaseProcessor.runStep(PhaseProcessor.java:349)
at oracle.ias.update.PhaseProcessor$ExtendedRunnable.run(PhaseProcessor.java:1030)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: ORA-01450: maximum key length (6398) exceeded

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1006)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1316)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:5195)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1546)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.runSqlStatement(JDBCEngine.java:1268)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(JDBCEngine.java:930)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:948)
... 20 more

 

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