Skip to Content
0
Former Member
Feb 22, 2015 at 05:57 AM

ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed during migration.

210 Views

Hello Experts ,

We are in process of migration and after 90% of migration we are getting the following error as mentioned in MIGRATE_DT_XXXXX_IMP.log.:

ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed

( ALTER TABLE "EDID4" ADD PRIMARY KEY( "MANDT" , "DOCNUM" , "COUNTER" , "SEGNUM" ))

DbSlExecute: rc = 99

(SQL error -10108)

error message returned by DbSl:

ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed

( ALTER TABLE "EDID4" enable persistent merge )

DbSlExecute: rc = 99

(SQL error 131)

error message returned by DbSl:

transaction rolled back by lock wait timeout: Lock timeout occurs while waiting TABLE_LOCK of mode EXCLUSIVE(TRANSACTION_ID=14, UPDATE_TRANSACTION_ID=1442668)

(DB) INFO: disconnected from DB

I ran r3tans -d too to check the connection but it shows "Disconnected from DB".

Can someone please let me know what went wrong.

Environment Details :

SOurce : ECC 6 Ehp5 NW702 Oracle10

Target : ECC 6 Ehp7 NW740 HANA 1.0 Rev85

Tool : SUM 1.0 SP12 PL04

Phase Name :

MAIN_SWITCH/SUBMOD_MIG_SWITCH/SUBMOD_MIG_DOWNTIME_RUN/EU_CLONE_MIG_DT_RUN

Thanks

Dev