|Applies To||RSA Product Set: Archer|
RSA Product/Service Type: Data Feeds
RSA Version/Condition: 18.104.22.168
|Issue||After the upgrading from RSA Archer 5.x to 6.x the following two errors for Data Feeds (UI / Execution History) begin to occur.|
Data feeds don't run (which may occur intermittently) and throw these errors:
|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.
|Resolution||The old server can be identified by running the script below on the instance database.|
This will list all servers picking the jobs. Upon recognizing the old server, stop the job engine service on it to resolve the issue.