ERROR: Unable to establish a SAS Metadata Server connection. Proc Upload

[vfarmak]

Hi everone!

I execute a proc upload statement as listed below:

%let sashost=sasva01.myserver.com 7551;
options COMAMID=tcp;
libname vaload 'E:\SAS\VA';
signon sashost user='lasradm' password='mypassword';
rsubmit status=no;
libname SASDATA BASE "/opt/sas/sashome/DATA";
proc upload inlib=WORK outlib=SASDATA memtype=data;
select my_dataset;
run;
endrsubmit;
signoff;

And I Get the following error:

386 %let sashost=sasva01.myserver.com 7551;
387 options COMAMID=tcp;
388 libname vaload 'E:\SAS\VA';
NOTE: Libref VALOAD refers to the same physical library as VALOAD.
NOTE: Libref VALOAD was successfully assigned as follows:
Engine: V9
Physical Name: E:\SAS\VA
389 signon sashost user='lasradm' password=XXXXXXXXXXXXX;
NOTE: Remote signon to SASHOST commencing (SAS Release 9.04.01M8P011823).
NOTE: SASPROPRIETARY encryption is being used to protect network traffic.
NOTE: Copyright (c) 2016 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.4 (TS1M6)
Licensed to Company SA - VA DIST.ENV, Site 70141580.
NOTE: This session is executing on the Linux 3.10.0-1160.119.1.el7.x86_64 (LIN X64) platform.

NOTE: Additional host information:

Linux LIN X64 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue May 14 11:55:25 EDT 2024 x86_64 Red Hat Enterprise Linux Server release 7.9
(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:
real time 0.07 seconds
cpu time 0.06 seconds

ERROR: Unable to establish a SAS Metadata Server connection.

The Visual Analytics machine is a linux server, whereas the machine in which the SAS Data Integration Studio is installed is a Windows machine.

Any ideas?

Best Regards

[LinusH]

We have a slightly different setup, SAS Compute (corresponds to your DI Server I assume) is on the same host as LASR root (controller) node.

How is your LASR defined in metadata, when it comes to Logical Server, hosts etc?

Also, it doesn't look like you are using the SAS LASR Analytic Server Loader transformation? 

Please share your Job diagram and the complete job code.

[vfarmak]

The code can be found below:

/*==========================================================================* 
 * Step:            Proc Upload                           A5779UC5.BX00663Z * 
 * Transform:       User Written                                            * 
 * Description:                                                             * 
 *                                                                          * 
 * Source Table:    VA_LEADS_KPIS - work.LEADS_KPIS       A5779UC5.BZ0030RD * 
 *                                                                          * 
 * User Written:    SourceCode                                              * 
 *==========================================================================*/ 

%let transformID = %quote(A5779UC5.BX00663Z);
%let trans_rc = 0;
%let etls_stepStartTime = %sysfunc(datetime(), datetime20.); 

%let etls_recCheckExist = 0; 
%let etls_recnt = 0; 
%macro etls_recordCheck; 
   %let etls_recCheckExist = %eval(%sysfunc(exist(work.LEADS_KPIS, DATA)) or 
         %sysfunc(exist(work.LEADS_KPIS, VIEW))); 
   
   %if (&etls_recCheckExist) %then
   %do;
      %local etls_syntaxcheck; 
      %let etls_syntaxcheck = %sysfunc(getoption(syntaxcheck)); 
      /* Turn off syntaxcheck option to perform following steps  */ 
      options nosyntaxcheck;
      
      proc contents data = work.LEADS_KPIS out = work.etls_contents(keep = nobs) noprint; 
      run; 
      
      data _null_; 
         set work.etls_contents (obs = 1); 
         call symput("etls_recnt", left(put(nobs,32.))); 
      run;
      
      proc datasets lib = work nolist nowarn memtype = (data view);
         delete etls_contents;
      quit;
      
      /* Reset syntaxcheck option to previous setting  */ 
      options &etls_syntaxcheck; 
   %end;
%mend etls_recordCheck;
%etls_recordCheck;

%let SYSLAST = %nrquote(work.LEADS_KPIS); 

/* Runtime statistics macros  */ 
%etls_setPerfInit;
%perfstrt(txnname=%BQUOTE(_DISARM|&transformID|&syshostname|UserWritten), metrNam6=_DISROWCNT, metrDef6=Count32)   ;

%let _INPUT_count = 1;
%let _INPUT = work.LEADS_KPIS;
%let _INPUT_connect = ;
%let _INPUT_engine = ;
%let _INPUT_memtype = DATA;
%let _INPUT_options = %nrquote();
%let _INPUT_alter = %nrquote();
%let _INPUT_path = %nrquote(/VA_LEADS_KPIS_A5779UC5.BZ0030RD%(WorkTable%));
%let _INPUT_type = 1;
%let _INPUT_label = %nrquote();
%let _INPUT_filetype = WorkTable;

%let _INPUT1 = work.LEADS_KPIS;
%let _INPUT1_connect = ;
%let _INPUT1_engine = ;
%let _INPUT1_memtype = DATA;
%let _INPUT1_options = %nrquote();
%let _INPUT1_alter = %nrquote();
%let _INPUT1_path = %nrquote(/VA_LEADS_KPIS_A5779UC5.BZ0030RD%(WorkTable%));
%let _INPUT1_type = 1;
%let _INPUT1_label = %nrquote();
%let _INPUT1_filetype = WorkTable;

%let _OUTPUT_count = 0;
data VA_LEADS_KPIS;
	SET WORK.LEADS_KPIS;
RUN;

%let sashost=sasva01.dwh.gr 7551;
options COMAMID=tcp;
libname vaload 'E:\SAS\VA';
signon sashost user='lasradm' password='XXXXX';
rsubmit status=no;
libname SASDATA BASE "/opt/sas/sashome/DATA";
proc upload inlib=WORK outlib=SASDATA memtype=data;
select VA_LEADS_KPIS;
run;
endrsubmit;
signoff;
%rcSet(&syserr); 
%rcSet(&sqlrc); 
%perfstop(metrVal6=%sysfunc(max(&etls_recnt,-1)));
%let etls_recnt=-1;



/** Step end Proc Upload **/

I have also compressed the file including the image.

The SAS LASR Analytic Server Loader transformation I think that we do not have it (at least from the list option access options available in SAS Data Integration Studio.

[LinusH]

The transformation is available her: