Search Index Takes a Long Time To Complete (Doc ID 2067870.1)

Last updated on DECEMBER 22, 2016

Applies to:

Oracle ATG Web Commerce Search - Version 10.0 and later
Information in this document applies to any platform.

Symptoms

Full search indexes, although always successful, don't complete in a consistent amount of time. Sometimes they take a long time (5 hours) and sometimes complete in a shorter period (2 hours).

The search index file gets copied into the index directory but the BCC shows the index is still running. It appears that the bulk of the indexing time is spent marking the status as done.

The deployment thread itself is looping and appears to constantly reading the ROUT_DEP_HIST table in the database using the following SQL:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms