My Oracle Support Banner

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 SEPTEMBER 28, 2022

Applies to:

Oracle WebCenter Content: Imaging - Version and later
Information in this document applies to any platform.


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.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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