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 FEBRUARY 17, 2016

Applies to:

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

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

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