Skip to main content

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?

 

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