3 Replies Latest reply on May 14, 2019 10:54 PM by Glen Conway

    Can no longer Export

    bobby.hussey

      When trying to Export data by right clicking and selecting Export. I'm getting the below error. This worked recently and I am not aware of any changes.

       

      'Internal Error when attempting to create this panel:'

       

      java.lang.reflect.InvocationTargetException

      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

      at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

      at oracle.ide.panels.MetaTraversable.newTraversable(MetaTraversable.java:315)

      at oracle.ide.wizard.Step.newTraversable(Step.java:171)

      at oracle.ide.wizard.FSMStateInfo.getTraversable(FSMStateInfo.java:99)

      at oracle.ide.wizard.FSMWizard._addPage(FSMWizard.java:580)

      at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:534)

      at oracle.ide.wizard.FSMWizard.<init>(FSMWizard.java:121)

      at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchWizard(ExportWizMain.java:226)

      at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchForGrid(ExportWizMain.java:204)

      at oracle.dbtools.raptor.dialogs.actions.TableExportAction.launchForGrid(TableExportAction.java:73)

      at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:165)

      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.AbstractButton.doClick(AbstractButton.java:376)

      at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)

      at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)

      at java.awt.Component.processMouseEvent(Component.java:6535)

      at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)

      at java.awt.Component.processEvent(Component.java:6300)

      at java.awt.Container.processEvent(Container.java:2236)

      at java.awt.Component.dispatchEventImpl(Component.java:4891)

      at java.awt.Container.dispatchEventImpl(Container.java:2294)

      at java.awt.Component.dispatchEvent(Component.java:4713)

      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:2750)

      at java.awt.Component.dispatchEvent(Component.java:4713)

      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 java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)

      at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)

      at java.awt.EventQueue$4.run(EventQueue.java:731)

      at java.awt.EventQueue$4.run(EventQueue.java:729)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)

      at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

      at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

      at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)

      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

      at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

      Caused by: java.lang.NullPointerException

      at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectory(URLFileChooser.java:507)

      at oracle.dbtools.raptor.ui.URLFileChooser.setToFirstContextPathDirectory(URLFileChooser.java:1495)

      at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1471)

      at oracle.dbtools.raptor.ui.URLFileChooser.setDefaultPathContext(URLFileChooser.java:1537)

      at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:130)

      at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:114)

      at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:110)

      at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:106)

      at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.<init>(URLFileChooser.java:831)

      at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.<init>(URLFileChooser.java:889)

      at oracle.dbtools.raptor.ui.URLFileChooser.createURLFileChooserPanel(URLFileChooser.java:794)

      at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(TargetOptionsPanel.java:237)

      at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:63)

      at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:55)

      at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.<init>(ExportWizDestinstaionPanel.java:98)

      ... 54 more

      java.lang.NullPointerException

      at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectory(URLFileChooser.java:507)

      at oracle.dbtools.raptor.ui.URLFileChooser.setToFirstContextPathDirectory(URLFileChooser.java:1495)

      at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1471)

      at oracle.dbtools.raptor.ui.URLFileChooser.setDefaultPathContext(URLFileChooser.java:1537)

      at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:130)

      at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:114)

      at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:110)

      at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:106)

      at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.<init>(URLFileChooser.java:831)

      at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.<init>(URLFileChooser.java:889)

      at oracle.dbtools.raptor.ui.URLFileChooser.createURLFileChooserPanel(URLFileChooser.java:794)

      at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(TargetOptionsPanel.java:237)

      at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:63)

      at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:55)

      at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.<init>(ExportWizDestinstaionPanel.java:98)

      at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

      at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

      at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

      at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

      at oracle.ide.panels.MetaTraversable.newTraversable(MetaTraversable.java:315)

      at oracle.ide.wizard.Step.newTraversable(Step.java:171)

      at oracle.ide.wizard.FSMStateInfo.getTraversable(FSMStateInfo.java:99)

      at oracle.ide.wizard.FSMWizard._addPage(FSMWizard.java:580)

      at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:534)

      at oracle.ide.wizard.FSMWizard.<init>(FSMWizard.java:121)

      at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchWizard(ExportWizMain.java:226)

      at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchForGrid(ExportWizMain.java:204)

      at oracle.dbtools.raptor.dialogs.actions.TableExportAction.launchForGrid(TableExportAction.java:73)

      at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:165)

      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.AbstractButton.doClick(AbstractButton.java:376)

      at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)

      at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)

      at java.awt.Component.processMouseEvent(Component.java:6535)

      at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)

      at java.awt.Component.processEvent(Component.java:6300)

      at java.awt.Container.processEvent(Container.java:2236)

      at java.awt.Component.dispatchEventImpl(Component.java:4891)

      at java.awt.Container.dispatchEventImpl(Container.java:2294)

      at java.awt.Component.dispatchEvent(Component.java:4713)

      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:2750)

      at java.awt.Component.dispatchEvent(Component.java:4713)

      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 java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)

      at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)

      at java.awt.EventQueue$4.run(EventQueue.java:731)

      at java.awt.EventQueue$4.run(EventQueue.java:729)

      at java.security.AccessController.doPrivileged(Native Method)

      at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)

      at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

      at oracle.javatools.internal.ui.EventQueueWrapper._dispatchEvent(EventQueueWrapper.java:169)

      at oracle.javatools.internal.ui.EventQueueWrapper.dispatchEvent(EventQueueWrapper.java:151)

      at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)

      at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

      at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

      at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

        • 1. Re: Can no longer Export
          Glen Conway

          According to the stack trace, your error is caused by

          Caused by: java.lang.NullPointerException

          at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectory(URLFileChooser.java:507)

          at oracle.dbtools.raptor.ui.URLFileChooser.setToFirstContextPathDirectory(URLFileChooser.java:1495)

          at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1471)

          at oracle.dbtools.raptor.ui.URLFileChooser.setDefaultPathContext(URLFileChooser.java:1537)

          at oracle.dbtools.raptor.ui.URLFileChooser.<init>(URLFileChooser.java:130)

          In step 1 of the Export Wizard, my default directory is just C:\Users\<my_userid>, which is also the value of my user.home property in Help -> About -> Properties.  Maybe something changed in your environment related to that?

          • 2. Re: Can no longer Export
            bobby.hussey

            The default directory and user.home match C:\Users\<my_userid>

            • 3. Re: Can no longer Export
              Glen Conway

              Perhaps someone on the SQL Developer team can look into exactly which object is null in line 507, and comment on how it might have suddenly gotten that way in your environment.  Not sure if system administrators can restrict which applications can access the user settings folder.

               

              As a test to see whether the Export panel will appear as expected if the user.home is overridden, just add something like

              AddVMOption -Duser.home=C:\Temp

              to the sqldeveloper.conf file in your SQL Developer installation's sqldeveloper\sqldeveloper\bin folder.

               

              Edit:  If I change user.home to a non-existent folder, like C:\XTempX, then the default folder changes to C:\ and the export fails since Windows presumably does not want us writing random files there and cluttering it up.

              Capture.JPG