Error "TCM-00787 A repository error occurred." When Searching for Imaging Documents Within an Application With a Large Volume of Objects (Doc ID 1421114.1)

Last updated on APRIL 17, 2024

Applies to:

Symptoms

Full table scans are caused when using the "*" wildcard in the search prompt for a WebCenter Content: Imaging search.  By using the "*" by itself (unabated) or in conjunction with other search values, a full table scan will be completed. Depending on the number of rows in the table, the system may return rows very slowly, or return errors like "repository error" after a timeout occurs. The "repository error" error is misleading, when the issue is really a recordset full table scan issue.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.