BookmarkSubscribeRSS Feed
CosminBusca
Calcite | Level 5

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.

7 REPLIES 7
ArchMitch
Calcite | Level 5

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...

gergely_batho
SAS Employee

Yes. Check your metadata connection settings.

proc options group=meta;run;

ArchMitch
Calcite | Level 5

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

Edoedoedo
Pyrite | Level 9

Thank you so much, it worked perfectly!

Raven01
Obsidian | Level 7

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?

error_prone
Barite | Level 11
Your local SAS administrator should be able to provide the necessary information to establish the connection to the metadata server.
abinash_mishra
Calcite | Level 5
Can anyone share me code, which worked perfectly, I am also getting the same error, write access to member denied.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 7020 views
  • 3 likes
  • 7 in conversation