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

All ID fields in history tables should have the length of 10

    XMLWordPrintable

Details

    • Fix
    • Status: Approved (View Workflow)
    • Minor
    • Resolution: Fixed
    • 1.10.6, 1.11.1
    • 1.10.7, 1.11.2
    • None
    • None

    Description

      Current Situation

      The lenght of id fields are

      SCHEDULER_HISTORY: 10
      SCHEDULER_ORDER_HISTORY: 9
      SCHEDULER_ORDER_STEP_HISTORY: 9
      SCHEDULER_TASKS: 9
      SCHEDULER_VARIABLES: 9

      In the reporting inventory tables all id fields habe the length 10. But the sequences are created for a maxvalue of 999999999.

      Desired behaviour

      The lenght of id fields should be

      SCHEDULER_HISTORY: 10
      SCHEDULER_ORDER_HISTORY: 10
      SCHEDULER_ORDER_STEP_HISTORY: 10
      SCHEDULER_TASKS: 10
      SCHEDULER_VARIABLES: 10

      All sequences should be created with a maximum value of 9999999999

      Attachments

        Issue Links

          responds to trouble ticket

          Fix - JS-1688 For Stopped File order source job chain JobScheduler creates unnecessary Job_Ids

          • Major - Major loss of function.
          • Released

          Activity

            People

              sp Santiago Aucejo Petzoldt
              ur Uwe Risse
              Uwe Risse Uwe Risse
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: