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:

The SASComplianceSolutionsMid7.1.log file can display information similar to the following; in this example, the database is Oracle:

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

A fix for this issue for SAS Compliance Solutions 7.1 is available at: