1                                                          The SAS System                           10:56 Thursday, October 12, 2017

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='2_Add_Users_Groups_to_Metadata';
4          %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5          %LET _CLIENTPROJECTPATH='';
6          %LET _CLIENTPROJECTNAME='';
7          %LET _SASPROGRAMFILE=;
8          
9          ODS _ALL_ CLOSE;
10         OPTIONS DEV=ACTIVEX;
11         GOPTIONS XPIXELS=0 YPIXELS=0;
12         FILENAME EGSR TEMP;
13         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
14             STYLE=HtmlBlue
15             STYLESHEET=(URL="file:///O:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
16             NOGTITLE
17             NOGFOOTNOTE
18             GPATH=&sasworklocation
19             ENCODING=UTF8
20             options(rolap="on")
21         ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
22         
23         GOPTIONS ACCESSIBLE;
24         %mduimpc();
25         /* Create the grpmems table for user/grousp association to add to Metadata. */
26         data &idgrpmemstbla;
27              %defineidgrpmemscols;
28              infile datalines delimiter=',' missover;
29                  input grpkeyid memkeyid;
30             datalines;

NOTE: The data set WORK.GRPMEMS has 1 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      
32         ;

33         
34         * Load the information from the work library into the metadata server. */;
35         %mduimplb();
NOTE: Table WORK.MDUIMPLB_FAILEDOBJS created, with 0 rows and 12 columns.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      


NOTE: Variable keyid is uninitialized.
NOTE: Variable authDomName is uninitialized.
NOTE: Variable authDomOutboundOnly is uninitialized.
NOTE: Variable authDomTrustedOnly is uninitialized.
NOTE: The data set WORK.AUTHDOMAIN_TEMP has 0 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.02 seconds
      
2                                                          The SAS System                           10:56 Thursday, October 12, 2017



NOTE: There were 1 observations read from the data set WORK.IDGRPS.
NOTE: 0 observations with duplicate key values were deleted.
NOTE: The data set WORK.IDGRPS_TEMP has 1 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

NOTE: Simple index keyid has been defined.

NOTE: MODIFY was successful for WORK.IDGRPS_TEMP.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      


NOTE: There were 1 observations read from the data set WORK.PERSON.
NOTE: 0 observations with duplicate key values were deleted.
NOTE: The data set WORK.PERSON_TEMP has 1 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

NOTE: Simple index keyid has been defined.

NOTE: MODIFY was successful for WORK.PERSON_TEMP.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      


NOTE: Variable keyid is uninitialized.
NOTE: Variable userid is uninitialized.
NOTE: Variable password is uninitialized.
NOTE: Variable authdomkeyid is uninitialized.
NOTE: The data set WORK.LOGINS_TEMP has 0 observations and 4 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.02 seconds
      


NOTE: Variable keyid is uninitialized.
NOTE: Variable locationName is uninitialized.
NOTE: Variable locationType is uninitialized.
NOTE: Variable address is uninitialized.
NOTE: Variable city is uninitialized.
NOTE: Variable postalcode is uninitialized.
NOTE: Variable area is uninitialized.
NOTE: Variable country is uninitialized.
NOTE: The data set WORK.LOCATION_TEMP has 0 observations and 8 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
3                                                          The SAS System                           10:56 Thursday, October 12, 2017

      cpu time            0.00 seconds
      


NOTE: Variable keyid is uninitialized.
NOTE: Variable phoneNumber is uninitialized.
NOTE: Variable phoneType is uninitialized.
NOTE: The data set WORK.PHONE_TEMP has 0 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      


NOTE: Variable keyid is uninitialized.
NOTE: Variable emailAddr is uninitialized.
NOTE: Variable emailType is uninitialized.
NOTE: The data set WORK.EMAIL_TEMP has 0 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      


NOTE: There were 1 observations read from the data set WORK.GRPMEMS.
NOTE: 0 observations with duplicate key values were deleted.
NOTE: The data set WORK.GRPMEMS_TEMP has 1 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

NOTE: Simple index grpkeyid has been defined.
NOTE: MODIFY was successful for WORK.GRPMEMS_TEMP.DATA.
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

NOTE: Table WORK.GRPMEMS_TEMP has been modified, with 5 columns.
NOTE: Table WORK.IDENTITY_IDS created, with 0 rows and 2 columns.
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      


NOTE: There were 1 observations read from the data set WORK.IDGRPS_TEMP.
NOTE: There were 1 observations read from the data set WORK.PERSON_TEMP.
NOTE: There were 0 observations read from the data set WORK.LOGINS_TEMP.
NOTE: There were 0 observations read from the data set WORK.PHONE_TEMP.
NOTE: There were 0 observations read from the data set WORK.LOCATION_TEMP.
NOTE: There were 0 observations read from the data set WORK.EMAIL_TEMP.
NOTE: The data set WORK.INTERLEAVE has 2 observations and 24 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      
4                                                          The SAS System                           10:56 Thursday, October 12, 2017



NOTE: There were 2 observations read from the data set WORK.INTERLEAVE.
NOTE: The data set WORK.INTERLEAVE has 2 observations and 24 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      


NOTE: The file _IDNTMP is:
      Filename=/opt/sas/saswork/SAS_work03A400003F3E_lrv153sd/#LN00044,
      Owner Name=lasradm,Group Name=sas,
      Access Permission=-rw-r--r--,
      Last Modified=12Oct2017:10:58:44

NOTE: 83 records were written to the file _IDNTMP.
      The minimum record length was 1.
      The maximum record length was 118.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      


NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      


NOTE: The file _OUTXML is:
      Filename=/opt/sas/saswork/SAS_work03A400003F3E_lrv153sd/#LN00045,
      Owner Name=lasradm,Group Name=sas,
      Access Permission=-rw-r--r--,
      Last Modified=12Oct2017:10:58:44

NOTE: 2 records were written to the file _OUTXML.
      The minimum record length was 10.
      The maximum record length was 13.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      


NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      35:1   
NOTE: Variable AuthDomObjID is uninitialized.
NOTE: The file _OUTXML is:
      Filename=/opt/sas/saswork/SAS_work03A400003F3E_lrv153sd/#LN00045,
      Owner Name=lasradm,Group Name=sas,
      Access Permission=-rw-r--r--,
      Last Modified=12Oct2017:10:58:44,
      File Size (bytes)=25

NOTE: 10 records were written to the file _OUTXML.
      The minimum record length was 9.
5                                                          The SAS System                           10:56 Thursday, October 12, 2017

      The maximum record length was 127.
NOTE: There were 2 observations read from the data set WORK.INTERLEAVE.
NOTE: DATA statement used (Total process time):
      real time           0.02 seconds
      cpu time            0.03 seconds
      


NOTE: The file _OUTXML is:
      Filename=/opt/sas/saswork/SAS_work03A400003F3E_lrv153sd/#LN00045,
      Owner Name=lasradm,Group Name=sas,
      Access Permission=-rw-r--r--,
      Last Modified=12Oct2017:10:58:44,
      File Size (bytes)=585

NOTE: 6 records were written to the file _OUTXML.
      The minimum record length was 10.
      The maximum record length was 34.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

NOTE: Libref _RESPONS was successfully assigned as follows: 
      Engine:        XML 
      Physical Name: _RESPONS

ERROR: An IdentityGroup named MYGROUP already exists in this server.
NOTE: PROCEDURE METADATA used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      
NOTE: The SAS System stopped processing this step because of errors.


NOTE: 2 rows were inserted into WORK.MDUIMPLB_FAILEDOBJS.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      

NOTE: Libref _RESPONS has been deassigned.
NOTE: Fileref _RESPONS has been deassigned.
NOTE: Fileref _OUTXML has been deassigned.
NOTE: Fileref _IDNTMP has been deassigned.
NOTE: 1 row was updated in WORK.GRPMEMS_TEMP.

NOTE: 1 row was updated in WORK.GRPMEMS_TEMP.

NOTE: No rows were updated in WORK.GRPMEMS_TEMP.

NOTE: No rows were updated in WORK.GRPMEMS_TEMP.

NOTE: Table WORK.MDUIMPLB_FAILEDOBJS_IN created, with 2 rows and 12 columns.

NOTE: No rows were inserted into WORK.MDUIMPLB_FAILEDOBJS.

6                                                          The SAS System                           10:56 Thursday, October 12, 2017

NOTE: No rows were updated in WORK.MDUIMPLB_FAILEDOBJS.

NOTE: No rows were updated in WORK.MDUIMPLB_FAILEDOBJS.

NOTE: No rows were updated in WORK.MDUIMPLB_FAILEDOBJS.

NOTE: Table WORK.MDUIMPLB_FAILEDOBJS_IN has been dropped.
NOTE: No rows were deleted from WORK.GRPMEMS_TEMP.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.02 seconds
      cpu time            0.03 seconds
      


NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      


NOTE: The file _OUTXML is:
      Filename=/opt/sas/saswork/SAS_work03A400003F3E_lrv153sd/#LN00047,
      Owner Name=lasradm,Group Name=sas,
      Access Permission=-rw-r--r--,
      Last Modified=12Oct2017:10:58:44

NOTE: 2 records were written to the file _OUTXML.
      The minimum record length was 10.
      The maximum record length was 16.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      


NOTE: The file _OUTXML is:
      Filename=/opt/sas/saswork/SAS_work03A400003F3E_lrv153sd/#LN00047,
      Owner Name=lasradm,Group Name=sas,
      Access Permission=-rw-r--r--,
      Last Modified=12Oct2017:10:58:44,
      File Size (bytes)=28

NOTE: 5 records were written to the file _OUTXML.
      The minimum record length was 16.
      The maximum record length was 39.
NOTE: There were 1 observations read from the data set WORK.GRPMEMS_TEMP.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.01 seconds
      


NOTE: The file _OUTXML is:
      Filename=/opt/sas/saswork/SAS_work03A400003F3E_lrv153sd/#LN00047,
      Owner Name=lasradm,Group Name=sas,
      Access Permission=-rw-r--r--,
      Last Modified=12Oct2017:10:58:44,
7                                                          The SAS System                           10:56 Thursday, October 12, 2017

      File Size (bytes)=150

NOTE: 6 records were written to the file _OUTXML.
      The minimum record length was 10.
      The maximum record length was 34.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      


ERROR: There is an illegal character in the name.
NOTE: PROCEDURE METADATA used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      
NOTE: The SAS System stopped processing this step because of errors.


NOTE: 1 row was inserted into WORK.MDUIMPLB_FAILEDOBJS.

NOTE: 1 row was updated in WORK.MDUIMPLB_FAILEDOBJS.

NOTE: 1 row was updated in WORK.MDUIMPLB_FAILEDOBJS.

NOTE: 1 row was updated in WORK.MDUIMPLB_FAILEDOBJS.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

NOTE: Fileref _RESPONS has been deassigned.
NOTE: Fileref _OUTXML has been deassigned.

NOTE: Deleting WORK.AUTHDOMAIN_TEMP (memtype=DATA).
NOTE: Deleting WORK.IDGRPS_TEMP (memtype=DATA).
NOTE: Deleting WORK.PERSON_TEMP (memtype=DATA).
NOTE: Deleting WORK.LOGINS_TEMP (memtype=DATA).
NOTE: Deleting WORK.LOCATION_TEMP (memtype=DATA).
NOTE: Deleting WORK.PHONE_TEMP (memtype=DATA).
NOTE: Deleting WORK.EMAIL_TEMP (memtype=DATA).
NOTE: Deleting WORK.GRPMEMS_TEMP (memtype=DATA).
NOTE: Deleting WORK.IDENTITY_IDS (memtype=DATA).
NOTE: Deleting WORK.INTERLEAVE (memtype=DATA).
NOTE: PROCEDURE DATASETS used (Total process time):
      real time           0.00 seconds
      cpu time            0.02 seconds
      



ERROR: Errors returned from Proc Metadata prevented objects from being Loaded.  Table: work.mduimplb_failedobjs identifies 3 such 
objects.  Consult the SAS Log for the specific Metadata Server errors returned.
36         
37         
38         GOPTIONS NOACCESSIBLE;
39         %LET _CLIENTTASKLABEL=;
8                                                          The SAS System                           10:56 Thursday, October 12, 2017

40         %LET _CLIENTPROCESSFLOWNAME=;
41         %LET _CLIENTPROJECTPATH=;
42         %LET _CLIENTPROJECTNAME=;
43         %LET _SASPROGRAMFILE=;
44         
45         ;*';*";*/;quit;run;
46         ODS _ALL_ CLOSE;
47         
48         
49         QUIT; RUN;
50