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
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 | |
*
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: | 2016-10-06 08:42:49 |
Date Created: | 2016-08-08 13:24:38 |