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