cancel
Showing results for 
Search instead for 
Did you mean: 

DB import failed at Import Java Dump

Former Member
0 Kudos

Hi experts,

Im still stucked at DB import to XD8 and the import failed at step Import Java dump with error in jload.log below:

28.09.12 09:38:58 com.sap.inst.jload.Jload dbImport
SEVERE: DB Error during import of XI_AF_MSG

28.09.12 09:38:58 com.sap.inst.jload.Jload printSQLException
SEVERE: Message: Violation of PRIMARY KEY
constraint 'PK__XI_AF_MS__99C1915D60096C7C'. Cannot insert duplicate
key in object 'SAPXD8DB.XI_AF_MSG'.

28.09.12 09:38:58 com.sap.inst.jload.Jload printSQLException
SEVERE: SQLState: 23000

28.09.12 09:38:58 com.sap.inst.jload.Jload printSQLException
SEVERE: ErrorCode: 2627

28.09.12 09:38:58 com.sap.inst.jload.Jload printSQLException
SEVERE: Message: Violation of PRIMARY KEY
constraint 'PK__XI_AF_MS__99C1915D60096C7C'. Cannot insert duplicate
key in object 'SAPXD8DB.XI_AF_MSG'.

28.09.12 09:38:58 com.sap.inst.jload.Jload printSQLException
SEVERE: SQLState: 23000

28.09.12 09:38:58 com.sap.inst.jload.Jload printSQLException
SEVERE: ErrorCode: 2627
.....

Any idea what is wrong?

Thanks.

Thava

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Thava,

Thavachelvi Velautham wrote:

SEVERE: Message: Violation of PRIMARY KEY
constraint 'PK__XI_AF_MS__99C1915D60096C7C'. Cannot insert duplicate
key in object 'SAPXD8DB.XI_AF_MSG'.

I think the message is self explanatory. You have a primary key constraint on the table & you are try to insert something with the same primary key that already exists in the table.

Regards, Trevor