This discussion is archived
1 2 Previous Next 26 Replies Latest reply: Aug 29, 2013 11:10 AM by Brendan RSS

EA4.0 Errors

Brendan Oracle ACE Director
Currently Being Moderated

Hi

 

After upgrading to SQL Dev and the ODM repository (on a 11.2.0.3 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..
SEVERE1640oracle.dmt.dataminer.repository.StringUtils

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.

 

Regards

Brendan

  • 1. Re: EA4.0 Errors
    Brendan Oracle ACE Director
    Currently Being Moderated

    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-4.0.0.12.27-no-jre\sqldeveloper\sqldeveloper\bin

     

    I only get the following on screen

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


    I cannot scroll across to get the rest

  • 2. Re: EA4.0 Errors
    Mark Kelly Oracle ACE
    Currently Being Moderated

    Thanks, Created bug 17191182

    Mark

  • 3. Re: EA4.0 Errors
    Brendan Oracle ACE Director
    Currently Being Moderated

    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.

     

    Regards

    Brendan

     

    Message was edited by: Brendan

  • 4. Re: EA4.0 Errors
    Mark Kelly Oracle ACE
    Currently Being Moderated

    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 11.2.0.4 or above it will run match faster.

          ODMr uses a different XMLDB storage implementation in 11.2.0.4 above.

          In DBs prior to 11.2.0.4, XMLDB OR storage is used whereas in 11.2.0.4 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 11.2.0.3 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 11.2.0.4 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
    Brendan Oracle ACE Director
    Currently Being Moderated

    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 11.2.0.3. 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 11.2.0.4 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 11.2.0.4 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 ACE
    Currently Being Moderated

    Hi Brendan,

    When I run the Explore Node using MINING_DATA_BUILD_V on 11.2.0.3 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 11.2.0.3 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
    Brendan Oracle ACE Director
    Currently Being Moderated

    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
    START(WORKFLOW)ODMR$WFJOB4368

    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
    Brendan Oracle ACE Director
    Currently Being Moderated

    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

    username:module:program:type:sid:serial:status

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

     

    Regards

    Brendan

     

    Message was edited by: Brendan

  • 9. Re: EA4.0 Errors
    Brendan Oracle ACE Director
    Currently Being Moderated

    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.

     

    Regards

    Brendan

  • 10. Re: EA4.0 Errors
    Mark Kelly Oracle ACE
    Currently Being Moderated

    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 ACE
    Currently Being Moderated

    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
    Brendan Oracle ACE Director
    Currently Being Moderated

    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 11.2.0.3? Seem odd all was fine before the upgrade to SQL Dev 4

  • 13. Re: EA4.0 Errors
    Brendan Oracle ACE Director
    Currently Being Moderated

    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

     

    Regards

    Brendan

  • 14. Re: EA4.0 Errors
    Brendan Oracle ACE Director
    Currently Being Moderated

    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

Legend

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