Problem Note 63268: You see a warning when you append a REPLICATION_DATES table to DB_KC.fsk_REPLICATION_DATES in a relational database management system (RDBMS)
 |  |  |  |  |
When the %FCF_GET_REPLICATE_INFO macro executes, a warning might occur when a table is appended from the SAS Work library to the SAS® Anti-Money Laundering database in the RDBMS.
The issue occurs when the RDBMS is Teradata or Microsoft SQL Server.
The following warning appears in the alert generation process (AGP) log about the datetime format. The datetime format is assigned to a START_DATE column, and the format is different in both of the tables that are used in the APPEND procedure:
There is no workaround, and it is not possible to suppress this warning. Despite the difference in the datetime format between both tables, the APPEND procedure completes successfully with no loss of information.
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 | Microsoft® Windows® for x64 | 7.1 | |||
| 64-bit Enabled AIX | 7.1 | |||||
| 64-bit Enabled Solaris | 7.1 | |||||
| Linux for x64 | 7.1 | |||||
A fix for this issue for SAS Compliance Solutions 7.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A5T.html#63268| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-01-22 13:04:54 |
| Date Created: | 2018-11-27 10:02:39 |