Problem Note 62693: The SAS® Compliance Solution alert-generation process fails in the FCF_REPLICATE_EXT_TRANSACTIONS.SAS macro after you apply Hot Fix A5T002
 |  |  |  |  |
The following error occurs when you run the replicate external party transaction section of the alert-generation process. The problem occurs after you apply Hot Fix A5T002 for SAS Compliance Solutions:
ERROR: ORACLE prepare error: ORA-00933: SQL command not properly ended. SQL statement: select TRN.*, ALT.TEMP_NUM_1_VALUE as
alert_id from FCFBU1.FSK_TEMP_TABLE ALT, join FCFBU1.FSK_REPLICATION_DATES DTE on ALT.TEMP_NUM_1_VALUE = DTE.alert_id join
FCFBU1.fsc_cash_flow_fact FCT on FCT.BENEFICIARY_EXT_PARTY_KEY = ALT.TEMP_NUM_2_VALUE join FCFBU1.FSC_TRANSACTION_DIM TRN on
FCT.transaction_key = TRN.transaction_key where FCT.date_key > DTE.start_date_key and FCT.date_key <= 20170130.
alert_id from FCFBU1.FSK_TEMP_TABLE ALT, join FCFBU1.FSK_REPLICATION_DATES DTE on ALT.TEMP_NUM_1_VALUE = DTE.alert_id join
FCFBU1.fsc_cash_flow_fact FCT on FCT.BENEFICIARY_EXT_PARTY_KEY = ALT.TEMP_NUM_2_VALUE join FCFBU1.FSC_TRANSACTION_DIM TRN on
FCT.transaction_key = TRN.transaction_key where FCT.date_key > DTE.start_date_key and FCT.date_key <= 20170130.
Note: This is the message that you receive if you use Oracle. This message can be different if you use a different database.
The syntax error in the FCF_REPLICATE_EXT_TRANSACTIONS.SAS compiled macro is fixed in Hot Fix A5T003 for SAS Compliance Solutions.
To fix the issue, install the latest SAS Compliance Solutions hot fix.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Compliance Solutions | Linux for x64 | 7.1 | 7.1 | 9.4 TS1M4 | 9.4 TS1M4 |
| 64-bit Enabled Solaris | 7.1 | 7.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| 64-bit Enabled AIX | 7.1 | 7.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
| Microsoft® Windows® for x64 | 7.1 | 7.1 | 9.4 TS1M4 | 9.4 TS1M4 | ||
A fix for this issue for SAS Compliance Solutions 7.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A5T.html#62693| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2018-08-01 10:47:40 |
| Date Created: | 2018-07-30 13:28:20 |