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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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