Problem Note 41891: With SAS® Anti-Money Laundering, an Oracle error occurs when clicking the Alert ID link of a transaction that is listed on the All Available tab
The following Oracle error ORA-00918 occurs when you click the Alert ID link of a transaction that is listed on the All Available tab:
An unexpected error has occurred in the application.
Please have an administrator review the system log.
Details:
com.sas.aml.service.ServiceException:
Error getting Alert Transaction Count using:
select count(tran.transaction_key) from ( SELECT DISTINCT transaction_key
FROM fsc_cash_flow_fact cff JOIN fsc_account_dim acct ON acct.account_key =
cff.account_key JOIN fsc_transaction_dim td ON cff.transaction_key =
td.transaction_key WHERE acct.account_number = ? UNION SELECT DISTINCT
transaction_key FROM fsc_account_trade_fact atf JOIN fsc_account_dim acct ON
acct.account_key = atf.account_key JOIN fsc_transaction_dim td ON
atf.transaction_key = td.transaction_key WHERE acct.account_number = ? UNION
SELECT DISTINCT transaction_key FROM fsc_account_event_fact aef JOIN
fsc_account_dim acct ON acct.account_key = aef.account_key JOIN
fsc_transaction_dim td ON aef.transaction_key = td.transaction_key WHERE
acct.account_number = ? UNION SELECT DISTINCT transaction_key FROM
fsk_cash_flow_alert cfa JOIN fsc_account_dim acct ON acct.account_key =
cfa.account_key JOIN fsk_transaction_alert ta ON cfa.transaction_key =
ta.transaction_key WHERE acct.account_number = ? UNION SELECT DISTINCT
transaction_key FROM fsk_account_trade_alert ata JOIN fsc_account_dim acct ON
acct.account_key = ata.account_key JOIN fsk_transaction_alert ta ON
ata.transaction_key = ta.transaction_key WHERE acct.account_number = ? UNION
SELECT DISTINCT transaction_key FROM fsk_account_event_alert aea JOIN
fsc_account_dim acct ON acct.account_key = aea.account_key JOIN
fsk_transaction_alert ta ON aea.transaction_key = ta.transaction_key WHERE
acct.account_number = ? ) tran
java.sql.SQLException: ORA-00918:
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
SAS System | SAS Anti-Money Laundering | Microsoft® Windows® for 64-Bit Itanium-based Systems | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Datacenter 64-bit Edition | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Enterprise 64-bit Edition | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Microsoft Windows XP 64-bit Edition | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Microsoft Windows 2000 Advanced Server | 2.2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Datacenter Server | 2.2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Server | 2.2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
Microsoft Windows 2000 Professional | 2.2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
Microsoft Windows NT Workstation | 2.2.1 | 2.2.1 | 9.1 TS1M3 SP4 | 9.1 TS1M3 SP4 |
Microsoft Windows Server 2003 Datacenter Edition | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Enterprise Edition | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Microsoft Windows Server 2003 Standard Edition | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Microsoft Windows XP Professional | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Windows Vista | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Windows Vista for x64 | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
64-bit Enabled AIX | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
64-bit Enabled HP-UX | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
64-bit Enabled Solaris | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
HP-UX IPF | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Linux | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
Solaris for x64 | 2.2.1 | 4.1 | 9.1 TS1M3 SP4 | 9.2 TS2M2 |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
Type: | Problem Note |
Priority: | medium |
Date Modified: | 2010-12-17 10:42:30 |
Date Created: | 2010-12-16 16:56:57 |