My Oracle Support Banner

ODI Load Plan Execution Error "com.sunopsis.core.SecurityAccessException: ODI-10082: You are not authorized to View the Object: SQL: 14" (Doc ID 2665324.1)

Last updated on JUNE 15, 2020

Applies to:

Oracle Data Integrator - Version 12.2.1.3.0 and later
Information in this document applies to any platform.

Symptoms

An ODI load plan is failing with the following error when executing a variable refresh:

ODI-1519: Serial step "<Serial Step Name> (InternalID:<id#>)" failed because child step "<child step>(76876) (InternalID:<id#>)" is in error.
ODI-1519: Serial step "<SERIAL_STEP_NAME>(76876) (InternalID:<INTERNAL_ID>)" failed because child step "Case Variable: <VARIABLE_NAME>(InternalID:<INTERNAL_ID>)" is in error.
ODI-1529: Refresh of variable "<VARIABLE_NAME>" failed :
null
ODI-1528: Error refreshing variable "<VARIABLE_NAME>": oracle.odi.core.exception.OdiRuntimeException: com.sunopsis.tools.core.exception.SnpsSimpleNLSMessageException: ODI-17810: Error during BeanShell evaluation: The application script threw an exception: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getObjectName("L", "ODISRC", "D") : com.sunopsis.core.SecurityAccessException: ODI-10082: You are not authorized to View the Object: SQL: 14 BSF info: at line: 0 column: columnNo, Pre-execution code:
out.print("SELECT '<?=odiRef.getObjectName("L", "ODISRC", "D") ?>' FROM dual ") ;

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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