Search on ODI Objects Results in "ODI-26112: Error While Performing Search For ODI Sessions" From the Operator Tab on MS SQL Server

(Doc ID 2302403.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Data Integrator - Version 12.2.1.1.0 to 12.2.1.3.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 12.2.1.1.0, from a repository on MS SQL Server, the following error is displayed:

ODI-26112: Error while performing the search - Table or View does not exists.

NOTE: This error is being triggered only when ODI repositories are created in SQL Server database. This case is not seen when ODI repositories are created in Oracle database.

The problem can be reproduced with the following steps:

  1. In ODI Studio, go to the Operator tab.
  2. Click on any object to highlight it.
  3. Click on Search option in the drop down menu bar and select 'Find ODI Object.'
  4. In the 'Find ODI Object' panel, enter any string that matches an existing object.
  5. There will be no results with repositories on a MS SQL Server database and you will get the above error.
  6. However, if you perform the search from the Designer tab, or with a non-MS SQL Server database, you will see results.

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