000029105 - data feed token LastRunTime does not work

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

Article Content

Article Number000029105
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Archer
RSA Version/Condition: 5.3.1
Platform: Windows
Platform (Other): null
O/S Version: Customer doesn't know/not sure-see notes
Product Name: null
Product Description: null
IssueSQL data feed to bring in new records, if a record was processed yesterday then don’t bring it in again and do not update the existing record in Archer. Initial approach is use the LastRunTime token in the SQL query.
Data Feed Token document states: Time Date/Time Date and time the last execution completed. One use for this token is to process deltas of the source content. For example, when running a Database Query Transporter, this token can be included in the WHERE clause of the query string to only include records from the source database that were inserted.
Query in the data feed manager to pull in records where the date/time from the [AddedOn] field is greater than the last time the data feed ran successfully. 
SELECT [ID] ,[Status] ,[DID] ,[AddedOn] FROM [db].[dbo].[tbl_Archer_Extract] WHERE [AddedOn] > {LastRunTime}
When this feed runs the following error results: Incorrect syntax near ‘00’.

ResolutionExpected to be fixed in 5.5.2 or greater. Change the {LastRunTime} in the SQL to LEFT('{LastRunTime}', 23)
This removes extra time information recorded in the TOKEN for LastRunTime and allows for a match from the source SQL database.