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

    Details

    • Type: Fix Fix
    • Status: Released (View Workflow)
    • Priority: Minor 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

        Issue Links

          Activity

          There are no comments yet on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved: