This discussion is archived
10 Replies Latest reply: Jan 23, 2013 2:15 AM by Marwim RSS

sqldeveloper-3.2.20.09.87: Import Data Wizard Not working

mhathi Newbie
Currently Being Moderated
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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Oracle ACE Director
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points