NOTE: Log file opened at Tue, 6 Dec 2016 18:06:19.063 1 The SAS System 18:06 Tuesday, December 6, 2016 NOTE: Copyright (c) 2002-2012 by SAS Institute Inc., Cary, NC, USA. NOTE: SAS (r) Proprietary Software 9.4 (TS1M3) Licensed to COMPANY, Site 12345678. 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: real time 8.90 seconds cpu time 0.04 seconds NOTE: No preassigned object definitions were found on the metadata server. NOTE: No preassigned object definitions were found on the metadata server. NOTE: AUTOEXEC processing beginning; file is C:\sas94\config\Lev2\SASApp\appserver_autoexec.sas. NOTE: AUTOEXEC processing completed. 1 /* 2 * AutoLoad 3 * 4 * Purpose: Synchronizes SAS data sets placed in a single disk location with 5 * a single LASR Analytic Server library defined in metadata. 6 * 7 */ 8 9 /* Set up Metadata server connection Information */ 10 options 11 metauser="demo" 12 metapass=XXXXXXXXXXXX 13 METASERVER="host.sample.com" 14 METAPORT=8562 15 METAREPOSITORY="FOUNDATION"; 16 17 /* Set the name of the LASR library to which to Auto Load */ 18 %LET AL_META_LASRLIB=Visual Analytics LASR; 19 20 /* Include and execute main AutoLoad functionality */ 21 %LET 21 ! INCLUDELOC=C:\sas94\sashome\SASVisualAnalyticsHighPerformanceConfiguration\7.3\config\Deployment\Code\AutoLoad/include; 22 23 /* ------- No edits necessary below this line -------- */ 24 filename inclib "&INCLUDELOC."; 25 %include inclib ( AutoLoadMain.sas ); 3840 %AutoLoadMain; VA.AutoLoad.Location =C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA va.monitoringPath=C:\sas94\config\Lev2\Applications\SASVisualAnalytics\VisualAnalyticsAdministrator\Monitoring NOTE: DATA statement used (Total process time): real time 0.56 seconds cpu time 0.34 seconds 2 The SAS System 18:06 Tuesday, December 6, 2016 NOTE: The file "C:\sas94\config\Lev2\Applications\SASVisualAnalytics\VisualAnalyticsAdministrator\Monitoring\PIDs\autoload_VisualAnalyticsLAS R.pid" is: Filename=C:\sas94\config\Lev2\Applications\SASVisualAnalytics\VisualAnalyticsAdministrator\Monitoring\PIDs\autoload_VisualAnal yticsLASR.pid, RECFM=V,LRECL=32767,File Size (bytes)=0, Last Modified=06Dec2016:18:06:20, Create Time=06Dec2016:18:06:20 NOTE: 1 record was written to the file "C:\sas94\config\Lev2\Applications\SASVisualAnalytics\VisualAnalyticsAdministrator\Monitoring\PIDs\autoload_VisualAnalyticsLAS R.pid". The minimum record length was 4. The maximum record length was 4. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Libref DBLOG was successfully assigned as follows: Engine: BASE Physical Name: C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA\Logs NOTE: LASR Auto Load 7.2 NOTE: Task Name: AUTOLOAD NOTE: Process ID: 9868 NOTE: Configuration Settings: VA.AutoLoad.Enabled =Yes VA.Default.MetadataFolder =/Shared Data/SAS Visual Analytics/Autoload/VALIBLA VA.AutoLoad.AutoStart =Yes VA.AutoLoad.Sync.Enabled =Yes VA.AutoLoad.Sync.Import =Yes VA.AutoLoad.Sync.Load =Yes VA.AutoLoad.Sync.Unload =Yes VA.AutoLoad.Sync.Refresh =Yes VA.AutoLoad.Sync.Append =Yes VA.AutoLoad.Compress.Enabled =No VA.AutoLoad.ExpandChars.Enabled =No VA.AutoLoad.Import.Delimiter.TXT =TAB VA.AutoLoad.Import.RowsToScan =500 VA.AutoLoad.Debug.Enabled =No NOTE: Loading library attributes... SASIOLA library Visual Analytics LASR LIBREF=VALIBLA TAG=HPS SASClientConnection Port 10012 HOST=host.sample.com SIGNER=https://host.sample.com:443/SASLASRAuthorization ServerComponent LASR Analytic Server - host INSTALL=/opt/TKGrid PATH=C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles SMP=1 No data provider library associated with LASR library. NOTE: The data set WORK.LASRLIB has 1 observations and 35 variables. NOTE: DATA statement used (Total process time): 3 The SAS System 18:06 Tuesday, December 6, 2016 real time 0.23 seconds cpu time 0.18 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: PROCEDURE SQL used (Total process time): real time 0.00 seconds cpu time 0.00 seconds AL_LIBID = A58IU9TM.AC0002AO AL_DPLIBID = AL_LIBNAME = Visual Analytics LASR AL_DPLIBNAME = AL_LIBENGINE = SASIOLA AL_DPLIBENGINE = AL_LIBREF = VALIBLA AL_DPLIBREF = AL_LIBTAG = HPS AL_SMP = 1 AL_LASRHOST = host.sample.com AL_LASRPORT = 10012 AL_SIGNER = https://host.sample.com:443/SASLASRAuthorization AL_LASRMONPATH = AL_LASRINST = /opt/TKGrid AL_PATH = C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\sigfiles AL_DPPATH = AL_FORCE = AL_NODES = AL_TABLEMEM = AL_EXTERNALMEM = AL_LIFETIME = AL_LOGGINGENABLED = AL_LOGGINGPATH = AL_LOGGINGMAXFILESIZE = AL_LOGGINGMAXROLLOVER = AL_LOGGINGKEEPLOG = AL_LOGGINGADDITIONAL = AL_SERVERVERBOSE = AL_ROS_ENABLED = Yes AL_ROS_TBLDEFAULT = Yes AL_ROS_METHOD = All AL_TABLEFULLCOPIES = AL_METAFOLDER = /Shared Data/SAS Visual Analytics/Autoload/VALIBLA AL_SERVNAME = LASR Analytic Server - host NOTE: Connecting to LASR server host.sample.com:10012 NOTE: If the server is not running, an ERROR could appear here. NOTE: Libref LASRTEST was successfully assigned as follows: Engine: SASIOLA Physical Name: SAS LASR Analytic Server engine on local host, port 10012 NOTE: Libref LASRTEST has been deassigned. NOTE: LASR server host.sample.com:10012 is running NOTE: Examining C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA content NOTE: Libref DB was successfully assigned as follows: 4 The SAS System 18:06 Tuesday, December 6, 2016 Engine: BASE Physical Name: C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA NOTE: Libref DBOUT refers to the same physical library as DB. NOTE: Libref DBOUT was successfully assigned as follows: Engine: BASE Physical Name: C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA NOTE: Libref DBAPPEND was successfully assigned as follows: Engine: BASE Physical Name: C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA\Append NOTE: Libref DBAPPOUT refers to the same physical library as DBAPPEND. NOTE: Libref DBAPPOUT was successfully assigned as follows: Engine: BASE Physical Name: C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA\Append NOTE: Libref DBUNLOAD was successfully assigned as follows: Engine: BASE Physical Name: C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA\Unload NOTE: Libref DBFORMAT was successfully assigned as follows: Engine: BASE Physical Name: C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA\Formats WARNING: No matching members in directory. WARNING: Output 'members' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. NOTE: FMTSEARCH=( APFMTLIB WORK LIBRARY ) NOTE: SCANNING INPUT FOLDERS NOTE: There were 0 observations read from the data set WORK.SCANADDF. NOTE: The data set WORK.SCANADDF has 0 observations and 7 variables. NOTE: DATA statement 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.SCANAPDF. NOTE: The data set WORK.SCANAPDF has 0 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Examining LASR tables to append NOTE: If no append tables are present, it is normal to receive a WARNING here. WARNING: No matching members in directory. WARNING: Output 'members' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. NOTE: There were 0 observations read from the data set WORK.SCANUNLF. NOTE: The data set WORK.SCANUNLF has 0 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds NOTE: Examining LASR tables to unload NOTE: If no unload tables are present, it is normal to receive a WARNING here. WARNING: No matching members in directory. 5 The SAS System 18:06 Tuesday, December 6, 2016 WARNING: Output 'members' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. NOTE: Examining loaded LASR tables NOTE: If no tables are loaded, it is normal to receive a WARNING here. NOTE: Libref VALIBLA was successfully assigned as follows: Engine: SASIOLA Physical Name: SAS LASR Analytic Server engine on local host, port 10012 NOTE: Building actions list -------------------------------------------------------- NOTE: SCANNING C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA NO FILES TABLES: DAMARKETPRICES2013 -------------------------------------------------------- NOTE: SCANNING C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA\Append NO FILES NO TABLES -------------------------------------------------------- NOTE: SCANNING C:\sas94\config\Lev2\AppData\SASVisualAnalytics\VisualAnalyticsAdministrator\AutoLoad\VALIBLA\Unload NO FILES NO TABLES -------------------------------------------------------- NOTE: SCANNING LASR SERVER TABLES: DAMARKETPRICES2013 -------------------------------------------------------- NOTE: IMPORT NO NEW FILES TO IMPORT -------------------------------------------------------- NOTE: LOAD NO NEW TABLES TO LOAD TO LASR -------------------------------------------------------- NOTE: REFRESH NO TABLES TO REFRESH IN LASR -------------------------------------------------------- NOTE: APPEND NO TABLES TO APPEND TO LASR -------------------------------------------------------- NOTE: UNLOAD NO CURRENTLY LOADED LASR TABLES TO UNLOAD -------------------------------------------------------- NOTE: SCANNING INPUT FOLDERS NOTE: There were 0 observations read from the data set WORK.SCANADDF. NOTE: The data set WORK.SCANADDF has 0 observations and 7 variables. NOTE: DATA statement 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.SCANAPDF. NOTE: The data set WORK.SCANAPDF has 0 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 6 The SAS System 18:06 Tuesday, December 6, 2016 NOTE: Examining LASR tables to append NOTE: If no append tables are present, it is normal to receive a WARNING here. WARNING: No matching members in directory. WARNING: Output 'members' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. NOTE: There were 0 observations read from the data set WORK.SCANUNLF. NOTE: The data set WORK.SCANUNLF has 0 observations and 7 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: Examining LASR tables to unload NOTE: If no unload tables are present, it is normal to receive a WARNING here. WARNING: No matching members in directory. WARNING: Output 'members' was not created. Make sure that the output object name, label, or path is spelled correctly. Also, verify that the appropriate procedure options are used to produce the requested output object. For example, verify that the NOPRINT option is not used. NOTE: Examining loaded LASR tables NOTE: If no tables are loaded, it is normal to receive a WARNING here. NOTE: Libref VALIBLA was successfully assigned as follows: Engine: SASIOLA Physical Name: SAS LASR Analytic Server engine on local host, port 10012 NOTE: Building actions list NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds NOTE: LASR Auto Load 7.2 completed at December 06, 2016 6:06:25 PM NOTE: SAS Institute Inc., SAS Campus Drive, Cary, NC USA 27513-2414 NOTE: The SAS System used: real time 14.73 seconds cpu time 4.90 seconds NOTE: Log file closing at Tue, 6 Dec 2016 18:06:24.969