Problem Note 71043: Running a scenario flow in SAS® Anti-Money Laundering fails during external replication when using Microsoft SQL Server Database
 |  |  |  |  |
An error might occur during replication when running scenario flow in SAS Anti-Money Laundering when you use an external replication table (entity table storage) defined in a Microsoft SQL Server database.
As a result, an error similar to the following might occur:
NOTE: Performing serial SaveTable action using SAS Data Connector to SQL Server.
ERROR: ERROR: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Invalid object name 'amlprep'.
ERROR: ERROR: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Statement(s) could not be prepared.
NOTE: The target table has been dropped due to a failure during the Save action.
ERROR: Function failed.
ERROR: The action stopped due to errors.
debug=0x80fff802:TKTS_ERROR
To circumvent this issue, add EnableQuotedIdentifiers=1 to your odbc.ini file and review the Set up an External Microsoft SQL Server Database section of the SAS Anti-Money Laundering Adminstrator's Guide.
Click 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 (on SAS 9.x) | Linux for x64 | 8.3 | |||
An update for this issue is available for SAS Compliance Solutions 8.3. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/ComplianceSol_83_home.html#71043| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2024-12-17 16:04:23 |
| Date Created: | 2024-11-08 14:49:20 |