My Oracle Support Banner

Search for ODI Objects Results in "ODI-26112: Error While Performing The Search" (Doc ID 2400621.1)

Last updated on JULY 16, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 to 12.1.3.0.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

When attempting to search for objects on the Operator tab in Oracle Data Integrator (ODI) Studio 12c versions up to 12.2.1.3.0, the following error is received:

ODI-26112: Error while performing the search ORA-00942: table or view does not exist

The problem can be reproduced with the following steps:

  1. In ODI Studio, go to the Operator tab and click on any object to highlight it.
  2. Select the Search option in the drop down menu, and select "Find ODI Object".
  3. In the "Find ODI Object" panel, enter any string that matches an existing Operator object.
  4. There will be no results with repositories.
  5. However, when performing the above steps from the Designer tab you will see results.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.