Problem Note 48576: The watch list parameter p10019_country_watch_list is truncated in SAS® Anti-Money Laundering
 |  |  |  |  |
When specifying a list of watch list countries in the Scenario Administrator for scenario SAS10018, parameter p10019_country_watch_list, truncation occurs if the list is greater than 1024 characters. The Scenario Administrator allows the user to enter more than 1024 characters. However, the column FSK_SCENARIO_PARAMETER.PARM_VALUE that stores the parameter values is defined at 1024 characters. Therefore, truncation occurs when storing character data that is greater than this amount.
Perform the following steps to avoid truncation:
- Edit the auotexec.sas file that is located in the \Lev1\Applications\AntiMoneyLaunderingAlertCfg\4.2\<Bank>\custom\config\ directory. Add the following options to the connection string for the Knowledge Center:
%let segKCDBLibOpts = %str(DBMAX_TEXT=4000); %let kcDBLibOpts = %str(DBMAX_TEXT=4000);
- Expand the column length of FSK_SCENARIO_PARAMETER.PARM_VALUE from 1024 bytes to 4000 bytes.
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 Server 2008 for x64 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 |
| Microsoft Windows XP Professional | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Enterprise 32 bit | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Enterprise x64 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Home Premium 32 bit | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Home Premium x64 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Professional 32 bit | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Professional x64 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Ultimate 32 bit | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows 7 Ultimate x64 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows Vista | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Windows Vista for x64 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| 64-bit Enabled AIX | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| 64-bit Enabled HP-UX | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| 64-bit Enabled Solaris | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| HP-UX IPF | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Linux | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Linux for x64 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Solaris for x64 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 R2 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2008 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
| Microsoft® Windows® for x64 | 4.2 | 5.1_M1 | 9.2 TS2M3 | 9.3 TS1M2 | ||
A fix for this issue for SAS Anti-Money Laundering 4.2 is available at:
http://ftp.sas.com/techsup/download/hotfix/HF2/D05.html#48576A fix for this issue for SAS Anti-Money Laundering 5.1_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/J74.html#48576A fix for this issue for SAS Anti-Money Laundering 5.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/R26.html#48576| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2014-04-11 10:10:06 |
| Date Created: | 2012-11-30 14:20:02 |