Problem Note 55300: You might encounter an error when you use the default settings for the Integrated Event Management (IEM) process in SAS® Anti-Money Laundering
 |  |  |  |  |
The Integrated Event Management (IEM) process synchronizes the data between the SAS® Financial Crimes Foundation and SAS® Enterprise Case Management databases. However, you might encounter a database error when you run the Integrated Event Management process with the default setting for the iem_performance_load macro variable in the fcf_autoexec.sas macro.
When the iem_performance_load macro variable is set to the default value of Yes, the Integrated Event Management process uses optimization to minimize execution time. The optimization requires that the user running the process has the ALTER SEQUENCE database permission. If you cannot grant the required database permission to the user running the process, you must change the value of iem_performance_load to No.
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 | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 |
| Linux for x64 | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Ultimate x64 | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Ultimate 32 bit | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Professional x64 | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 for x64 | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Microsoft Windows Server 2008 R2 | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| HP-UX IPF | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| 64-bit Enabled Solaris | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| 64-bit Enabled AIX | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Professional 32 bit | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Home Premium x64 | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Home Premium 32 bit | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Enterprise x64 | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Windows 7 Enterprise 32 bit | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||
| Microsoft® Windows® for x64 | 5.2 | 6.3 | 9.3 TS1M0 | 9.4 TS1M3 | ||