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...
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
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| 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 | |||||
A fix for this issue for SAS Compliance Solutions 7.1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A5T.html#62919
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 |