Missing In Or Out Parameter At Index:: 4 For Index Optimization

(Doc ID 1672351.1)

Last updated on AUGUST 01, 2017

Applies to:

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

Symptoms

Index Optimization in SES 11.2.2.2 is failing with following errors in the ess_server1 managed server log -

SESParallelIndexOptimizer Running, Request ID: 1003 isResumed=false pausedState=null
tenantId: 1
SESParallelIndexOptimizer got unexpected exception ORA-20000: EQG-10000:en-US:
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "SEARCHSYS.EQ_ERR", line 260
ORA-06512: at line 1

oracle.as.scheduler.ExecutionErrorException: Missing IN or OUT parameter at index:: 4
at SESParallelIndexOptimizer.execute(SESParallelIndexOptimizer.java:179)
at oracle.as.scheduler.rp.JavaSysExecWrapper$1.run(JavaSysExecWrapper.java:353)
at java.security.AccessController.doPrivileged(Native Method)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315)
at oracle.security.jps.internal.jaas.AccActionExecutor.execute(AccActionExecutor.java:74)
at oracle.security.jps.internal.jaas.CascadeActionExecutor$SubjectPrivilegedExceptionAction.run(CascadeActionExecutor.java:83)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:146)
at weblogic.security.Security.runAs(Security.java:61) 

Some additional information can also be found from the optimization log file, while the index optimization is running. The optimization log file name has a pattern like opt_REBUILD_<date/timestamp>.log e.g :- opt_REBUILD_2014_08_14_10_26_47.log and is present under the database $ORACLE_HOME/ctx/log/ directory.

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