My Oracle Support Banner

SES Index Optimization Fails with EQA-15021, ORA-20000, DRG-50857, and ORA-00001: unique constraint violated (Doc ID 2417443.1)

Last updated on JUNE 29, 2018

Applies to:

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

Symptoms



Secure Enterprise Search (SES) index optimization fails with an error similar to this,

 
EQA-15021: The associated Oracle Enterprise Scheduler (ESS) request with ID 20607 is no longer executing. The request ended in state ERROR with the following information: oracle.as.scheduler.ExecutionErrorException: ORA-20000: EQG-10000:en-US:
ORA-20000: Oracle Text error:
DRG-50857: oracle error in dresoflush
ORA-00001: unique constraint (SEARCHSYS.SYS_IOT_TOP_77303) violated
ORA-06512: at "SEARCHSYS.EQ_ERR", line 260
ORA-06512: at line 1
at SESParallelIndexOptimizer.execute(SESParallelIndexOptimizer.java:190)
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)





Changes

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.