cannot sync up metadata with physical library

haibh — Fri, 14 Jul 2023 18:25:20 GMT

I use Enterprise Guide with user sasadm@saspw

proc metalib;
omr (library="sasdbetlLIB");
run;

ERROR: The user does not have permission to perform this action.

Detail logs:

1 The SAS System 01:23 Saturday, July 15, 2023

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program 1';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='/home/main-sas/Project.egp';
6 %LET _CLIENTPROJECTPATHHOST='dc-sas-app';
7 %LET _CLIENTPROJECTNAME='Project.egp';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGHTML TEMP;
18 ODS HTML5(ID=EGHTML) FILE=EGHTML
19 OPTIONS(BITMAP_MODE='INLINE')
20 %HTML5AccessibleGraphSupported
21 ENCODING='utf-8'
22 STYLE=HTMLBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27
28 /* sync up metadata with physical library */
29 /* requires Create permissions for the library */
30 /*libname _temp meta library="sasdbetlLIB" metaout=data;*/
31 /*proc metalib;
32 /*omr (library="sasdbetlLIB");*/
33 /*update_rule=(delete);*/
34 /*select(NEWDATA);*/
35 /*report;*/
36 /*run;*/
37 /*libname _temp clear;*/
38 proc metalib;
39 omr (library="sasdbetlLIB");
40 run;

ERROR: The user does not have permission to perform this action.
NOTE: A total of 1 tables were analyzed for library "sasdbetlLIB".
NOTE: Metadata for 0 tables was updated.
NOTE: Metadata for 0 tables was added.
NOTE: Metadata for 1 tables matched the data sources.
NOTE: 0 other tables were not processed due to error or UPDATE_RULE.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE METALIB used (Total process time):
real time 0.45 seconds
cpu time 0.12 seconds

41
42 %LET _CLIENTTASKLABEL=;
43 %LET _CLIENTPROCESSFLOWNAME=;
44 %LET _CLIENTPROJECTPATH=;
45 %LET _CLIENTPROJECTPATHHOST=;
2 The SAS System 01:23 Saturday, July 15, 2023

46 %LET _CLIENTPROJECTNAME=;
47 %LET _SASPROGRAMFILE=;
48 %LET _SASPROGRAMFILEHOST=;
49
50 ;*';*";*/;quit;run;
51 ODS _ALL_ CLOSE;
52
53
54 QUIT; RUN;
55

Re: cannot sync up metadata with physical library

Kurt_Bremser — Fri, 14 Jul 2023 18:51:03 GMT

sasadm@saspw is an internal user which exists only in SAS metadata. You can not start a workspace server with it or run any oher type of SAS session, as it is not known to the operating system (which is necessary to run any process).

Re: cannot sync up metadata with physical library

SAYAN009 — Tue, 25 Jul 2023 11:37:09 GMT

I think you are facing the Error because of internal sasadm@saspw account. Try using an external account with proper SAS admin permission.

topic Re: cannot sync up metadata with physical library in SAS Enterprise Guide

cannot sync up metadata with physical library

Re: cannot sync up metadata with physical library

Re: cannot sync up metadata with physical library