Problem Note 63556: Applying a hot fix for SAS® Anti-Money Laundering results in an error during the data definition language (DDL) application
 |  |  |  |  |
You might encounter an error that is similar to the following after you apply Hot Fix A5T005 for SAS® Anti-Money Laundering 7.1:
REORG TABLE FCFKC.FSK_ALERTED_ENTITY
The command was processed as an SQL statement because it was not a valid Command Line Processor command.
During SQL processing it returned:
During SQL processing it returned:
SQL0104N An unexpected token "END-OF-STATEMENT" was found following "C.FSK_ALERTED_ENTITY".
Expected tokens may include: "JOIN <joined_table>".
Expected tokens may include: "JOIN <joined_table>".
SQLSTATE=42601
This issue occurs if IBM DB2 is your solution database provider.
To work around this issue, you can do either of the following:
- Apply Hot Fix A5T007 (or a later hot fix).
- Replace line 32 of the db2_7.1_to_7.1HF4_ddl.sql file with the following text:
REORG TABLE FCFKC.FSK_ALERTED_ENTITY;
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 | 7.1 | 9.4 TS1M6 | |
| 64-bit Enabled AIX | 7.1 | 7.1 | 9.4 TS1M6 | |||
| 64-bit Enabled Solaris | 7.1 | 7.1 | 9.4 TS1M6 | |||
| Linux for x64 | 7.1 | 7.1 | 9.4 TS1M6 | |||
A fix for this issue for SAS Compliance Solutions 7.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A5T.html#63556
You can encounter an error while applying Hot Fix A5T005 if you use IBM DB2 as a solution database provider. The error text looks similar to the following: "REORG TABLE FCFKC.FSK_ALERTED_ENTITY The command was processed as an SQL statement because it was not a valid Command Line Processor command."
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2019-10-14 15:43:22 |
| Date Created: | 2019-01-28 11:09:32 |