SUPPORT / SAMPLES & SAS NOTES
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | |||