Skip to Content
0
Former Member
May 08, 2008 at 06:12 AM

Unarchive error at linux DB2

31 Views

Hi MDM guys,we met a problem when we tried to unarchive the Customer repository which shipped by SAP.If someone has experienced the similar situation and had a solution,please kindly tell us.Thanks a lot.

MDM Verison 5.5.62.33

MDM Server:OS:Windows Server 2003

DB Server:OS Linux;DB:IBM DB2 for Linux

Error log:

Error: SQL_ERROR SQLSTATE= 54010, ErrorCode= -670, Msg=[IBM][CLI Driver][DB2/LINUXX8664] SQL0670N The row length of the table exceeded a limit of "32677" bytes. (Table space "".) SQLSTATE=54010

CREATE TABLE A2i_Relationships (Id INT NOT NULL, Name_L0 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L1 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L2 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L3 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L4 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L5 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L6 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L7 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L8 VARCHAR(1020) DEFAULT '' NOT NULL, Name_L9 VARCHAR(1020) DEFAULT '' NOT NULL, Name_LA VARCHAR(1020) DEFAULT '' NOT NULL, Name_LB VARCHAR(1020) DEFAULT '' NOT NULL, Name_LC VARCHAR(1020) DEFAULT '' NOT NULL, Name_LD VARCHAR(1020) DEFAULT '' NOT NULL, Name_LE VARCHAR(1020) DEFAULT '' NOT NULL, Name_LF VARCHAR(1020) DEFAULT '' NOT NULL, Name_LG VARCHAR(1020) DEFAULT '' NOT NULL, NameIsParent SMALLINT NOT NULL, SubName_L0 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L1 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L2 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L3 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L4 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L5 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L6 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L7 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L8 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_L9 VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LA VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LB VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LC VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LD VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LE VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LF VARCHAR(1020) DEFAULT '' NOT NULL, SubName_LG VARCHAR(1020) DEFAULT '' NOT NULL, Position INT NOT NULL, Type INT NOT NULL, ParentTableId INT NOT NULL, ChildTableId INT NOT NULL, HasPosition SMALLINT NOT NULL, HasQuantity SMALLINT NOT NULL, HasRequired SMALLINT NOT NULL)