Problem Note 62919: Error messages are seen in SAS® Anti-Money Laundering after you open either a case or an entity that has 10 or more related cases
After you open a case in the user interface, the Case Details window shows error pop-up messages when the case that you are opening has 10 or more related cases:
Similarly, you encounter the same error message in the Entity Details window when you try to view an entity that has 10 or more related cases.
SASComplianceSolutionsMid7.1.log shows the following lines:
2018-06-14 14:42:03,422 ERROR [tomcat-http--15] - DataAccessException error.
org.springframework.jdbc.InvalidResultSetAccessException: PreparedStatementCallback; invalid ResultSet access for SQL [SELECT COUNT(DISTINCT A.CASE_ID) FROM FSK_CASE_ENTITY B LEFT JOIN FSK_CASE A ON B.CASE_ID=A.CASE_ID WHERE B.ENTITY_LEVEL_CODE = ? AND B.%ID_OR_KEY_COLUMN% = ? AND ( ( TRUNC(CREATE_DATE) >= ? or ( TRUNC(A.LSTUPDATE_DATE) >= ? and CASE_STATUS_CODE in ( ?,? ) ) ) ) ]; nested exception is java.sql.SQLException: Invalid column index
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:241)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:605)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:639)
...more data...
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 x64 | 7.1 | | | |
64-bit Enabled AIX | 7.1 | | | |
64-bit Enabled Solaris | 7.1 | | | |
Linux for x64 | 7.1 | | | |
*
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.
The error messages "Error: An unexpected data access error has occurred. Please contact the administrator. rest/cases: 400: Bad Request" and "Could not load cases" appear after you try to open either a case with 10 or more related cases or an entity with 10 or more related cases.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2018-10-15 15:40:00 |
Date Created: | 2018-09-14 09:22:30 |