topic metadata error in SAS Visual Analytics

metadata error

jitinsethi07 — Thu, 02 Feb 2017 09:11:43 GMT

Hi,

I've been trying to import some data as csv file, however I am getting an error:

5 The SAS System 19:26 Thursday, February 2, 2017

43 Options VALIDVARNAME=ANY VALIDMEMNAME=EXTEND;
44 %macro deletedsifexists(lib,name);
45 %if %sysfunc(exist(&lib..&name.)) %then %do;
46 proc datasets library=&lib. nolist;
47 delete &name.;
48 quit;
49 %end;
50 %mend deletedsifexists;
51
ERROR: Metadata Server denied access to operation.
52 /* Remove target data table from Library */
53 %deletedsifexists(LASRLIB, salesrbt);
54
55

I have tried removing spaces from the output table name as one of the sugesstions from google. I am still not able to get through. Kindly help!!!!

Thanks,

Jitin Sethi

Re: metadata error

RW9 — Thu, 02 Feb 2017 09:15:20 GMT

What type of SAS are you using, e.g. Enterprise Guide, DI, etc. This post should most definately not be in Community Matters!

Re: metadata error

LinusH — Thu, 02 Feb 2017 15:46:32 GMT

Include the libname statement and matadata server options if you have any.

My guess is that you either has a META engine allocation that doesn't allow delete operations, or perhaps you are working with a metadata bound library?

Re: metadata error

ballardw — Thu, 02 Feb 2017 15:49:46 GMT

If you are trying to import CSV then why are you attempting to delete a data set? If successful the import will overwrite the existing data set.

I suspect that you have issues about permissions with that library

run this code:

Libname LASRLIB list;

Look at the log to see characteristics and see if you have something like READONLY

Re: metadata error

jitinsethi07 — Fri, 03 Feb 2017 06:04:00 GMT

I am using SAS VA and it auto creates the delete macro that you are seeing in the error log.

I got my issue fixed after deleting the AUTOLOAD Log fines from the server. There were around 30,000 log files that were required to be cleared.

Thanks!