SUPPORT / SAMPLES & SAS NOTES
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 | |||