8 Replies Latest reply on Sep 27, 2013 11:40 AM by user13430807

    4.0 EA2 Unable open File explorer under Windows

    user13430807


      Hello,

       

      When I try to open a design from the file system using File explorer under windows, no window is opened. After some time the  message ' Open Design: Canceled'in the Messages Log is shown.

      In the log file the following trace file is created:

      2013-09-26 14:36:37,270 [AWT-EventQueue-1] ERROR ControllerApplication - Error Oen design!

      java.lang.ArrayIndexOutOfBoundsException: 7

      at oracle.ide.layout.URL2String.toURL(URL2String.java:103)

      at oracle.dbtools.crest.util.gui.swing.URLChooserShortcuts.createShortcuts(URLChooserShortcuts.java:102)

      at oracle.ide.dialogs.DialogUtil.addShortcutButtons(DialogUtil.java:240)

      at oracle.ide.dialogs.DialogUtil.initURLChooser(DialogUtil.java:160)

      at oracle.ide.dialogs.DialogUtil.newURLChooser(DialogUtil.java:125)

      at oracle.ide.dialogs.DialogUtil.newURLChooser(DialogUtil.java:93)

      at oracle.ide.dialogs.DialogUtil.newURLChooser(DialogUtil.java:77)

      at oracle.dbtools.crest.swingui.ControllerApplication$OpenDesign.selectDesign(ControllerApplication.java:2259)

      at oracle.dbtools.crest.swingui.ControllerApplication$OpenDesign.doActionPerformed(ControllerApplication.java:2312)

      at oracle.dbtools.crest.swingui.MDBAction$ActionInvoker.run(MDBAction.java:248)

      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(AccessControlContext.java:87)

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

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

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

      at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.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)

       

      A similar log is created when trying to open a domain file:

      2013-09-26 14:36:11,083 [AWT-EventQueue-1] ERROR ImportDomainsDialog - Error import domain file

      java.lang.ArrayIndexOutOfBoundsException: 7

      at oracle.ide.layout.URL2String.toURL(URL2String.java:103)

      at oracle.dbtools.crest.util.gui.swing.URLChooserShortcuts.createShortcuts(URLChooserShortcuts.java:102)

      at oracle.ide.dialogs.DialogUtil.addShortcutButtons(DialogUtil.java:240)

      at oracle.ide.dialogs.DialogUtil.initURLChooser(DialogUtil.java:160)

      etc...

        • 1. Re: 4.0 EA2 Unable open File explorer under Windows
          Dimitar Slavov-Oracle

          Hi,

           

          Do you mean you can't even see 'Open Design' dialog i.e. When doing File->Open exception is raised? Or when you select file from 'Open Design' dialog nothing is happening and exception is raised?

          Are you able to open design after DM restart?

          • 2. Re: 4.0 EA2 Unable open File explorer under Windows
            user13430807

            Hello,

             

            Indeed, I can't see the 'Open Design' dialog or 'Open domain file' dialog. So I can't open any design from the file system.

             

            Joop

            • 3. Re: 4.0 EA2 Unable open File explorer under Windows
              Dimitar Slavov-Oracle

              Issue is related to building of the last used locations list in the left part of file browser dialog. Seems that when trying to build that list, one (few) of the last used paths are somehow non valid i.e. they contain non-valid symbols when trying to create URL from the path. I'm trying to reproduce it but no luck so far.

              Are there any special symbols in the directories names (file names) you have been used lately?

              • 4. Re: 4.0 EA2 Unable open File explorer under Windows
                user13430807

                Hello Dimitar,

                 

                I did the same thing in SQL Developer EA2, but there the file browser window opens. It shows only normal directories. So there are no special issues in the last locations.

                 

                I suppose SQL Developer and DM use the same code to open the file browser, and use the same last locations list.

                 

                Joop


                • 5. Re: 4.0 EA2 Unable open File explorer under Windows
                  David Last-Oracle

                  Hi Joop,

                   

                  I suspect this problem is now happening whenever you get a file chooser dialog when creating or opening a file in DM 4.0 EA2, including saving a DDL file, etc.

                   

                  Do you remember what file was the last file you created/opened (or attempted to create/open) before this started happening?

                  Was there anything unusual about it or its directory ?

                   

                  David

                  • 6. Re: 4.0 EA2 Unable open File explorer under Windows
                    user13430807

                    Hello David,

                     

                    I can't remember the last file I tried to open, that's to long ago.

                     

                    However I have the relevant part of the contents of the ide.properties for you:

                    OpenedFilesHistoryCount=4

                    OpenedFilesHistoryItem0=file ; ; -1 %2FM%3A%2FUBERSVN%2Fp_cbs_chk_pod_fnm.pls ; ;

                    OpenedFilesHistoryItem1=file ; ; -1 %2FH%3A%2Ftmp%2FScript+OPLJCS_J_OPL_EXPORT_OBJ_SVN.sql ; ;

                    OpenedFilesHistoryItem2=file ; ; -1 %2FH%3A%2Ftmp%2Fcntt_bir.pls ; ;

                    OpenedFilesHistoryItem3=file ; ; -1 %2FH%3A%2Ftmp%2Falternatief.sql ; ;

                     

                    and part of the contents of preferences.xml:

                       <Item>

                          <Key>editors-options</Key>

                          <Value class="oracle.ide.editor.EditorsOptions">

                             <editorsData/>

                             <lruFiles>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1378802564981"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1378895031615"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1378969409863"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1379417118712"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1379419971405"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1379424053379"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1379424063441"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.ideimpl.editor.DeclarativeEditorAddin-oracle.dbtools.worksheet.editor.Worksheet</editor>

                                   <explicit>true</explicit>

                                   <nodeURL protocol="file" path="/K:/ICT-SO-TA/SOKS/Controle querie/6_3_4/bouw_set_6_3_4.sql"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1379928296435"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.ideimpl.editor.DeclarativeEditorAddin-oracle.dbtools.worksheet.editor.Worksheet</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/M:/tst/19869/cb_system_tvt.sql"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.ideimpl.editor.DeclarativeEditorAddin-oracle.dbtools.worksheet.editor.Worksheet</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/H:/tmp/aanbiedingsbestelbiljet_regel.sql"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.ideimpl.editor.DeclarativeEditorAddin-oracle.dbtools.worksheet.editor.Worksheet</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/H:/tmp/alternatief.sql"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.ideimpl.editor.DeclarativeEditorAddin-oracle.ide.ceditor.CodeEditor</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/H:/tmp/cntt_bir.pls"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.ideimpl.editor.DeclarativeEditorAddin-oracle.ide.ceditor.CodeEditor</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/M:/UBERSVN/p_cbs_chk_pod_fnm.pls"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.ideimpl.editor.DeclarativeEditorAddin-oracle.dbtools.worksheet.editor.Worksheet</editor>

                                   <explicit>true</explicit>

                                   <nodeURL protocol="file" path="/H:/tmp/Script OPLJCS_J_OPL_EXPORT_OBJ_SVN.sql"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1380198487592"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1380198487904"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1380201764357"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                                <Item class="oracle.ide.editor.RecentFile">

                                   <editor>oracle.dbtools.crest.fcp.DataModelerAddin</editor>

                                   <explicit>false</explicit>

                                   <nodeURL protocol="file" path="/dmnode/1380201764560"/>

                                   <projectURL/>

                                   <recentTime>0</recentTime>

                                   <workspaceURL/>

                                </Item>

                             </lruFiles>

                             <recentFilesShowAll>false</recentFilesShowAll>

                             <recentFilesShowClosedOnly>true</recentFilesShowClosedOnly>

                          </Value>

                       </Item>

                    • 7. Re: 4.0 EA2 Unable open File explorer under Windows
                      Dimitar Slavov-Oracle

                      Hi Joop,

                       

                      There should not be file names in ide.properties 'OpenedFilesHistoryItem' lines. This was previous implementation and now there should be directories paths only. Obviously there is an old code in some of the file browser dialogs. Or there is some problem when migrating preferences between versions. Presence of the file names however is not a problem and should not raise an exception.

                       

                      Actually the exception

                      2013-09-26 14:36:37,270 [AWT-EventQueue-1] ERROR ControllerApplication - Error Oen design!

                      java.lang.ArrayIndexOutOfBoundsException: 7

                      at oracle.ide.layout.URL2String.toURL(URL2String.java:103)

                      is raised, because DM is trying to create URL with more than 7 parts, which is not possible. So one or more of the paths is not valid.

                      Solution is to delete all lines 'OpenedFilesHistoryItem'. You'll loose last used directories in file browser dialog. Do it when DM is closed.

                      • 8. Re: 4.0 EA2 Unable open File explorer under Windows
                        user13430807

                        Hello Dimitar,

                         

                        deletion of the mentioned lines works. The File explorer works again.

                         

                        Thanks for your help.

                         

                        Joop