Question

ORA-20000: Oracle Text error in background job

  • 10 May 2024
  • 1 reply
  • 27 views
Link
Rank
Userlevel 7
Badge +22
  • Link
  • Superhero (Customer)
  • 935 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?

 

Kind regards

1 reply

Link
Rank
Userlevel 7
Badge +22

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.

Kind regards

Reply


Terms & ConditionsCookie settings