000035830 - In Data Feeds reports the error "is_dde_filter_value_list_action_cumulative" is seen in RSA Archer

Document created by RSA Customer Support Employee on Dec 16, 2017•Last modified by RSA Customer Support Employee on Jul 3, 2019
Version 2Show 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 the error:
 
No related errors are in the logs.
Cause
  • This 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 following script 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