000033750 - How to start a Data Feed outside of RSA Archer 5.x using SQL

Document created by RSA Customer Support Employee on Aug 12, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000033750
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x
IssueHow to start a Data Feed outside of RSA Archer using SQL?
Client would like to trigger the first Data Feed in a convoy (Reference Feed) once a source file is delivered to a file share outside of an Archer process. Is there a way to trigger a Data Feed to execute outside of the Archer interface?
ResolutionSuggested workarounds:
The REST API can start Data Feeds starting in Archer 5.5 SP4, the following REST API calls were added for existing Data Feeds:
* Execute Data Feed
* Get History Message for a History
* Get Recent Run Detail for a Data Feed
* Get Run History for a Data Feed
The following direct SQL interaction can also be used to start a scheduled Data Feed 
1. Use the first select statement to locate the Data Feed ID
SELECT * FROM tblDataFeed WHERE datafeed_type_id = 1

2. Change the 4 after the > in the next two select statements with the one found in the first select statement. This will also show the next scheduled run time and date in the (InactiveUntil) column.
SELECT InactiveUntil, * FROM tblAsyncJobQueue WHERE JobType LIKE '%datafeed%'
AND CAST (named_arguments as varchar (max)) LIKE '%Assembly="0">4</value>%' AND running = 0

3. Run the following update to NULL out this schedule and cause the feed to be picked up by the Job engine and run as soon as possible. Remember to change the 4 after the > to the correct data feed ID.
update tblAsyncJobQueue set InactiveUntil = NULL WHERE JobType like '%datafeed%'
AND CAST (named_arguments AS varchar (max)) LIKE '%Assembly="0">4</value>%' AND running = 0