![]() | ![]() | ![]() | ![]() | ![]() |
You might experience poor performance in the Investigation user interface (UI) with queries that use the Fsc_Transaction_View table. The reason for the slow performance is that the UI adds a JOIN statement to the Fsc_Account_Dim table at the end of the Fsc_Transaction_View query.
Select the Hot Fix tab in this note to access the hot fix for this issue.
The JOIN statement has been incorporated into the Fsc_Transaction_View table to improve the performance. The metadata table Fsk_Ui_Column has also been modified to prevent the UI from adding the JOIN statement after the view code.
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 |