000034152 - RSA Archer Data Imports stuck in "Pending" state

Document created by RSA Customer Support Employee on Oct 6, 2016Last modified by RSA Customer Support on Apr 26, 2019
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000034152
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.X and 6.X
Platform: Windows
IssueData Import shows as "Pending" but you can check in the Archer Control Panel > Job Engine Manager > Failed Jobs and see that the job actually Faulted.
CauseVarious reasons the job faulted. The objective is to get the Archer UI to reflect the proper status.
ResolutionSQL access will be required.  You will need the ability to run UPDATE statements.
NOTE: Take a database backup of the RSA Archer Instance database prior to running ANY update statements

SELECT * FROM tblDataFeedHistory WHERE job_id = 'X'  --Insert Job ID here

SELECT * FROM tblDataFeedHistoryStatus --This will show you all the available status

UPDATE tblDataFeedHistory SET status_id = '3' WHERE job_id = 'x'  --Insert status here

You can now validate in the Archer UI that the Data Import reflects the proper status.