Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-1641

JOC does not show folder view when runnig with Oracle in a cluster with more than 1000 distributed job chains

    XMLWordPrintable

Details

    Description

      Current situation

      When running JOC with an JobScheduler instance that is connected to an Oracle Database and JobScheduler is started with the option -distributed-orders the folder view is not available when having more than 1000 distributed job chains.

      The reason is a limitation in Oracle that allows not more than 1000 literals in a in clause. ora-01795: maximum number of expressions in a list is 1000

      Desired Behaviour

      JOC should offer the folder view even when running in a cluster with more than 1000 distributed job chains for each database.

      Attachments

        Issue Links

          Activity

            People

              jz Joacim Zschimmer
              ur Uwe Risse
              Joacim Zschimmer Joacim Zschimmer
              Uwe Risse Uwe Risse
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: