When running the Dow Jones Watch-list ETL process in SAS Anti-Money Laundering with Oracle in the UTF-8 mode, the following error might appear in the log:

ERROR: ERROR: ERROR: ORACLE execute error: ORA-12899: value too large for column
"ALSCORE"."FSC_ENTITY_WATCH_LIST_DIM"."MATCH_CODE_INDIVIDUAL" (actual: 19,
maximum: 15).
NOTE: Statements not processed because of errors noted above.

This error occurs when SAS^® attempts to store UTF-8 characters in the FSC_ENTITY_WATCH_LIST_DIM.MATCH_CODE_INDIVIDUAL column. The column length VARCHAR 15, UTF-8 characters might exceed this length.

To avoid this error run the Dow Jones Watch List ETL using a UTF-8 encoded instance of SAS. To do this, perform the following steps:

1. Go to !SASHOME\SASFoundation\9.2.
2. Edit the SASV9.CFG file.

   Locate this line:

   -CONFIG "C:\Program Files\SAS\SASFoundation\9.2\nls\en\SASV9.CFG"
   
   

   Change the preceding line as follows:

   -CONFIG "C:\Program Files\SAS\SASFoundation\9.2\nls\u8\SASV9.CFG"


3. Next, if you are using Oracle, from a command prompt go to the following directory and set NLS_LANG as follows:
   C:\Program Files\SAS\SASFoundation\9.2>set NLS_LANG=American_America.UTF8


4. Type sas to start SAS as follows:
   C:\Program Files\SAS\SASFoundation\9.2>sas

Setting the Oracle NLS_LANG parameter enable UTF-8 characters to be stored in the FSC_ENTITY_WATCH_LIST_DIM.MATCH_CODE_INDIVIDUAL column.

Operating System and Release Information