ORA-20000: Oracle Text Error
(Doc ID 2559087.1)
Last updated on FEBRUARY 10, 2020
Applies to:
Oracle Banking Platform - Version 2.3 and laterInformation in this document applies to any platform.
Symptoms
SUMMARY_TEXT search is failing intermittently with below errors.
ERROR
-----------------------
Caused By: java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
ORA-20000: Oracle Text error:
DRG-50610: internal error: drexdsync
DRG-50857: oracle error in drekrtd (reselect rowid row locator)
ORA-01591: lock held by in-doubt distributed transaction 92.23.227524
ORA-06512: at "CTXSYS.SYNCRN", line 1
ORA-06512: at line 1
Observation:
SUMMARY_TEXT search is working for table FLX_WRF_TRK_SUMMARY_ENTITY_B whereas it is not working for table FLX_DD_NON_FIN_STMT_SUMMARY_B.
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 |