1 2 Previous Next 26 Replies Latest reply on Aug 29, 2013 6:10 PM by Brendan

    EA4.0 Errors




      After upgrading to SQL Dev and the ODM repository (on a DB), I've gone into some of my existing workflows.  After a few minutes I noticed in the Logging Page-Log tab at the bottom of the screen the following errors. I don't know what I did to cause these, but you might be able to work out something

      SEVERE18336204oracle.ide.controller.IdeActionError during handleEvent on action 'null' (id=785). None of the attached controllers handled the action..
      SEVERE18073994oracle.ide.controller.IdeActionError during handleEvent on action 'null' (id=784). None of the attached controllers handled the action..
      SEVERE1791331716oracle.ide.controller.IdeActionError during handleEvent on action 'null' (id=784). None of the attached controllers handled the action..

      null - java.lang.String.compareTo(String.java:1139)


      Another thing. I try to re-run the Explore node on an existing workflow that was running against MINING_DATA_BUILD_V and after 5 minutes it is still running.  An ideas?

      This used to take a few seconds before the upgrade.

      Completed after 10 minutes!!!


      Opening a workflow, opening a node, etc all seems to take a few seconds longer that ver 3.2.2.   or is it me?  this is not just for the ODM part but for most things in SQL Dev 4.




        • 1. Re: EA4.0 Errors

          Another possible issue that I have come across is when you want to create the deployment script. At stage 2 of the Generate Scrip, I cannot scroll across this field to see the full location and file name, for example


          C:\Users\btierney\Documents\9.Downloads\Apps\Oracle SQL Developer\sqldeveloper-\sqldeveloper\sqldeveloper\bin


          I only get the following on screen

          C:\Users\btierney\Documents\9.Downloads\Apps\Oracle SQL Developer\sqldeveloper-\sqldevelo

          I cannot scroll across to get the rest

          • 2. Re: EA4.0 Errors
            Mark Kelly-Oracle

            Thanks, Created bug 17191182


            • 3. Re: EA4.0 Errors

              Hi Mark


              Any ideas of the errors in the first post and the speed issue?


              Update on Timings:  The Explore node used to take 30 seconds-ish.  It is now taking 6 minutes.   Model nodes are about the same amount of time as before.





              Message was edited by: Brendan

              • 4. Re: EA4.0 Errors
                Mark Kelly-Oracle

                Hi Brendan,

                  The event handling errors would not affect the behavior of the product but should still be fixed so I have filed bug 17191918 .

                  As for performance differences:

                  1) If you install the data miner repository on or above it will run match faster.

                      ODMr uses a different XMLDB storage implementation in above.

                      In DBs prior to, XMLDB OR storage is used whereas in and above XMLDB Binary storage is used.

                      The performance of the Binary implementation is significantly faster than OR for ODMr's xml schema definition and overall implementation.

                      I don't mean for this to be a knock on OR, it is just that Binary is now a much better fit for ODMr.

                      For and earlier, as newer versions of the repository are installed, the complexity of the schema for the workflow documents increases, which also increases the overhead of processing.

                      So we clients to move forward to either upgrade to or 12.1 to improve performance.

                2) I don't know of any global issues in SQL Dev that would affect performance across the board.

                     You could consider adding more memory allocation to the SQL Dev Virtual Machine.

                     This can be done by editing the ide.conf file in the C:\<Install Directory>\sqldeveloper\ide\bin directory to increase the memory.

                     Here are some instructions from the ide.conf file:

                # If you are getting the 'Low Memory Warning' Message Dialog while running

                # JDeveloper, please increase the -Xmx value below from the default 800M to

                # something greater, like 1024M or 1250M.  If after increasing the value,

                # JDeveloper is no longer starting up because it fails to create a virtual

                # machine, then please reduce the modified -Xmx value, or use a 64bit JDK

                # which allows for very very large value for -Xmx.


                AddVMOption  -Xmx800M



                3) Does a new Explore Node running any faster then an existing Explore Node that was migrated?

                    I would not expect so.


                4)To actually see the run times for the nodes, you can right click the node and select Show Event Log.

                  You can then click on the Info icon on the grid tool bar to display information event logs that contain run time information for specific tasks accomplished by the node.


                Thanks, Mark

                • 5. Re: EA4.0 Errors

                  Thanks Mark

                  I'll have a look at the memory allocation to SQL Dev to see if that makes a difference.


                  The change in performance of the Explore node is a bit of a surprise.  I've done lots of ODM demos over the years and I've always included the Explore Node. It did run quickly (30 seconds) previous to the upgrade on the same data.  I'm running So it is a bit surprising the difference in time. It now takes 5 minutes, for the same data and database.  So based on this timing I cannot use it in a demo.   Some of the build nodes are doing more processing and there is very little difference in timings. This is good.


                  There is no difference in timing between a newly created Explore node and an Explore node that was migrated.


                  What about existing customers who are using ODM. Should they stay with SQL Dev 3 until they can upgrade to or 12.1?  for performance reasons.  Also to consider the number of customers who have just moved to or are currently moving 11 and it will be some time before they will looking at 12


                  Any idea of a time frame when will be available?


                  I haven't gotten to testing ODM on 12.1 yet. I'll be doing that testing over the weekend 


                  Message was edited by: Brendan

                  • 6. Re: EA4.0 Errors
                    Mark Kelly-Oracle

                    Hi Brendan,

                    When I run the Explore Node using MINING_DATA_BUILD_V on it takes 26 seconds. So there does seem to be something about your configuration. Are you running in 32 or 64 bit mode at the client?

                    We do not expect users to hit the type of performance problem you have.

                    I will try a test on a upgrade ODMRSYS repository on and see if I can recreate this condition.

                    Do you recall what the history of your repository is?

                    For example, did you originally install SQl Dev 3.0 and then do upgrades from that point on, or was the repository loaded fresh using SQL Dev 3.2 and then upgraded to 4.0 from there?

                    This will help me recreate the same migration path to see if it makes any difference.

                    Thanks, Mark

                    • 7. Re: EA4.0 Errors

                      Interesting. That is the timing I was expecting-ish.

                      Typical it might be something to do with me so

                      I started with SQL Dev 3 and upgraded with each release and EAs


                      I've tried it again and this time it took 6 minutes. From watching the Workflow Jobs progress bar it get to the 3/4 point quickly and then spends the rest of the time (approx 5.25 minutes) at this point before completing.


                      It seems to be something just before or starting the cleanup


                      EventJobNodeSub NodeTimeMessageDuration
                      END(WORKFLOW)ODMR$WFJOB436819/07/13 22:02:15D:0 H:0 M:6 S:17
                      END(CLEANUP)ODMR$WFJOB436819/07/13 22:02:15D:0 H:0 M:0 S:0
                      START(CLEANUP)ODMR$WFJOB436819/07/13 22:02:14
                      END(NODE)ODMR$WFJOB4368Explore Data 119/07/13 21:57:18D:0 H:0 M:0 S:45
                      END(STATISTICS)ODMR$WFJOB4368Explore Data 119/07/13 21:57:18D:0 H:0 M:0 S:23
                      END(CREATE HISTOGRAMS)ODMR$WFJOB4368Explore Data 119/07/13 21:57:14D:0 H:0 M:0 S:9
                      START(CREATE HISTOGRAMS)ODMR$WFJOB4368Explore Data 119/07/13 21:57:06
                      END(CREATE EXPLORE STATISTICS)ODMR$WFJOB4368Explore Data 119/07/13 21:57:06D:0 H:0 M:0 S:11
                      START(CREATE EXPLORE STATISTICS)ODMR$WFJOB4368Explore Data 119/07/13 21:56:55
                      START(STATISTICS)ODMR$WFJOB4368Explore Data 119/07/13 21:56:55
                      END(CREATE HISTOGRAM SAMPLE)ODMR$WFJOB4368Explore Data 119/07/13 21:56:55D:0 H:0 M:0 S:0
                      START(CREATE HISTOGRAM SAMPLE)ODMR$WFJOB4368Explore Data 119/07/13 21:56:54
                      END(CREATE SAMPLE DATA)ODMR$WFJOB4368Explore Data 119/07/13 21:56:54D:0 H:0 M:0 S:13
                      START(CREATE SAMPLE DATA)ODMR$WFJOB4368Explore Data 119/07/13 21:56:42
                      END(SAMPLE)ODMR$WFJOB4368Explore Data 119/07/13 21:56:38D:0 H:0 M:0 S:0
                      START(SAMPLE)ODMR$WFJOB4368Explore Data 119/07/13 21:56:38
                      END(VALIDATE)ODMR$WFJOB4368Explore Data 119/07/13 21:56:38D:0 H:0 M:0 S:6
                      START(VALIDATE)ODMR$WFJOB4368Explore Data 119/07/13 21:56:38
                      START(NODE)ODMR$WFJOB4368Explore Data 119/07/13 21:56:38
                      END(NODE)ODMR$WFJOB4368MINING_DATA_BUILD_V119/07/13 21:56:25D:0 H:0 M:0 S:20
                      END(SAMPLE)ODMR$WFJOB4368MINING_DATA_BUILD_V119/07/13 21:56:25D:0 H:0 M:0 S:13
                      START(SAMPLE)ODMR$WFJOB4368MINING_DATA_BUILD_V119/07/13 21:56:12
                      END(VALIDATE)ODMR$WFJOB4368MINING_DATA_BUILD_V119/07/13 21:56:12D:0 H:0 M:0 S:7
                      START(VALIDATE)ODMR$WFJOB4368MINING_DATA_BUILD_V119/07/13 21:56:11
                      START(NODE)ODMR$WFJOB4368MINING_DATA_BUILD_V119/07/13 21:56:11

                      19/07/13 21:55:57


                      Is there are way to automatically expand the all the Workflow Editor tabs, or is there a setting to do this.  Otherwise I have to expand them each time I go into ODM.   I should have asked for/about something like this before now.


                      I've make the memory changes to the SQL Dev VM as you suggested and it seems to have made a difference and getting the response that I'm used to.


                      Message was edited by: Brendan

                      • 8. Re: EA4.0 Errors

                        Hi Mark

                        My mind has been niggling away all weekend about the performance issue. I keep on thinking we had similar discussions for a previous release.


                        When using the Predictive Query node (against a 12c DB) when I press F1 or click on the help button I get, No help topic available.



                        Can you point me to where I can see the new feature Prediction Result Explanation.



                        When dropping the repository from the 12.1 I get the following in SQL Dev4


                        DMUSER:SQL Developer:SQL Developer:USER:257:317:INACTIVE





                        Message was edited by: Brendan

                        • 9. Re: EA4.0 Errors

                          Hi Mark


                          There seems to be some inconsistency with the Components Workflow Editor.

                          It happens when I'm expanding each of the options. I use the mouse to adjust the height for each option and it appears that sometimes the icons get reduced in size with maybe 3 being displayed per line. Then sometimes they go to 4 per line.

                          So we can end up with some icons having a different size for one option (e.g. Models) and icons for another option (e.g. Predictive queries) having a different size.




                          • 10. Re: EA4.0 Errors
                            Mark Kelly-Oracle

                            Hi Brendan,

                            I don't notice any changes in size of icons. I do notice that you could trigger a vertical scroll bar to be introduced into one of the categories, if you fail to provide sufficient space to display it.

                            This could reduce that categories ability to display as many components per line.

                            Thanks, Mark

                            • 11. Re: EA4.0 Errors
                              Mark Kelly-Oracle

                              Hi Brendan,

                                I see this gap of time in the event log, between the Explore Node end event and the start of the workflow cleanup event.

                                Could be Oracle Scheduler held off on allowing the workflow clean up step to be run.

                                If you have OEM running on your db, you might be able to gain more information by monitoring the workflow via the Oracle Scheduler interface.

                              Thanks, Mark

                              • 12. Re: EA4.0 Errors

                                Sometimes it displays 3 across and sometimes it displays 4 across.

                                ill see if I can get a video of this happening and email the link to it


                                Any update on the performance issue I was having with the explore node on Seem odd all was fine before the upgrade to SQL Dev 4

                                • 13. Re: EA4.0 Errors

                                  Hi Mark

                                  I've sent the video of the node scaling possible issue.


                                  I can not connect a data source to the Filter Column Details node.  I can connect the data source node to other nodes not problem. But the connect link/arrow does not form when I try to connect to Filter Column Detail node




                                  • 14. Re: EA4.0 Errors

                                    ODM/SQL Dev is not remembering the positions of the workflow worksheet and the (node) properties tab.  I have to preposition these each time I open ODM.

                                    1 2 Previous Next