Unarchive repository error

[Former Member]

Hi,I wanted to unarchive the repository template

(in the Setup CD MDM55MDMBusiness_Content) in the MDM Console,But except for Article, the other four(Material,Vendor,Employee and Customer)were failed. I attached the log info.Please help to solve it.Thanks.

MDM Server version: 5.5.28.02 Built on 2005-Nov-18

Repository schema version: 1.264

DB Server:IBM DB2 8.1.0.36 Simplified Chinese Edition

2006/04/02 06:22:22.620 GMT Creating Repository: SP3_P1_MATERIAL, on DBMS Server: DB2DBS1

2006/04/02 06:23:42.165 GMT Init Database Tag: SP3_P1_MATERIALDB2DBS1IDB2_15_7_4_3

2006/04/02 06:23:42.695 GMT Repository SP3_P1_MATERIAL creation completed OK

2006/04/02 06:23:49.515 GMT UnArchive starting to server: DB2DBS1, target Repository: SP3_P1_MATERIAL, archivePath: C:PROGRA_1SAPMDM1.5ServerArchivesSP3_MATERIAL.a2a

2006/04/02 06:24:30.214 GMT SQL_ERROR SQLSTATE= 42601, ErrorCode= -104, Msg=[IBM][CLI Driver][DB2/NT] SQL0104N ÔÚ "res', '実験室', '" Ö®ºó·¢ÏÖÒâÍâµÄ±ê¼Ç "Лаборатория', '실험실'"¡£ÆÚÍûµÄ±ê¼Ç¿ÉÄÜ°üÀ¨£º""¡£ SQLSTATE=42601

INSERT INTO A2i_CM_Tables (TableId, TableName_L0, TableName_L3, TableName_L5, TableName_L6, TableName_L7, TableName_L8, TableName_L9, TableName_LA, TableName_LB, TableType, Flags, Lookup, NextAutoId, PrimaryDisplayField) VALUES (8, 'Laboratories', 'Labore', 'Laboratoires', '実験室', 'Лаборатория', '실험실', 'Laboratórios', 'Laboratorios', 'Lab.', 1, 2, '1:41;', 1, 0);

2006/04/02 06:24:37.294 GMT UnArchiving operation for SP3_P1_MATERIAL ended in error

[Former Member]

Hi Subbu and Rajani Kumar

Thanks very much for your helps.I have followed the post installation steps in installation guide and our MDM Server and Database server are in the same host. db2admin is the DB2 user for MDM.

I'm afarid the table A2i_CM_Tables of Material templet mentioned in the log may have not been created since I only found one A2i_CM_Tables in the DB2 Server but its schema was SP3P1ARTICLE_M000 which should belongs to Article templet.

Waiting for your helps.Thanks.

Best regards,

Zhi Jie

[Former Member]

ZhiJie,

For every repository in MDM, you will find two schemas <repository name>_M000 and <repository name>_Z000. Every repository will have the table called A2i_CM_Tables - This table holds all table IDs existing in your repository. So, please do not get confused with the existance of A2i_CM_Tables in both the schemas.

Please let me know how the "Article" repository was created. Are you following the same "Unarchive" procedure that you followed for this "Article" ?

Regards,

Rajani Kumar

[Former Member]

Rajani Kumar

I took the same procedure in unarchiving "Article" and "Material". It does not seem occasional because my colleague tried it on his machine(OS:Windows XP Chinese edition,DB:IBM DB2)and met the same situation with me.

By the way,in unarchiving the "Article",there was some err log too,but finally it gave the successful information. Attached it for your reference.Thanks.

3136 2006/04/02 06:00:42.891 GMT Creating Repository: SP3_P1_ARTICLE, on DBMS Server: DB2DBS1

3136 2006/04/02 06:02:02.386 GMT Init Database Tag: SP3_P1_ARTICLEDB2DBS1IDB2_14_7_4_3

3136 2006/04/02 06:02:04.589 GMT Repository SP3_P1_ARTICLE creation completed OK

3136 2006/04/02 06:02:31.297 GMT UnArchive starting to server: DB2DBS1, target Repository: SP3_P1_ARTICLE, archivePath: C:PROGRA_1SAPMDM1.5ServerArchivesSP3_ARTICLE.a2a

3136 2006/04/02 06:03:45.694 GMT Starting Repository: SP3_P1_ARTICLE on DB2DBS1

3136 2006/04/02 06:03:46.295 GMT Stopping Repository: SP3_P1_ARTICLE on DB2DBS1

3136 2006/04/02 06:03:46.936 GMT Repository Stopped: SP3_P1_ARTICLE on DB2DBS1

3136 2006/04/02 06:03:54.947 GMT Starting Repository: SP3_P1_ARTICLE on DB2DBS1

3136 2006/04/02 06:03:55.909 GMT Stopping Repository: SP3_P1_ARTICLE on DB2DBS1

3136 2006/04/02 06:03:56.470 GMT Repository Stopped: SP3_P1_ARTICLE on DB2DBS1

640 2006/04/02 06:04:19.373 GMT SQL_ERROR SQLSTATE= 42890, ErrorCode= -573, Msg=[IBM][CLI Driver][DB2/NT] SQL0573N ÔÚÔ¼Êø "F1_49_HSL_LIS" µÄ²Î¿¼×Ó¾äÖÐÖ¸¶¨µÄÁÐ±í²»±êʶ¸¸±í "SP3P1ARTICLE_M000.A2I_1_49" µÄΨһԼÊø¡£ SQLSTATE=42890

ALTER TABLE A2i_1_49_HSL ADD CONSTRAINT F1_49_HSL_LIS FOREIGN KEY (LinkId, Id, SubId) REFERENCES A2i_1_49(LinkId, Id, SubId)

640 2006/04/02 06:04:19.383 GMT Error on FK: F1_49_HSL_LIS

640 2006/04/02 06:04:19.813 GMT SQL_ERROR SQLSTATE= 42890, ErrorCode= -573, Msg=[IBM][CLI Driver][DB2/NT] SQL0573N ÔÚÔ¼Êø "F1_102_HSL_LIS" µÄ²Î¿¼×Ó¾äÖÐÖ¸¶¨µÄÁÐ±í²»±êʶ¸¸±í "SP3P1ARTICLE_M000.A2I_1_102" µÄΨһԼÊø¡£ SQLSTATE=42890

ALTER TABLE A2i_1_102_HSL ADD CONSTRAINT F1_102_HSL_LIS FOREIGN KEY (LinkId, Id, SubId) REFERENCES A2i_1_102(LinkId, Id, SubId)

640 2006/04/02 06:04:19.813 GMT Error on FK: F1_102_HSL_LIS

640 2006/04/02 06:04:27.244 GMT Init Database Tag: SP3_P1_ARTICLEDB2DBS1IDB2_14_7_4_3

640 2006/04/02 06:04:28.746 GMT UnArchive Completed with success to DB2DBS1:SP3_P1_ARTICLE from archivePath: 'C:PROGRA_1SAPMDM1.5ServerArchivesSP3_ARTICLE.a00'

[Former Member]

Hi ZhiJie,

Aprt from the suggetions given by Subbu, make sure the DB user has all the administrative privilages. It lloks like Unarchive failed at "INSERT" statement.

Regards,

Rajani Kumar

[Former Member]

Hi,

Did you follow the Post Installation steps for DBMS configuration in the MDM SP3 installation guides.

Installation guides are available in SAP Service market place.

URL:

https://websmp205.sap-ag.de/instguides

If MDM Server and Database server are in 2 different hosts, on the MDM Server host you need to install the Database client software.

Thanks and Regards

Subbu.