SAPINST System Copy MaxDB J2EE 7.0 "Row too long" at CREATE TABLE

[Former Member]

Hello Guru's,

w'll make a system copy of a EP J2EE JAVA standalone system with sapinst an jload.

At the phase Import JAVA Dump, the import halted with the following error...

{Apr 1, 2009 3:10:35 PM com.sap.inst.jload.Jload dbImport

INFO: trying to drop table KMC_UWL_ITEMS

Apr 1, 2009 3:10:35 PM com.sap.inst.jload.Jload dbImport

INFO: table dropped

Apr 1, 2009 3:10:35 PM com.sap.inst.jload.Jload dbImport

INFO: trying to create table KMC_UWL_ITEMS

Apr 1, 2009 3:10:36 PM com.sap.inst.jload.Jload logStackTrace

SEVERE: com.sap.dictionary.database.dbs.JddException: CREATE TABLE KMC_UWL_ITEMS failed

15:10:35 2009-04-01 dbs-Info: <<< Analyze table KMC_UWL_ITEMS >>>

15:10:36 2009-04-01 dbs-Info: predefined action is: >>>null<<<

15:10:36 2009-04-01 sap-Info: Table KMC_UWL_ITEMS not found on DB.

15:10:36 2009-04-01 dbs-Info: Action: CREATE

15:10:36 2009-04-01 ope-Info: Create table in database SAPDB

E R R O R ******* (DbObjectSqlStatements)

15:10:36 2009-04-01 dbs-Error: Exception caught during SQL execution [-2000] (at 831): Row too long CREATE TABLE "KMC_UWL_ITEMS"("ITEM_ID" FIXED(19) DEFAULT 0 NOT NULL, "I_CONNECTOR_ID" INTEGER DEFAULT 0 NOT NULL, "SYSTEM_ID" VARCHAR(54) UNICODE NOT NULL, "EXTERNAL_ID" VARCHAR(300) UNICODE NOT NULL, "USER_ID" FIXED(19) DEFAULT 0 NOT NULL, "APP_CONTEXT" VARCHAR(255) UNICODE , "ATTACHMENT_COUNT" INTEGER , "CREATED_DATE" TIMESTAMP , "CREATOR_ID" VARCHAR(255) UNICODE , "DESCRIPTION" LONG UNICODE , "DELETED_FLAG" VARCHAR(1) UNICODE NOT NULL, "DUE_DATE" TIMESTAMP , "EXTERNAL_OBJECT_ID" VARCHAR(255) UNICODE , "EXECUTION_URL" VARCHAR(750) UNICODE , "EXPIRY_DATE" TIMESTAMP , "EXTERNAL_TYPE" VARCHAR(255) UNICODE , "FLAGS" INTEGER , "ITEM_TYPE" VARCHAR(255) UNICODE NOT NULL, "PRIORITY" INTEGER , "STATUS" VARCHAR(50) UNICODE , "SUBJECT" VARCHAR(255) UNICODE , "GROUP_ACTION" VARCHAR(1024) UNICODE DEFAULT ' ' , "PROCESSOR" VARCHAR(255) UNICODE DEFAULT ' ' )

15:10:36 2009-04-01 ope-Info: Table KMC_UWL_ITEMS could not be created in database

at com.sap.inst.jload.db.DBTable.create(DBTable.java:109)

at com.sap.inst.jload.Jload.dbImport(Jload.java:278)

at com.sap.inst.jload.Jload.executeJob(Jload.java:397)

at com.sap.inst.jload.Jload.main(Jload.java:621)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:85)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:58)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:60)

at java.lang.reflect.Method.invoke(Method.java:391)

at com.sap.engine.offline.OfflineToolStart.main(OfflineToolStart.java:81)

Apr 1, 2009 3:10:36 PM com.sap.inst.jload.db.DBConnection disconnect

INFO: disconnected

}

We have MaxDB 7.6.00.09.

The SAP Note 852597 is only for MaxDB Databases at Build 10.

It's fixed at Build 15. SapHelp is not helpful.

how WE can solve it????

regards

chris

[Former Member]

We have solved the issue with a newer MaxDB version. Not the best solution but works.