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 MARCH 08, 2017

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

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