SUPPORT / SAMPLES & SAS NOTES
Problem Note 58750: All relationships associated with a party are deleted after you run the Integrated Event Management (IEM) process in SAS® Anti-Money Laundering
 |  |  |  |  |
The Integrated Event Management (IEM) process might incorrectly delete all relationships associated with a party. Instead of deleting only the specific relationship associated with a party, the %fcf_iem_close_dimension_rels macro might incorrectly delete all the corresponding relationship entries from the PARTY_X_PARTY table in SAS® Enterprise Case Management.
To work around the problem, replace the code section shown below:
proc sql;
delete from ecm_db.PARTY_X_PARTY
where PARTY_X_PARTY.PARTY_RK IN (
select PARTY_X_PARTY.PARTY_RK
from work.all_pty_x_pty as all_pty_x_pty inner join
ecm_db.PARTY_X_PARTY as PARTY_X_PARTY
on ( all_pty_x_pty.PARTY_RK = PARTY_X_PARTY.PARTY_RK and
all_pty_x_pty.MEMBER_PARTY_RK = PARTY_X_PARTY.MEMBER_PARTY_RK
)
);
quit;
Replace the preceding section with the corrected section shown below:
proc sql;
delete from ecm_db.PARTY_X_PARTY as ecm
where exists ( select 1
from
work.all_pty_x_pty as iem
where
iem.PARTY_RK = ecm.PARTY_RK and
iem.MEMBER_PARTY_RK = ecm.MEMBER_PARTY_RK and
iem.MEMBER_TYPE_CD = ecm.MEMBER_TYPE_CD
)
;
quit;
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 | Solaris for x64 | 6.1 | 9.4 TS1M0 | ||
| Linux for x64 | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Enterprise 32-bit | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows 8 Pro x64 | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows 8 Enterprise x64 | 6.1 | 9.4 TS1M0 | ||||
| HP-UX IPF | 6.1 | 9.4 TS1M0 | ||||
| 64-bit Enabled Solaris | 6.1 | 9.4 TS1M0 | ||||
| 64-bit Enabled AIX | 6.1 | 9.4 TS1M0 | ||||
| Windows 7 Professional x64 | 6.1 | 9.4 TS1M0 | ||||
| Windows 7 Enterprise x64 | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Std | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 R2 Std | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 R2 Datacenter | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2012 Datacenter | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 for x64 | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows Server 2008 R2 | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows 10 | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro x64 | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Pro 32-bit | 6.1 | 9.4 TS1M0 | ||||
| Microsoft Windows 8.1 Enterprise x64 | 6.1 | 9.4 TS1M0 | ||||
| Microsoft® Windows® for x64 | 6.1 | 9.4 TS1M0 | ||||