000032135 - DPS (Data Publication Service) Delta Records in RSA Archer 5.5.2 are not accurate

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 Number000032135
Applies ToRSA Product Set: Archer
RSA Product/Service Type: Data Publication Service (DPS)
RSA Version/Condition: 5.5.2, 5.5.3
IssueDPS records in Archer 5.5.2 and 5.5.3 that are updated as a result of a calculation that references changes in related records are not getting published.
ResolutionThis issue has a fix in a future release.
Workaround Add the SQL (Structured Query Language) below to a SQL Server Agent job to run around 10 minutes before the DPS publishes, then new data shall be displayed the next time the DPS runs.
 
DECLARE @sqlCmd VARCHAR(MAX)
SELECT @sqlCmd = ISNULL(@sqlCmd,'') + ISNULL('DROP TABLE [' + t.TABLE_SCHEMA + '].[' +t.TABLE_NAME + '];
','')
FROM INFORMATION_SCHEMA.TABLES t
WHERE t.TABLE_TYPE = 'BASE TABLE'
ORDER BY t.TABLE_NAME
SELECT @sqlCmd
EXECUTE(@sqlcmd)


 

Attachments

    Outcomes