Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

error while exporting data to excel file from table

User_02YNASep 15 2021

i get this error when trying to export table data to excel. I mon version Version 21.2.1.204, same issue with previous version so i decided to upgrade.
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:579)
at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:533)
at oracle.ide.wizard.FSMWizard.<init>(FSMWizard.java:120)
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:75)
at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:159)
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:842)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:886)
at java.awt.Component.processMouseEvent(Component.java:6539)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6304)
at java.awt.Container.processEvent(Container.java:2239)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2297)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
at java.awt.Container.dispatchEventImpl(Container.java:2283)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
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:74)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
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:205)
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.ClassCastException: java.lang.String cannot be cast to oracle.javatools.data.ListStructure
at oracle.javatools.data.HashStructure.getListStructure(HashStructure.java:1070)
at oracle.javatools.data.HashStructure.getOrCreateListStructure(HashStructure.java:1084)
at oracle.dbtools.raptor.config.URLFileChooserPaths$URLFileChooserPathContext.getURLList(URLFileChooserPaths.java:250)
at oracle.dbtools.raptor.config.URLFileChooserPaths$URLFileChooserPathContext.getURLPath(URLFileChooserPaths.java:191)
at oracle.dbtools.raptor.ui.URLFileChooser.getPathContextPaths(URLFileChooser.java:1601)
at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1542)
at oracle.dbtools.raptor.ui.URLFileChooser.setPathContext(URLFileChooser.java:1528)
at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.setPathContext(URLFileChooser.java:1341)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(TargetOptionsPanel.java:278)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:64)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:56)
at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.<init>(ExportWizDestinstaionPanel.java:96)
... 54 more
java.lang.ClassCastException: java.lang.String cannot be cast to oracle.javatools.data.ListStructure
at oracle.javatools.data.HashStructure.getListStructure(HashStructure.java:1070)
at oracle.javatools.data.HashStructure.getOrCreateListStructure(HashStructure.java:1084)
at oracle.dbtools.raptor.config.URLFileChooserPaths$URLFileChooserPathContext.getURLList(URLFileChooserPaths.java:250)
at oracle.dbtools.raptor.config.URLFileChooserPaths$URLFileChooserPathContext.getURLPath(URLFileChooserPaths.java:191)
at oracle.dbtools.raptor.ui.URLFileChooser.getPathContextPaths(URLFileChooser.java:1601)
at oracle.dbtools.raptor.ui.URLFileChooser.setCurrentDirectoryFromPathContext(URLFileChooser.java:1542)
at oracle.dbtools.raptor.ui.URLFileChooser.setPathContext(URLFileChooser.java:1528)
at oracle.dbtools.raptor.ui.URLFileChooser$URLFileChooserPanel.setPathContext(URLFileChooser.java:1341)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.initFilePanel(TargetOptionsPanel.java:278)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:64)
at oracle.dbtools.raptor.export.wizard.TargetOptionsPanel.<init>(TargetOptionsPanel.java:56)
at oracle.dbtools.raptor.export.wizard.ExportWizDestinstaionPanel.<init>(ExportWizDestinstaionPanel.java:96)
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:579)
at oracle.ide.wizard.FSMWizard._populatePages(FSMWizard.java:533)
at oracle.ide.wizard.FSMWizard.<init>(FSMWizard.java:120)
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:75)
at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:159)
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:842)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:886)
at java.awt.Component.processMouseEvent(Component.java:6539)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6304)
at java.awt.Container.processEvent(Container.java:2239)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2297)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
at java.awt.Container.dispatchEventImpl(Container.java:2283)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
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:74)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
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:205)
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)
then in the detail
oracle.ide.panels.TraversalException: Internal error in FSM: Transition not found: <null>
at oracle.ide.wizard.FSMWizard.handleFSMTransitionException(FSMWizard.java:1224)
at oracle.ide.wizard.FSMWizard._canTraverseFSM(FSMWizard.java:804)
at oracle.ide.wizard.FSMWizard._validateFSMState(FSMWizard.java:670)
at oracle.ide.wizard.FSMWizard.selectPage(FSMWizard.java:452)
at oracle.bali.ewt.wizard.WizardRoadMap$Listener$1.run(WizardRoadMap.java:1157)
at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
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:74)
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:205)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:190)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:235)
at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:233)
at java.security.AccessController.doPrivileged(Native Method)
at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:233)
at java.awt.Dialog.show(Dialog.java:1084)
at java.awt.Component.show(Component.java:1671)
at java.awt.Component.setVisible(Component.java:1623)
at java.awt.Window.setVisible(Window.java:1014)
at java.awt.Dialog.setVisible(Dialog.java:1005)
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.export.wizard.ExportWizMain.launchWizard(ExportWizMain.java:251)
at oracle.dbtools.raptor.export.wizard.ExportWizMain.launchForGrid(ExportWizMain.java:204)
at oracle.dbtools.raptor.dialogs.actions.TableExportAction.launchForGrid(TableExportAction.java:75)
at oracle.dbtools.raptor.controls.grid.contextmenu.ExportGrid$1.actionPerformed(ExportGrid.java:159)
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:842)
at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:886)
at java.awt.Component.processMouseEvent(Component.java:6539)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
at java.awt.Component.processEvent(Component.java:6304)
at java.awt.Container.processEvent(Container.java:2239)
at java.awt.Component.dispatchEventImpl(Component.java:4889)
at java.awt.Container.dispatchEventImpl(Container.java:2297)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4904)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4535)
at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4476)
at java.awt.Container.dispatchEventImpl(Container.java:2283)
at java.awt.Window.dispatchEventImpl(Window.java:2746)
at java.awt.Component.dispatchEvent(Component.java:4711)
at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:760)
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:74)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:84)
at java.awt.EventQueue$4.run(EventQueue.java:733)
at java.awt.EventQueue$4.run(EventQueue.java:731)
at java.security.AccessController.doPrivileged(Native Method)
at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:74)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:730)
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:205)
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)

Comments
Post Details
Added on Sep 15 2021
4 comments
1,438 views