Failed Package installation stuck in running status in Archer
RSA Product Set: Archer RSA Version/Condition: 6x
The Archer user interface indicates that a package installation is running. However, the job is no longer running in the job engine. A new package installation for this package cannot be started while the existing one is stuck in a running state.
The job may have failed or may have been intentionally removed.
Replace the highlighted area (e.g. INSERT PACKAGE NAME) and insert package name. Run the first query to display the status of package installation
/* ** DISPLAY STATUS OF PACKAGE INSTALLATION **
Vers. 6.2.x. Mar 2017. RS
** LIST JOB STATUS CODES **
SELECT * FROM tblJobStatusDef
FROM tblPackage p
JOIN tblPackageRun pr on pr.package_id=p.package_id
JOIN tblJobStatus js on js.job_id=pr.job_id
JOIN tblJobStatusDef jsd on jsd.job_status_id=js.job_status_id
WHERE p.package_name = 'INSERT PACKAGE NAME'
Replace the Job ID found from the first query and replace into the high-lighted area (e.g. INSERT JOB ID)
/* ** TO SET JOB STATUS TO 4=FAILED: ** */
WHERE job_id = 'INSERT JOB ID'