SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 14888: Replicate_Transactions job runs slow for large volumes of alerts

DetailsHotfixAboutRate It
Replicate_Transactions performs poorly for large volumes of alerts.  The
SQL query that fetches transactions for alerts needs to be converted to
SQL pass-thru.



A fix for this issue is available at:

http://www.sas.com/techsup/download/hotfix/aml14.html#014888


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Anti-Money Laundering Alert Generation ServerMicrosoft Windows XP Professional1.42.19.1 TS1M3
Microsoft Windows NT Workstation1.42.19.1 TS1M3
Microsoft Windows 2000 Datacenter Server1.42.19.1 TS1M3
Microsoft Windows 2000 Professional1.42.19.1 TS1M3
Microsoft Windows 2000 Server1.42.19.1 TS1M3
Microsoft Windows 2000 Advanced Server1.42.19.1 TS1M3
Linux1.42.19.1 TS1M3
Solaris1.42.19.1 TS1M3
64-bit Enabled Solaris1.42.19.1 TS1M3
64-bit Enabled AIX1.42.19.1 TS1M3
AIX1.42.19.1 TS1M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.