Null Pointer Exception is Received in ODI 12c when Attempting to Use a Hint

Last updated on APRIL 10, 2018

Applies to:

Symptoms

After unchecking a Hint flag in an Oracle Data Integrator (ODI) 12c Mapping, users cannot simulate the Mapping execution to gather the information to utilize hints to lower the cost of execution.

The following error occurs when attempting to simulate the Mapping execution:

java.lang.RuntimeException: oracle.odi.mapping.generation.GenerationException: Error when calling generation delegate for component KM XKM Oracle Extract: null
Caused by: JNPE
  at oracle.odi.mapping.generation.OracleSqlQuery.setSelectHints(OracleSqlQuery.java:204)
  at com.sunopsis.graphical.dialog.SnpsDialogExecution$1.doAction(SnpsDialogExecution.java:914)
  at oracle.odi.core.persistence.dwgobject.DwgObjectTemplate.execute(DwgObjectTemplate.java:203)
  at oracle.odi.core.persistence.dwgobject.TransactionalDwgObjectTemplate.execute(TransactionalDwgObjectTemplate.java:64)
  at com.sunopsis.graphical.dialog.SnpsDialogExecution.doPackageExecuter(SnpsDialogExecution.java:845)
  at oracle.odi.ui.action.SnpsPopupActionExecuteHandler.actionPerformed(SnpsPopupActionExecuteHandler.java:154)
  at oracle.odi.ui.SnpsFcpActionAdapter.handleEvent(SnpsFcpActionAdapter.java:366)
  at oracle.ide.controller.IdeAction$ControllerDelegatingController.handleEvent(IdeAction.java:1488)
  at oracle.ide.controller.IdeAction.performAction(IdeAction.java:663)
  at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:1159)
  at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:618)
  at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
  at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
  at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
  at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
  at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
  at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:290)
  at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:289)
  at java.awt.Component.processMouseEvent(Component.java:6533)
  at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
  at java.awt.Component.processEvent(Component.java:6298)
  at java.awt.Container.processEvent(Container.java:2236)
  at java.awt.Component.dispatchEventImpl(Component.java:4889)
  at java.awt.Container.dispatchEventImpl(Container.java:2294)
  at java.awt.Component.dispatchEvent(Component.java:4711)
  at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
  at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
  at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
  at java.awt.Container.dispatchEventImpl(Container.java:2280)
  at java.awt.Window.dispatchEventImpl(Window.java:2746)
  at java.awt.Component.dispatchEvent(Component.java:4711)
  at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
  at java.awt.EventQueue.access$500(EventQueue.java:97)
  at java.awt.EventQueue$3.run(EventQueue.java:709)
  at java.awt.EventQueue$3.run(EventQueue.java:703)
  at java.security.AccessController.doPrivileged(Native Method)
  at ...

Changes

Cause