Problem Note 66099: The message "An unexpected data access error has occurred" appears in the user interface when you try to view audit events for CDD Reviews
In the user interface for SAS® Anti-Money Laundering 7.1, you click the CDD Reviews menu and select a review to view it. After you click View audit events to see the list of events, the page fails to display and the following error appears in the UI:
An unexpected data access error has occurred. Please contact the administrator.
rest/auditEvents: 400: Bad Request
The SASComplianceSolutionsMid7.1.log file can display information similar to the following; in this example, the database is Oracle:
ERROR 2020-05-18 04:20:49,176 [tomcat-http--45] - DataAccessException error.
org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [SELECT COUNT ( distinct event_id ) FROM FSK_RISK_ASSESSMENT_EVENT where review_key=? ];
nested exception is java.sql.SQLSyntaxErrorException: ORA-00904: "REVIEW_KEY": invalid identifier
This problem occurs when a review is linked to a greater number of audit events than the number of events that are enabled for display by the audit.events.paging.size preference.
You can use one of the following workarounds.
- Increase the value of the audit.events.paging.size preference.
This preference sets the number of audit events that can be retrieved at one time. The default value is 20. When you reset the value to be greater than the expected total number of audit events, all events can load simultaneously.
- Correct the query that is used to retrieve the information about this page. Here are the steps:
1. In SAS® Management Console, navigate to Application Management ► Configuration Manager ► SAS Application Infrastructure ► Compliance Solutions Mid 7.1. You then need to right-click and select Properties, and then go to the Settings tab.
2. Within Compliance Solution ► Knowledge Center database information, check whether you already have a Knowledge Center (KC) database override file in place. If you do, go to Step 7.
3. If there is no override file, enter your preferred name for the override file. The example in these steps uses the name sascustom.properties. Save your changes in SAS Management Console.
4. Go to SAS-configuration-directory\Lev1\Web\WebAppServer\SASServer8_1\sas_webapps\sas.financialservices.aml.war\WEB-INF.
5. Create a directory that is called classes.
6. In this directory, create the file with the name sascustom.properties.
7. Open the sascustom.properties file and insert the following line into it:
sasaml.auditrail.getCddReview.count.sql= SELECT COUNT ( distinct event_id )
FROM FSK_CDD_REVIEW_EVENT where review_key=? %FILTERS%
8. Save the file.
9. Then, at minimum, you must clear the cache in the UI (if the setting was already in place in SAS Management Console) or restart the SASServer8 service (if you had to create the setting).
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.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2020-06-15 10:34:24 |
Date Created: | 2020-06-08 09:15:06 |