Problem Note 18061: A 314a query containing certain characters will cause java exceptions to
be surfaced to the client
In SAS® Anti-Money Laundering 1.4, when running a 314a query, if the
query contains certain characters such as "&", "%" or "'", an exception
like the following may be issued:
Error
An unexpected error has occurred in the application.
A system administrator has been notified.
Details:
com.sas.aml.service.ServiceException: Error getting Customer List
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL0010N
The string constant beginning with "'A ) order by party_last_name,
party_name" does not have an ending string delimiter. SQLSTATE=42603
Select 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 Alert Generation Server | Microsoft Windows XP Professional | 1.4 | 2.1 | 9.1 TS1M3 | |
| Microsoft Windows NT Workstation | 1.4 | 2.1 | 9.1 TS1M3 | |
| Microsoft Windows 2000 Datacenter Server | 1.4 | 2.1 | 9.1 TS1M3 | |
| Microsoft Windows 2000 Professional | 1.4 | 2.1 | 9.1 TS1M3 | |
| Microsoft Windows 2000 Server | 1.4 | 2.1 | 9.1 TS1M3 | |
| Microsoft Windows 2000 Advanced Server | 1.4 | 2.1 | 9.1 TS1M3 | |
| Linux | 1.4 | 2.1 | 9.1 TS1M3 | |
| Solaris | 1.4 | 2.1 | 9.1 TS1M3 | |
| 64-bit Enabled Solaris | 1.4 | 2.1 | 9.1 TS1M3 | |
| 64-bit Enabled AIX | 1.4 | 2.1 | 9.1 TS1M3 | |
| AIX | 1.4 | 2.1 | 9.1 TS1M3 | |
*
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: | high |
| Date Modified: | 2006-08-04 08:07:35 |
| Date Created: | 2006-07-13 11:18:21 |
