The following error message appears in the log file when you run the RC_UPDATE_ASSESSMENT_DATE section of the FCF_RAP.sas (Risk Assessment Process) program with Microsoft SQL Server in SAS Anti-Money Laundering.

ERROR: CLI execute error: [Microsoft][ODBC SQL Server Driver][SQL
Server]Incorrect syntax near 'base'. : [Microsoft][ODBC SQL Server Driver][SQL
Server]Incorrect syntax near the keyword 'where'.
NOTE: The SAS System stopped processing this step because of errors.

This issue is caused by an incorrect query syntax.

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

Operating System and Release Information

A fix for this issue for SAS Compliance Solutions 6.2_M1 is available at:

A fix for this issue for SAS Enterprise Case Management Mid-Tier 6.2_M1 is available at:

A fix for this issue for SAS Anti-Money Laundering 6.1_M1 is available at:

A fix for this issue for SAS Anti-Money Laundering 6.1 is available at:

A fix for this issue for SAS Anti-Money Laundering 5.1_M1 is available at:

A fix for this issue for SAS Anti-Money Laundering 5.1 is available at: