Problem Note 63099: You see a "CLI execute error . . ." regarding the FSK_RC_REPORT_ENTITY_BRIDGE table in SAS® Anti-Money Laundering after you apply Hot Fix A5T006
 |  |  |  |  |
In SAS Anti-Money Laundering, you might encounter a CLI execute error related to a Delete operation that violated a constraint. You also see an error that states that data from a particular database has been rolled back.
Here are examples of these types of error:
ERROR: CLI execute error: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The DELETE statement conflicted with the
REFERENCE constraint "FSK_RC_ENT_BRIDGE_RPT". The conflict occurred in database "localdb1", table
"FCFKC.FSK_RC_REPORT_ENTITY_BRIDGE", column 'report_key'. : [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The
statement has been terminated.
REFERENCE constraint "FSK_RC_ENT_BRIDGE_RPT". The conflict occurred in database "localdb1", table
"FCFKC.FSK_RC_REPORT_ENTITY_BRIDGE", column 'report_key'. : [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The
statement has been terminated.
ERROR: ROLLBACK issued due to errors for data set data-set-name.
These types of error occur when all of the following conditions are true:
- There is at least one Risk Classification (RC) report in your environment.
- You try to restore data that was backed up before you applied Hot Fix A5T006.
- Microsoft SQL Server is the underlying database for your environment.
To resolve this issue, drop and re-create the FSK_RC_ENT_BRIDGE_RPT foreign-key constraint on the FSK_RC_REPORT_ENTITY_BRIDGE table. Here are two examples of queries that can remove and re-create the constraint:
ALTER TABLE SCHKC.FSK_RC_REPORT_ENTITY_BRIDGE
DROP CONSTRAINT FSK_RC_ENT_BRIDGE_RPT
GO
DROP CONSTRAINT FSK_RC_ENT_BRIDGE_RPT
GO
ALTER TABLE SCHKC.FSK_RC_REPORT_ENTITY_BRIDGE
ADD CONSTRAINT FSK_RC_ENT_BRIDGE_RPT FOREIGN KEY (report_key) REFERENCES SCHKC.FSK_RC_REPORT (report_key)
GO
ADD CONSTRAINT FSK_RC_ENT_BRIDGE_RPT FOREIGN KEY (report_key) REFERENCES SCHKC.FSK_RC_REPORT (report_key)
GO
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 | Linux for x64 | 7.1 | |||
| 64-bit Enabled Solaris | 7.1 | |||||
| 64-bit Enabled AIX | 7.1 | |||||
| Microsoft® Windows® 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#63099
The FSK_RC_REPORT_ENTITY_BRIDGE table attempts to restore data after you apply Hot Fix A5T006. You then encounter a "CLI execute error . . . ." message. This error occurs when Microsoft SQL Server is your underlying database.
| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2018-10-23 15:50:23 |
| Date Created: | 2018-10-19 15:55:58 |