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

    • Fix
    • Status: Released (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 1.12.9
    • 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

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

              Dates

                Created:
                Updated:
                Resolved: