SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 54123: SQL queries against a DB2 database fail in SAS® Anti-Money Laundering

DetailsHotfixAboutRate It

Reference to a non-existing FSK_USER table is found in SQL queries that are listed in sasaml.db2. The incorrect reference can cause some SQL queries from the middle tier to fail.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Anti-Money LaunderingMicrosoft Windows Server 2008 R26.1
Microsoft Windows Server 2008 for x646.1
Microsoft Windows Server 2012 Datacenter6.1
Microsoft Windows Server 2012 R2 Datacenter6.1
Linux for x646.1
Microsoft Windows Server 2012 R2 Std6.1
Microsoft Windows Server 2012 Std6.1
Microsoft Windows XP Professional6.1
Windows 7 Enterprise 32 bit6.1
Windows 7 Enterprise x646.1
Windows 7 Home Premium 32 bit6.1
Windows 7 Ultimate 32 bit6.1
Windows Millennium Edition (Me)6.1
Windows Vista6.1
Windows Vista for x646.1
64-bit Enabled AIX6.1
64-bit Enabled Solaris6.1
HP-UX IPF6.1
Windows 7 Home Premium x646.1
Windows 7 Professional 32 bit6.1
Windows 7 Professional x646.1
Microsoft Windows Server 20086.1
Windows 7 Ultimate x646.1
Microsoft Windows Server 2003 for x646.1
Microsoft Windows Server 2003 Standard Edition6.1
Microsoft Windows Server 2003 Enterprise Edition6.1
Microsoft Windows Server 2003 Datacenter Edition6.1
Microsoft Windows NT Workstation6.1
Microsoft Windows 2000 Professional6.1
Microsoft Windows 2000 Server6.1
Microsoft Windows 2000 Datacenter Server6.1
Microsoft Windows 2000 Advanced Server6.1
Microsoft Windows 95/986.1
Microsoft Windows 8.1 Pro 32-bit6.1
Microsoft Windows 8.1 Pro6.1
Microsoft Windows 8.1 Enterprise x646.1
Microsoft Windows 8.1 Enterprise 32-bit6.1
Microsoft Windows 8 Pro x646.1
Microsoft Windows 8 Pro 32-bit6.1
Microsoft Windows 8 Enterprise x646.1
Microsoft Windows 8 Enterprise 32-bit6.1
Microsoft® Windows® for x646.1
Solaris for x646.1
* 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.