7 Replies Latest reply on Sep 25, 2015 7:59 PM by tfa

    Export dialog suddenly stopped working (internal error)

    anders_hedberg

      Sql Developer v4.1.0.18 Build MAIN-18.37

       

      The export data dialog (right-clicking in a query result) suddenly stopped working this morning. The dialog window where I normally get to choose a file format and destination refuses to say anything other than "Internal Error when attempting to create this panel", followed by a big chunk of java-related stuff:

      sql developer 4.1.1 export dialog.jpg

      Everything was fine yesterday. Can someone help me get this fixed, or point me in the right direction?

       

      If I launch an older version (v4.0.0.13 Build MAIN-13.80) the export dialog works as expected...

        • 1. Re: Export dialog suddenly stopped working (internal error)
          Gary Graham-Oracle

          If it worked yesterday, something must have changed...

          1. Did the Java version in use change?

          2. Did you suffer any disk corruption or delete anything from the SQL Developer installation?

          3. And, in the stack trace, is there any reference to Caused by?

           

          As the error is buried so deep, is so low level, and the older version works, your best bet is probably to download and install the latest production release...

          Oracle SQL Developer Downloads

           

          Note that neither of the two versions you mention are production releases. For the respective releases, those would be...

          4.0    -- 4.0.3.16.84

          4.1.0 -- 4.1.0.19.07

          4.1.1 -- 4.1.1.19.59

          • 2. Re: Export dialog suddenly stopped working (internal error)
            anders_hedberg

            Thanks for your answer. Yes, I realize that something must have changed overnight but I cannot figure out what.

            To my knowledge, I haven't touched the Java version, deleted anything from the SQL Developer installation or suffered any disk corruption.

             

            I just downloaded the latest production release, 4.1.1.19.59 (Windows 64-bit with JDK 8 included) - which gives me the same error.

             

            As for "Caused by", I'va pasted the full stack trace below. It says something about "URLFileChooser" which sounds like my problem:

             

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

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

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

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

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

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

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

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

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

                at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898)

                at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)

                at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)

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

                at java.awt.Window.dispatchEventImpl(Window.java:2750)

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

                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$1.doIntersectionPrivilege(ProtectionDomain.java:75)

                at java.security.ProtectionDomain$1.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$1.doIntersectionPrivilege(ProtectionDomain.java:75)

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

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

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

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

                ... 54 more

            java.lang.NullPointerException

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

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

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

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

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

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

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

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

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

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

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

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

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

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

                at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4898)

                at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4533)

                at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4462)

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

                at java.awt.Window.dispatchEventImpl(Window.java:2750)

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

                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$1.doIntersectionPrivilege(ProtectionDomain.java:75)

                at java.security.ProtectionDomain$1.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$1.doIntersectionPrivilege(ProtectionDomain.java:75)

                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)

            • 3. Re: Export dialog suddenly stopped working (internal error)
              Gary Graham-Oracle

              Try checking if Tools > Preferences > Database > Utilities > Export > Directory points to a directory that exists and to which you have write access, both for the 4.1.1 you just installed and the old v4.0.0.13 Build MAIN-13.80 install where the export feature works as expected.  Possibly the user settings did not get migrated or initialized properly.

              • 4. Re: Export dialog suddenly stopped working (internal error)
                anders_hedberg

                Thanks again for trying to help me figure this out.

                 

                I cannot see the option/node "Directory" that you refer to under Tools > Preferences > Database > Utilities > Export:

                sql developer preferences.jpg

                Actually, I cannot find a "Directory" entry anywhere in the Preferences.

                Note: if I click on the "Import" node below "Export", an error message similar to the export dialog one appears ("Internal Error..:" / java.lang.NullPointerException)... Same thing with the "SSH" node near the end of the preferences.

                 

                At this point, I would like to try a fresh, clean install of SQL Developer, but since there is no uninstall option (actually there is no install either, since you just unpack a zip file) stuff (in his case: messed up stuff) will most likely remain in the Registry. Any idea on how to wipe out a version (since I still have one working version) of SQL Developer completely from a Windows machine? :-)

                • 5. Re: Export dialog suddenly stopped working (internal error)
                  Gary Graham-Oracle

                  Any idea on how to wipe out a version

                  There is no registry aspect to a SQL Developer install.  Only...

                  1. The folder into which you install SQL Developer.  You should always unzip into an empty folder, of course.

                  2. The folder containing the user settings (either the default, initial settings, or settings migrated from one of the earlier installs).

                   

                  For WIndows Vista & up, for example, by default the user settings for all SQL Developer installs may be found under %APPDATA%\SQL Developer.

                  The %APPDATA% is something like C:\Users\<your_userid>\AppData\Roaming.  Win XP used a slightly different naming convention.  Each install has a separate folder for its user settings of the form systemN.N.N.N.N.  Keep in mind that AppData is one of those Windows hidden folders.

                   

                  So the current production install will have user settings in C:\Users\<your userid>\AppData\Roaming\SQL Developer\system4.1.1.19.59.

                  For SQL Developer 4.0 & up, there is also a separate C:\Users\<your userid>\AppData\Roaming\sqldeveloper\...\product.conf to point to the JDK.

                   

                  It is always a good idea to export your connection definitions for an install prior to nuking its systemN.N.N.N.N folders.

                   

                  So, removing a SQL Developer install is as simple as removing the install directory and the user settings directory for that version.

                   

                  By the way, the Export Utility preferences page for 4.0.0.13.80 (and 4.1.1.19.59 is the same) should look like...

                  ExportDirPref.jpg

                  • 6. Re: Export dialog suddenly stopped working (internal error)
                    anders_hedberg

                    Thanks again for your help!

                     

                    I wiped out the directories for version 4.1.1.19.59, then restarted and skipped importing connections and settings from the previous version. After that, I imported only the connections.

                    And viola! - now everything seems to work as expected again! I'll have to spend a few minutes setting my preferences again, but that's ok.

                     

                    The Export Utility preferences page now looks like your screenshot, too. It didn't before. I'm happy and grateful!

                    • 7. Re: Export dialog suddenly stopped working (internal error)
                      tfa

                      I also encountered the error.  What caused the issue for me was I tried to export a query result to an excel file I had named with a ":" in the file name.  I edited the following file to remove the colon character then restarted SQL Developer and downloads worked again after that.

                       

                      C:\Users\<USERID>\AppData\Roaming\SQL Developer\system4.1.0.18.37\o.sqldeveloper.12.2.0.18.37\product-preferences.xml

                      Capture.PNG