SUPPORT / SAMPLES & SAS NOTES
Problem Note 20077: Incorrect transaction counts are returned for Account, Customer, and Household in the All Available Alerts tab
 |  |  |  |  |
Incorrect transaction counts are displayed in the All Available Alerts tab. This is due to a problem with the queries that are defined in SASAML.DB2 and SASAML.ORACLE. There is a UNION ALL join statement that is double counting transactions in these queries:
sasaml.alerttrans.allcore.foracct.count.sqlsasaml.alerttrans.allcore.forhousehold.count.sql
sasaml.alerttrans.allcore.forparty.count.sql
The UNION ALL statement should be changed to a UNION join.
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering Alert Generation Server | Microsoft Windows XP Professional | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |
| Microsoft Windows NT Workstation | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Server | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Datacenter Server | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Advanced Server | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Linux | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Solaris | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled Solaris | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| Microsoft Windows 2000 Professional | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| 64-bit Enabled AIX | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||
| AIX | 2.1 | 2.2 | 9.1 TS1M3 SP4 | |||