2 Replies Latest reply on Aug 21, 2015 5:19 AM by Jerald

    SQL Developer 3.2 not showing chain diagram

    Jerald

      We recently imported a schema into a new database. When I checked the scheduler job chain in the sql developer, it shows no diagram like in the old database. The rules and steps are listed in the rules and steps tab but the diagram does not show.. Any ideas? There are no invalid objects in the database.

       

      Thanks,
      Jerald

        • 1. Re: SQL Developer 3.2 not showing chain diagram
          Gary Graham-Oracle

          A couple of ideas...

          1. Run bin\sqldeveloper.exe directly from a command console window and see if you get any errors / stack trace.

          2. Upgrade to at least 4.0.3 or the current 4.1.1.  There were several bug fixes in the Scheduler made post-3.2, maybe this is one such case.

          Also, with 4.1.0 or 4.1.1 (if the problem still exists) the new Statement tab in the Logging pane will show you all the SQL statements that get run. You can determine if it is the SQL which is not returning the data rows necessary to build the diagram.  If so, maybe the import was somehow incomplete.

          • 2. Re: SQL Developer 3.2 not showing chain diagram
            Jerald

            I managed to resolve this. It turned out that there was something wrong with the rules in the database... I overlooked that one case solved