Deployment errors: ERROR: No logical assign for filename SCRSRV. WEBDAV filename=https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/party_watchlist_he ERROR: Error in the FILENAME statement. Filename=!AMLROOT/scenario/header_code_active/empty_header_v_1.sas WEBDAV filename=https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasd ERROR: Error in the FILENAME statement. Filename=!AMLROOT/scenario/header_code_active/ext_party_header_cor_v_1.sas WEBDAV filename=https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/defa ERROR: Error in the FILENAME statement. Filename=!AMLROOT/scenario/header_code_active/ext_party_header_msb_v_1.sas WEBDAV filename=https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/defa ERROR: Error in the FILENAME statement. Filename=!AMLROOT/scenario/header_code_active/ext_party_header_pty_v_1.sas WEBDAV filename=https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/defa Stored Process Error This request completed with errors. SAS Log 1 The SAS System 20:07 Tuesday, June 19, 2018 NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M3 MBCS3170) Licensed to BANGKOK BANK - AML HONG KONG SITE, Site 70237499. NOTE: This session is executing on the Linux 3.10.0-229.el7.x86_64 (LIN X64) platform. NOTE: Updated analytical products: SAS/STAT 14.1 SAS/OR 14.1 NOTE: Additional host information: Linux LIN X64 3.10.0-229.el7.x86_64 #1 SMP Thu Jan 29 18:37:38 EST 2015 x86_64 Red Hat Enterprise Linux Server release 7.1 (Maipo) You are running SAS 9. Some SAS 8 files will be automatically converted by the V9 engine; others are incompatible. Please see http://support.sas.com/rnd/migration/planning/platform/64bit.html PROC MIGRATE will preserve current SAS file attributes and is recommended for converting all your SAS libraries from any SAS 8 release to SAS 9. For details and examples, please see http://support.sas.com/rnd/migration/index.html This message is contained in the SAS news file, and is presented upon initialization. Edit the file "news" in the "misc/base" directory to display site-specific news and information in the program log. The command line option "-nonews" will prevent this display. NOTE: SAS Initialization used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The autoexec file, /sasconf/AML63/Config/Lev1/SASApp/StoredProcessServer/autoexec.sas, was executed at server initialization. >>> SAS Macro Variables: _APSLIST=_srvname,_rmthost,_htcook,_srvport,_username,_reqmeth,_htua,_grafloc,_version,_url,_rmtaddr,_reqencoding,_program,_userlocale,_result,_metaperson,_metauser,_metafolder,_client,_SECUREUS ERNAME _CLIENT=StoredProcessService 9.4; JVM 1.7.0_181; Linux (amd64) 3.10.0-229.el7.x86_64 _GRAFLOC=/sasweb/graph _HTCOOK=9178f72cd17b29eb1363aad4d9358aed_Cluster1=9F82BAA82E91406F62A27490F84B9798.9178f72cd17b29eb1363aad4d9358aed_SASServer1_1; 9178f72cd17b29eb1363aad4d9358aed_Cluster1=D6796CD8AD76A514BF7F46 2A8F16440C.9178f72cd17b29eb1363aad4d9358aed_SASServer1_1 _HTUA=Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.1; Trident/7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; InfoPath.3; .NET4.0C; .NET4.0E; Tabl et PC 2.0; wbx 1.0.0) _METAFOLDER=/System/Applications/SAS Compliance Solutions/Compliance Solutions Svr/Application SAS Code/ _METAPERSON=sasdemo _METAUSER=sasdemo _PROGRAM=/System/Applications/SAS Compliance Solutions/Compliance Solutions Svr/Application SAS Code/fcf_sa_update_fcf_tables_sp _REPLAY="&_URL?_sessionid=2E3B0531-9AC4-E043-8223-7E0F8D6151C9&_program=replay&_entry=&_TMPCAT.." _REQENCODING=UTF-8 _REQMETH=GET _RESULT=STREAM _RMTADDR=172.18.89.4 _RMTHOST=172.18.89.4 _SECUREUSERNAME=sasdemo _SRVNAME=amlwebhkpp.intranet.bbl _SRVPORT=8343 _TMPCAT=APSWORK.TCAT0008 _URL=/SASStoredProcess/do _USERLOCALE=en_US _USERNAME=sasdemo _VERSION=Version 9.4 (Build 506) NOTE: %INCLUDE (level 1) file /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/sasstp/fcf_sa_update_fcf_tables_sp.sas is file /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/sasstp/fcf_sa_update_fcf_tables_sp.sas. 3 +/* MAINDOC 4 ++------------------------------------------------------------------------------+ The SAS System 5 +| NAME: fcf_sa_update_fcf_tables_sp.sas 6 +| PRODUCT: SAS Compliance Solutions 7 +| SYSTEM: Windows, Unix 8 +| DESC: Stored process to update Scenario Administrator tables by extracting 9 +| the data from ECM and to download scenario, risk factor and header 10 +| source code from the SAS Content server. 11 ++------------------------------------------------------------------------------+ 12 +MAINDOCEND */ 13 + 14 +/*------------------------------------------------------------------- 15 + * Copyright (c) 2012-2015 by SAS Institute Inc., Cary, NC 27513 USA 16 + * ---All Rights Reserved. 17 + *-------------------------------------------------------------------*/ 18 +%inc "/sasconf/AML63/Config/Lev1/Applications/SASEnterpriseCaseManagement/Source/control/ecm_autoexec.sas"; NOTE: %INCLUDE (level 2) file /sasconf/AML63/Config/Lev1/Applications/SASEnterpriseCaseManagement/Source/control/ecm_autoexec.sas is file /sasconf/AML63/Config/Lev1/Applications/SASEnterpriseCaseManagement/Source/control/ecm_autoexec.sas. 19 +/***********************************************************************************/ 20 +/* Copyright (c) 2009-2010, SAS Institute Inc., Cary, NC, USA, All Rights Reserved */ 21 +/* NAME: ecm_autoexec.sas */ 22 +/* */ 23 +/* PRODUCT: Enterprise Case Management */ 24 +/* PURPOSE: */ 25 +/* */ 26 +/* USAGE: autoexec for the batch programs */ 27 +/* */ 28 +/* PARAMETERS: I|O|U - comments */ 29 +/* DOCUMENT: */ 30 +/* TEST PROGRAM: */ 31 +/* NOTES: */ 32 +/* END */ 33 +/***********************************************************************************/ 34 + 35 +%macro ecm_setup; 36 + 37 + 38 + 39 + /* ECM file paths */ 40 + %global ecm_config_path The SAS System 41 + ecm_config_ucmacro_path 42 + ecm_install_ucmacro_path 43 + ecm_install_cmacro_path 44 + ecm_etl_output_path 45 + ecm_sasmisc_path 46 + ecm_dbserver 47 + ecm_dbauth 48 + ecm_dbname 49 + ecm_dbhost 50 + ecm_dbport 51 + ecm_efile_path 52 + ecm_wsauthdomain 53 + ecm_server_component_nm 54 + ecm_midtier_component_nm 55 + slash 56 + mkdirCmd 57 + moveCmd 58 + copyCmd 59 + delCmd 60 + dirCmd 61 + ; 62 + 63 + %let ecm_config_path=/sasconf/AML63/Config/Lev1/Applications/SASEnterpriseCaseManagement; 64 + %let ecm_config_ucmacro_path=/sasconf/AML63/Config/Lev1/Applications/SASEnterpriseCaseManagement/Source/ucmacros; 65 + %let ecm_install_ucmacro_path=/sasinst/AML63/SASHome/SASFoundation/9.4/ucmacros/casemgmtmva; 66 + %let ecm_install_cmacro_path=/sasinst/AML63/SASHome/SASFoundation/9.4/cmacros/casemgmtmva; 67 + %let ecm_etl_output_path=/sasconf/AML63/Config/Lev1/Applications/SASEnterpriseCaseManagement/Libraries; 68 + %let ecm_sasmisc_path=/sasinst/AML63/SASHome/SASFoundation/9.4/misc/casemgmtmva; 69 + %let ecm_dbserver=oracle; 70 + %let ecm_dbauth=casemgmt_db_auth; 71 + %let ecm_dbhost='afdthtt2.intranet.bbl'; 72 + %let ecm_dbport=1516; 73 + %let ecm_dbname='AHKTSTDB'; 74 + %let ecm_wsauthdomain=DefaultAuth; 75 + %let ecm_server_component_nm=Ent Case Mgmt Server 6.3; 76 + %let ecm_midtier_component_nm=Ent Case Mgmt Mid-Tier 6.3; 77 + 78 + The SAS System 79 + 80 + 81 + %global sysdms /* 0 for SAS non-interactively environment, 1 for SAS interactive enviroment */ 82 + smdds /* location of message file */ 83 + slash /* OS specific directory separator */ 84 + locale_sas /* locale for SAS server */ 85 + locale_default /* default locale */ 86 + locale_report /* locale for reports */ 87 + ; 88 + 89 + %let smdds=sashelp.entcm; 90 + %let locale_sas=%SYSFUNC(getpxlocale()) ; 91 + %let locale_default=%substr(&locale_sas,1,2); 92 + %let locale_report=&locale_sas; 93 + 94 + options locale=&locale_sas; 95 + 96 + data _null_; 97 + if getoption('DMS') eq 'NODMS' then call symput('SYSDMS','0'); 98 + else call symput('SYSDMS','1'); 99 + 100 + if symget('sysscp') eq "WIN" then 101 + do; 102 + call symput('slash','\'); 103 + call symput( 'mkdirCmd', 'mkdir'); 104 + call symput( 'moveCmd', 'move/y' ); 105 + call symput( 'copyCmd', 'xcopy'); 106 + call symput( 'delCmd', 'erase' ); 107 + call symput( 'dirCmd', 'dir /B' ); 108 + end; 109 + else 110 + do; 111 + call symput('slash','/'); 112 + call symput( 'mkdirCmd', 'mkdir'); 113 + call symput( 'moveCmd', 'mv -f' ); 114 + call symput( 'copyCmd', 'cp' ); 115 + call symput( 'delCmd', 'rm -f' ); 116 + call symput( 'dirCmd', 'ls' ); The SAS System 117 + end; 118 + run; 119 + 120 + %let ecm_efile_path=&ecm_config_path&slash.Source&slash.efiles; 121 + 122 + %local sasmstore_path; 123 + %let sasmstore_path=; 124 + proc sql noprint; 125 + select distinct quote(strip(path)) into :sasmstore_path separated by ',' 126 + from dictionary.libnames where upcase(libname)=upcase("%sysfunc(getoption(sasmstore))"); 127 + quit; 128 + 129 + %SYSMSTORECLEAR ; 130 + 131 + data _null_; 132 + 133 + /* Define ucompiled macro search path */ 134 + 135 + length autocall_path $ 4096 136 + sasmstore_path $ 4096 137 + ; 138 + autocall_path=kcompress(getoption('sasautos'),'()'); 139 + 140 + if index(upcase(autocall_path),"SASAUTOS") =0 then 141 + autocall_path='sasautos'||' , '||strip(autocall_path); 142 + if index(autocall_path,"&ecm_install_ucmacro_path") =0 then 143 + autocall_path=quote("&ecm_install_ucmacro_path")||' , '||strip(autocall_path); 144 + if index(autocall_path,"&ecm_config_ucmacro_path") =0 then 145 + autocall_path=quote("&ecm_config_ucmacro_path")||' , '||strip(autocall_path); 146 + call execute('options sasautos=('||strip(autocall_path)||');'); 147 + 148 + /* Define compiled macro search path */ 149 + 150 + sasmstore_path=symget('sasmstore_path'); 151 + if sasmstore_path ne '' then do; 152 + if index(sasmstore_path,"&ecm_install_cmacro_path") =0 then 153 + sasmstore_path=quote("&ecm_install_cmacro_path")||' ,'||strip(sasmstore_path); 154 + end; The SAS System 155 + else sasmstore_path=quote("&ecm_install_cmacro_path"); 156 + 157 + call execute('libname ECMCMAC ('||strip(sasmstore_path)||') access=readonly;'); 158 + call execute('options sasmstore=ECMCMAC mstored;'); 159 + 160 + 161 + 162 + run; 163 + 164 + 165 + %ecm_global_mvar; /* define more ECM global variables */ 166 + 167 + 168 + 169 + 170 + /* Libname to reporting data mart */ 171 + libname ecm_rpt BASE "&ecm_etl_output_path/ecmreport"; 172 + %if (%sysfunc(libref(ecm_rpt))) %then 173 + %do; 174 + %put %sysfunc(sysmsg()); 175 + %if ^&SYSDMS %then 176 + %do; 177 + %abort return; 178 + %end; 179 + %end; 180 + 181 + 182 + /* Libname to regulary form information mart */ 183 + %let form_path=&ecm_config_path&slash.Source&slash.form_template; 184 + libname ecm_form "&form_path"; 185 + 186 + %if (%sysfunc(libref(ecm_form))) %then 187 + %do; 188 + %put %sysfunc(sysmsg()); 189 + %if ^&SYSDMS %then 190 + %do; 191 + %abort return; 192 + %end; The SAS System 193 + %end; 194 + 195 +%mend ecm_setup; 196 + 197 +options metaserver="afmhkpp1.intranet.bbl" metaport=8561 metarepository="Foundation"; 198 + 199 +%ecm_setup; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: No rows were selected. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Libref ECMCMAC was successfully assigned as follows: Levels: 1 Engine(1): V9 Physical Name(1): /sasinst/AML63/SASHome/SASFoundation/9.4/cmacros/casemgmtmva NOTE: Libref ECM_RPT was successfully assigned as follows: Engine: BASE Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASEnterpriseCaseManagement/Libraries/ecmreport NOTE: Libref ECM_FORM was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASEnterpriseCaseManagement/Source/form_template NOTE: %INCLUDE (level 2) ending. NOTE: %INCLUDE (level 1) resuming. 200 +%inc "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/config/aml_autoexec.sas"; The SAS System NOTE: %INCLUDE (level 2) file /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/config/aml_autoexec.sas is file /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/config/aml_autoexec.sas. 201 +/* MAINDOC 202 ++------------------------------------------------------------------------------+ 203 +| NAME: aml_autoexec.sas 204 +| PRODUCT: SAS Anti-Money Laundering 205 +| SYSTEM: Windows, Unix 206 +| DESC: Set up the SAS Anti-Money Laundering environment. 207 +| Used as an autoexec or include. 208 ++------------------------------------------------------------------------------+ 209 +MAINDOCEND */ 210 + 211 +/*------------------------------------------------------------------- 212 + * Copyright (c) 2012-2014 by SAS Institute Inc., Cary, NC 27513 USA 213 + * ---All Rights Reserved. 214 + *-------------------------------------------------------------------*/ 215 + 216 +%inc "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/config/fcf_autoexec.sas"; NOTE: %INCLUDE (level 3) file /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/config/fcf_autoexec.sas is file /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/config/fcf_autoexec.sas. 217 +/* MAINDOC 218 ++------------------------------------------------------------------------------+ 219 +| NAME: fcf_autoexec.sas 220 +| PRODUCT: SAS Compliance Solutions 221 +| SYSTEM: Windows, Unix 222 +| DESC: Sets up the SAS Compliance Solutions environment. 223 ++------------------------------------------------------------------------------+ 224 +| USAGE: Use as an autoexec or include it into another program. 225 ++-------------+----------------------------------------------------------------+ 226 +MAINDOCEND */ 227 + 228 +/*------------------------------------------------------------------- 229 + * Copyright (c) 2012-2014 by SAS Institute Inc., Cary, NC 27513 USA 230 + * ---All Rights Reserved. 231 + *-------------------------------------------------------------------*/ 232 + 233 +%macro fcf_run_autoexec; 234 + The SAS System 235 + %global fcf_autoexec_run; 236 + 237 + /*--------------------------------------- 238 + * Global Error Handling Macro Variables 239 + *---------------------------------------*/ 240 + %global _fcfmodule_ 241 + _fcfmodulever_ 242 + _fcfmsg_ 243 + job_rc 244 + trans_rc; 245 + 246 + /*--------------------- 247 + * Global FCF settings 248 + *---------------------*/ 249 + %global ml_risk tf_risk sysadmin fcf_enable_bulkload enable_formats 250 + enable_base_currency replication_period replicate_suppressed_alerts 251 + autoroute2currentinvestigator watch_list_processing_method rptxml 252 + currency_code teradata_mode fcf_application_name fcfroot cmnroot 253 + fcfdata fcfland fcf_business_unit_normalized fcf_xml_map_path 254 + fcf_config_locale fcf_supported_locale_list fcf_dav_root 255 + iem_performance_load iem_bulk_load iem_bulk_load_options iem_bridge_load 256 + iem_sar_type_cd iem_sar_window fcf_closed_case_status_lst fcf_non_active_case_status_lst 257 + fcf_closed_alert_status_lst fcf_closed_ra_status_lst 258 + ; 259 + 260 + /* set fcf_config_locale to the default locale */ 261 + /* default.locale is set during deployment to language part of the system locale 262 + * for zh_* locales it is set as: 263 + * zh_CN -> zh, zh_TW -> zt, zh_HK -> zt, zh_* -> en 264 + * fcf_config_locale is set to match the locale names for sashelp files. 265 + */ 266 + %let fcf_config_locale=en; /* system locale used during install */ 267 + %let fcf_supported_locale_list=en ar es fr it ja ko nl ru zh_CN zh_TW; 268 + 269 + /*--------------------------------- 270 + * Global DBMS connection settings 271 + *---------------------------------*/ 272 + %global dbflavor The SAS System 273 + kcSchema kcDBUser kcDBConnOpts kcDBLibOpts 274 + segKCSchema segKCDBUser segKCDBConnOpts segKCDBLibOpts 275 + coreSchema coreDBUser coreDBConnOpts coreDBLibOpts 276 + coreAuthDomain kcAuthDomain segkcAuthDomain omaAuthDomain 277 + db_core_libname db_kc_libname seg_kc_libname fcf_max_udf_len 278 + ecm_user_group ecm_db_conopts ecm_user 279 + ; 280 + 281 + /*--------------------------------- 282 + * Global ECM reservations. 283 + *---------------------------------*/ 284 + %global reserved_case_config reserved_incident_config 285 + reserved_party_config reserved_financial_item_config; 286 + 287 + /*--------------------------------------- 288 + * Make sure this code is run only once. 289 + *---------------------------------------*/ 290 + %if &fcf_autoexec_run ne 1 %then %do; 291 + %let metaserver = "afmhkpp1.intranet.bbl"; 292 + %let metaport = 8561; 293 + %let metarepository = "Foundation"; 294 + 295 + options metaserver = &metaserver 296 + metaport = &metaport 297 + metaprotocol = bridge 298 + metarepository = &metarepository; 299 + 300 + /*------------------------------------------------------ 301 + * Set index page size for indexing large unicode values 302 + *------------------------------------------------------ */ 303 + options ibufsize=32767; 304 + 305 + /*----------------------- 306 + * Assign path to macros 307 + *-----------------------*/ 308 + %local fcf_cmacro_path; 309 + %local fcf_ucmacro_path; 310 + %let fcf_cmacro_path=/sasinst/AML63/SASHome/SASFoundation/9.4/cmacros/antimnycmn; The SAS System 311 + %let fcf_ucmacro_path=/sasinst/AML63/SASHome/SASFoundation/9.4/ucmacros/antimnycmn; 312 + %let fcf_custsrc_path=/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/source; 313 + 314 + /*-------------------------- 315 + * Configuration parameters 316 + *--------------------------*/ 317 + options set=FCFROOT "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions"; 318 + %let FCFROOT=%sysfunc(sysget(FCFROOT)); 319 + options set=CMNROOT "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions"; 320 + %let CMNROOT=%sysfunc(sysget(CMNROOT)); 321 + options set=FCFDATA "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data"; 322 + %let FCFDATA=%sysfunc(sysget(FCFDATA)); 323 + options set=FCFLAND "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/landing"; 324 + %let FCFLAND=%sysfunc(sysget(FCFLAND)); 325 + 326 + %let sysadmin = amltest.notification.group@bbl.co.th; 327 + 328 + /* max size of the CHAR UDF for FCF/AML parties in the ECM database 329 + * this value is also used when generating XML UI data for ECM, see 330 + * fcf_write_ecm_ui_xml_data macro. 331 + */ 332 + %let fcf_max_udf_len = 1024; 333 + 334 + /*---------------------------------------------------------- 335 + * Risk Ranking 336 + * By default, alerts are not create for Risk Factors. 337 + * TF_RISK and ML_RISK set the score threshold for creating 338 + * risk factor alerts, the value 1000 means disabled. 339 + *----------------------------------------------------------*/ 340 + %let tf_risk=1000; 341 + %let ml_risk=1000; 342 + 343 + /*--------------------------------------------------------------- 344 + * Risk Ranking 345 + * Sets the maximum number of days of alert history that 346 + * will be considered as input in the ranking of future alerts. 347 + *---------------------------------------------------------------*/ 348 + %let replication_period = 31; The SAS System 349 + 350 + /*-------------------------------------------------------------------- 351 + * Replication 352 + * By default, only transactions for active alerts are replicated. 353 + * N - replicate transactions for active alerts. 354 + * Y - replicate transactions for active and batch suppressed alerts. 355 + *--------------------------------------------------------------------*/ 356 + %let replicate_suppressed_alerts=N; 357 + 358 + /*--------------------- 359 + * Match Code Settings 360 + *---------------------*/ 361 + options DQLOCALE=(ENUSA); 362 + options DQSETUPLOC="/sasinst/AML63/qkb/ci/26"; 363 + 364 + /*---------------------------------------------------------------------- 365 + * Routing 366 + * By default, automatically route new alerts to current investigator. 367 + * Y - Default, automatically route new alerts to current investigator. 368 + * N - Do NOT automatically route new alerts to current investigator. 369 + *----------------------------------------------------------------------*/ 370 + %let autoroute2currentinvestigator = Y; 371 + 372 + /*------------------------------------------------------------------ 373 + * Enable Formats 374 + * N - Formats are not enabled - valid during installation. 375 + * Y - Enable formats after the install.sas successfully completes. 376 + * When set to Y then AGP and Deploy To FCF button in Scenario 377 + * Administrator execute fcf_create_formats macro. 378 + *------------------------------------------------------------------*/ 379 + %let enable_formats=Y; 380 + 381 + /*--------------------------------------------------------------------------- 382 + * Enable Base Currency 383 + * N - Base Currency is not enabled - valid during installation. 384 + * Y - Base Currency available after the install.sas successfully completes. 385 + *---------------------------------------------------------------------------*/ 386 + %let enable_base_currency=N; The SAS System 387 + 388 + /*---------------------------------------------------------------------- 389 + * Set get_scenario_performance_stats to Y so fcf_agp_codegen generates 390 + * code to gather performance statistics for scenarios. 391 + *----------------------------------------------------------------------*/ 392 + %let get_scenario_performance_stats = N; 393 + 394 + /*------------------------------------------------------------------ 395 + * Valid entries: db2, odbc, oracle or teradata: 396 + * all lower-case 397 + *------------------------------------------------------------------*/ 398 + %let dbflavor = oracle; 399 + 400 + 401 + 402 + /*------------------------------------------------------ 403 + * Note: Schema, User and Password must match database 404 + * and all settings are case sensitive. 405 + *------------------------------------------------------*/ 406 + 407 + /*------------------------- 408 + * Authentication Domains 409 + *-------------------------*/ 410 + %let coreAuthDomain=Core; 411 + %let kcAuthDomain=Knowledge Center; 412 + %let segkcAuthDomain=Segmented Knowledge Center; 413 + %let omaAuthDomain=DefaultAuth; 414 + 415 + /*------------------------- 416 + * Common Knowledge Center 417 + *-------------------------*/ 418 + %let kcSchema = FCFKC; 419 + %let kcDBUser = FCFKC; 420 + %let kcDBConnOpts = %str(path=AHKTSTDB); 421 + %let kcDBLibOpts = %str(); 422 + 423 + /*---------------------------- 424 + * Segmented Knowledge Center The SAS System 425 + *----------------------------*/ 426 + %let segKCSchema = BBLHK; 427 + %let segKCDBUser = BBLHK; 428 + %let segKCDBConnOpts = %str(path=AHKTSTDB); 429 + %let segKCDBLibOpts = %str(); 430 + 431 + /*------------- 432 + * Common Core 433 + *-------------*/ 434 + %let coreSchema = FCFCORE; 435 + %let coreDBUser = FCFCORE; 436 + %let coreDBConnOpts = %str(path=AHKTSTDB); 437 + %let coreDBLibOpts = %str(); 438 + 439 + /*------------- 440 + * ECM options 441 + *-------------*/ 442 + %let ecm_db_conopts=path=AHKTSTDB; 443 + 444 + /*----------------------------------------------------------------------- 445 + * ECM reservations. 446 + * 447 + * These values are set based on the maximum key values of the ECM 448 + * load_post_install_data.sas program. 449 + *-----------------------------------------------------------------------*/ 450 + 451 + %let reserved_case_config=4; 452 + %let reserved_incident_config=4; 453 + %let reserved_party_config=3; 454 + %let reserved_financial_item_config=7; 455 + 456 + /*----------------------------------------------------------------------- 457 + * !! WARNING: It is recommended that you do NOT edit below this line !! 458 + *-----------------------------------------------------------------------*/ 459 + 460 + options 461 + fmtsearch = (work fmts sashelp.mapfmts library) 462 + mstored The SAS System 463 + mexecsize = 128K 464 + minoperator 465 + ; 466 + 467 + /*---------------------------------- 468 + * Site-specific custom source code 469 + *----------------------------------*/ 470 + libname custsrc "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/source"; 471 + 472 + /*--------- 473 + * Formats 474 + *---------*/ 475 + libname fmts "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/fmts"; 476 + 477 + /*----------- 478 + * Job stats 479 + *-----------*/ 480 + libname job_stat "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/job_stats"; 481 + 482 + /*------------- 483 + * Common Data 484 + *-------------*/ 485 + libname cmndata "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data"; 486 + 487 + /*-------- 488 + * Master 489 + *--------*/ 490 + libname mst_aler '!FCFDATA/master/alert'; 491 + libname mst_prep '!FCFDATA/master/prep'; 492 + libname mst_rpt '!FCFDATA/master/report'; 493 + libname mst_rc '!FCFDATA/master/rc'; 494 + libname mst_nbrs '!FCFDATA/master/nn'; 495 + libname mst_ca '!FCFDATA/master/ca'; /*Compliance Analytics*/ 496 + 497 + /*------- 498 + * Stage 499 + *-------*/ 500 + libname stg_aler '!FCFDATA/stage/alert'; The SAS System 501 + libname stg_bdg '!FCFDATA/stage/bridge'; 502 + libname stg_ctrl '!FCFDATA/stage/control'; 503 + libname stg_dim '!FCFDATA/stage/dim'; 504 + libname stg_fact '!FCFDATA/stage/fact'; 505 + libname stg_wtch '!FCFDATA/stage/watchlist' compress=yes; 506 + libname stg_err '!FCFDATA/stage/error'; 507 + libname stg_rc '!FCFDATA/stage/rc'; 508 + libname stgrcacc '!FCFDATA/stage/rc/acc'; 509 + libname stgrcppf '!FCFDATA/stage/rc/ppf'; 510 + libname stgrcpty '!FCFDATA/stage/rc/pty'; 511 + libname stg_ca '!FCFDATA/stage/ca'; /*Compliance Analytics*/ 512 + libname stg_xref '!FCFDATA/stage/xref'; 513 + 514 + /*--------- 515 + * SOLR Search 516 + *---------*/ 517 + libname solr '!FCFDATA/solr'; 518 + 519 + /*---------------------------------- 520 + * IEM-specific settings 521 + *----------------------------------*/ 522 + %let ecm_user_group=Ent Case Mgmt Users; 523 + %let ecm_user=ecmadmin; 524 + %let iem_performance_load=yes; 525 + %let iem_bulk_load=no; 526 + %let iem_bulk_load_options=; 527 + %let iem_bridge_load=yes; 528 + %let iem_sar_type_cd=SAR; 529 + %let iem_sar_window=540; 530 + 531 + libname iem '!FCFDATA/iem'; 532 + 533 + /* FCF case status settings, full list in ref_table_value table FCF_CASE_STATUS */ 534 + %let fcf_closed_case_status_lst='C', 'T'; /* List of case status codes for closed cases */ 535 + %let fcf_non_active_case_status_lst='C', 'T', 'S'; /* List of case status codes for non-active cases - not shown in various lists */ 536 + 537 + /* FCF alert status, full list in ref_table_value table RT_ALERT_STATUS */ 538 + %let fcf_closed_alert_status_lst='CLS', 'CLR'; /* List of alert status codes for closed alerts screen/query */ The SAS System 539 + %let fcf_closed_ra_status_lst='CLS'; /* List of risk assessment status codes for closed RA screen/query */ 540 + 541 + /*------------------------------ 542 + * Stored Compiled Macro Source 543 + *------------------------------*/ 544 + %macro fcf_assign_source_library; 545 + %let old_source_libs = %sysfunc(kcompress(%sysfunc(getoption(sasmstore)),%str(%(%)))); 546 + %if (%sysfunc(libref(source))) ne 0 %then %do; /*returns 0 if already assigned*/ 547 + libname source (custsrc "&fcf_cmacro_path" &old_source_libs) access=readonly; 548 + %if &syslibrc eq 0 %then %do; 549 + options sasmstore=source; 550 + %end; 551 + %else %do; 552 + %put ERROR: FCF: Cannot assign SOURCE library.; 553 + %end; 554 + %end; 555 + %else %do; 556 + %put NOTE: FCF: SOURCE library already assigned.; 557 + options sasmstore=source; 558 + %end; 559 + %mend fcf_assign_source_library; 560 + %fcf_assign_source_library 561 + 562 + /*----------------------------------------------- 563 + * Figure out what the former autocall path was. 564 + *-----------------------------------------------*/ 565 + %let old_autocall_path = %sysfunc(kcompress(%sysfunc(getoption(sasautos)),%str(%(%)))); 566 + 567 + /*------------------------------------------- 568 + * Add FCF macros in front of existing path. 569 + *-------------------------------------------*/ 570 + options sasautos=( "&fcf_custsrc_path" "&fcf_ucmacro_path" &old_autocall_path ); 571 + 572 + /* SCENARIO ADMINISTRATOR */ 573 + libname parms xml '!FCFDATA/scenario/xml/ruleconf.xml'; 574 + 575 + /*-------------------------------------------- 576 + * Knowledge Center (KC) Database Connections The SAS System 577 + *--------------------------------------------*/ 578 + libname db_kc 579 + &dbflavor 580 + authdomain="&kcAuthDomain." 581 + &kcDBConnOpts 582 + &kcDBLibOpts; 583 + 584 + %if (%sysfunc(libref(db_kc))) %then %do; 585 + %put %sysfunc(sysmsg()); 586 + %abort cancel 4; 587 + %end; 588 + 589 + %let db_kc_libname = db_kc; 590 + 591 + libname seg_kc 592 + &dbflavor 593 + authdomain="&segkcAuthDomain." 594 + &segKCDBConnOpts 595 + &segKCDBLibOpts; 596 + 597 + %if (%sysfunc(libref(seg_kc))) %then %do; 598 + %put %sysfunc(sysmsg()); 599 + %abort cancel 4; 600 + %end; 601 + 602 + %let seg_kc_libname = seg_kc; 603 + 604 + /*--------------------------- 605 + * Core Database Connections 606 + *---------------------------*/ 607 + libname db_core 608 + &dbflavor 609 + authdomain="&coreAuthDomain." 610 + &coreDBConnOpts 611 + &coreDBLibOpts; 612 + 613 + %if (%sysfunc(libref(db_core))) %then %do; 614 + %put %sysfunc(sysmsg()); The SAS System 615 + %abort cancel 4; 616 + %end; 617 + 618 + %let db_core_libname = db_core; 619 + 620 + /*----------------------------------------------------------------- 621 + * Alert Reminders 622 + * Used in fcf_notify_manager and fcf_send_alert_reminder, 623 + * for example: %include custsrc(send_alert_reminder_messages.sas) 624 + *-----------------------------------------------------------------*/ 625 + filename custsrc "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/source"; 626 + 627 + /*---------------------- 628 + * Enable Base Currency 629 + *----------------------*/ 630 + %macro fcf_enable_base_currency; 631 + %if &enable_base_currency eq Y %then %do; 632 + proc sql noprint; 633 + select lov_type_code into :currency_code 634 + from seg_kc.fsk_lov 635 + where upcase(lov_type_name) = 'BASE CURRENCY'; 636 + quit; 637 + %end; 638 + %else %do; 639 + %put NOTE: FCF: Base currency is not enabled.; 640 + %end; 641 + %mend fcf_enable_base_currency; 642 + %fcf_enable_base_currency 643 + 644 + /*------------------------------ 645 + * Watch List Processing Method 646 + * INDEX_ARRAY - 32-bit OS. 647 + * HASH_ARRAY - 64 bit OS. 648 + *------------------------------*/ 649 + %macro fcf_wlproc; 650 + %if &sysmaxlong lt 2147483648 %then %do; 651 + %let watch_list_processing_method = INDEX_ARRAY; 652 + %end; The SAS System 653 + %else %do; 654 + %let watch_list_processing_method = HASH_ARRAY; 655 + %end; 656 + %put ; 657 + %put NOTE: WATCH_LIST_PROCESSING_METHOD = &watch_list_processing_method; 658 + %mend fcf_wlproc; 659 + %fcf_wlproc 660 + 661 + /*----------------------------- 662 + * Display release information 663 + *-----------------------------*/ 664 + %let _fcfmodule_=%str(SAS Compliance Solutions); 665 + %let _fcfmsg_=; 666 + %put ; 667 + %fcf_put_error; 668 + %let _fcfmodule_=; 669 + 670 + /*-------------------------------- 671 + * Reference the Application Name 672 + *--------------------------------*/ 673 + %let fcf_application_name=%str(Compliance Solutions Mid 6.3); 674 + 675 + /*----------------------------------------------------- 676 + * Location of XML maps for SNA Web Service processing 677 + *-----------------------------------------------------*/ 678 + %let fcf_xml_map_path=%str(/sasinst/AML63/SASHome/SASFoundation/9.4/misc/antimnycmn/xml/map); 679 + 680 + /*----------------------------------------------------- 681 + * ECM Source System Code 682 + *-----------------------------------------------------*/ 683 + %global fcf_source_system_cd; 684 + %let fcf_source_system_cd=%str(BBLHK); 685 + %fcf_get_dav_root() 686 + 687 + /*----------------------------------------------------- 688 + * Set to make sure the FCF autoexec is run only once. 689 + *-----------------------------------------------------*/ 690 + %let fcf_autoexec_run = 1; The SAS System 691 + %end; 692 +%mend fcf_run_autoexec; 693 +%fcf_run_autoexec NOTE: Libref CUSTSRC was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/source NOTE: Libref FMTS was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/fmts NOTE: Libref JOB_STAT was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/job_stats NOTE: Libref CMNDATA was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data NOTE: Libref MST_ALER was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/master/alert NOTE: Libref MST_PREP was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/master/prep NOTE: Libref MST_RPT was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/master/report NOTE: Libref MST_RC was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/master/rc NOTE: Libref MST_NBRS was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/master/nn NOTE: Libref MST_CA was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/master/ca NOTE: Libref STG_ALER was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/alert NOTE: Libref STG_BDG was successfully assigned as follows: Engine: V9 The SAS System Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/bridge NOTE: Libref STG_CTRL was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/control NOTE: Libref STG_DIM was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/dim NOTE: Libref STG_FACT was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/fact NOTE: Libref STG_WTCH was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/watchlist NOTE: Libref STG_ERR was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/error NOTE: Libref STG_RC was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/rc NOTE: Libref STGRCACC was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/rc/acc NOTE: Libref STGRCPPF was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/rc/ppf NOTE: Libref STGRCPTY was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/rc/pty NOTE: Libref STG_CA was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/ca NOTE: Libref STG_XREF was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/stage/xref NOTE: Libref SOLR was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/solr NOTE: Libref IEM was successfully assigned as follows: The SAS System Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/data/iem NOTE: Libref SOURCE was successfully assigned as follows: Levels: 3 Engine(1): V9 Physical Name(1): /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/custom/source Engine(2): V9 Physical Name(2): /sasinst/AML63/SASHome/SASFoundation/9.4/cmacros/antimnycmn Engine(3): V9 Physical Name(3): /sasinst/AML63/SASHome/SASFoundation/9.4/cmacros/casemgmtmva NOTE: Libref PARMS was successfully assigned as follows: Engine: XML Physical Name: !FCFDATA/scenario/xml/ruleconf.xml NOTE: Libref DB_KC was successfully assigned as follows: Engine: ORACLE Physical Name: AHKTSTDB NOTE: Libref SEG_KC was successfully assigned as follows: Engine: ORACLE Physical Name: AHKTSTDB NOTE: Libref DB_CORE was successfully assigned as follows: Engine: ORACLE Physical Name: AHKTSTDB NOTE: FCF: Base currency is not enabled. NOTE: WATCH_LIST_PROCESSING_METHOD = HASH_ARRAY SAS Compliance Solutions VERSION 6.3M1 NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds The SAS System NOTE: %INCLUDE (level 3) ending. NOTE: %INCLUDE (level 2) resuming. 694 + 695 +%macro aml_run_autoexec; 696 + 697 + %global aml_autoexec_run AMLROOT; 698 + 699 + /*--------------------------------------- 700 + * Make sure this code is run only once. 701 + *---------------------------------------*/ 702 + %if &aml_autoexec_run ne 1 %then %do; 703 + 704 + /*----------------------------- 705 + * Display release information 706 + *-----------------------------*/ 707 + %let _fcfmodule_=%str(SAS Anti-Money Laundering); 708 + %let _fcfmsg_=; 709 + %put ; 710 + %fcf_put_error; 711 + %let _fcfmodule_=; 712 + 713 + /*-------------------------- 714 + * Configuration parameters 715 + *--------------------------*/ 716 + options set=AMLROOT "/sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions"; 717 + %let AMLROOT=%sysfunc(sysget(AMLROOT)); 718 + 719 + /*----------------------------------------------------- 720 + * Set to make sure the AML autoexec is run only once. 721 + *-----------------------------------------------------*/ 722 + %let aml_autoexec_run = 1; 723 + 724 + %end; 725 +%mend aml_run_autoexec; 726 +%aml_run_autoexec The SAS System SAS Anti-Money Laundering VERSION 6.3M1 NOTE: %INCLUDE (level 2) ending. NOTE: %INCLUDE (level 1) resuming. 727 +%ecm_db_connect NOTE: Libref ECM_DB was successfully assigned as follows: Engine: ORACLE Physical Name: AHKTSTDB NOTE: Libref ECM_TMP was successfully assigned as follows: Engine: ORACLE Physical Name: AHKTSTDB 728 + 729 +/* ********************************************************************** */ 730 +/* */ 731 +/* !! WARNING: It is recommended that you do NOT edit below this line */ 732 +/* */ 733 +/* ********************************************************************** */ 734 +/* path to the scenarios folder on the SAS WEBDAV server */ 735 +%let scr_dav_path=Products/SASComplianceSolutions/scenarios/; 736 +/* path to the headers folder on the SAS WEBDAV server */ 737 +%let hdr_dav_path=Products/SASComplianceSolutions/headers/; 738 + 739 +/* reset error codes to zero */ 740 +%let trans_rc = 0; 741 +%let sqlrc = 0; 742 +%let sqlxrc = 0; 743 +%let sysrc = 0; 744 +%let fcf_sa_update_already_running=0; 745 +%let ds_errors_cnt = 0; 746 + 747 +/* ********************************************************************** */ 748 +/* read Scenario Admin config values from metadata */ 749 +/* ********************************************************************** */ 750 +%fcf_sa_read_config_data(app_name=&fcf_application_name) NOTE: Libref FCF_SYNC was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/fcfsync The SAS System NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.02 seconds NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.03 seconds NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.03 seconds NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.02 seconds NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.03 seconds NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.03 seconds NOTE: DATA statement used (Total process time): real time 0.07 seconds The SAS System cpu time 0.02 seconds NOTE: Codegen location : !AMLROOT/scenario/codegen/ NOTE: Header source code path : !AMLROOT/scenario/header_code_active/ NOTE: Scenario source code path : !AMLROOT/scenario/scenario_code_active/ NOTE: Logs path : !AMLROOT/logs/ NOTE: Backups path : !CMNROOT/backups/ NOTE: Number of backup generations: 99 NOTE: Prep data sets library name : MST_PREP 751 + 752 +%fcf_sa_deploy_scenarios(scr_dav_path=&scr_dav_path, hdr_dav_path=&hdr_dav_path, fcf_debug_flg=N); NOTE: FCF_SYNC.FCF_SA_SYNC_MUTEX.DATA is now locked for exclusive access by you. NOTE: Variable msg is uninitialized. NOTE: The data set WORK.ERRORS has 0 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Libref FCFSABK was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/backups NOTE: There were 28 observations read from the data set SEG_KC.FSK_HEADER. NOTE: The data set FCFSABK.FSK_HEADER has 28 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 260 observations read from the data set SEG_KC.FSK_HEADER_ELEMENT. NOTE: The data set FCFSABK.FSK_HEADER_ELEMENT has 260 observations and 7 variables. NOTE: DATA statement used (Total process time): The SAS System real time 0.00 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 90 observations read from the data set SEG_KC.FSK_SCENARIO. NOTE: The data set FCFSABK.FSK_SCENARIO has 90 observations and 38 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 503 observations read from the data set SEG_KC.FSK_SCENARIO_PARAMETER. NOTE: The data set FCFSABK.FSK_SCENARIO_PARAMETER has 503 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 0 observations read from the data set SEG_KC.FSK_SCENARIO_ALERT_COLUMN. NOTE: The data set FCFSABK.FSK_SCENARIO_ALERT_COLUMN has 0 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 0 observations read from the data set SEG_KC.FSK_ROUTING_GROUP. The SAS System NOTE: The data set FCFSABK.FSK_ROUTING_GROUP has 0 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 0 observations read from the data set SEG_KC.FSK_ROUTING_RULE. NOTE: The data set FCFSABK.FSK_ROUTING_RULE has 0 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 0 observations read from the data set SEG_KC.FSK_ROUTING_CONSTRAINT. NOTE: The data set FCFSABK.FSK_ROUTING_CONSTRAINT has 0 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Table WORK.HEADERSC created, with 336 rows and 3 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.02 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} The SAS System NOTE: There were 336 observations read from the data set WORK.HEADERSC. NOTE: The data set WORK.HDRC has 27 observations and 16 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.HEADERSD created, with 54 rows and 3 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 54 observations read from the data set WORK.HEADERSD. NOTE: The data set WORK.HDRDT has 27 observations and 5 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 27 observations read from the data set WORK.HDRDT. NOTE: The data set WORK.HDRD has 27 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Table WORK.HEADERSN created, with 0 rows and 3 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 0 observations read from the data set WORK.HEADERSN. NOTE: The data set WORK.HDRNT has 1 observations and 3 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 1 observations read from the data set WORK.HDRNT. NOTE: The data set WORK.HDRN has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds WARNING: Variable PARTY_RK already exists on file WORK.HDRJOIN. WARNING: Variable PARTY_RK already exists on file WORK.HDRJOIN. NOTE: Table WORK.HDRJOIN created, with 27 rows and 19 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} WARNING: Variable LSTUPDATE_USER_ID already exists on file WORK.HDRALL. NOTE: Table WORK.HDRALL created, with 27 rows and 21 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: Table WORK.HDRDEL created, with 0 rows and 4 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 752:12 WARNING: Multiple lengths were specified for the variable HEADER_LOCATION_DESC by input data set(s). This can cause truncation of data. NOTE: There were 27 observations read from the data set WORK.HDRALL. NOTE: The data set WORK.HDRNONDEL has 27 observations and 18 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Table WORK.HDRUPD created, with 0 rows and 18 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.01 seconds NOTE: Table WORK.HDRUNDELETED created, with 0 rows and 18 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Table WORK.HDRNEW created, with 0 rows and 18 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds The SAS System cpu time 0.01 seconds NOTE: There were 1 observations read from the data set SEG_KC.FSK_HEADER. NOTE: The data set WORK.HDRINS has 0 observations and 16 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Appending WORK.HDRNEW to WORK.HDRINS. WARNING: Variable CREATE_DATE has format DATETIME20. on the BASE data set and format DATETIME27. on the DATA data set. DATETIME20. used. WARNING: Variable HEADER_NAME has different lengths on BASE and DATA files (BASE 128 DATA 1024). WARNING: Variable HEADER_DESCRIPTION has different lengths on BASE and DATA files (BASE 1020 DATA 1024). WARNING: Variable ENTITY_LEVEL_CODE has different lengths on BASE and DATA files (BASE 12 DATA 1024). WARNING: Variable DENORM_TABLE_NAME has different lengths on BASE and DATA files (BASE 128 DATA 1024). WARNING: Variable ALERT_TABLE_NAME has different lengths on BASE and DATA files (BASE 96 DATA 1024). WARNING: Variable HEADER_AUTOGEN_IND has different lengths on BASE and DATA files (BASE 4 DATA 1024). WARNING: Variable HEADER_LOCATION_DESC has different lengths on BASE and DATA files (BASE 1020 DATA 255). WARNING: Variable SOURCE_TYPE_DESC has different lengths on BASE and DATA files (BASE 128 DATA 1024). WARNING: Variable LSTUPDATE_USER_ID has different lengths on BASE and DATA files (BASE 240 DATA 1024). WARNING: Variable HEADER_HOST_DESC has different lengths on BASE and DATA files (BASE 200 DATA 1024). WARNING: Variable LOGICAL_DELETE_IND has different lengths on BASE and DATA files (BASE 4 DATA 1024). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 0 observations read from the data set WORK.HDRNEW. NOTE: 0 observations added. NOTE: The data set WORK.HDRINS has 0 observations and 16 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.01 seconds cpu time 0.02 seconds NOTE: There were 1 observations read from the data set SEG_KC.FSK_HEADER_ELEMENT. NOTE: The data set WORK.COLINS has 0 observations and 7 variables. NOTE: DATA statement used (Total process time): The SAS System real time 0.00 seconds cpu time 0.01 seconds NOTE: Table WORK.COLUMNSC created, with 783 rows and 4 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 783 observations read from the data set WORK.COLUMNSC. NOTE: The data set WORK.COLC has 261 observations and 7 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.COLUMNSN created, with 0 rows and 4 columns. NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect. NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 0 observations read from the data set WORK.COLUMNSN. NOTE: The data set WORK.COLNT has 1 observations and 4 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.01 seconds The SAS System NOTE: There were 1 observations read from the data set WORK.COLNT. NOTE: The data set WORK.COLN has 1 observations and 2 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.DATASET_LIST created, with 23 rows and 1 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 23 observations read from the data set WORK.DATASET_LIST. NOTE: The data set WORK.ELEMENTS has 338 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds WARNING: Variable PARTY_RK already exists on file WORK.COLALL. WARNING: Variable ROW_NO already exists on file WORK.COLALL. NOTE: Table WORK.COLALL created, with 260 rows and 11 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Table WORK.DS_ERRORS created, with 0 rows and 1 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds The SAS System NOTE: There were 260 observations read from the data set WORK.COLALL. NOTE: The data set WORK.COLFULL has 260 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Appending WORK.COLFULL to WORK.COLINS. WARNING: Variable ELEMENT_NAME has different lengths on BASE and DATA files (BASE 140 DATA 1024). WARNING: Variable ELEMENT_TYPE_CODE has different lengths on BASE and DATA files (BASE 24 DATA 6). WARNING: Variable ELEMENT_FORMAT_CODE has different lengths on BASE and DATA files (BASE 48 DATA 8). WARNING: Variable ELEMENT_LABEL_DESC has different lengths on BASE and DATA files (BASE 140 DATA 35). WARNING: Variable ELEMENT_USAGE_DESC has different lengths on BASE and DATA files (BASE 140 DATA 1024). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 260 observations read from the data set WORK.COLFULL. NOTE: 260 observations added. NOTE: The data set WORK.COLINS has 260 observations and 7 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.RGROUPSC created, with 0 rows and 3 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were deleted from SEG_KC.FSK_ROUTING_CONSTRAINT. The SAS System NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were deleted from SEG_KC.FSK_ROUTING_RULE. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were updated in SEG_KC.FSK_ROUTING_GROUP. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were deleted from SEG_KC.FSK_ROUTING_GROUP. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Deleting WORK.RGROUPSC (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds The SAS System cpu time 0.00 seconds NOTE: Table WORK.SCENARIOSC created, with 1599 rows and 3 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.02 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 1599 observations read from the data set WORK.SCENARIOSC. NOTE: The data set WORK.SCRCT has 89 observations and 24 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds WARNING: The variable routing_group_id in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 89 observations read from the data set WORK.SCRCT. NOTE: The data set WORK.SCRC has 89 observations and 21 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.SCENARIOSD created, with 267 rows and 3 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} The SAS System NOTE: There were 267 observations read from the data set WORK.SCENARIOSD. NOTE: The data set WORK.SCRDT has 89 observations and 6 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 89 observations read from the data set WORK.SCRDT. NOTE: The data set WORK.SCRD has 89 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.SCENARIOSN created, with 541 rows and 3 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 541 observations read from the data set WORK.SCENARIOSN. NOTE: The data set WORK.SCRNT has 89 observations and 10 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 89 observations read from the data set WORK.SCRNT. NOTE: The data set WORK.SCRN has 89 observations and 8 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds The SAS System cpu time 0.00 seconds WARNING: Variable PARTY_RK already exists on file WORK.SCRALL0. WARNING: Variable PARTY_RK already exists on file WORK.SCRALL0. NOTE: Table WORK.SCRALL0 created, with 89 rows and 32 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.02 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.SCRNONDEL1 created, with 89 rows and 32 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds WARNING: Variable PARTY_RK already exists on file WORK.SCRDEL. WARNING: Variable PARTY_RK already exists on file WORK.SCRDEL. NOTE: Table WORK.SCRDEL created, with 0 rows and 31 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.HDRXSCR created, with 89 rows and 4 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Table WORK.SCRXRG created, with 0 rows and 4 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Table WORK.SCRNONDEL created, with 89 rows and 36 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.02 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 752:122 752:51 WARNING: Multiple lengths were specified for the variable SCENARIO_CODE_LOCATION_DESC by input data set(s). This can cause truncation of data. WARNING: The variable _LABEL_ in the DROP, KEEP, or RENAME list has never been referenced. WARNING: The variable _NAME_ in the DROP, KEEP, or RENAME list has never been referenced. NOTE: There were 89 observations read from the data set WORK.SCRNONDEL. NOTE: The data set WORK.SCRFIX1 has 89 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Table WORK.SCRDEL1 created, with 0 rows and 1 columns. The SAS System NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.03 seconds NOTE: 89 rows were deleted from WORK.SCRFIX1. NOTE: PROCEDURE SQL used (Total process time): real time 0.06 seconds cpu time 0.03 seconds NOTE: The PROCEDURE SQL printed page 1. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 0 NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Libref FCF_SYNC was successfully assigned as follows: Engine: V9 Physical Name: /sasconf/AML63/Config/Lev1/Applications/SASComplianceSolutions/fcfsync NOTE: FCF_SYNC.FSK_SEQUENCE.DATA is now locked for exclusive access by you. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NEXT_ID_VAL= 1089 NEW_NEXT_ID=1089 NOTE: 1 row was updated in SEG_KC.FSK_SEQUENCE. The SAS System NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.00 seconds NOTE: FCF_SYNC.FSK_SEQUENCE.DATA is no longer locked by you. NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NEXT_ID=1089 NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 0 observations read from the data set WORK.SCRFIX1. NOTE: The data set WORK.SCRFIX has 0 observations and 35 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 1 observations read from the data set SEG_KC.FSK_SCENARIO. NOTE: The data set WORK.SCRUPD has 0 observations and 38 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Appending WORK.SCRFIX to WORK.SCRUPD. WARNING: Variable CREATE_DATE has format DATETIME20. on the BASE data set and format DATETIME27. on the DATA data set. DATETIME20. used. WARNING: Variable END_DATE has format DATETIME20. on the BASE data set and format DATETIME27. on the DATA data set. DATETIME20. used. WARNING: Variable SCENARIO_NAME has different lengths on BASE and DATA files (BASE 128 DATA 1024). WARNING: Variable SCENARIO_SHORT_DESCRIPTION has different lengths on BASE and DATA files (BASE 400 DATA 1024). WARNING: Variable SCENARIO_DESCRIPTION has different lengths on BASE and DATA files (BASE 1020 DATA 1024). WARNING: Variable SCENARIO_CATEGORY_CODE has different lengths on BASE and DATA files (BASE 12 DATA 1024). WARNING: Variable SCENARIO_CODE_LOCATION_DESC has different lengths on BASE and DATA files (BASE 1020 DATA 255). WARNING: Variable PRODUCT_TYPE_CODE has different lengths on BASE and DATA files (BASE 12 DATA 1024). WARNING: Variable SCENARIO_STATUS_CODE has different lengths on BASE and DATA files (BASE 12 DATA 1024). The SAS System WARNING: Variable CURRENT_IND has different lengths on BASE and DATA files (BASE 4 DATA 1024). WARNING: Variable RISK_FACTOR_IND has different lengths on BASE and DATA files (BASE 4 DATA 1024). WARNING: Variable END_USER_ID has different lengths on BASE and DATA files (BASE 240 DATA 1024). WARNING: Variable LOGICAL_DELETE_IND has different lengths on BASE and DATA files (BASE 4 DATA 1024). WARNING: Variable ALERT_TYPE_CD has different lengths on BASE and DATA files (BASE 128 DATA 1024). WARNING: Variable ALERT_CATEGORY_CD has different lengths on BASE and DATA files (BASE 128 DATA 1024). WARNING: Variable ALERT_SUBCATEGORY_CD has different lengths on BASE and DATA files (BASE 128 DATA 1024). WARNING: Variable SCENARIO_TYPE_CODE has different lengths on BASE and DATA files (BASE 12 DATA 1024). WARNING: Variable SCENARIO_RUN_FREQUENCY_CODE has different lengths on BASE and DATA files (BASE 12 DATA 1024). WARNING: Variable ENTITY_LEVEL_CODE has different lengths on BASE and DATA files (BASE 12 DATA 1024). WARNING: Variable PRIMARY_ENTITY_NUMBER_VAR_NAME has different lengths on BASE and DATA files (BASE 128 DATA 1024). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 0 observations read from the data set WORK.SCRFIX. NOTE: 0 observations added. NOTE: The data set WORK.SCRUPD has 0 observations and 38 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.PARAMSC created, with 2517 rows and 4 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.02 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 1 observations read from the data set SEG_KC.FSK_SCENARIO_PARAMETER. NOTE: The data set WORK.PRMINS has 0 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 2517 observations read from the data set WORK.PARAMSC. The SAS System NOTE: The data set WORK.PRMALL has 503 observations and 10 variables. NOTE: PROCEDURE TRANSPOSE used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 503 observations read from the data set WORK.PRMALL. NOTE: The data set WORK.PRMFIX has 503 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Table WORK.PRMFULL created, with 0 rows and 8 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Appending WORK.PRMFULL to WORK.PRMINS. WARNING: Variable PARM_NAME has different lengths on BASE and DATA files (BASE 128 DATA 1024). WARNING: Variable PARM_VALUE has different lengths on BASE and DATA files (BASE 4096 DATA 1024). WARNING: Variable PARM_TYPE_DESC has different lengths on BASE and DATA files (BASE 128 DATA 1024). WARNING: Variable PARM_DESC has different lengths on BASE and DATA files (BASE 1020 DATA 1024). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 0 observations read from the data set WORK.PRMFULL. NOTE: 0 observations added. NOTE: The data set WORK.PRMINS has 0 observations and 5 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: There were 0 observations read from the data set SEG_KC.FSK_SCENARIO_ALERT_COLUMN. NOTE: The data set WORK.ACINS has 0 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Table WORK.ALERTCOLSC created, with 0 rows and 4 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Table WORK.HDR_DEL_LIST created, with 0 rows and 16 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were updated in SEG_KC.FSK_HEADER. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} The SAS System NOTE: {END: fcf_chkrc} WARNING: Multiple lengths were specified for the variable HEADER_NAME by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable HEADER_DESCRIPTION by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable ENTITY_LEVEL_CODE by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable DENORM_TABLE_NAME by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable ALERT_TABLE_NAME by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable HEADER_AUTOGEN_IND by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable SOURCE_TYPE_DESC by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable LSTUPDATE_USER_ID by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable HEADER_HOST_DESC by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable LOGICAL_DELETE_IND by input data set(s). This can cause truncation of data. NOTE: The data set SEG_KC.FSK_HEADER has been updated. There were 0 observations rewritten, 0 observations added and 0 observations deleted. NOTE: There were 0 observations read from the data set WORK.HDRUPD. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were inserted into SEG_KC.FSK_HEADER. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: 260 rows were deleted from SEG_KC.FSK_HEADER_ELEMENT. NOTE: PROCEDURE SQL used (Total process time): real time 0.08 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} The SAS System NOTE: {END: fcf_chkrc} NOTE: 260 rows were inserted into SEG_KC.FSK_HEADER_ELEMENT. NOTE: PROCEDURE SQL used (Total process time): real time 0.04 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were updated in SEG_KC.FSK_SCENARIO. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were updated in SEG_KC.FSK_SCENARIO. NOTE: PROCEDURE SQL used (Total process time): real time 0.04 seconds cpu time 0.02 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: Table WORK.SCRDEL2 created, with 0 rows and 38 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: No rows were inserted into SEG_KC.FSK_SCENARIO. NOTE: PROCEDURE SQL used (Total process time): The SAS System real time 0.03 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were inserted into SEG_KC.FSK_SCENARIO_PARAMETER. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were deleted from SEG_KC.FSK_SCENARIO_ALERT_COLUMN. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.01 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: No rows were inserted into SEG_KC.FSK_SCENARIO_ALERT_COLUMN. NOTE: PROCEDURE SQL used (Total process time): real time 0.03 seconds cpu time 0.00 seconds NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} ERROR: FCF_SYNC.FCF_SA_SYNC_MUTEX.DATA is not locked by you. NOTE: There were 0 observations read from the data set WORK.SCRFIX. WHERE (scenario_id>0) and (LOGICAL_DELETE_IND not = 'Y') and (CURRENT_IND not = 'N') and scenario_type_code in ('CUS', 'HPS'); NOTE: DATA statement used (Total process time): The SAS System real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 5 observations read from the data set WORK.HDRNONDEL. WHERE (header_id>0) and (LOGICAL_DELETE_IND not = 'Y') and (HEADER_LOCATION_DESC not = ' ') and (HEADER_AUTOGEN_IND not = 'Y') and SOURCE_TYPE_DESC in ('Custom', 'HP Datastep', 'SAS Datastep'); NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ERROR: Given URL https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/party_watchlist_header.sas not found. Use the debug option for more information. ERROR: No logical assign for filename SCRSRV. ERROR: Error in the FILENAME statement. ERROR: No logical assign for filename SCRSRV. NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ERROR: No logical assign for filename SCRSRV. WEBDAV filename=https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/party_watchlist_header.sas Filename=!AMLROOT/scenario/header_code_active/party_watchlist_header_v_1.sas WARNING: No logical assign for filename SCRSRV. NOTE: The data set WORK.ERRORS1 has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: Appending WORK.ERRORS1 to WORK.ERRORS. WARNING: Variable msg has different lengths on BASE and DATA files (BASE 200 DATA 400). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 1 observations read from the data set WORK.ERRORS1. NOTE: 1 observations added. NOTE: The data set WORK.ERRORS has 1 observations and 1 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ERROR: Given URL https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/empty_header.sas not found. Use the debug option for more information. ERROR: No logical assign for filename SCRSRV. ERROR: Error in the FILENAME statement. ERROR: Error in the FILENAME statement. Filename=!AMLROOT/scenario/header_code_active/empty_header_v_1.sas WEBDAV filename=https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/empty_header.sas WARNING: No logical assign for filename SCRSRV. NOTE: The data set WORK.ERRORS1 has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Appending WORK.ERRORS1 to WORK.ERRORS. WARNING: Variable msg has different lengths on BASE and DATA files (BASE 200 DATA 400). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 1 observations read from the data set WORK.ERRORS1. NOTE: 1 observations added. NOTE: The data set WORK.ERRORS has 2 observations and 1 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ERROR: Given URL https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/ext_party_header_cor.sas not found. Use the debug option The SAS System for more information. ERROR: No logical assign for filename SCRSRV. ERROR: Error in the FILENAME statement. ERROR: Error in the FILENAME statement. Filename=!AMLROOT/scenario/header_code_active/ext_party_header_cor_v_1.sas WEBDAV filename=https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/ext_party_header_cor.sas WARNING: No logical assign for filename SCRSRV. NOTE: The data set WORK.ERRORS1 has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Appending WORK.ERRORS1 to WORK.ERRORS. WARNING: Variable msg has different lengths on BASE and DATA files (BASE 200 DATA 400). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 1 observations read from the data set WORK.ERRORS1. NOTE: 1 observations added. NOTE: The data set WORK.ERRORS has 3 observations and 1 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds ERROR: Given URL https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/ext_party_header_msb.sas not found. Use the debug option for more information. ERROR: No logical assign for filename SCRSRV. ERROR: Error in the FILENAME statement. ERROR: Error in the FILENAME statement. Filename=!AMLROOT/scenario/header_code_active/ext_party_header_msb_v_1.sas WEBDAV filename=https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/ext_party_header_msb.sas WARNING: No logical assign for filename SCRSRV. NOTE: The data set WORK.ERRORS1 has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: Appending WORK.ERRORS1 to WORK.ERRORS. WARNING: Variable msg has different lengths on BASE and DATA files (BASE 200 DATA 400). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 1 observations read from the data set WORK.ERRORS1. NOTE: 1 observations added. NOTE: The data set WORK.ERRORS has 4 observations and 1 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.01 seconds ERROR: Given URL https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/ext_party_header_pty.sas not found. Use the debug option for more information. ERROR: No logical assign for filename SCRSRV. ERROR: Error in the FILENAME statement. ERROR: Error in the FILENAME statement. Filename=!AMLROOT/scenario/header_code_active/ext_party_header_pty_v_1.sas WEBDAV filename=https://amlwebhkpp.intranet.bbl:8343/SASContentServer/repository/default/sasdav/Products/SASComplianceSolutions/headers/ext_party_header_pty.sas WARNING: No logical assign for filename SCRSRV. NOTE: The data set WORK.ERRORS1 has 1 observations and 1 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Appending WORK.ERRORS1 to WORK.ERRORS. WARNING: Variable msg has different lengths on BASE and DATA files (BASE 200 DATA 400). NOTE: FORCE is specified, so dropping/truncating will occur. NOTE: There were 1 observations read from the data set WORK.ERRORS1. NOTE: 1 observations added. NOTE: The data set WORK.ERRORS has 5 observations and 1 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: Format $BLNK is already on the library FMTS.FORMATS. NOTE: Format $BLNK has been written to FMTS.FORMATS. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Format DTMMDDYY is already on the library FMTS.FORMATS. NOTE: Format DTMMDDYY has been written to FMTS.FORMATS. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 7304 observations read from the data set SEG_KC.FSK_JOB_CALENDAR. NOTE: The data set WORK.DATE_NUM has 7304 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.21 seconds cpu time 0.02 seconds NOTE: There were 5217 observations read from the data set SEG_KC.FSK_JOB_CALENDAR. WHERE business_day_count not = -1; NOTE: The data set WORK.NUM_DATE has 5218 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: Format DATE_TO_NUM is already on the library FMTS.FORMATS. The SAS System NOTE: Format DATE_TO_NUM has been written to FMTS.FORMATS. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds NOTE: There were 7304 observations read from the data set WORK.DATE_NUM. NOTE: Format NUM_TO_DATE is already on the library FMTS.FORMATS. NOTE: Format NUM_TO_DATE has been written to FMTS.FORMATS. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 5218 observations read from the data set WORK.NUM_DATE. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 172 observations read from the data set SEG_KC.FSK_LOV. NOTE: The data set WORK.LOV_FORMATS has 87 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 87 observations read from the data set WORK.LOV_FORMATS. NOTE: 0 observations with duplicate key values were deleted. NOTE: The data set WORK.LOV_FORMATS has 87 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: Format $ACCTTYP is already on the library FMTS.FORMATS. NOTE: Format $ACCTTYP has been written to FMTS.FORMATS. NOTE: Format $CLASSIFIER_TYPE is already on the library FMTS.FORMATS. NOTE: Format $CLASSIFIER_TYPE has been written to FMTS.FORMATS. NOTE: Format $EVNTTYP is already on the library FMTS.FORMATS. NOTE: Format $EVNTTYP has been written to FMTS.FORMATS. NOTE: Format $MANREAS is already on the library FMTS.FORMATS. NOTE: Format $MANREAS has been written to FMTS.FORMATS. NOTE: Format $PRODUCT is already on the library FMTS.FORMATS. NOTE: Format $PRODUCT has been written to FMTS.FORMATS. NOTE: Format $SCENCAT is already on the library FMTS.FORMATS. NOTE: Format $SCENCAT has been written to FMTS.FORMATS. NOTE: Format $SCNSTAT is already on the library FMTS.FORMATS. NOTE: Format $SCNSTAT has been written to FMTS.FORMATS. NOTE: Format $STATUS is already on the library FMTS.FORMATS. NOTE: Format $STATUS has been written to FMTS.FORMATS. NOTE: Format $SUBJECT is already on the library FMTS.FORMATS. NOTE: Format $SUBJECT has been written to FMTS.FORMATS. NOTE: Format $TRANCDI is already on the library FMTS.FORMATS. NOTE: Format $TRANCDI has been written to FMTS.FORMATS. NOTE: Format $YESNO is already on the library FMTS.FORMATS. NOTE: Format $YESNO has been written to FMTS.FORMATS. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 87 observations read from the data set WORK.LOV_FORMATS. NOTE: There were 172 observations read from the data set SEG_KC.FSK_LOV. NOTE: The data set WORK.LOV_FORMATS_NUMERIC has 2 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds The SAS System NOTE: There were 2 observations read from the data set WORK.LOV_FORMATS_NUMERIC. NOTE: 0 observations with duplicate key values were deleted. NOTE: The data set WORK.LOV_FORMATS_NUMERIC has 2 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Format $SCENARIO_STATUS_SORTKEY is already on the library FMTS.FORMATS. NOTE: Format $SCENARIO_STATUS_SORTKEY has been written to FMTS.FORMATS. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 2 observations read from the data set WORK.LOV_FORMATS_NUMERIC. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 90 observations read from the data set SEG_KC.FSK_SCENARIO. NOTE: The data set WORK.SCENARIO_NAMES has 90 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 90 observations read from the data set WORK.SCENARIO_NAMES. NOTE: 0 observations with duplicate key values were deleted. NOTE: The data set WORK.SCENARIO_NAMES has 90 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: Format SCENAME is already on the library FMTS.FORMATS. NOTE: Format SCENAME has been written to FMTS.FORMATS. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 90 observations read from the data set WORK.SCENARIO_NAMES. NOTE: There were 90 observations read from the data set SEG_KC.FSK_SCENARIO. NOTE: The data set WORK.SCENARIO_DESC has 90 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 90 observations read from the data set WORK.SCENARIO_DESC. NOTE: 0 observations with duplicate key values were deleted. NOTE: The data set WORK.SCENARIO_DESC has 90 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Format SCENDES is already on the library FMTS.FORMATS. NOTE: Format SCENDES has been written to FMTS.FORMATS. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 90 observations read from the data set WORK.SCENARIO_DESC. The SAS System NOTE: The file _USERQRY is: Filename=/saswork/SAS_work47E200003356_afchkpp1/#LN00168, Owner Name=sassrv,Group Name=sas, Access Permission=-rw-r-----, Last Modified=19Jun2018:20:07:22 NOTE: 31 records were written to the file _USERQRY. The minimum record length was 3. The maximum record length was 72. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The file _USERMAP is: Filename=/saswork/SAS_work47E200003356_afchkpp1/#LN00167, Owner Name=sassrv,Group Name=sas, Access Permission=-rw-r-----, Last Modified=19Jun2018:20:07:22 NOTE: 315 records were written to the file _USERMAP. The minimum record length was 1. The maximum record length was 158. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: PROCEDURE METADATA used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: Libref _METPINF was successfully assigned as follows: Engine: XML Physical Name: _METPINF NOTE: Table WORK.PERSON_INFO created, with 6 rows and 8 columns. The SAS System NOTE: Simple index id has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Table WORK.TLOGIN created, with 5 rows and 10 columns. NOTE: Table WORK.LOGINS_INFO created, with 5 rows and 12 columns. NOTE: Table WORK.TLOGIN has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Table WORK.TEMAIL created, with 0 rows and 6 columns. NOTE: Table WORK.EMAIL_INFO created, with 0 rows and 8 columns. NOTE: Table WORK.TEMAIL has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.TLOCATION created, with 0 rows and 10 columns. NOTE: Table WORK.LOCATION_INFO created, with 0 rows and 12 columns. NOTE: Table WORK.TLOCATION has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.TPHONE created, with 0 rows and 6 columns. The SAS System NOTE: Table WORK.PHONE_INFO created, with 0 rows and 8 columns. NOTE: Table WORK.TPHONE has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 6 observations read from the data set WORK.PERSON_INFO. NOTE: The data set WORK.PERSON has 6 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Simple index keyid has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 0 observations read from the data set WORK.LOCATION_INFO. NOTE: The data set WORK.LOCATION has 0 observations and 10 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.02 seconds NOTE: Simple index keyid has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: There were 0 observations read from the data set WORK.EMAIL_INFO. NOTE: The data set WORK.EMAIL has 0 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Simple index keyid has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 0 observations read from the data set WORK.PHONE_INFO. NOTE: The data set WORK.PHONE has 0 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Simple index keyid has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The file _GRPQRY is: Filename=/saswork/SAS_work47E200003356_afchkpp1/#LN00171, Owner Name=sassrv,Group Name=sas, Access Permission=-rw-r-----, Last Modified=19Jun2018:20:07:22 NOTE: 23 records were written to the file _GRPQRY. The minimum record length was 13. The maximum record length was 77. NOTE: DATA statement used (Total process time): The SAS System real time 0.00 seconds cpu time 0.01 seconds NOTE: The file _GRPMAP is: Filename=/saswork/SAS_work47E200003356_afchkpp1/#LN00170, Owner Name=sassrv,Group Name=sas, Access Permission=-rw-r-----, Last Modified=19Jun2018:20:07:22 NOTE: 137 records were written to the file _GRPMAP. The minimum record length was 2. The maximum record length was 165. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: PROCEDURE METADATA used (Total process time): real time 0.02 seconds cpu time 0.00 seconds NOTE: Libref _METGINF was successfully assigned as follows: Engine: XML Physical Name: _METGINF NOTE: Table WORK.GROUP_INFO created, with 96 rows and 7 columns. NOTE: Simple index id has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Table WORK.TIDGROUPLOGINS created, with 8 rows and 10 columns. NOTE: Table WORK.GROUPLOGINS_INFO created, with 8 rows and 12 columns. The SAS System NOTE: Table WORK.TIDGROUPLOGINS has been dropped. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 96 observations read from the data set WORK.GROUP_INFO. NOTE: The data set WORK.IDGRPS has 96 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Simple index keyid has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: The file _GRPMMAP is: Filename=/saswork/SAS_work47E200003356_afchkpp1/#LN00173, Owner Name=sassrv,Group Name=sas, Access Permission=-rw-r-----, Last Modified=19Jun2018:20:07:22 NOTE: 87 records were written to the file _GRPMMAP. The minimum record length was 2. The maximum record length was 110. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The file _INGMINF is: The SAS System Filename=/saswork/SAS_work47E200003356_afchkpp1/#LN00175, Owner Name=sassrv,Group Name=sas, Access Permission=-rw-r-----, Last Modified=19Jun2018:20:07:22 NOTE: 2 records were written to the file _INGMINF. The minimum record length was 10. The maximum record length was 13. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The file _INGMINF is: Filename=/saswork/SAS_work47E200003356_afchkpp1/#LN00175, Owner Name=sassrv,Group Name=sas, Access Permission=-rw-r-----, Last Modified=19Jun2018:20:07:22, File Size (bytes)=25 NOTE: 288 records were written to the file _INGMINF. The minimum record length was 19. The maximum record length was 47. NOTE: There were 96 observations read from the data set WORK.IDGRPS. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: The file _INGMINF is: Filename=/saswork/SAS_work47E200003356_afchkpp1/#LN00175, Owner Name=sassrv,Group Name=sas, Access Permission=-rw-r-----, Last Modified=19Jun2018:20:07:22, File Size (bytes)=9049 The SAS System NOTE: 6 records were written to the file _INGMINF. The minimum record length was 10. The maximum record length was 34. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: PROCEDURE METADATA used (Total process time): real time 0.01 seconds cpu time 0.00 seconds NOTE: Libref _METMINF was successfully assigned as follows: Engine: XML Physical Name: _METMINF NOTE: There were 102 observations read from the data set _METMINF.GRPMEMPERSONS. NOTE: The data set WORK.GROUPMEMPERSONS_INFO has 102 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.02 seconds NOTE: There were 117 observations read from the data set _METMINF.GRPMEMGROUPS. NOTE: The data set WORK.GROUPMEMGROUPS_INFO has 117 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Simple index id has been defined. NOTE: Simple index memid has been defined. NOTE: Simple index id has been defined. NOTE: Simple index memid has been defined. NOTE: Table WORK.GRPMEMS created, with 219 rows and 2 columns. NOTE: Simple index grpkeyid has been defined. The SAS System NOTE: Simple index memkeyid has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: SQL view WORK.PLOGINS has been defined. NOTE: SQL view WORK.GLOGINS has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 5 observations read from the data set WORK.LOGINS_INFO. NOTE: There were 5 observations read from the data set WORK.PLOGINS. NOTE: There were 8 observations read from the data set WORK.GROUPLOGINS_INFO. NOTE: There were 8 observations read from the data set WORK.GLOGINS. NOTE: The data set WORK.LOGINS has 13 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Simple index keyid has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: The file _ATHDREQ is: Filename=/saswork/SAS_work47E200003356_afchkpp1/#LN00177, Owner Name=sassrv,Group Name=sas, Access Permission=-rw-r-----, Last Modified=19Jun2018:20:07:22 NOTE: 17 records were written to the file _ATHDREQ. The SAS System The minimum record length was 15. The maximum record length was 80. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: PROCEDURE METADATA used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The file _ATHDMAP is: Filename=/saswork/SAS_work47E200003356_afchkpp1/#LN00179, Owner Name=sassrv,Group Name=sas, Access Permission=-rw-r-----, Last Modified=19Jun2018:20:07:22 NOTE: 57 records were written to the file _ATHDMAP. The minimum record length was 2. The maximum record length was 149. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Libref _ADOMINF was successfully assigned as follows: Engine: XML Physical Name: _ADOMINF NOTE: There were 12 observations read from the data set _ADOMINF.AUTHDOMS. NOTE: The data set WORK.AUTHDOMAIN has 12 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds The SAS System NOTE: Libref _ADOMINF has been deassigned. NOTE: Fileref _ATHDREQ has been deassigned. NOTE: Fileref _ADOMINF has been deassigned. NOTE: Fileref _ATHDMAP has been deassigned. NOTE: Simple index keyid has been defined. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Libref _METPINF has been deassigned. NOTE: Libref _METGINF has been deassigned. NOTE: Libref _METMINF has been deassigned. NOTE: Fileref _METPINF has been deassigned. NOTE: Fileref _METGINF has been deassigned. NOTE: Fileref _INGMINF has been deassigned. NOTE: Fileref _METMINF has been deassigned. NOTE: Fileref _USERMAP has been deassigned. NOTE: Fileref _USERQRY has been deassigned. NOTE: Fileref _GRPMAP has been deassigned. NOTE: Fileref _GRPQRY has been deassigned. NOTE: Fileref _GRPMMAP has been deassigned. NOTE: Fileref _GRPMQRY has been deassigned. NOTE: Deleting WORK.PLOGINS (memtype=VIEW). NOTE: Deleting WORK.GLOGINS (memtype=VIEW). NOTE: PROCEDURE DATASETS used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Table WORK.USER_FORMATS created, with 6 rows and 2 columns. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds The SAS System NOTE: There were 6 observations read from the data set WORK.USER_FORMATS. NOTE: The data set WORK.USER_FORMATS has 12 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 12 observations read from the data set WORK.USER_FORMATS. NOTE: 0 observations with duplicate key values were deleted. NOTE: The data set WORK.USER_FORMATS has 12 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Format $UNAME is already on the library FMTS.FORMATS. NOTE: Format $UNAME has been written to FMTS.FORMATS. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 12 observations read from the data set WORK.USER_FORMATS. NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 257 observations read from the data set SEG_KC.FSC_COUNTRY_DIM. NOTE: The data set WORK.CTRL has 257 observations and 6 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds The SAS System NOTE: There were 257 observations read from the data set WORK.CTRL. NOTE: 0 observations with duplicate key values were deleted. NOTE: The data set WORK.CTRL has 257 observations and 6 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Format $COUNTRY_CODE is already on the library FMTS.FORMATS. NOTE: Format $COUNTRY_CODE has been written to FMTS.FORMATS. NOTE: PROCEDURE FORMAT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: There were 257 observations read from the data set WORK.CTRL. NOTE: {START: fcf_chkrc} NOTE: {END: fcf_chkrc} NOTE: The file WORK.RGALL (memtype=DATA) was not found, but appears on a DELETE statement. NOTE: Deleting WORK.HDRDEL (memtype=DATA). NOTE: Deleting WORK.HDRALL (memtype=DATA). NOTE: Deleting WORK.ELEMENTS (memtype=DATA). NOTE: Deleting WORK.HDRXSCR (memtype=DATA). NOTE: Deleting WORK.SCRFIX1 (memtype=DATA). NOTE: Deleting WORK.SCRXRG (memtype=DATA). NOTE: Deleting WORK.DATASET_LIST (memtype=DATA). NOTE: Deleting WORK.HDRINS (memtype=DATA). NOTE: Deleting WORK.HDRC (memtype=DATA). NOTE: Deleting WORK.HDRD (memtype=DATA). NOTE: Deleting WORK.HDRDT (memtype=DATA). NOTE: Deleting WORK.HDRJOIN (memtype=DATA). NOTE: Deleting WORK.HDRN (memtype=DATA). NOTE: Deleting WORK.HDRNT (memtype=DATA). NOTE: Deleting WORK.HEADERSC (memtype=DATA). The SAS System NOTE: Deleting WORK.HEADERSD (memtype=DATA). NOTE: Deleting WORK.HEADERSN (memtype=DATA). NOTE: Deleting WORK.HDRUNDELETED (memtype=DATA). NOTE: Deleting WORK.PARAMSC (memtype=DATA). NOTE: Deleting WORK.PRMALL (memtype=DATA). NOTE: Deleting WORK.PRMFIX (memtype=DATA). NOTE: Deleting WORK.PRMFULL (memtype=DATA). NOTE: Deleting WORK.ALERTCOLSC (memtype=DATA). NOTE: Deleting WORK.SCENARIOSC (memtype=DATA). NOTE: Deleting WORK.SCENARIOSD (memtype=DATA). NOTE: Deleting WORK.SCENARIOSN (memtype=DATA). NOTE: Deleting WORK.SCRNONDEL1 (memtype=DATA). NOTE: Deleting WORK.SCRNONDEL (memtype=DATA). NOTE: Deleting WORK.SCRALL0 (memtype=DATA). NOTE: Deleting WORK.SCRCT (memtype=DATA). NOTE: Deleting WORK.SCRC (memtype=DATA). NOTE: Deleting WORK.SCRD (memtype=DATA). NOTE: Deleting WORK.SCRDT (memtype=DATA). NOTE: Deleting WORK.SCRN (memtype=DATA). NOTE: Deleting WORK.SCRNT (memtype=DATA). NOTE: Deleting WORK.COLALL (memtype=DATA). NOTE: Deleting WORK.COLC (memtype=DATA). NOTE: Deleting WORK.COLFULL (memtype=DATA). NOTE: Deleting WORK.COLN (memtype=DATA). NOTE: Deleting WORK.COLNT (memtype=DATA). NOTE: Deleting WORK.COLUMNSC (memtype=DATA). NOTE: Deleting WORK.COLUMNSN (memtype=DATA). NOTE: Deleting WORK.ACINS (memtype=DATA). NOTE: Deleting WORK.COLINS (memtype=DATA). NOTE: Deleting WORK.PRMINS (memtype=DATA). NOTE: Deleting WORK.SCRFIX (memtype=DATA). NOTE: PROCEDURE DATASETS used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 753 + 754 +/**************************************************************************** The SAS System 755 + **************************************************************************** 756 + ** Return the result: error messages or success message 757 + **************************************************************************** 758 + ****************************************************************************/ 759 +%macro fcf_sa_update_rc (); 760 + %if &ds_errors_cnt = 0 and &fcf_sa_dav_err_flg = 0 %then %do; 761 + proc sql; 762 + CREATE TABLE hdr_list as 763 + select h.header_name 764 + from hdrnew h 765 + UNION 766 + select h.header_name 767 + from hdrupd h 768 + ORDER BY header_name 769 + ; 770 + quit; 771 + %let hdr_cnt = &SQLOBS; 772 + 773 + proc sql; 774 + CREATE TABLE hdr_del_list_1 as 775 + select header_name 776 + from hdr_del_list 777 + ; 778 + quit; 779 + %let hdr_cnt = %sysevalf(&hdr_cnt + &SQLOBS); 780 + 781 + proc sql; 782 + create table scr_list as 783 + select s.scenario_name, h.header_name 784 + from hdrnondel h 785 + inner join scrupd s 786 + on s.header_id = h.header_id 787 + order by scenario_name 788 + ; 789 + quit; 790 + %let scr_cnt = &SQLOBS; 791 + 792 + proc sql; The SAS System 793 + create table scr_del_list as 794 + select s.scenario_name 795 + from scrdel s 796 + UNION 797 + select s.scenario_name 798 + from scrdel1 s 799 + UNION 800 + select s.scenario_name 801 + from scrdel2 s 802 + order by scenario_name 803 + ; 804 + quit; 805 + %let scr_cnt = %sysevalf(&scr_cnt + &SQLOBS); 806 + 807 + %let sa_sp_ecm_deploy_success_title=%sysfunc(sasmsg(sashelp.fcfmsg, sa_sp_ecm_deploy_success_title, N)); 808 + data messages; 809 + length msg $400; 810 + msg = sasmsg("sashelp.fcfmsg", "sa_sp_success_msg", "noquote", "&hdr_cnt", "&scr_cnt"); 811 + output; 812 + run; 813 + proc print data=messages NOOBS LABEL; 814 + Var msg; 815 + Label msg='00'x; 816 + Title "&sa_sp_ecm_deploy_success_title"; 817 + run; 818 + title; 819 + 820 + %let scenario_name_label=%sysfunc(sasmsg(sashelp.fcfmsg, sa_test_scenario_name_label, N)); 821 + %let header_name_label=%sysfunc(sasmsg(sashelp.fcfmsg, sa_test_header_name_label, N)); 822 + %let deployed_scenarios_title=%sysfunc(sasmsg(sashelp.fcfmsg, sa_test_deployed_scenarios_title, N)); 823 + %let deployed_headers_title=%sysfunc(sasmsg(sashelp.fcfmsg, sa_test_deployed_headers_title, N)); 824 + %let deleted_scenarios_title=%sysfunc(sasmsg(sashelp.fcfmsg, sa_deleted_scenarios_title, N)); 825 + %let deleted_headers_title=%sysfunc(sasmsg(sashelp.fcfmsg, sa_deleted_headers_title, N)); 826 + 827 + proc print data=hdr_list NOOBS LABEL; 828 + Label header_name=&header_name_label; 829 + Title "&deployed_headers_title"; 830 + run; The SAS System 831 + proc print data=hdr_del_list_1 NOOBS LABEL; 832 + Label header_name=&header_name_label; 833 + Title "&deleted_headers_title"; 834 + run; 835 + proc print data=scr_list NOOBS LABEL; 836 + Label scenario_name=&scenario_name_label; 837 + Label header_name=&header_name_label; 838 + Title "&deployed_scenarios_title"; 839 + run; 840 + proc print data=scr_del_list NOOBS LABEL; 841 + Label scenario_name=&scenario_name_label; 842 + Title "&deleted_scenarios_title"; 843 + run; 844 + %end; %else %do; 845 + %let sa_sp_error_prefix=%sysfunc(sasmsg(sashelp.fcfmsg, sa_sp_error_prefix, N)); 846 + %let sa_sp_ecm_deploy_errors_title=%sysfunc(sasmsg(sashelp.fcfmsg, sa_sp_ecm_deploy_errors_title, N)); 847 + %if &ds_errors_cnt ne 0 %then %do; 848 + data messages; 849 + set ds_errors; 850 + length msg $400; 851 + msg = "&sa_sp_error_prefix " || sasmsg("sashelp.fcfmsg", "sa_sp_ds_not_found", "noquote", kstrip(DENORM_TABLE_NAME)); 852 + output; 853 + run; 854 + %end; 855 + %if &fcf_sa_dav_err_flg ne 0 %then %do; 856 + proc append base=messages data=errors; 857 + run; 858 + %end; 859 + proc print data=messages NOOBS LABEL; 860 + Var msg; 861 + Label msg='00'x; 862 + Title "&sa_sp_ecm_deploy_errors_title"; 863 + run; 864 + %end; 865 +%mend fcf_sa_update_rc; 866 + 867 +%stpbegin; 868 +%fcf_sa_update_rc() The SAS System NOTE: Appending WORK.ERRORS to WORK.MESSAGES. NOTE: BASE data set does not exist. DATA file is being copied to BASE file. NOTE: There were 5 observations read from the data set WORK.ERRORS. NOTE: The data set WORK.MESSAGES has 5 observations and 1 variables. NOTE: PROCEDURE APPEND used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: There were 5 observations read from the data set WORK.MESSAGES. NOTE: PROCEDURE PRINT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 869 +%stpend; 870 + 871 +proc datasets lib=work nolist; 872 + delete scrdel scrdel1 hdrnew hdrupd hdrnondel scrupd ds_errors errors 873 + hdr_del_list hdr_del_list_1 hdr_list scr_list scr_del_list messages 874 +quit; NOTE: %INCLUDE (level 1) ending.