Uploaded image for project: 'JITL - JobScheduler Integrated Template Library'
  1. JITL - JobScheduler Integrated Template Library
  2. JITL-541

Inventory does not update the JobChain node job info when a job was renamed

    XMLWordPrintable

    Details

    • Type: Fix
    • Status: Released (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.12.9
    • Labels:
      None

      Description

      Current Situation

      • When the JobScheduler is running and one of the existing JobChain jobs is renamed, Inventory does not update
        • INVENTORY_JOB_CHAIN_NODES.JOB_ID
          • The database statements based on the Inventory tables to get the Job Information (e.g. FactPlugin statements) delivers in that case the wrong result.
        • INVENTORY_JOBS.USED_IN_JOB_CHAINS
          • JOC: Job View displays a job as not used in a job chain

      How to reproduce

      • JobScheduler is running
      • Use any existing JobChain
        • find this JobChain in the Reporting INVENTORY_JOB_CHAINS table
        • find the related JobChain nodes in the INVENTORY_JOB_CHAIN_NODES table
          • INVENTORY_JOB_CHAIN_NODES.JOB_CHAIN_ID=INVENTORY_JOB_CHAINS.ID
        • find the related Jobs in the INVENTORY_JOBS table
          • INVENTORY_JOBS.ID= INVENTORY_JOB_CHAIN_NODES.JOB_ID
        • rename one of the existing jobs with the JOE Editor or manually
        • rename again using the original name
        • compare the INVENTORY_JOB_CHAIN_NODES and INVENTORY_JOBS tables
          • INVENTORY_JOB_CHAIN_NODES table contains the old (no more exists) JOB_ID

      Workaround

      • JobScheduler restart

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                sp Santiago Aucejo Petzoldt
                Reporter:
                re Robert Ehrlich
                Approver:
                Kanika Agrawal
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: