'ODI-10082: You are not authorized to View the Object: SnpSubLang.Aggregation.label: 9999' When Executing a Scenario or a Load Plan in ODI 11.1.1.7 (Doc ID 2028563.1)

Last updated on MARCH 10, 2017

Applies to:

Oracle Data Integrator - Version 11.1.1.7.0 to 11.1.1.7.0 [Release 11gR1]
Information in this document applies to any platform.

Symptoms

Customer has an interface that transfers data from one database to another, in ODI 11.1.1.7.
Based on this interface, a Scenario and a Load Plan were created and are executed using a Standalone Agent.

Additionally a new profile was created, named "CUSTOM OPERATOR" by duplicating the OPERATOR profile and the following methods / privileges were added:

These privileges were set up as "Generic Privilege".
The profile "CUSTOM OPERATOR" was assigned to user "CUSTOM_OPERATOR", along with the "CONNECT" profile.

After restarting the Standalone Agent and connecting with user "CUSTOM_OPERATOR" in ODI Studio, when executing the Load Plan the error below occurs:

If connecting in ODI Studio with SUPERVISOR user and executing the Load Plan, it executes successfully.

After that, connecting with user CUSTOM_OPERATOR in ODI Studio and executing the the Load Plan, it also executes successfully.

If the Standalone Agent is restarted, the Load Plan execution will fail again (with the error above) when connecting with the user CUSTOM_OPERATOR in ODI Studio.

Whenever the Standalone Agent is restarted, the Load Plan execution will fail when executing it with the CUSTOM_OPERATOR user.

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