Null Pointer Exception is Received in ODI 12c when Attempting to Use a Hint (Doc ID 2381541.1)

Last updated on AUGUST 17, 2020

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

Cause

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