000035830 - Data Feeds report the error "is_dde_filter_value_list_action_cumulative" in RSA Archer

Document created by RSA Customer Support Employee on Dec 16, 2017
Version 1Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000035830
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Data Feeds
RSA Version/Condition: 6.2.0.4
Platform: Windows
IssueAfter the upgrading from RSA Archer 5.x to 6.x the following two errors for Data Feeds (UI / Execution History) begin to occur.

Unable to login with specified credentials


is_dde_filter_value_list_action_cumulative

Data feeds don't run (which may occur intermittently) and throw these errors:

No related errors are in the logs.
CauseThis is caused by an old RSA Archer 5.x server still running the job engine service and picking up the jobs from the queue.
The old version is unaware of the new column "is_dde_filter_value_list_action_cumulative" added into the database in later versions.
ResolutionThe old server can be identified by running the script below on the instance database.

SELECT EngineInstance, COUNT(*) FROM tblAsyncInstrumentation 
GROUP BY EngineInstance 
ORDER BY COUNT(*) DESC

This will list all servers picking the jobs.  Upon recognizing the old server, stop the job engine service on it to resolve the issue.

Attachments

    Outcomes