My Oracle Support Banner

"ODI-10082: You are not authorized to View the Object: SQL:: Drop work table " Error When Running a Job in ODI 11.1.1.7 (Doc ID 2103253.1)

Last updated on MAY 12, 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

Running a Scenario or LoadPlan containing an Interface by a user that has Connect and Operator profiles fails at step "Drop Work Table", and the code to drop the table is not generated:

2015-11-13 16:45:49.593 WARNING ODI-1134 Agent Internal encountered an error: ODI-17517: Error during task interpretation.
Task: 1
java.lang.Exception: The application script threw an exception: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getObjectName("L", "%COL_PRF0EMPLOYEES", "W") : com.sunopsis.core.SecurityAccessException: ODI-10082: You are not authorized to View the Object: SQL: 1999 BSF info: Drop work table at line: 0 column: columnNo
at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:489)
at com.sunopsis.dwg.dbobj.SnpSessStep.createTaskLogs(SnpSessStep.java:737)
at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:465)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2128)
at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:1930)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$2.doAction(StartScenRequestProcessor.java:580)
at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor.doProcessStartScenTask(StartScenRequestProcessor.java:513)
at oracle.odi.runtime.agent.processor.impl.StartScenRequestProcessor$StartScenTask.doExecute(StartScenRequestProcessor.java:1073)
at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:82)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.Exception: The application script threw an exception: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getObjectName("L", "%COL_PRF0EMPLOYEES", "W") : com.sunopsis.core.SecurityAccessException: ODI-10082: You are not authorized to View the Object: SQL: 1999 BSF info: Drop work table at line: 0 column: columnNo
at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:476)
... 11 more
Caused by: org.apache.bsf.BSFException: The application script threw an exception: com.sunopsis.tools.core.exception.SnpsSimpleMessageException: Exception getObjectName("L", "%COL_PRF0EMPLOYEES", "W") : com.sunopsis.core.SecurityAccessException: ODI-10082: You are not authorized to View the Object: SQL: 1999 BSF info: Drop work table at line: 0 column: columnNo
at bsh.util.BeanShellBSFEngine.eval(Unknown Source)
at bsh.util.BeanShellBSFEngine.exec(Unknown Source)
at com.sunopsis.dwg.codeinterpretor.SnpCodeInterpretor.transform(SnpCodeInterpretor.java:471)
... 11 more

Text: drop table <?=snpRef.getObjectName("L", "%COL_PRF0EMPLOYEES", "W") ?> purge.

 

The issue might be intermittent if the Supervisor logged in for a while using the same Studio client. Starting up odi Studio with -clean option will clear the cache and issue will reproduce.
  $ODI_HOME/oracledi/client/odi[64][.exe|.sh] -clean

 

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
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.