SES Index Optimization Fails with EQA-15021, ORA-20000, DRG-50857, and ORA-00001: unique constraint violated
(Doc ID 2417443.1)
Last updated on FEBRUARY 02, 2024
Applies to:
Oracle Secure Enterprise Search - Version 11.2.2.2.0 and laterInformation 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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |