topic Re: autosys job failed while pulling metadata person info in Administration and Deployment

autosys job failed while pulling metadata person info

shuchidxt_gmail_com — Fri, 19 Apr 2019 15:55:48 GMT

Hi,

When I ran my code in SAS EG it ran fine without any error.

but when I run the same code through autosys batch .I got below error. _metpinf is the output dataset created when we call

mduextr

macro to pull metadata information.

MPRINT(MDUEXTR):   filename _metpinf temp lrecl=1024 ;
MPRINT(MDUEXTR):   PROC METADATA header=full out=_metpinf in=_USERQRY;
MPRINT(MDUEXTR):   RUN;
ERROR: Insufficient information provided for a connection to the metadata server.
NOTE: PROCEDURE METADATA used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

Does anyone know why?

Re: autosys job failed while pulling metadata person info

LinusH — Fri, 19 Apr 2019 16:42:46 GMT

The mesaage is quite clear IMO.
When you are running through EG you are already connected to the metadata server.
Make sure that your batch execution configuration have the necessary options set to be able to connect.

Re: autosys job failed while pulling metadata person info

kdebruhl — Sat, 20 Apr 2019 17:27:55 GMT

I agree with @LinusH assessment.

We use this block of code when running in batch:

/* Create metadata macro variables */
%let IOMServer = %nrquote(SASApp);
%let metaPort = %nrquote(8561);
%let metaServer = %nrquote(yourhost.domain.com);

/* Set metadata options */
options metaport = &metaPort
metaserver = "&metaServer";

options metaserver=&metaserver..domain.com metauser="username@saspw" metapass="encodedpassword";