Problem Note 35772: The PROMOTE_SCENARIOS macro in SAS® Anti-Money Laundering might generate a constraint error when the macro is invoked twice
 |  |  |  |  |
The PROMOTE_SCENARIOS macro might fail for all Database Management Systems (DBMS) when an Advanced Routing Rule is being promoted and the macro is executed twice. This is due to the constraints that are placed on the Fsk_Routing_Rule and Fsk_Routing_Constraint tables.
The PROMOTE_SCENARIOS macro is deleting rows from the Fsk_Routing_Rule table prior to deleting referenced rows in the Fsk_Routing_Constraint table. This action violates the following reference index constraint imposed on the two tables.
Select the Hot Fix tab in this note to access the hot fix for this issue.
The fix contains code that has been changed to delete rows from the Fsk_Routing_Constraint table first, then delete rows from the Fsk_Routing_Rule table. This prevents the constraint error from occurring when the macro is executed twice.
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 2000 Advanced Server | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
| Microsoft Windows 2000 Datacenter Server | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Server | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows 2000 Professional | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows NT Workstation | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows Server 2003 Standard Edition | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Microsoft Windows XP Professional | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Windows Vista | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled AIX | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled HP-UX | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| 64-bit Enabled Solaris | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||
| Linux | 2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 | ||