2 Replies Latest reply: Dec 7, 2012 10:10 AM by 978225 RSS

    NullPointerException when importing database objects from XE database

    978225
      I have a 11.2 EE DB with OWB installed locally on a developer machine.
      I also have a remote Oracle DB 11 XE (lets call it "RDB1").

      In OWB, I have defined an Oracle Location "OL1" pointing to RDB1 and an Oracle Database Module "DBM1", which is using OL1 as location.
      When I try to import the database objects for DBM1 in the OWB design center, I get a NullPointerException.
      I do get a "SUCCESSFUL" location connection test, so that should not be the problem.

      Trying to do the database objects import several times, I got two different types of NullpointerExceptions. Mostly the first one without the stacktrace, but one time I also got the stack trace.
      I am not sure why this is.

      Could the reason for the NullPointerException be the fact that the remote DB is an XE Edition without any OWB components installed?
      I am not sure if database objects import would require the Control Center Service installed and running on RDB1.

      On the local DB, I created a materialized view of a table on RDB1 through a database link, and importing the database objects from that does work without problems.


      The OWB logs show this (the one without stacktrace):
      --------------------
           Thu Dec 06 20:48:01 CET 2012
           Import service failed when try to make connection to metadata location and got the following error:java.lang.NullPointerException.

      and this (the one with stacktrace):
      --------------------
           Thu Dec 06 18:23:57 CET 2012

           java.lang.NullPointerException
           java.lang.NullPointerException
           java.lang.NullPointerException
                at oracle.wh.ui.integrator.oracle.WBOracleFilterPanel.buildPanel(WBOracleFilterPanel.java:209)
                at oracle.wh.ui.integrator.oracle.WBOracleFilterPanel.<init>(WBOracleFilterPanel.java:120)
                at oracle.wh.ui.integrator.oracle.WBOracleMetaData.showFilterUI(WBOracleMetaData.java:194)
                at oracle.wh.ui.integrator.common.ImportService.showFilterPanel(ImportService.java:426)
                at oracle.wh.ui.integrator.common.wizards.ImportWizardPanel.onEnterFilterPanel(ImportWizardPanel.java:143)
                at oracle.wh.ui.integrator.common.wizards.ImportWizardPanel.onEnter(ImportWizardPanel.java:107)
                at oracle.wh.ui.owbcommon.OWBWizard.wizardSelectionChanged(OWBWizard.java:1081)
                at oracle.bali.ewt.wizard.BaseWizard.processWizardEvent(Unknown Source)
                at oracle.bali.ewt.wizard.BaseWizard.processEventImpl(Unknown Source)
                at oracle.bali.ewt.LWComponent.processEvent(Unknown Source)
                at oracle.bali.ewt.wizard.BaseWizard.selectPage(Unknown Source)
                at oracle.bali.ewt.wizard.BaseWizard.doNext(Unknown Source)
                at oracle.bali.ewt.wizard.BaseWizard$Action.actionPerformed(Unknown Source)
                at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
                at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
                at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
                at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
                at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:236)
                at java.awt.Component.processMouseEvent(Component.java:5517)
                at javax.swing.JComponent.processMouseEvent(JComponent.java:3135)
                at java.awt.Component.processEvent(Component.java:5282)
                at java.awt.Container.processEvent(Container.java:1966)
                at java.awt.Component.dispatchEventImpl(Component.java:3984)
                at java.awt.Container.dispatchEventImpl(Container.java:2024)
                at java.awt.Component.dispatchEvent(Component.java:3819)
                at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212)
                at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)
                at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
                at java.awt.Container.dispatchEventImpl(Container.java:2010)
                at java.awt.Window.dispatchEventImpl(Window.java:1791)
                at java.awt.Component.dispatchEvent(Component.java:3819)
                at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
                at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
                at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
                at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:153)
                at java.awt.Dialog$1.run(Dialog.java:535)
                at java.awt.Dialog$2.run(Dialog.java:565)
                at java.security.AccessController.doPrivileged(Native Method)
                at java.awt.Dialog.show(Dialog.java:563)
                at java.awt.Component.show(Component.java:1302)
                at java.awt.Component.setVisible(Component.java:1255)
                at oracle.bali.ewt.wizard.WizardDialog.runDialog(Unknown Source)
                at oracle.bali.ewt.wizard.WizardDialog.runDialog(Unknown Source)
                at oracle.wh.ui.owbcommon.OWBWizard.initialize(OWBWizard.java:834)
                at oracle.wh.ui.owbcommon.OWBWizard.<init>(OWBWizard.java:202)
                at oracle.wh.ui.owbcommon.OWBWizard.<init>(OWBWizard.java:184)
                at oracle.wh.ui.owbcommon.IdeUtils._doShowWizardDefinition(IdeUtils.java:1247)
                at oracle.wh.ui.owbcommon.IdeUtils.showWizard(IdeUtils.java:487)
                at oracle.wh.ui.integrator.common.CommonController$1ImportDialogListener.actionPerformed(CommonController.java:127)
                at oracle.wh.service.sdk.OWBConsumer.dataItemAvailable(OWBInfoBus.java:381)
                at javax.infobus.DefaultController.fireItemAvailable(DefaultController.java:90)
                at javax.infobus.InfoBus.fireItemAvailable(InfoBus.java:989)
                at oracle.wh.service.sdk.OWBInfoBus.produce(OWBInfoBus.java:160)
                at oracle.wh.service.sdk.OWBInfoBus.produce(OWBInfoBus.java:76)
                at oracle.wh.ui.console.commands.TreeMenuHandler.notify(TreeMenuHandler.java:104)
                at oracle.wh.ui.console.commands.ModuleImportCmd.performAction(ModuleImportCmd.java:189)
                at oracle.owbimpl.ide.menu.TreeMenuHandlerAdapter.handleEvent(TreeMenuHandlerAdapter.java:46)
                at oracle.ide.controller.IdeAction.performAction(IdeAction.java:524)
                at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:866)
                at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:496)
                at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1849)
                at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2169)
                at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:420)
                at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258)
                at javax.swing.AbstractButton.doClick(AbstractButton.java:302)
                at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:1051)
                at javax.swing.plaf.basic.BasicPopupMenuUI$Actions.doReturn(BasicPopupMenuUI.java:441)
                at javax.swing.plaf.basic.BasicPopupMenuUI$Actions.actionPerformed(BasicPopupMenuUI.java:415)
                at javax.swing.SwingUtilities.notifyAction(SwingUtilities.java:1571)
                at javax.swing.JComponent.processKeyBinding(JComponent.java:2772)
                at javax.swing.KeyboardManager.fireBinding(KeyboardManager.java:255)
                at javax.swing.KeyboardManager.fireKeyboardAction(KeyboardManager.java:204)
                at javax.swing.JComponent.processKeyBindingsForAllComponents(JComponent.java:2849)
                at javax.swing.JComponent.processKeyBindings(JComponent.java:2841)
                at javax.swing.JComponent.processKeyEvent(JComponent.java:2735)
                at java.awt.Component.processEvent(Component.java:5294)
                at java.awt.Container.processEvent(Container.java:1966)
                at java.awt.Component.dispatchEventImpl(Component.java:3984)
                at java.awt.Container.dispatchEventImpl(Container.java:2024)
                at java.awt.Component.dispatchEvent(Component.java:3819)
                at java.awt.KeyboardFocusManager.redispatchEvent(KeyboardFocusManager.java:1826)
                at java.awt.DefaultKeyboardFocusManager.dispatchKeyEvent(DefaultKeyboardFocusManager.java:681)
                at java.awt.DefaultKeyboardFocusManager.preDispatchKeyEvent(DefaultKeyboardFocusManager.java:938)
                at java.awt.DefaultKeyboardFocusManager.typeAheadAssertions(DefaultKeyboardFocusManager.java:810)
                at java.awt.DefaultKeyboardFocusManager.dispatchEvent(DefaultKeyboardFocusManager.java:645)
                at java.awt.Component.dispatchEventImpl(Component.java:3857)
                at java.awt.Container.dispatchEventImpl(Container.java:2024)
                at java.awt.Window.dispatchEventImpl(Window.java:1791)
                at java.awt.Component.dispatchEvent(Component.java:3819)
                at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
                at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread.java:242)
                at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:163)
                at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)
                at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)
                at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)

      Edited by: 975222 on 06.12.2012 12:42

      Edited by: 975222 on 06.12.2012 12:43