TSSA/BSA  ORA-02291: integrity constraint (BLADELOGIC.FK1197_JOB_RESULT) violated - parent key not found

Version 3
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Server Automation Suite


    APPLIES TO:

    TrueSight Server Automation Suite 8.x



    PROBLEM:

    When you run a patching job multiple times too close together, each job run will use the same download job.

    If a download job from 1 patching job run starts while the download job from a different run is still running, it will fail with the error saying the job is already running.

    Here is an entry from the download job from one of the job runs:

    4/13/2020 22:51 Job 'download-job--1-remediate-25813556-Patch Analysis & Remediation Job2020-04-13 21-26-21-938-0400-2020-04-13 21-26-21-961-0400' was manually executed by User:Role 'BLAdmin':'BLAdmins'.

    Here is an entry from the download job from one of the other job runs:

    4/13/2020 22:54 Error executing the download job,Error: Job 'download-job--1-remediate-25813556-Patch Analysis & Remediation Job2020-04-13 21-26-21-938-0400-2020-04-13 21-26-21-961-0400' is already running

    You will also see the following error in the appserver log:

    ORA-02291: integrity constraint (BLADELOGIC.FK1197_JOB_RESULT) violated - parent key not found


    CAUSE:

    Patching job runs were scheduled to run too close together.


    SOLUTION:

    Schedule the job runs farther apart so they don't try to run a download job at the same time.

    This is RFE QM002021376.


    Article Number:

    000191578


    Article Type:

    Solutions to a Product Problem



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles