2 Replies Latest reply on Jul 31, 2013 1:46 PM by 806213

    ODI error

    932942
      Hi When i try to join the source table with the lookup table in ODI 11.1.6. I am getting the following error. Can anyone help me with that

      ODI-26066- AN unexpected error has occured

      java.lang.NullPointerException
           at oracle.odi.ui.etlmodeler.dummy.AbstractDummyIInterfaceSubComponent.equals(AbstractDummyIInterfaceSubComponent.java:27)
           at java.util.ArrayList.indexOf(ArrayList.java:216)
           at java.util.ArrayList.contains(ArrayList.java:199)
           at oracle.odi.ui.etlmodeler.model.EtlModel.addDataStoreLinkedElement(EtlModel.java:112)
           at oracle.odi.ui.etlmodeler.model.EtlModel.fillLinkCache(EtlModel.java:99)
           at oracle.odi.ui.etlmodeler.model.EtlModel.loadNode(EtlModel.java:80)
           at oracle.odi.ui.etlmodeler.model.EtlModel.loadNode(EtlModel.java:72)
           at oracle.odi.ui.etlmodeler.model.EtlModel.addNodes(EtlModel.java:154)
           at oracle.odi.ui.etlmodeler.diag.wizard.panel.LookupStep2.wizardValidatePage(LookupStep2.java:414)
           at oracle.bali.ewt.wizard.WizardPage.processWizardValidateEvent(WizardPage.java:710)
           at oracle.bali.ewt.wizard.WizardPage.validatePage(WizardPage.java:680)
           at oracle.bali.ewt.wizard.BaseWizard.validateSelectedPage(BaseWizard.java:2367)
           at oracle.bali.ewt.wizard.BaseWizard._validatePage(BaseWizard.java:3072)
           at oracle.bali.ewt.wizard.BaseWizard.doFinish(BaseWizard.java:2167)
           at oracle.bali.ewt.wizard.BaseWizard$Action$1.run(BaseWizard.java:3940)
           at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:209)
           at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:646)
           at java.awt.EventQueue.access$000(EventQueue.java:84)
           at java.awt.EventQueue$1.run(EventQueue.java:607)
           at java.awt.EventQueue$1.run(EventQueue.java:605)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.awt.EventQueue.dispatchEvent(EventQueue.java:616)
           at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:178)
           at java.awt.Dialog$1.run(Dialog.java:1044)
           at java.awt.Dialog$3.run(Dialog.java:1096)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.awt.Dialog.show(Dialog.java:1094)
           at java.awt.Component.show(Component.java:1584)
           at java.awt.Component.setVisible(Component.java:1536)
           at java.awt.Window.setVisible(Window.java:841)
           at java.awt.Dialog.setVisible(Dialog.java:984)
           at oracle.bali.ewt.wizard.WizardDialog.runDialog(WizardDialog.java:382)
           at oracle.bali.ewt.wizard.WizardDialog.runDialog(WizardDialog.java:298)
           at oracle.ide.wizard.TitledWizardDialog.runDialog(TitledWizardDialog.java:144)
           at oracle.ide.dialogs.WizardLauncher.runDialog(WizardLauncher.java:51)
           at oracle.odi.ui.editor.pop.pane.quickedit.QuickEditLookup.launchLookupWizardFromQuickEdit(QuickEditLookup.java:147)
           at oracle.odi.ui.editor.pop.pane.quickedit.QuickEditLookup.access$0(QuickEditLookup.java:116)
           at oracle.odi.ui.editor.pop.pane.quickedit.QuickEditLookup$1.actionPerformed(QuickEditLookup.java:76)
           at com.sunopsis.graphical.component.toolbar.OdiTableToolbarAction.executeAction(OdiTableToolbarAction.java:200)
           at com.sunopsis.graphical.component.toolbar.AbstractOdiToolbarAction.actionPerformed(AbstractOdiToolbarAction.java:203)
           at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1995)
           at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2318)
           at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:387)
           at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242)
           at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
           at java.awt.AWTEventMulticaster.mouseReleased(AWTEventMulticaster.java:273)
           at java.awt.Component.processMouseEvent(Component.java:6290)
           at javax.swing.JComponent.processMouseEvent(JComponent.java:3267)
           at java.awt.Component.processEvent(Component.java:6055)
           at java.awt.Container.processEvent(Container.java:2039)
           at java.awt.Component.dispatchEventImpl(Component.java:4653)
           at java.awt.Container.dispatchEventImpl(Container.java:2097)
           at java.awt.Component.dispatchEvent(Component.java:4481)
           at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4575)
           at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4236)
           at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4166)
           at java.awt.Container.dispatchEventImpl(Container.java:2083)
           at java.awt.Window.dispatchEventImpl(Window.java:2482)
           at java.awt.Component.dispatchEvent(Component.java:4481)
           at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:648)
           at java.awt.EventQueue.access$000(EventQueue.java:84)
           at java.awt.EventQueue$1.run(EventQueue.java:607)
           at java.awt.EventQueue$1.run(EventQueue.java:605)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:98)
           at java.awt.EventQueue$2.run(EventQueue.java:621)
           at java.awt.EventQueue$2.run(EventQueue.java:619)
           at java.security.AccessController.doPrivileged(Native Method)
           at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessControlContext.java:87)
           at java.awt.EventQueue.dispatchEvent(EventQueue.java:618)
           at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:269)
           at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:184)
           at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:174)
           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:169)
           at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:161)
           at java.awt.EventDispatchThread.run(EventDispatchThread.java:122)
        • 1. Re: ODI error
          odi8329
          Hi

          I have faced similar error in ODI 11.1.1.3.0 and this is the "workaround" I had for such error:

          1. Move the datasets one after another.
          2. Let's say you got that error
          3. Look for the "Perform Layout" Button in the Mapping tab and hit it
          4. You should now see all of your datasets in the mapping diagram.
          5. Do the joins and save it.

          Let me know if it works for you too. Yes its not a permanent solution but a workaround.

          Good Luck!
          • 2. Re: ODI error
            806213

            Hi.

             

            I have the same error message also, but in my case it was when I tried to start a package.

            I have found that there is a patch (Patch 14087811) so I am going to check would it help or not.