Problem Note 67459: You are unable to process a FinCEN e-file response process because rr_job_resp_fincen_process.sas fails in SAS® Anti-Money Laundering
 |  |  |  |  |
You might encounter the following messages while running rr_job_resp_fincen_process.sas to process FinCEN (Financial Crimes Enforcement Network) e-file response files:
MPRINT(RR_RESP_FINCEN_UPDATE): proc append base=kc.rr_resp_error_list data=rr_resp_error_list force nowarn;
MPRINT(RR_RESP_FINCEN_UPDATE): run;
NOTE: FORCE is specified, so dropping/truncating will occur.
NOTE: There were 11 observations read from the data set WORK.RR_RESP_ERROR_LIST.
NOTE: 11 observations added.
NOTE: The data set KC.RR_RESP_ERROR_LIST has . observations and 12 variables.
ERROR: During insert: ERROR: duplicate key value violates unique constraint "rr_resp_error_list_pkey"; Error while executing the query
NOTE: Statements not processed because of errors noted above.
The FinCEN response file might include multiple errors with the same error codes, which the RR_RESP_ERROR_LIST data model in Postgres does not support.
The primary key is defined as PRIMARY KEY (response_id, rr_report_id, error_cd) instead of PRIMARY KEY (response_id, rr_report_id, error_cd, error_seq_no).
The workaround is to update the RR_RESP_ERROR_LIST table in Postgres by using the SQL query below:
ALTER TABLE kc.rr_resp_error_list ADD PRIMARY KEY (response_id, rr_report_id, error_seq_no, error_cd);
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Anti-Money Laundering | Linux for x64 | 8.1 | 8.1 | Viya | Viya |
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-03-01 13:06:12 |
| Date Created: | 2021-02-18 16:49:40 |