1 2 Previous Next 26 Replies Latest reply: Aug 29, 2013 1:10 PM by Brendan Go to original post RSS
      • 15. Re: EA4.0 Errors
        Brendan

        The Graph node only works on a sample of data. Sometimes (depending on data size) I would need to produce graphs on all the data.

        Perhaps this restriction needs to be removed. There is still a cache option in properties (for the graph node) to base it on a sample.

         

        I still get asked this even if I have generated a sample on the Data Source node (an option in properties).

         

        So this seems to be duplicating the work.  In the case where the Data Source node is run with sampling and then the Graph node does sampleing. Is the Graph node sample created from the Data Source sample (i.e. a sample of a sample) or is it sampling the original data (it does the sampling for a second time)?

         

        Regards

        Brendan

        • 16. Re: EA4.0 Errors
          Brendan

          A few more suggestions regarding the graphs, including

          - to make the graphs moveable, so that we can re-position the graphs in the different orders

          - can have different numbers of graphs on each line. Allows the grouping of related graphs together

          - can scale the graphs to a suitable size (i.e. to make them slightly bigger if required). This is in addition to the current full zoom.

          • 17. Re: EA4.0 Errors
            Brendan

            The ODM help in SQL Dev says the following for the SQL Node

             

            Below the text area are:

            Columns, list the columns and data types

            Preview, displays a small number of the rows returned by the query

             

             

            This area and preview does not exist on my SQL node

             

            There does seem to be something below the query text area as I get the mouse cursor to change to indicate that I can change the size of the area. But nothing happens when I try this

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

              Hi Brendan,

                In order to expose the sub tab panels described in the help , the query must be invoked. You should click on the green check mark on the top left of the tool bar above the sql text area.

              Thanks, Mark

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

                Hi Brendan,

                    There is a technical requirement that requires a table or view to be constructed as the source the graph node.

                    So currently the cache option is creating a sampled table.

                    What ever down stream sql etc. that was generated would proceed this sample.

                    So if you have a Sample node prior to the Graph node that creates say a sample of 100,000 rows.

                    The Graph node would then sample that down to a smaller set.

                   

                    We are now looking at an option where the user could check an option on the Graph node to use all the data.

                    In this case, at View would be created to resolve the technical requirement, and the user would have access to all the data from the parent node.

                    I think this addresses your request.

                Thanks, Mark

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

                  Hi Brendan,

                    Check out the SQL Dev OTN forum. It seems there are some performance issues noted in the SQL DEV 4.0 EA1 release.

                    This should be addressed as part of SQL Dev 4.0 EA2 or RTM release.

                    You should also consider either upgrading to 12.1 db or 11.2.0.4 (which should be out soon) as they will include significant improvements in the Data Miner server implementation.

                  Thanks, Mark

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

                    Hi Brendan,

                    See the following link for some server documentation on Dynamic Scoring (aka Predictive Queries):

                     

                    http://docs.oracle.com/cd/E16655_01/datamine.121/e17693/models_deploying.htm#BABCBIFB

                     

                    Thanks, Mark

                    • 22. Re: EA4.0 Errors
                      Brendan

                      Is there an ETA for EA2?

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

                        Sorry, but we can't give out ETAs on releases. It is in the works and expected fairly soon.

                        Thanks, Mark

                        • 24. Re: EA4.0 Errors
                          Brendan

                          I've opened SQL Dev this morning and it works. I then opened a ODM connection and Workflow.  The various containers/tab for ODM open in positions that were not previously used and then SQL Developer hangs. I cannot do anything in SQL Dev/ODM. I cannot click on anything, move anything. It does not respond.  I have to use task manager to kill SQL Dev

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

                            Hi Brendan,

                               Can you think of any changes made to your db or client that may have affected this change in behavior?

                               Can you do the following:

                            1) Launch SQL Dev with console:

                            2) View->Log

                            3) View->Extension Diagnostics

                            4) Proceed to the Data Miner tab, open connection and workflow and monitor Log, Extension Diagnostics and Console for any relevant messages and post results here.

                            5) Also go to the bottom the db alert log and see if there are any db query or system failures as well, that occurred at the same time.

                             

                            After that, you can also try rebooting client and bounding db to see how that affects behavior.

                            Thanks, Mark

                            • 26. Re: EA4.0 Errors
                              Brendan

                              I have made no changes to the 12.1 DB. I had closed SQL Dev cleanly, after adding a model details and create table nodes. These ran OK and produced the output.

                              I had shut down the DB and SQL Dev

                              It was after starting the DB and SQL Dev that the error occurs.

                              If I leave SQL Dev/ODM for approx 5 minutes it becomes usable.

                               

                              The window title area, where the SQL Dev icon is, keeps flickering with two different messages, which unfortunately I cannot read.

                               

                              I will try your suggestion for getting the log

                              1 2 Previous Next