BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.

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?

1 ACCEPTED SOLUTION

Accepted Solutions
kdebruhl
SAS Employee

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";

View solution in original post

2 REPLIES 2
LinusH
Tourmaline | Level 20
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.
Data never sleeps
kdebruhl
SAS Employee

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";

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1192 views
  • 0 likes
  • 3 in conversation