My Oracle Support Banner

SES 11.2.2.2.0 Install Failed At RCU With "EQG-10615:en-US:EQG-ARG:Creating eq$sec_attr_val" (Doc ID 1674375.1)

Last updated on JULY 10, 2018

Applies to:

Oracle Secure Enterprise Search - Version 11.2.2.2.0 and later
Information in this document applies to any platform.

Symptoms

While trying to install SES 11.2.2.2.0 with option 2 (SES+middleware on box 1 and database on box 2) it fails running eq0definst.sql with the error below:

 

JDBC SQLException - ErrorCode: 20000SQLState:72000 Message: ORA-20000: EQG-10000:en-US:
User-Defined Exception
EQG-10615:en-US:EQG-ARG:creating eq$sec_attr_val
ORA-01450: maximum key length (3800) exceeded
ORA-06512: at "SEARCHSYS.EQ_ERR", line 260
ORA-06512: at "SEARCHSYS.EQ_TENANT", line 131
ORA-06512: at line 3


or the rcu.log file may show the following trace :

...
2015-10-16 15:21:51.776 ERROR rcu: oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine::executeNextSQLStatement: Error encountered executing SQL statement  FileName: '/psoft/oracle/ses/Oracle_SES1/rcu/rcu/integration/search/sql/eq0tabs.sql' LineNumber: '1444' Script log file: /psoft/oracle/ses/Oracle_SES1/cfgtoollogs/rcu/logdir.2015-10-16_15-21/search.log
2015-10-16 15:21:51.776 INCIDENT_ERROR rcu: oracle.sysman.assistants.rcu.backend.action.JDBCAction::cleanAndLog: RCU-6134:Error while trying to execute JDBC action. - SEARCH
oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLException: ORA-01450: maximum key length (3215) exceeded

at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.onException(JDBCEngine.java:869)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:833)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:773)
at oracle.sysman.assistants.common.dbutil.jdbc.OracleDDLStatement.execute(ANSISQLStatementType.java:711)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1460)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1364)
at oracle.sysman.assistants.rcu.backend.action.JDBCAction.perform(JDBCAction.java:402)
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:245)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:307)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: ORA-01450: maximum key length (3215) exceeded

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:953)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3488)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1374)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.runSqlStatement(JDBCEngine.java:1090)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.callRunSqlStatement(JDBCEngine.java:779)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:794)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:773)
at oracle.sysman.assistants.common.dbutil.jdbc.OracleDDLStatement.execute(ANSISQLStatementType.java:711)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1460)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1364)
at oracle.sysman.assistants.rcu.backend.action.JDBCAction.perform(JDBCAction.java:402)
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:245)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:306)
... 1 more

2015-10-16 15:21:51.780 ERROR rcu: oracle.sysman.assistants.rcu.backend.task.ActualTask::run: RCU Operation Failed
oracle.sysman.assistants.common.task.TaskExecutionException: RCU-6134:Error while trying to execute JDBC action.
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:302)
at oracle.sysman.assistants.rcu.backend.task.ActualTask.run(TaskRunner.java:307)
at java.lang.Thread.run(Thread.java:662)
Caused by: oracle.sysman.assistants.common.task.ActionFailedException: RCU-6134:Error while trying to execute JDBC action.
at oracle.sysman.assistants.rcu.backend.action.JDBCAction.perform(JDBCAction.java:424)
at oracle.sysman.assistants.rcu.backend.task.AbstractCompTask.execute(AbstractCompTask.java:245)
... 2 more
Caused by: oracle.sysman.assistants.common.dbutil.SQLFatalErrorException: java.sql.SQLException: ORA-01450: maximum key length (3215) exceeded

at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.onException(JDBCEngine.java:869)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:833)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeSql(JDBCEngine.java:773)
at oracle.sysman.assistants.common.dbutil.jdbc.OracleDDLStatement.execute(ANSISQLStatementType.java:711)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.executeNextSQLStatement(JDBCEngine.java:1460)
at oracle.sysman.assistants.common.dbutil.jdbc.JDBCEngine.parseNexecuteScript(JDBCEngine.java:1364)
at oracle.sysman.assistants.rcu.backend.action.JDBCAction.perform(JDBCAction.java:402)
... 3 more
Caused by: java.sql.SQLException: ORA-01450: maximum key length (3215) exceeded

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)

...

 

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.