Problem Note 35339: Duplicate scenario categories might appear in the SAS® Anti-Money Laundering Advanced Query screen of the Investigation user interface
 |  |  |  |  |
In earlier versions of SAS Anti-Money Laundering, the scenario category information wasn't stored in the Fsk_Lov table. The query sasaml.lov.sql used a UNION ALL statement to obtain this information from other tables.
At SAS Anti-Money Laundering 2.1.1, the scenario category information was added to the Fsk_Lov table, therefore, the UNION statement was no longer necessary. However, it was not removed, and this might generate duplicate scenario categories in the user interface.
Select the Hot Fix tab in this note to access the hot fix for this issue.
The fix removes the UNION statement from the sasaml.lov.sql query and replaces it with the following code:
sasaml.lov.sql=(SELECT DISTINCT lov_type_name, lov_type_code, lov_type_desc,
lov_sort_position_number
FROM fsk_lov)
ORDER BY lov_type_name, lov_sort_position_number
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Microsoft Windows 2000 Advanced Server | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Datacenter Server | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled HP-UX | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled Solaris | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Linux | 2.1.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
A fix for this issue for SAS Anti-Money Laundering 2.2.1 is available at:
http://www.sas.com/techsup/download/hotfix/aml221.html#035339
Duplicate scenario categories might appear in the Advanced Query screen.
| Type: | Problem Note |
| Priority: | low |
| Date Modified: | 2009-08-11 11:16:42 |
| Date Created: | 2009-03-27 08:23:42 |