Question

Create Keyword Search

  • 8 July 2022
  • 1 reply
  • 226 views

Userlevel 3
Badge +6

Background: Our users would like “Keyword Search's” enabled for Customers window, Quotes window, etc.…

Problem: Each Keyword Search must have enabled “Search Domain” which contains three jobs: Synchronized, Optimized, and Rebuilt. The last job, Rebuilt, is failing. The Error Text is below (I’ve removed the App User ID from Error Text, as seen in blue highlight):

ORA-29874: warning in the execution of ODCIINDEXALTER routine

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 2025

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 508

ORA-29960: line 1,

DRG-10595: ALTER INDEX CUSTOMER_TIX failed

DRG-50857: oracle error in drepopen

ORA-04063: package body "CTXSYS.DRVDML" has errors

ORA-06508: PL/SQL: could not find program unit being called: "CTXSYS.DRVDML"

ORA-06512: at line 1

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 497

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_SYS", line 778

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SQL", line 1721

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 2015

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 282

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 2025

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 508

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_INDEX_SYS", line 497

ORA-06512: at "APPOWNERNAME.APPLICATION_SEARCH_SYS", line 778

ORA-06512: at line 1

ORA-06512: at "SYS.DBMS_SQL", line 1721

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 2015

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 282

ORA-06512: at "APPOWNERNAME.TRANSACTION_SYS", line 857

 

Request: Assuming my problem statement is correct, how do we correct this failing job?

Notes:

1.) There are other posts regarding Keyword Searches, such as, Search with Keywords does not work in Customer database - APP10 | IFS Community, however, my post is seeking why this job fails.

2.) Attached screen shot for Keyword Search, Search Domain, Rebuilt Job.


1 reply

Badge +3

Hi Toni,

 

This is happening from the Oracle end and it has been investigated previously by Oracle support.

As a workaround, please execute the following two statements log in as SYS user; which would first grant UTL_HTTP package to CTXSYS & then compile the invalid DRVDML package.

In a multitenant (CDB) environment, connect as SYS to Container DB (not to PDB).

GRANT EXECUTE ON UTL_HTTP TO CTXSYS;

ALTER PACKAGE CTXSYS.DRVDML COMPILE BODY;

Once done, disable & enable the search domains again.

If you are in Windows platform , please run the below statements connecting to PBD as well (as SYSDBA)

GRANT EXECUTE ON UTL_HTTP TO CTXSYS;

 ALTER PACKAGE CTXSYS.DRVDML COMPILE BODY;

(Once done, disable & enable the search domains again.)

Reply