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

Document created by RSA Customer Support Employee on Oct 6, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • Comment • 0
  • 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.

Attachments

    Outcomes