ERROR: The I/O subsystem returned error message 'ERROR: Library I0000176 does not exist.' while attempting to create the email container in the Foundation repository.

Reply
New Contributor
Posts: 2

ERROR: The I/O subsystem returned error message 'ERROR: Library I0000176 does not exist.' while attempting to create the email container in the Foundation repository.

Hi All,

I am getting an error while loading the %mduchglb()

Please find the below input and output error details.

############################### Input ##########################

/* Specify connection options. Use an unrestricted user ID. */

options metaserver="rliblrXXXXXX"

  metaport=8561

  metauser="sasadm@saspw"

  metapass="XXXXXX"

  metarepository="Foundation"

  metaprotocol=BRIDGE;

/*Specify the directory  for the extracted AD data (master tables)*/

libname extlib '/SAS/user_info_extract';

/* Extract identity information from the metadata (target).*/

libname metlib '/SAS/user_info';

/* Specify the directory  for the comparison output (change tables).*/

libname updates '/SAS/user_info_updates';

/* Compare AD (master) to metadata (target).3 */

%mducmp(master=extlib, target=metlib, change=updates, externonly=0);

/*%mducmp(master=extlib, target=metlib, change=updates, externonly=0, exceptions=update.exceptions );*/

/* Validate the change tables.*/

%mduchgv(change=updates, target=metlib, temp=work, errorsds=updates.mduchgverrors);

/* Load  the  changes into the metadata.4 */

%mduchglb(change=updates );

----------------- import code ---------------

libname extlib '/SAS/user_info_extract';

/* Specify connection options. Use an unrestricted user ID. */

options metaserver="rliblrsXXXXXX"

  metaport=8561

  metauser="sasadm@saspw"

  metapass="XXXXXX"

  metarepository="Foundation"

  metaprotocol=BRIDGE;

/* Initialize the macro variables that create canonical tables. */

%mduimpc();

/* Create the person table. */

data &persontbla ;

%definepersoncols;

infile datalines delimiter=',' missover;

input keyid name description title displayname;

datalines;

AAAG1 ,70006589 , 03072015 ,Branch Manager ,SRINIVAS SILLA

AAAG2 ,70021973 , 03072015 ,Branch Manager ,Sumit Pattanayak

;run;

data extlib.person;

set WORK.person;

run;

/* Create the phone table. */

data &phonetbla ;

%definephonecols;

infile datalines delimiter=',' missover;

input keyid phoneNumber phoneType;

datalines;

;run;

data extlib.phone;

set work.phone;

run;

/* Create the location table. */

data &locationtbla ;

%definelocationcols;

infile datalines delimiter=',' missover;

input keyid locationName locationType address city postalcode area

country;

datalines;

; run;

data extlib.location;

set work.location;

run;

/* Create the email table. */

data &emailtbla ;

%defineemailcols;

infile datalines delimiter=',' missover;

input keyid emailAddr emailtype;

datalines;

AAAG1 ,70006589@relianceada.com  ,

AAAG2 ,70021973@relianceada.com  , 

;run;

data extlib.email;

set work.email;

run;

/* Create the idgrp table. */

data &idgrptbla ;

%defineidgrpcols;

infile datalines delimiter=',';

  input keyid name description grpType displayname objid externalkey;

datalines;

GPAG01,BM_Agency, , ,BM group for Agency,GPAG01,1

;run;

data extlib.idgrps;

set work.idgrps;

run;

/* Create the grpmems table. */

data &idgrpmemstbla;

%defineidgrpmemscols;

infile datalines delimiter=',' missover;

input grpkeyid memkeyid;

datalines;

GPAG01,AAAG1

GPAG01,AAAG2

;run;

data extlib.grpmems;

set work.grpmems;

run;

/* Create the authdomain table. */

data &authdomtbla;

%defineauthdomcols;

infile datalines delimiter=',' missover;

input keyid authDomName;

datalines;

A001,DefaultAuth

;run;

data extlib.authdomain;

set work.authdomain;

run;

/* Create the logins table. */

data &logintbla;

%definelogincols;

infile datalines delimiter=',' missover;

input keyid userid password authdomkeyid;

datalines;

AAAG1 ,RELIANCECAPITAL\70006589, , A001

AAAG2 ,RELIANCECAPITAL\70021973, , A001

;run;

data extlib.logins;

set work.logins;

run;

--------------------------------------------------------------------- import code ------------------------------------

libname extlib '/SAS/user_info_extract';

/* Specify connection options. Use an unrestricted user ID. */

options metaserver="rliblrXXXXXXX"

  metaport=8561

  metauser="sasadm@saspw"

  metapass="XXXXXXXXXXX"

  metarepository="Foundation"

  metaprotocol=BRIDGE;

/* Initialize the macro variables that create canonical tables. */

%mduimpc();

/* Create the person table. */

data &persontbla ;

%definepersoncols;

infile datalines delimiter=',' missover;

input keyid name description title displayname;

datalines;

AAAG1 ,70006589 , 03072015 ,Branch Manager ,SRINIVAS SILLA

AAAG2 ,70021973 , 03072015 ,Branch Manager ,Sumit Pattanayak

;run;

data extlib.person;

set WORK.person;

run;

/* Create the phone table. */

data &phonetbla ;

%definephonecols;

infile datalines delimiter=',' missover;

input keyid phoneNumber phoneType;

datalines;

;run;

data extlib.phone;

set work.phone;

run;

/* Create the location table. */

data &locationtbla ;

%definelocationcols;

infile datalines delimiter=',' missover;

input keyid locationName locationType address city postalcode area

country;

datalines;

; run;

data extlib.location;

set work.location;

run;

/* Create the email table. */

data &emailtbla ;

%defineemailcols;

infile datalines delimiter=',' missover;

input keyid emailAddr emailtype;

datalines;

AAAG1 ,70006589@relianceada.com  ,

AAAG2 ,70021973@relianceada.com  , 

;run;

data extlib.email;

set work.email;

run;

/* Create the idgrp table. */

data &idgrptbla ;

%defineidgrpcols;

infile datalines delimiter=',';

  input keyid name description grpType displayname objid externalkey;

datalines;

GPAG01,BM_Agency, , ,BM group for Agency,GPAG01,1

;run;

data extlib.idgrps;

set work.idgrps;

run;

/* Create the grpmems table. */

data &idgrpmemstbla;

%defineidgrpmemscols;

infile datalines delimiter=',' missover;

input grpkeyid memkeyid;

datalines;

GPAG01,AAAG1

GPAG01,AAAG2

;run;

data extlib.grpmems;

set work.grpmems;

run;

/* Create the authdomain table. */

data &authdomtbla;

%defineauthdomcols;

infile datalines delimiter=',' missover;

input keyid authDomName;

datalines;

A001,DefaultAuth

;run;

data extlib.authdomain;

set work.authdomain;

run;

/* Create the logins table. */

data &logintbla;

%definelogincols;

infile datalines delimiter=',' missover;

input keyid userid password authdomkeyid;

datalines;

AAAG1 ,RELIANCECAPITAL\70006589, , A001

AAAG2 ,RELIANCECAPITAL\70021973, , A001

;run;

data extlib.logins;

set work.logins;

run;

######################## CODE END ###############################################

###############Error OUT PUT START ################################################

1                                                          The SAS System                                17:44 Monday, July 27, 2015

1          ;*';*";*/;quit;run;

2          OPTIONS PAGENO=MIN;

3          %LET _CLIENTTASKLABEL='sychronization';

4          %LET _CLIENTPROJECTPATH='C:\Users\sasdemo\Desktop\user syncronization.egp';

5          %LET _CLIENTPROJECTNAME='user syncronization.egp';

6          %LET _SASPROGRAMFILE=;

7         

8          ODS _ALL_ CLOSE;

9          OPTIONS DEV=ACTIVEX;

10         GOPTIONS XPIXELS=0 YPIXELS=0;

11         FILENAME EGSR TEMP;

12         ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR

13             STYLE=HtmlBlue

14             STYLESHEET=(URL="file:///C:/SAS/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")

15             NOGTITLE

16             NOGFOOTNOTE

17             GPATH=&sasworklocation

18             ENCODING=UTF8

19             options(rolap="on")

20         ;

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR

21        

22         GOPTIONS ACCESSIBLE;

23         /* Specify connection options. Use an unrestricted user ID. */

24          options metaserver="rliblrsundb01n"

25           metaport=8561

26           metauser="sasadm@saspw"

27           metapass=XXXXXXXXXXXXX

28           metarepository="Foundation"

29           metaprotocol=BRIDGE;

30         /*Specify the directory  for the extracted AD data (master tables)*/

31         libname extlib '/SAS/user_info_extract';

NOTE: Libref EXTLIB was successfully assigned as follows:

      Engine:        V9

      Physical Name: /SAS/user_info_extract

32        

33         /* Extract identity information from the metadata (target).*/

34         libname metlib '/SAS/user_info';

NOTE: Libref METLIB was successfully assigned as follows:

      Engine:        V9

      Physical Name: /SAS/user_info

35        

36         /* Specify the directory  for the comparison output (change tables).*/

37         libname updates '/SAS/user_info_updates';

NOTE: Libref UPDATES was successfully assigned as follows:

      Engine:        V9

      Physical Name: /SAS/user_info_updates

38        

39        

40        

41         /* Compare AD (master) to metadata (target).3 */

42         %mducmp(master=extlib, target=metlib, change=updates, externonly=0);

NOTE: Table WORK.COLUMNS created, with 34 rows and 18 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

2                                                          The SAS System                                17:44 Monday, July 27, 2015

NOTE: Table WORK.MPERSON created, with 2 rows and 5 columns.

NOTE: Table WORK.TPERSON created, with 5 rows and 7 columns.

NOTE: Table WORK.MPERSON has been modified, with 7 columns.

NOTE: 2 rows were updated in WORK.MPERSON.

NOTE: No rows were deleted from WORK.MPERSON.

NOTE: 5 rows were deleted from WORK.TPERSON.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.02 seconds

     

NOTE: No observations in data set WORK.TPERSON.

WARNING: No observations match on the ID variable values.

NOTE: There were 2 observations read from the data set WORK.MPERSON.

NOTE: There were 0 observations read from the data set WORK.TPERSON.

NOTE: The data set WORK.PERSON_COMP has 0 observations and 7 variables.

NOTE: PROCEDURE COMPARE used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: Table UPDATES.PERSON_DELETE created, with 0 rows and 7 columns.

NOTE: Table UPDATES.PERSON_ADD created, with 2 rows and 7 columns.

NOTE: Table UPDATES.PERSON_UPDATE created, with 0 rows and 7 columns.

NOTE: Table UPDATES.PERSON_SUMMARY created, with 2 rows and 8 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.02 seconds

      cpu time            0.03 seconds

     

NOTE: Table WORK.MLOCATION created, with 0 rows and 8 columns.

NOTE: Table WORK.TLOCATION created, with 0 rows and 10 columns.

NOTE: Table WORK.MLOCATION has been modified, with 10 columns.

NOTE: No rows were updated in WORK.MLOCATION.

NOTE: No rows were deleted from WORK.MLOCATION.

NOTE: No rows were deleted from WORK.TLOCATION.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.03 seconds

      cpu time            0.02 seconds

     

3                                                          The SAS System                                17:44 Monday, July 27, 2015

NOTE: No observations in data set WORK.MLOCATION.

NOTE: No observations in data set WORK.TLOCATION.

WARNING: No observations match on the ID variable values.

NOTE: There were 0 observations read from the data set WORK.MLOCATION.

NOTE: There were 0 observations read from the data set WORK.TLOCATION.

NOTE: The data set WORK.LOCATION_COMP has 0 observations and 10 variables.

NOTE: PROCEDURE COMPARE used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: Table UPDATES.LOCATION_DELETE created, with 0 rows and 10 columns.

NOTE: Table UPDATES.LOCATION_ADD created, with 0 rows and 10 columns.

NOTE: Table UPDATES.LOCATION_UPDATE created, with 0 rows and 10 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.03 seconds

     

NOTE: Table WORK.MEMAIL created, with 2 rows and 3 columns.

NOTE: Table WORK.TEMAIL created, with 0 rows and 5 columns.

NOTE: Table WORK.MEMAIL has been modified, with 5 columns.

NOTE: 2 rows were updated in WORK.MEMAIL.

NOTE: No rows were deleted from WORK.MEMAIL.

NOTE: No rows were deleted from WORK.TEMAIL.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.02 seconds

      cpu time            0.02 seconds

     

NOTE: No observations in data set WORK.TEMAIL.

WARNING: No observations match on the ID variable values.

NOTE: There were 2 observations read from the data set WORK.MEMAIL.

NOTE: There were 0 observations read from the data set WORK.TEMAIL.

NOTE: The data set WORK.EMAIL_COMP has 0 observations and 5 variables.

NOTE: PROCEDURE COMPARE used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

NOTE: Table UPDATES.EMAIL_DELETE created, with 0 rows and 5 columns.

NOTE: Table UPDATES.EMAIL_ADD created, with 2 rows and 5 columns.

NOTE: Table UPDATES.EMAIL_UPDATE created, with 0 rows and 5 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.02 seconds

4                                                          The SAS System                                17:44 Monday, July 27, 2015

     

NOTE: Table WORK.MPHONE created, with 0 rows and 3 columns.

NOTE: Table WORK.TPHONE created, with 0 rows and 5 columns.

NOTE: Table WORK.MPHONE has been modified, with 5 columns.

NOTE: No rows were updated in WORK.MPHONE.

NOTE: No rows were deleted from WORK.MPHONE.

NOTE: No rows were deleted from WORK.TPHONE.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.02 seconds

      cpu time            0.02 seconds

     

NOTE: No observations in data set WORK.MPHONE.

NOTE: No observations in data set WORK.TPHONE.

WARNING: No observations match on the ID variable values.

NOTE: There were 0 observations read from the data set WORK.MPHONE.

NOTE: There were 0 observations read from the data set WORK.TPHONE.

NOTE: The data set WORK.PHONE_COMP has 0 observations and 5 variables.

NOTE: PROCEDURE COMPARE used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

NOTE: Table UPDATES.PHONE_DELETE created, with 0 rows and 5 columns.

NOTE: Table UPDATES.PHONE_ADD created, with 0 rows and 5 columns.

NOTE: Table UPDATES.PHONE_UPDATE created, with 0 rows and 5 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.02 seconds

      cpu time            0.02 seconds

     

NOTE: Table WORK.MAUTHDOMAIN created, with 1 rows and 4 columns.

NOTE: Table WORK.TAUTHDOMAIN created, with 10 rows and 6 columns.

NOTE: Table WORK.MAUTHDOMAIN has been modified, with 6 columns.

NOTE: 1 row was updated in WORK.MAUTHDOMAIN.

NOTE: 1 row was updated in WORK.MAUTHDOMAIN.

NOTE: 1 row was updated in WORK.MAUTHDOMAIN.

NOTE: No rows were updated in WORK.TAUTHDOMAIN.

NOTE: No rows were updated in WORK.TAUTHDOMAIN.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.02 seconds

5                                                          The SAS System                                17:44 Monday, July 27, 2015

      cpu time            0.02 seconds

     

NOTE: Table WORK.MOUTBOUNDDOM created, with 0 rows and 6 columns.

NOTE: No rows were deleted from WORK.MAUTHDOMAIN.

NOTE: Table WORK.TOUTBOUNDDOM created, with 0 rows and 6 columns.

NOTE: No rows were deleted from WORK.TAUTHDOMAIN.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.02 seconds

     

NOTE: Table UPDATES.AUTHDOMAIN_DELETE created, with 0 rows and 6 columns.

NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized.

NOTE: Table UPDATES.AUTHDOMAIN_UPDATE created, with 0 rows and 4 columns.

NOTE: Table UPDATES.AUTHDOMAIN_ADD created, with 0 rows and 6 columns.

NOTE: Table WORK.TMISSINGAUTHDOMS created, with 9 rows and 5 columns.

NOTE: Table UPDATES.AUTHDOMAIN_SUMMARY created, with 10 rows and 5 columns.

NOTE: Table WORK.AUTHDOMKEYMAP created, with 1 rows and 2 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.05 seconds

      cpu time            0.03 seconds

     

NOTE: Table WORK.MIDGRPS created, with 1 rows and 5 columns.

NOTE: Table WORK.TIDGRPS created, with 46 rows and 7 columns.

NOTE: Table WORK.MIDGRPS has been modified, with 7 columns.

NOTE: 1 row was updated in WORK.MIDGRPS.

NOTE: No rows were deleted from WORK.MIDGRPS.

NOTE: 46 rows were deleted from WORK.TIDGRPS.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

     

NOTE: No observations in data set WORK.TIDGRPS.

WARNING: No observations match on the ID variable values.

NOTE: There were 1 observations read from the data set WORK.MIDGRPS.

NOTE: There were 0 observations read from the data set WORK.TIDGRPS.

NOTE: The data set WORK.IDGRPS_COMP has 0 observations and 7 variables.

NOTE: PROCEDURE COMPARE used (Total process time):

      real time           0.00 seconds

6                                                          The SAS System                                17:44 Monday, July 27, 2015

      cpu time            0.02 seconds

     

NOTE: Table UPDATES.IDGRPS_DELETE created, with 0 rows and 7 columns.

NOTE: Table UPDATES.IDGRPS_ADD created, with 1 rows and 7 columns.

NOTE: Table UPDATES.IDGRPS_UPDATE created, with 0 rows and 7 columns.

NOTE: Table UPDATES.IDGRPS_SUMMARY created, with 1 rows and 8 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.02 seconds

      cpu time            0.02 seconds

     

NOTE: Table WORK.CGRPTYPE created, with 0 rows and 7 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: There were 0 observations read from the data set WORK.CGRPTYPE.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

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

NOTE: Table WORK.TGRPMEMS created, with 33 rows and 2 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: Table UPDATES.GRPMEMS_DELETE created, with 33 rows and 2 columns.

NOTE: Table UPDATES.GRPMEMS_ADD created, with 2 rows and 2 columns.

NOTE: Table UPDATES.GRPMEMS_DELETE has been modified, with 5 columns.

NOTE: Table UPDATES.GRPMEMS_ADD has been modified, with 5 columns.

NOTE: 33 rows were updated in UPDATES.GRPMEMS_DELETE.

NOTE: 33 rows were updated in UPDATES.GRPMEMS_DELETE.

NOTE: 16 rows were updated in UPDATES.GRPMEMS_DELETE.

NOTE: 17 rows were updated in UPDATES.GRPMEMS_DELETE.

NOTE: 17 rows were updated in UPDATES.GRPMEMS_DELETE.

NOTE: No rows were updated in UPDATES.GRPMEMS_DELETE.

NOTE: No rows were updated in UPDATES.GRPMEMS_DELETE.

7                                                          The SAS System                                17:44 Monday, July 27, 2015

NOTE: 33 rows were deleted from UPDATES.GRPMEMS_DELETE.

NOTE: No rows were deleted from UPDATES.GRPMEMS_DELETE.

NOTE: No rows were deleted from UPDATES.GRPMEMS_DELETE.

NOTE: 2 rows were updated in UPDATES.GRPMEMS_ADD.

NOTE: 2 rows were updated in UPDATES.GRPMEMS_ADD.

NOTE: No rows were updated in UPDATES.GRPMEMS_ADD.

NOTE: 2 rows were updated in UPDATES.GRPMEMS_ADD.

NOTE: No rows were updated in UPDATES.GRPMEMS_ADD.

NOTE: No rows were updated in UPDATES.GRPMEMS_ADD.

NOTE: 2 rows were updated in UPDATES.GRPMEMS_ADD.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.07 seconds

      cpu time            0.08 seconds

     

NOTE: Table WORK.MLOGINS created, with 2 rows and 4 columns.

NOTE: Table WORK.TLOGINS created, with 10 rows and 6 columns.

NOTE: Table WORK.MLOGINS has been modified, with 6 columns.

NOTE: 2 rows were updated in WORK.MLOGINS.

NOTE: No rows were deleted from WORK.MLOGINS.

NOTE: 10 rows were deleted from WORK.TLOGINS.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.03 seconds

      cpu time            0.03 seconds

     

NOTE: No rows were deleted from WORK.TLOGINS.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: No rows were updated in WORK.TLOGINS.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: Table UPDATES.LOGINS_DELETE created, with 0 rows and 6 columns.

8                                                          The SAS System                                17:44 Monday, July 27, 2015

NOTE: Table UPDATES.LOGINS_ADD created, with 2 rows and 6 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

NOTE: Deleting WORK.COLUMNS (memtype=DATA).

NOTE: Deleting WORK.MPERSON (memtype=DATA).

NOTE: Deleting WORK.TPERSON (memtype=DATA).

NOTE: Deleting WORK.PERSON_COMP (memtype=DATA).

NOTE: Deleting WORK.MLOCATION (memtype=DATA).

NOTE: Deleting WORK.TLOCATION (memtype=DATA).

NOTE: Deleting WORK.LOCATION_COMP (memtype=DATA).

NOTE: Deleting WORK.MEMAIL (memtype=DATA).

NOTE: Deleting WORK.TEMAIL (memtype=DATA).

NOTE: Deleting WORK.EMAIL_COMP (memtype=DATA).

NOTE: Deleting WORK.MPHONE (memtype=DATA).

NOTE: Deleting WORK.TPHONE (memtype=DATA).

NOTE: Deleting WORK.PHONE_COMP (memtype=DATA).

NOTE: Deleting WORK.MAUTHDOMAIN (memtype=DATA).

NOTE: Deleting WORK.TAUTHDOMAIN (memtype=DATA).

NOTE: Deleting WORK.TOUTBOUNDDOM (memtype=DATA).

NOTE: Deleting WORK.MOUTBOUNDDOM (memtype=DATA).

NOTE: Deleting WORK.TMISSINGAUTHDOMS (memtype=DATA).

NOTE: Deleting WORK.AUTHDOMKEYMAP (memtype=DATA).

NOTE: Deleting WORK.MIDGRPS (memtype=DATA).

NOTE: Deleting WORK.TIDGRPS (memtype=DATA).

NOTE: Deleting WORK.IDGRPS_COMP (memtype=DATA).

NOTE: Deleting WORK.MGRPMEMS (memtype=DATA).

NOTE: Deleting WORK.TGRPMEMS (memtype=DATA).

NOTE: Deleting WORK.MLOGINS (memtype=DATA).

NOTE: Deleting WORK.TLOGINS (memtype=DATA).

NOTE: Deleting WORK.CGRPTYPE (memtype=DATA).

NOTE: PROCEDURE DATASETS used (Total process time):

      real time           0.01 seconds

      cpu time            0.03 seconds

     

43         /*%mducmp(master=extlib, target=metlib, change=updates, externonly=0, exceptions=update.exceptions );*/

44        

45         /* Validate the change tables.*/

46         %mduchgv(change=updates, target=metlib, temp=work, errorsds=updates.mduchgverrors);

NOTE: Table WORK.TOUTBOUNDDOM created, with 0 rows and 6 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: Table WORK.LOGINSEXCEPT1 created, with 0 rows and 6 columns.

NOTE: Table WORK.TMPLOGINS created, with 2 rows and 6 columns.

NOTE: 10 rows were inserted into WORK.TMPLOGINS.

NOTE: The query requires remerging summary statistics back with the original data.

9                                                          The SAS System                                17:44 Monday, July 27, 2015

NOTE: Table WORK.LOGINSEXCEPT2 created, with 0 rows and 6 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.02 seconds

      cpu time            0.03 seconds

     

NOTE: Table WORK.IDGRPSEXCEPT1 created, with 0 rows and 7 columns.

NOTE: Table WORK.IDGRPSEXCEPT2 created, with 0 rows and 7 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

NOTE: Table WORK.PEXCEPT1 created, with 0 rows and 7 columns.

NOTE: Table WORK.PEXCEPT2 created, with 0 rows and 7 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

NOTE: The query requires remerging summary statistics back with the original data.

NOTE: Table WORK.IDGRPSEXCEPT3 created, with 0 rows and 8 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: The query requires remerging summary statistics back with the original data.

NOTE: Table WORK.PEXCEPT3 created, with 0 rows and 8 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: The query requires remerging summary statistics back with the original data.

NOTE: Table WORK.AUTHDOMAINEXCEPT1 created, with 0 rows and 5 columns.

NOTE: The query requires remerging summary statistics back with the original data.

NOTE: Table WORK.AUTHDOMAINEXCEPT2 created, with 0 rows and 5 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.02 seconds

     

NOTE: Table UPDATES.MDUCHGVERRORS created, with 0 rows and 8 columns.

WARNING: Character expression will be truncated when assigned to character column filter.

NOTE: No rows were inserted into UPDATES.MDUCHGVERRORS.

WARNING: Character expression will be truncated when assigned to character column filter.

NOTE: No rows were inserted into UPDATES.MDUCHGVERRORS.

10                                                         The SAS System                                17:44 Monday, July 27, 2015

WARNING: Character expression will be truncated when assigned to character column filter.

NOTE: No rows were inserted into UPDATES.MDUCHGVERRORS.

WARNING: Character expression will be truncated when assigned to character column filter.

NOTE: No rows were inserted into UPDATES.MDUCHGVERRORS.

WARNING: Character expression will be truncated when assigned to character column filter.

NOTE: No rows were inserted into UPDATES.MDUCHGVERRORS.

WARNING: Character expression will be truncated when assigned to character column filter.

NOTE: No rows were inserted into UPDATES.MDUCHGVERRORS.

WARNING: Character expression will be truncated when assigned to character column filter.

NOTE: No rows were inserted into UPDATES.MDUCHGVERRORS.

WARNING: Character expression will be truncated when assigned to character column filter.

NOTE: No rows were inserted into UPDATES.MDUCHGVERRORS.

WARNING: Character expression will be truncated when assigned to character column filter.

NOTE: No rows were inserted into UPDATES.MDUCHGVERRORS.

WARNING: Character expression will be truncated when assigned to character column filter.

NOTE: No rows were inserted into UPDATES.MDUCHGVERRORS.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.03 seconds

      cpu time            0.03 seconds

     

NOTE: Deleting WORK.TOUTBOUNDDOM (memtype=DATA).

NOTE: Deleting WORK.LOGINSEXCEPT1 (memtype=DATA).

NOTE: Deleting WORK.TMPLOGINS (memtype=DATA).

NOTE: Deleting WORK.LOGINSEXCEPT2 (memtype=DATA).

NOTE: Deleting WORK.IDGRPSEXCEPT1 (memtype=DATA).

NOTE: Deleting WORK.IDGRPSEXCEPT2 (memtype=DATA).

NOTE: Deleting WORK.PEXCEPT1 (memtype=DATA).

NOTE: Deleting WORK.PEXCEPT2 (memtype=DATA).

NOTE: Deleting WORK.IDGRPSEXCEPT3 (memtype=DATA).

NOTE: Deleting WORK.PEXCEPT3 (memtype=DATA).

NOTE: Deleting WORK.AUTHDOMAINEXCEPT1 (memtype=DATA).

NOTE: Deleting WORK.AUTHDOMAINEXCEPT2 (memtype=DATA).

NOTE: PROCEDURE DATASETS used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

47        

48         /* Load  the  changes into the metadata.4 */

49         %mduchglb(change=updates );

NOTE: Table WORK.MDUCHGLB_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

     

11                                                         The SAS System                                17:44 Monday, July 27, 2015

NOTE: DATA statement used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

     

NOTE: Table WORK.AUTHDOMAIN_COMB created, with 0 rows and 5 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: SQL view WORK.IDGRPS_COMB has been defined.

NOTE: Table WORK.GRPMEMS_COMB created, with 2 rows and 6 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

NOTE: There were 2 observations read from the data set WORK.GRPMEMS_COMB.

NOTE: The data set WORK.GRPMEMS_COMB has 2 observations and 6 variables.

NOTE: PROCEDURE SORT used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: SQL view WORK.PERSON_COMB has been defined.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: Table WORK.IDENTITY_SUMMARY created, with 3 rows and 5 columns.

NOTE: Simple index keyid has been defined.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.02 seconds

     

NOTE: Table WORK.LOGINS_TEMP created, with 2 rows and 11 columns.

NOTE: No rows were updated in WORK.LOGINS_TEMP.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.02 seconds

     

NOTE: There were 2 observations read from the data set WORK.LOGINS_TEMP.

NOTE: The data set WORK.LOGINS_TEMP has 2 observations and 11 variables.

NOTE: PROCEDURE SORT used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

12                                                         The SAS System                                17:44 Monday, July 27, 2015

NOTE: SQL view WORK.LOCATION_COMB has been defined.

NOTE: Table WORK.LOCATION_TEMP created, with 0 rows and 12 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

NOTE: SQL view WORK.PHONE_COMB has been defined.

NOTE: Table WORK.PHONE_TEMP created, with 0 rows and 8 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: SQL view WORK.EMAIL_COMB has been defined.

NOTE: Table WORK.EMAIL_TEMP created, with 2 rows and 8 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.02 seconds

     

NOTE: There were 1 observations read from the data set UPDATES.IDGRPS_ADD.

NOTE: There were 0 observations read from the data set UPDATES.IDGRPS_UPDATE.

NOTE: There were 1 observations read from the data set WORK.IDGRPS_COMB.

NOTE: There were 2 observations read from the data set UPDATES.PERSON_ADD.

NOTE: There were 0 observations read from the data set UPDATES.PERSON_UPDATE.

NOTE: There were 2 observations read from the data set WORK.PERSON_COMB.

NOTE: There were 2 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 2 observations read from the data set WORK.EMAIL_TEMP.

NOTE: The data set WORK.INTERLEAVE has 7 observations and 29 variables.

NOTE: DATA statement used (Total process time):

      real time           0.02 seconds

      cpu time            0.03 seconds

     

NOTE: There were 7 observations read from the data set WORK.INTERLEAVE.

NOTE: The data set WORK.INTERLEAVE has 7 observations and 29 variables.

NOTE: PROCEDURE SORT used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: The file _IDNTMAP is:

      Filename=/SASWORK/SAS_workF0A1000015C4_rliblrsundb01n/#LN00037,

      Owner Name=sasdemo,Group Name=sas,

      Access Permission=-rw-r--r--,

      Last Modified=27Jul2015:18:54:57

NOTE: 83 records were written to the file _IDNTMAP.

13                                                         The SAS System                                17:44 Monday, July 27, 2015

      The minimum record length was 1.

      The maximum record length was 121.

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

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

     

NOTE: DATA statement used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

NOTE: The file _OUTXML is:

      Filename=/SASWORK/SAS_workF0A1000015C4_rliblrsundb01n/#LN00038,

      Owner Name=sasdemo,Group Name=sas,

      Access Permission=-rw-r--r--,

      Last Modified=27Jul2015:18:54:57

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

     

NOTE: The file _OUTXML is:

      Filename=/SASWORK/SAS_workF0A1000015C4_rliblrsundb01n/#LN00038,

      Owner Name=sasdemo,Group Name=sas,

      Access Permission=-rw-r--r--,

      Last Modified=27Jul2015:18:54:57,

      File Size (bytes)=28

NOTE: 41 records were written to the file _OUTXML.

      The minimum record length was 8.

      The maximum record length was 160.

NOTE: There were 7 observations read from the data set WORK.INTERLEAVE.

NOTE: DATA statement used (Total process time):

      real time           0.02 seconds

      cpu time            0.02 seconds

     

NOTE: The file _OUTXML is:

      Filename=/SASWORK/SAS_workF0A1000015C4_rliblrsundb01n/#LN00038,

      Owner Name=sasdemo,Group Name=sas,

      Access Permission=-rw-r--r--,

      Last Modified=27Jul2015:18:54:57,

      File Size (bytes)=1875

14                                                         The SAS System                                17:44 Monday, July 27, 2015

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

     

TRACE: sasioxml()

TRACE: Entering mlinit

TRACE: begin mlkwin()

TRACE: end mlkwin()

ACCESS ENGINE:  Entering dbiconi.

ACCESS ENGINE:  Exiting dbiconi.  rc=0x00000000

TRACE: Exiting mlinit

ACCESS ENGINE: Entering DBICON

ACCESS ENGINE:  CONNECTION= SHAREDREAD

mlcon : Entering

ACCESS ENGINE: Successful physical conn id 0

ACCESS ENGINE: Number of connections is 1

ACCESS ENGINE: Exiting DBICON with  rc=0X00000000

NOTE: Libref _RESPONS was successfully assigned as follows:

      Engine:        XML

      Physical Name: _RESPONS

ERROR: The I/O subsystem returned error message '         ERROR: Library I0000176 does not exist.' while attempting to create the

email container in the Foundation repository.

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.

WARNING: Character expression will be truncated when assigned to character column chgtype.

NOTE: 7 rows were inserted into WORK.MDUCHGLB_FAILEDOBJS.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

ACCESS ENGINE: Entering DBIDCON

mldcon : Entering

ACCESS ENGINE: Physical disconnect on id = 0

ACCESS ENGINE: Exiting DBIDCON with rc=0X00000000, rc2=0X00000000

TRACE: yheterm()

TRACE: Begin routine mlterm

TRACE: End routine mlterm

NOTE: Libref _RESPONS has been deassigned.

NOTE: Fileref _RESPONS has been deassigned.

NOTE: Fileref _OUTXML has been deassigned.

NOTE: Fileref _IDNTMAP has been deassigned.

NOTE: 2 rows were updated in WORK.GRPMEMS_COMB.

NOTE: 2 rows were updated in WORK.GRPMEMS_COMB.

15                                                         The SAS System                                17:44 Monday, July 27, 2015

NOTE: No rows were updated in WORK.GRPMEMS_COMB.

NOTE: 2 rows were updated in WORK.GRPMEMS_COMB.

NOTE: Table WORK.MDUCHGLB_FAILEDOBJS_IN created, with 7 rows and 12 columns.

NOTE: 2 rows were inserted into WORK.MDUCHGLB_FAILEDOBJS.

NOTE: 2 rows were updated in WORK.MDUCHGLB_FAILEDOBJS.

NOTE: No rows were updated in WORK.MDUCHGLB_FAILEDOBJS.

NOTE: 2 rows were updated in WORK.MDUCHGLB_FAILEDOBJS.

NOTE: Table WORK.MDUCHGLB_FAILEDOBJS_IN has been dropped.

NOTE: 2 rows were deleted from WORK.GRPMEMS_COMB.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.04 seconds

      cpu time            0.05 seconds

     

NOTE: Table WORK.DELOBJS created, with 0 rows and 3 columns.

NOTE: PROCEDURE SQL used (Total process time):

      real time           0.01 seconds

      cpu time            0.01 seconds

     

NOTE: Deleting WORK.AUTHDOMAIN_COMB (memtype=DATA).

NOTE: Deleting WORK.GRPMEMS_COMB (memtype=DATA).

NOTE: Deleting WORK.IDENTITY_SUMMARY (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.INTERLEAVE (memtype=DATA).

NOTE: Deleting WORK.IDENTITY_IDS (memtype=DATA).

NOTE: Deleting WORK.DELOBJS (memtype=DATA).

NOTE: PROCEDURE DATASETS used (Total process time):

      real time           0.00 seconds

      cpu time            0.01 seconds

     

NOTE: Deleting WORK.IDGRPS_COMB (memtype=VIEW).

NOTE: Deleting WORK.PERSON_COMB (memtype=VIEW).

NOTE: Deleting WORK.LOCATION_COMB (memtype=VIEW).

NOTE: Deleting WORK.PHONE_COMB (memtype=VIEW).

NOTE: Deleting WORK.EMAIL_COMB (memtype=VIEW).

NOTE: PROCEDURE DATASETS used (Total process time):

      real time           0.00 seconds

      cpu time            0.00 seconds

     

16                                                         The SAS System                                17:44 Monday, July 27, 2015

ERROR: Errors returned from Proc Metadata prevented objects from being Added, Updated, or Deleted.  Table: work.mduchglb_failedobjs

identifies 9 such objects.  Consult the SAS Log for the specific Metadata Server errors returned.

50        

51         GOPTIONS NOACCESSIBLE;

52         %LET _CLIENTTASKLABEL=;

53         %LET _CLIENTPROJECTPATH=;

54         %LET _CLIENTPROJECTNAME=;

55         %LET _SASPROGRAMFILE=;

56        

57         ;*';*";*/;quit;run;

58         ODS _ALL_ CLOSE;

59        

60        

61         QUIT; RUN;

62        

###############Error OUT PUT END ################################################

Ask a Question
Discussion stats
  • 0 replies
  • 397 views
  • 0 likes
  • 1 in conversation