-1 -------------- Task Summary -------------- SUCCESS (SASJob PreCode) ERRORS (Store Process ID) ---------------------------------------------- ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [DATASTEP (2)] ERROR: Read Access Violation DATASTEP (2) Exception occurred at (00B0A0D2) Task Traceback Address Frame (DBGHELP API Version 4.0 rev 5) 0000000000B0A0D2 00000000062DE340 tkmk:tkBoot+0x18392 0000000000B084BC 00000000062DE390 tkmk:tkBoot+0x1677C 0000000001E61CE0 00000000062DE398 tkfauth:tkfauthTextToMode+0x890 0000000001E612D0 00000000062DE9E0 tkfauth:tkfauthSetFileSecurity+0x70 0000000001B95330 00000000062DE9E8 sashost:Main+0x4D810 0000000001B8C66E 00000000062DEF50 sashost:Main+0x44B4E 0000000002C84E9C 00000000062DEF58 sasxkern:tkvercn1+0x83E5C 00000000064CA6D5 00000000062DF038 sasdsx:tkvercn1+0x19695 00000000064C62B3 00000000062DF2B0 sasdsx:tkvercn1+0x15273 00000000064B1431 00000000062DF320 sasdsx:tkvercn1+0x3F1 0000000006105E31 00000000062DF328 sasds:tkvercn1+0x4DF1 0000000006104A40 00000000062DFBF0 sasds:tkvercn1+0x3A00 0000000001B589DB 00000000062DFF20 sashost:Main+0x10EBB 0000000001B5E62D 00000000062DFF50 sashost:Main+0x16B0D 00007FF9518413D2 00000000062DFF58 KERNEL32:BaseThreadInitThunk+0x22 00007FF9529E54E4 00000000062DFF88 ntdll:RtlUserThreadStart+0x34 ---------------------------------------------- -------------- LOG: SASJob PreCode -------------- 1 The SAS System 05:55 Friday, May 12, 2017 NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M3) Licensed to AGS HEALTH PVT LTD-VA, Site 11603991. NOTE: This session is executing on the X64_SRV12 platform. NOTE: Additional host information: X64_SRV12 WIN 6.2.9200 Server NOTE: SAS Initialization used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: The autoexec file, C:\Program Files\SAS\SASConfig\Lev1\SASApp\WorkspaceServer\autoexec.sas, was executed at server initialization. 1 %let _ENCODING=UTF-8; 2 options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND; 3 /* Status Checkpoint Macro */ 4 %macro statuscheckpoint(maxokstatus=4, varstocheck=SYSERR SYSLIBRC SYSDBRC ); 5 6 %GLOBAL LASTSTEPRC; 7 %LET pos=1; 8 %let var=notset; 9 %let var=%SCAN(&varstocheck.,&pos.); 10 %DO %WHILE ("&VAR." ne ""); 11 /* Retrieve the next return code to check */ 12 %if (%symexist(&VAR.)) %then %do; 13 %let val=&&&VAR..; 14 %if (("&VAL." ne "") and %eval(&VAL. > &maxokstatus.)) %then %do; 15 %put FAIL = &VAR.=&VAL. / SYSCC=&SYSCC.; 16 %let LASTSTEPRC=&VAL.; 17 %end; 18 %end; 19 %let pos = %eval(&pos.+1); 20 %let var=%SCAN(&varstocheck.,&pos.); 21 %END; 22 %mend; 23 /* Store the process ID in an external file */ 24 %macro CreateProcessIDFile(pidfl); 25 26 %global AL_PIDFILE; 27 data _null_; 28 file "&pidfl." PERMISSION='A::u::rw-,A::g::rw-,A::o::rw-'; 29 put "&SYSJOBID."; 30 run; 31 32 %if ( &SYSERR. le 4 ) %then 33 /* Store away the PIDFILE for future reference */ 34 %let AL_PIDFILE=&pidfl.; 35 36 %mend; 37 /* Remove process ID file */ 38 39 %macro DeleteProcessIDFile; 40 %if %SYMEXIST(AL_PIDFILE) %then %do; 41 data _null_; 2 The SAS System 05:55 Friday, May 12, 2017 42 fname="pidfile"; 43 rc=filename(fname, "&AL_PIDFILE."); 44 if rc=0 and fexist(fname) then 45 rc=fdelete(fname); 46 rc=filename(fname); 47 run; 48 %if ( &SYSERR. eq 0 ) %then %SYMDEL AL_PIDFILE; 49 %end; 50 %mend; -------------- LOG: Store Process ID -------------- 3 The SAS System 05:55 Friday, May 12, 2017 51 %statuscheckpoint; 52 /* Skip Next Step If We Have a Bad Status Code */ 53 %macro codeBody; 54 %GLOBAL LASTSTEPRC; 55 %if %symexist(LASTSTEPRC) %then %do; 56 %if %eval(&LASTSTEPRC. <= 4) %then %do; 57 58 %CreateProcessIDFile(C:\Program 58 ! Files\SAS\SASConfig\Lev1\Applications\SASVisualAnalytics\VisualAnalyticsAdministrator\Monitoring\PIDs\smp_agshdwp09-sasdr 58 ! _10031.pid); 59 %end; 60 %end; 61 %mend; 62 %codeBody; ERROR: An exception has been encountered. Please contact technical support and provide them with the following traceback information: The SAS task name is [DATASTEP (2)] ERROR: Read Access Violation DATASTEP (2) Exception occurred at (00B0A0D2) Task Traceback Address Frame (DBGHELP API Version 4.0 rev 5) 0000000000B0A0D2 00000000062DE340 tkmk:tkBoot+0x18392 0000000000B084BC 00000000062DE390 tkmk:tkBoot+0x1677C 0000000001E61CE0 00000000062DE398 tkfauth:tkfauthTextToMode+0x890 0000000001E612D0 00000000062DE9E0 tkfauth:tkfauthSetFileSecurity+0x70 0000000001B95330 00000000062DE9E8 sashost:Main+0x4D810 0000000001B8C66E 00000000062DEF50 sashost:Main+0x44B4E 0000000002C84E9C 00000000062DEF58 sasxkern:tkvercn1+0x83E5C 00000000064CA6D5 00000000062DF038 sasdsx:tkvercn1+0x19695 00000000064C62B3 00000000062DF2B0 sasdsx:tkvercn1+0x15273 00000000064B1431 00000000062DF320 sasdsx:tkvercn1+0x3F1 0000000006105E31 00000000062DF328 sasds:tkvercn1+0x4DF1 0000000006104A40 00000000062DFBF0 sasds:tkvercn1+0x3A00 0000000001B589DB 00000000062DFF20 sashost:Main+0x10EBB 0000000001B5E62D 00000000062DFF50 sashost:Main+0x16B0D 00007FF9518413D2 00000000062DFF58 KERNEL32:BaseThreadInitThunk+0x22 00007FF9529E54E4 00000000062DFF88 ntdll:RtlUserThreadStart+0x34 NOTE: The SAS System stopped processing this step because of errors. NOTE: DATA statement used (Total process time): real time 0.15 seconds cpu time 0.03 seconds -------------- LOG: Start Server -------------- 4 The SAS System 05:55 Friday, May 12, 2017 63 %statuscheckpoint; FAIL = SYSERR=20002 / SYSCC=20002 64 /* Skip Next Step If We Have a Bad Status Code */ 65 %macro codeBody; 66 %GLOBAL LASTSTEPRC; 67 %if %symexist(LASTSTEPRC) %then %do; 68 %if %eval(&LASTSTEPRC. <= 4) %then %do; 69 70 /* Start the single-machine LASR server process */ 71 libname ml sasiola startserver= 72 ( 73 PATH="C:\Program Files\SAS\SASConfig\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles" 74 ) 75 76 host="agshdwp09-sasdr.agshealth.com" port=10031 77 signer="http://agshdwp09-sasdr.agshealth.com:80/SASLASRAuthorization" 78 ; 79 80 %end; 81 %end; 82 %mend; 83 %codeBody; -------------- LOG: Wait For Server -------------- 5 The SAS System 05:55 Friday, May 12, 2017 84 %statuscheckpoint; FAIL = SYSERR=20002 / SYSCC=20002 85 /* Skip Next Step If We Have a Bad Status Code */ 86 %macro codeBody; 87 %GLOBAL LASTSTEPRC; 88 %if %symexist(LASTSTEPRC) %then %do; 89 %if %eval(&LASTSTEPRC. <= 4) %then %do; 90 91 /* Keep the SAS session up until SERVERTERM received */ 92 proc vasmp; 93 serverwait port=10031; 94 quit; 95 %end; 96 %end; 97 %mend; 98 %codeBody; -------------- LOG: Remove Process ID -------------- 6 The SAS System 05:55 Friday, May 12, 2017 99 %DeleteProcessIDFile; NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds -------------- SAS CODE -------------- %let _ENCODING=UTF-8; options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND; /* Status Checkpoint Macro */ %macro statuscheckpoint(maxokstatus=4, varstocheck=SYSERR SYSLIBRC SYSDBRC ); %GLOBAL LASTSTEPRC; %LET pos=1; %let var=notset; %let var=%SCAN(&varstocheck.,&pos.); %DO %WHILE ("&VAR." ne ""); /* Retrieve the next return code to check */ %if (%symexist(&VAR.)) %then %do; %let val=&&&VAR..; %if (("&VAL." ne "") and %eval(&VAL. > &maxokstatus.)) %then %do; %put FAIL = &VAR.=&VAL. / SYSCC=&SYSCC.; %let LASTSTEPRC=&VAL.; %end; %end; %let pos = %eval(&pos.+1); %let var=%SCAN(&varstocheck.,&pos.); %END; %mend; /* Store the process ID in an external file */ %macro CreateProcessIDFile(pidfl); %global AL_PIDFILE; data _null_; file "&pidfl." PERMISSION='A::u::rw-,A::g::rw-,A::o::rw-'; put "&SYSJOBID."; run; %if ( &SYSERR. le 4 ) %then /* Store away the PIDFILE for future reference */ %let AL_PIDFILE=&pidfl.; %mend; /* Remove process ID file */ %macro DeleteProcessIDFile; %if %SYMEXIST(AL_PIDFILE) %then %do; data _null_; fname="pidfile"; rc=filename(fname, "&AL_PIDFILE."); if rc=0 and fexist(fname) then rc=fdelete(fname); rc=filename(fname); run; %if ( &SYSERR. eq 0 ) %then %SYMDEL AL_PIDFILE; %end; %mend; %statuscheckpoint; /* Skip Next Step If We Have a Bad Status Code */ %macro codeBody; %GLOBAL LASTSTEPRC; %if %symexist(LASTSTEPRC) %then %do; %if %eval(&LASTSTEPRC. <= 4) %then %do; %CreateProcessIDFile(C:\Program Files\SAS\SASConfig\Lev1\Applications\SASVisualAnalytics\VisualAnalyticsAdministrator\Monitoring\PIDs\smp_agshdwp09-sasdr_10031.pid); %end; %end; %mend; %codeBody; %statuscheckpoint; /* Skip Next Step If We Have a Bad Status Code */ %macro codeBody; %GLOBAL LASTSTEPRC; %if %symexist(LASTSTEPRC) %then %do; %if %eval(&LASTSTEPRC. <= 4) %then %do; /* Start the single-machine LASR server process */ libname ml sasiola startserver= ( PATH="C:\Program Files\SAS\SASConfig\Lev1\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles" ) host="agshdwp09-sasdr.agshealth.com" port=10031 signer="http://agshdwp09-sasdr.agshealth.com:80/SASLASRAuthorization" ; %end; %end; %mend; %codeBody; %statuscheckpoint; /* Skip Next Step If We Have a Bad Status Code */ %macro codeBody; %GLOBAL LASTSTEPRC; %if %symexist(LASTSTEPRC) %then %do; %if %eval(&LASTSTEPRC. <= 4) %then %do; /* Keep the SAS session up until SERVERTERM received */ proc vasmp; serverwait port=10031; quit; %end; %end; %mend; %codeBody; %DeleteProcessIDFile;