topic Re: Error when accessing the metadata of a LASR library in SAS Programming

Error when accessing the metadata of a LASR library

CosminBusca — Tue, 10 Feb 2015 16:07:58 GMT

Hi,

I have a problem when I try to update a table in Visual Analytic

I mention when I run the cod in Enterprise Guide everything works,

but when I try to run the cod from command line I have errors:

Below is the log:

126 / update lasr server *****/

127

128 LIBNAME LASRLIB SASIOLA TAG=VAPUBLIC PORT=10031 HOST="sast1.site" SIGNER="http://sast2.site:7980/SASLASRAuthorization"

128 ! ;

NOTE: Libref LASRLIB was successfully assigned as follows:

Engine: SASIOLA

Physical Name: SAS LASR Analytic Server engine on single host 'sast1.site', port 10031

129

130 proc sql;

131 drop table lasrlib.lg_article_schedule_i;

ERROR: Unable to connect to Metadata Server.

ERROR: Write access to member LASRLIB.LG_ARTICLE_SCHEDULE_I.DATA is denied.

WARNING: Table LASRLIB.LG_ARTICLE_SCHEDULE_I has not been dropped.

NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.

132 quit;

NOTE: The SAS System stopped processing this step because of errors.

NOTE: PROCEDURE SQL used (Total process time):

real time 0.00 seconds

cpu time 0.01 seconds

133

134 data LASRLIB.lg_article_schedule_i;

135 set myfiles.lg_articles20150123;

136 run;

ERROR: Unable to connect to Metadata Server.

ERROR: Write access to member LASRLIB.LG_ARTICLE_SCHEDULE_I.DATA is denied.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: SAS set option OBS=0 and will continue to check statements. This might cause NOTE: No observations in data set.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

Can someone help me?

Thank you.

Re: Error when accessing the metadata of a LASR library

ArchMitch — Thu, 19 Mar 2015 18:12:43 GMT

I'm seeing the same thing. Any solutions? It's like we are not connecting to the Metadata Server properly when using the command line...

Re: Error when accessing the metadata of a LASR library

gergely_batho — Fri, 20 Mar 2015 02:52:00 GMT

Yes. Check your metadata connection settings.

proc options group=meta;run;

Re: Error when accessing the metadata of a LASR library

ArchMitch — Mon, 23 Mar 2015 20:48:47 GMT

I got this little tidbit from my install consultant for creating the connection to the metadata in the code. Works great.

options metapass="XXXXX" metaport=8561 metaprotocol=bridge metarepository="Foundation" metaserver="host.domain" metauser="userid";

Re: Error when accessing the metadata of a LASR library

Edoedoedo — Mon, 10 Aug 2015 15:37:03 GMT

Thank you so much, it worked perfectly!

Re: Error when accessing the metadata of a LASR library

Raven01 — Mon, 02 Oct 2017 09:55:46 GMT

I have also experienced this error:

ERROR: Unable to connect to Metadata Server.

ERROR: Write access to member VALIBLA.datasetname.data is denied.

Even if I had declared the Metadata Connection string on top of my script, and had successfully assigned the VALIBLA library. Is there something I have missed?

Re: Error when accessing the metadata of a LASR library

error_prone — Mon, 02 Oct 2017 10:31:47 GMT

Your local SAS administrator should be able to provide the necessary information to establish the connection to the metadata server.

Re: Error when accessing the metadata of a LASR library

abinash_mishra — Wed, 13 Feb 2019 03:35:07 GMT

Can anyone share me code, which worked perfectly, I am also getting the same error, write access to member denied.