ODI Non-supervisor User Receives java.lang.NullPointerException While Executing The OdiReverseSetMetaData Tool During a Customized Reverse Engineering Operation (Doc ID 1982744.1)

Last updated on JUNE 28, 2016

Applies to:

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

Symptoms

A non-supervisor user receives the following message when reverse engineering an Oracle Data Integrator (ODI) Model in customized mode (RKM-based):

java.lang.NullPointerException
  at com.sunopsis.dwg.DwgObject.insertActionUpdateSecurity(DwgObject.java:3567)
  at com.sunopsis.dwg.DwgObject.insert(DwgObject.java:3302)
  at com.sunopsis.dwg.DwgObject.insert(DwgObject.java:3325)
  at com.sunopsis.dwg.reverse.Reverse.setMetaDataTable(Reverse.java:4331)
  at com.sunopsis.dwg.reverse.Reverse.setMetaData(Reverse.java:3052)
  at com.sunopsis.dwg.tools.ReverseSetMetaData.actionExecute(ReverseSetMetaData.java:71)
  at com.sunopsis.dwg.function.SnpsFunctionBaseRepositoryConnected.execute(SnpsFunctionBaseRepositoryConnected.java:162)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.execIntegratedFunction(SnpSessTaskSql.java:3450)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.executeOdiCommand(SnpSessTaskSql.java:1511)
  at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:44)
  at oracle.odi.runtime.agent.execution.cmd.OdiCommandExecutor.execute(OdiCommandExecutor.java:1)
  at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.processTask(SnpSessTaskSql.java:2926)
  at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2638)
  at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(SnpSessStep.java:558)
  at com.sunopsis.dwg.dbobj.SnpSessStep.treatSessStep(SnpSessStep.java:464)
  at com.sunopsis.dwg.dbobj.SnpSession.treatSession(SnpSession.java:2078)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$2.doAction(StartSessRequestProcessor.java:368)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:216)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.doProcessStartSessTask(StartSessRequestProcessor.java:302)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor.access$0(StartSessRequestProcessor.java:294)
  at oracle.odi.runtime.agent.processor.impl.StartSessRequestProcessor$StartSessTask.doExecute(StartSessRequestProcessor.java:865)
  at oracle.odi.runtime.agent.processor.task.AgentTask.execute(AgentTask.java:126)
  at oracle.odi.runtime.agent.support.DefaultAgentTaskExecutor$2.run(DefaultAgentTaskExecutor.java:85)
  at java.lang.Thread.run(Thread.java:662)

Further investigation locates the problem at OdiReverseSetMetaData level.

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