Skip to main content
Question

ORA-20000: Oracle Text error in background job

  • May 10, 2024
  • 1 reply
  • 304 views

Forum|alt.badge.img+23
  • Superhero (Customer)
  • 1169 replies

Dear IFS experts,

I get the following error message from a background job:

ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvddl.IndexSync
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 2025
ORA-06512: at "IFSAPP.APPLICATION_SEARCH_INDEX_SYS", line 473
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.CTX_DDL", line 1231
ORA-06512: at "IFSAPP.APPLICATION_SEARCH_INDEX_SYS", line 455
ORA-06512: at "IFSAPP.APPLICATION_SEARCH_SYS", line 743
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 2015
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 282
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 2025
ORA-06512: at "IFSAPP.APPLICATION_SEARCH_INDEX_SYS", line 473
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.CTX_DDL", line 1231
ORA-06512: at "IFSAPP.APPLICATION_SEARCH_INDEX_SYS", line 455
ORA-06512: at "IFSAPP.APPLICATION_SEARCH_SYS", line 743
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 2015
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 282
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 857

 

What can I do here?

 

1 reply

Forum|alt.badge.img+23
  • Author
  • Superhero (Customer)
  • 1169 replies
  • May 13, 2024

In response to this error message, IFS processed the following SQL query:

Grant execute on utl_http to public;

EXEC DBMS_DDL.alter_compile('PACKAGE', 'CTXSYS', 'drvdml');

 

Source:

ORA-20000: Oracle Text error: DRG-50857: oracle error in drvddl.IndexSync ORA-06508: PL/SQL: could not find program unit being called ORA-06512 | IFS Community

 

So the error message isn’t there anymore.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings