10 Replies Latest reply: Jan 23, 2013 4:15 AM by Marwim RSS

    sqldeveloper-3.2.20.09.87: Import Data Wizard Not working

    mhathi
      Hello,

      I have installed sqldeveloper-3.2.20.09.87 (with jdk) on Win7 32-bit.

      I am trying to import data to a table using the Import Data Wizard launched from the Table ObjectViewer tab under Actions button. Everything goes well and last step for Verification shows success and then clicking on Finish button does NOTHING. I don't see any error message or logs or anything.

      Know how to make it work?

      This seems to be an issue on this particular laptop. I tested on another and this functionality works without issues.

      Thanks,

      Manish
        • 1. Re: sqldeveloper-3.2.20.09.87: Import Data Wizard Not working
          Jim Smith
          Try running <sqldev>\sqldeveloper\bin\sqldeveloper.exe. That will leave a console open which may display more information about any errors which occur.
          • 2. Re: sqldeveloper-3.2.20.09.87: Import Data Wizard Not working
            mhathi
            Here's the log from the console window as you suggested.



            LOAD TIME : 124Finished parsing = 671
            UsersCache.fillIn() time = 0 ret==null?: true
            Exception occurred during event dispatching:
            oracle.classloader.util.AnnotatedNoClassDefFoundError:

            Missing class: antlr.TokenStream

            Dependent class: org.antlr.stringtemplate.language.DefaultTemplateLexer
            Loader: ide-global:11.1.1.0.0
            Code-Source: /C:/sqldeveloper-3.2.20.09.87/sqldeveloper/sqldeveloper
            /lib/stringtemplate-3.1b1.jar
            Configuration: <classpath> in /file:/C:/sqldeveloper-3.2.20.09.87/sqld
            eveloper/sqldeveloper/extensions/oracle.sqldeveloper.jar!/META-INF/extension.xml


            The missing class is not available from any code-source or loader in the system.

            at oracle.classloader.PolicyClassLoader.defineClass(PolicyClassLoader.ja
            va:2387)
            at oracle.classloader.PolicyClassLoader.findLocalClass(PolicyClassLoader
            .java:1546)
            at oracle.classloader.SearchPolicy$FindLocal.getClass(SearchPolicy.java:
            226)
            at oracle.classloader.SearchSequence.getClass(SearchSequence.java:119)
            at oracle.classloader.PolicyClassLoader.internalLoadClass(PolicyClassLoa
            der.java:1728)
            at oracle.classloader.PolicyClassLoader.access$000(PolicyClassLoader.jav
            a:143)
            at oracle.classloader.PolicyClassLoader$LoadClassAction.run(PolicyClassL
            oader.java:331)
            at java.security.AccessController.doPrivileged(Native Method)
            at oracle.classloader.PolicyClassLoader.loadClass(PolicyClassLoader.java
            :1692)
            at oracle.classloader.PolicyClassLoader.loadClass(PolicyClassLoader.java
            :1674)
            at org.antlr.stringtemplate.StringTemplateGroup.<clinit>(Unknown Source)

            at oracle.dbtools.raptor.data.writers.ImportGenerator.loadTemplates(Impo
            rtGenerator.java:1923)
            at oracle.dbtools.raptor.data.writers.ImportGenerator.generate(ImportGen
            erator.java:522)
            at oracle.dbtools.raptor.data.ui.DataSummaryPage.onExit(DataSummaryPage.
            java:133)
            at oracle.ide.wizard.FSMWizard.exitCurrentPanel(FSMWizard.java:653)
            at oracle.ide.wizard.FSMWizard._validateFSMState(FSMWizard.java:614)
            at oracle.ide.wizard.FSMWizard.doFinish(FSMWizard.java:333)
            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:666)
            at java.awt.EventQueue.access$400(EventQueue.java:81)
            at java.awt.EventQueue$2.run(EventQueue.java:627)
            at java.awt.EventQueue$2.run(EventQueue.java:625)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
            ntrolContext.java:87)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:636)
            at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre
            ad.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:1591)
            at java.awt.Component.setVisible(Component.java:1543)
            at java.awt.Window.setVisible(Window.java:843)
            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.dialogs.WizardLauncher.runDialog(WizardLauncher.java:51)
            at oracle.dbtools.raptor.data.DataWizard.launch(DataWizard.java:298)
            at oracle.dbtools.raptor.controls.sqldialog.ObjectActionController.handl
            eEvent(ObjectActionController.java:195)
            at oracle.ide.controller.IdeAction.performAction(IdeAction.java:529)
            at oracle.ide.controller.IdeAction.actionPerformedImpl(IdeAction.java:88
            4)
            at oracle.ide.controller.IdeAction.actionPerformed(IdeAction.java:501)
            at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:19
            95)
            at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
            a:2318)
            at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
            .java:387)
            at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:242
            )
            at javax.swing.AbstractButton.doClick(AbstractButton.java:357)
            at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:8
            09)
            at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMen
            uItemUI.java:850)
            at java.awt.Component.processMouseEvent(Component.java:6297)
            at javax.swing.JComponent.processMouseEvent(JComponent.java:3275)
            at java.awt.Component.processEvent(Component.java:6062)
            at java.awt.Container.processEvent(Container.java:2039)
            at java.awt.Component.dispatchEventImpl(Component.java:4660)
            at java.awt.Container.dispatchEventImpl(Container.java:2097)
            at java.awt.Component.dispatchEvent(Component.java:4488)
            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:2489)
            at java.awt.Component.dispatchEvent(Component.java:4488)
            at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:668)
            at java.awt.EventQueue.access$400(EventQueue.java:81)
            at java.awt.EventQueue$2.run(EventQueue.java:627)
            at java.awt.EventQueue$2.run(EventQueue.java:625)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
            ntrolContext.java:87)
            at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
            ntrolContext.java:98)
            at java.awt.EventQueue$3.run(EventQueue.java:641)
            at java.awt.EventQueue$3.run(EventQueue.java:639)
            at java.security.AccessController.doPrivileged(Native Method)
            at java.security.AccessControlContext$1.doIntersectionPrivilege(AccessCo
            ntrolContext.java:87)
            at java.awt.EventQueue.dispatchEvent(EventQueue.java:638)
            at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThre
            ad.java:269)
            at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.
            java:184)
            at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
            ad.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)
            • 3. Re: sqldeveloper-3.2.20.09.87: Import Data Wizard Not working
              Gary Graham-Oracle
              Hi Manish,

              Do you have any antlr*.jar files in your <SQLDev_Home>\sqldeveloper\lib directory? Possibly your installation got corrupted somehow. Always remember to install into an empty directory.

              Regards,
              Gary
              SQL Developer Team
              • 4. Re: sqldeveloper-3.2.20.09.87: Import Data Wizard Not working
                mhathi
                Gary,

                There are following files in the directory you mentioned:
                antlr-all-2.7.6.jar
                antlr-runtime-3.1.3.jar

                It's odd that the same zip file that I had downloaded (sqldeveloper-3.2.20.09.87.zip) works on one laptop (Win7 32-bit) but doesn't work (as far as Import Data wizard) on this other laptop.

                Thanks,

                Manish
                • 5. Re: sqldeveloper-3.2.20.09.87: Import Data Wizard Not working
                  Gary Graham-Oracle
                  Manish,

                  Yes, very odd. So the zip file seems good (works on other laptop) and the unzip seems to have worked (antlr*.jar files exist) on problem laptop. The missing antl.TokenStream class should be found in the antlr-all-2.7.6.jar file. If it is actually present in that jar and the jar can be opened or unzipped without error, then I'm not sure what the problem could be. Perhaps try for another install into an empty directory. If you had disk corruption, then one would expect some OS level error message to appear.

                  -Gary
                  • 6. Re: sqldeveloper-3.2.20.09.87: Import Data Wizard Not working
                    YuryVelikanov
                    Faced the same issue.
                    After spending some time on troubleshooting (BTW: launching from sqldeveloper\sqldeveloper\bin helps a lot) found that after enabling app Extensions the import works again.
                    SQLDev team can you help identifying what extension should be enabled for the Import Table functionality?

                    PS I have disabled all extensions to speedup SQL Dev start up time.
                    • 7. Re: sqldeveloper-3.2.20.09.87: Import Data Wizard Not working
                      Gary Graham-Oracle
                      Hi Yury,

                      I believe that would be related to the DBA Navigator extension. Disabling that also automatically disables a couple of other extensions (Security and Scheduler). It is actually the Security extension upon which Import has a dependency.

                      Regards,
                      Gary
                      SQL Developer Team
                      • 8. Re: sqldeveloper-3.2.20.09.87: Import Data Wizard Not working
                        YuryVelikanov
                        Thanks Gary for the answer. Appreciate it. I will include it into my Tomorrows presentations on SQL Developer :)
                        http://www.sydneyoracle.com.au/events/94426872/
                        • 9. Re: sqldeveloper-3.2.20.09.87: Import Data Wizard Not working
                          Gary Graham-Oracle
                          Let me add an important correction. The antlr-all-2.7.6.jar is actually referenced in all of the following extensions:
                          1. Scheduler
                          2. Security
                          3. Migrations Core (specifically components Access, SQLServer, Sybase, and Translation)

                          So Import will fail only if all of those are disabled. Sorry for any confusion.

                          -Gary
                          • 10. Re: sqldeveloper-3.2.20.09.87: Import Data Wizard Not working
                            Marwim
                            Hello Yury,

                            disabling an extension can cause different features to fail, e.g. without Migrations Core at least "Cross Connection Query" and "Dragging a table into a worksheet to get a select statement" won't work.
                            {message:id=10651844}

                            Regards
                            Marcus