Skip to Content
avatar image
Former Member

Unarchive repository error

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:PROGRA1SAPMDM1.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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Apr 13, 2006 at 03:01 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 13, 2006 at 04:26 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 14, 2006 at 02:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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:PROGRA1SAPMDM1.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:PROGRA1SAPMDM1.5ServerArchivesSP3_ARTICLE.a00'