Problem Note 67233: The Run Date and Create Date fields in the Targeted Search Results data grid do not contain the correct information
 |  |  |  |  |
In SAS® Anti-Money Laundering, the dates that are displayed in the fields of the Create Date and Run Date columns in the alert Targeted Search Results data grid are off by a day when compared to their corresponding date values in the FSK_ALERT table in the Knowledge Center database.
There is a workaround for the Create Date column. Take the following steps:
- Update the Apache Solr data-config.xml file for each business unit for the alert entity. Use the following format string for the Create Date column in the file:
<field column="CREATE_DATE" name="create_date" dateTimeFormat="yyyy-MM-dd HH:mm:ss"/>
- Save the changes for the Apache Solr data-config.xml file.
- Reload the Apache Solr configuration.
- Re-index the affected alert entity.
There is no workaround for the Run Date column.
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#67233| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-01-21 16:38:46 |
| Date Created: | 2021-01-15 01:05:51 |