ORA-20000: Oracle Text Error
(Doc ID 2559087.1)
Last updated on FEBRUARY 10, 2020
Applies to:Oracle Banking Platform - Version 2.3 and later
Information in this document applies to any platform.
SUMMARY_TEXT search is failing intermittently with below errors.
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
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.
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