Problem Note 58746: A "Column new_file_nm could not be found" error occurs when you import a scenario using the Scenario Administrator in SAS® Anti-Money Laundering
 |  |  |  |  |
When you import a scenario package (*.spk) using the Scenario Administrator in SAS Anti-Money Laundering, you might encounter the following error message:
ERROR: Column new_file_nm could not be found in the table/view identified with the correlation name P.
After you encounter the error, you might be able to work around the problem by attempting to import the same scenario package again.
To fix the issue, find the following procedure in the fcf_sa_import_scenarios.sas macro:
proc sql;
create table &worklib..fcf_files_new as
select f.*, p.party_rk as party_rk_new, p.new_file_nm
from &worklib..fcf_files f
join &worklib..p_live_new p
on f.party_rk = p.party_rk_old
;
run;
Replace the procedure above with the following:
proc sql;
create table &worklib..fcf_files_new as
select f.*, p.party_rk as party_rk_new
from &worklib..fcf_files f
join &worklib..p_live_new p
on f.party_rk = p.party_rk_old
;
run;
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 | Linux for x64 | 6.3 | 9.4 TS1M2 | ||
| 64-bit Enabled Solaris | 6.3 | 9.4 TS1M2 | ||||
| 64-bit Enabled AIX | 6.3 | 9.4 TS1M2 | ||||
| Microsoft® Windows® for x64 | 6.3 | 9.4 TS1M2 | ||||
A fix for this issue for SAS Compliance Solutions 6.3_M1 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/A1I.html#58746| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2016-10-06 08:42:49 |
| Date Created: | 2016-08-08 13:24:38 |