Application Monitoring Console shows recurring Application Search errors for the 'Reports' Search Domain specifically ('No master record exists for rowid ... in Search Domain [Reports]', DRG-12604/DRG-50857) — is there a targeted database-level fix rather than a full drop-and-recreate of the whole Search Domain?

All FAQ questions / Platform, Aurena, and customization

Answer

Yes — drop and recreate the specific underlying Oracle Text index tied to that domain directly: DROP INDEX ARCHIVE_TIX; followed by CREATE INDEX ARCHIVE_TIX ON ARCHIVE_TAB (TEXT_ID$) INDEXTYPE IS CTXSYS.CONTEXT;. This targets just the specific index behind the Reports/Archive search domain rather than requiring the broader drop-and-recreate-the-whole-Search-Domain procedure, and clears this specific class of 'no master record exists' indexing error.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Platform, Aurena, and customization questions