+5
Dear Sirs;
Newly implementation IFS 10UPD8 being started at new customer.
The following error message is showed at backgroud job detail.
“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”
It seems like to be Oracle setup issue, but NOT IFS.
Please anyone advice me to solve.
Regards;
Susumu
+15
Hi
Could you please let us know which background job throws an error like this? Do you use document search indexes in your environment? You can go to Search domains Window on the application and see if you have Docman enabled in your system
+18
Hi Susumu,
You are right, this is an Oracle related issue affecting version 19c databases created using IFS DBCA template.
Issue: A known IFS Oracle bug when the database is first created in version 19c.
A missing permission invalidates an Oracle database package IFS relies for background jobs, scheduled tasks etc
More details: Package in question - CTXSYS.drvdml
Missing permission set - grant execute on utl_http to public;
This issue can re-occur when an IFS Update is installed as well.
Solution: A SYS Oracle user, add the missing grant in the database:
SQL> grant execute on utl_http to public;
Recompile CTXSYS.drvdml Package and make sure the status shows VALID
This should take care of the errors you are getting in IFS.
+18
Would IFSSYS, FND_RUNTIME, or some other grantee be more appropriate? UTL_HTTP could be used to send data to malicious web sites, so PUBLIC feels too broad.
http://www.dba-oracle.com/t_revoke_execute_from_public.htm
+18
The above grant is an exact solution listed in Oracle’s Metalink Document, covering this particular issue.
The grant isn’t applied to any IFS related objects/users. May be it can be assigned to CTXSYS user instead of public to see whether the package can be compiled.
I had this problem also and granting execute on package UTL_HTTP to only user CTXSYS solved the issue.
+4
Hi Susumu,
Does the problem solved from those suggestions?
Cheers,
Sutoto
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
