cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

anandkarthik_raja
Active Participant
0 Kudos

Hello Dev,

Could you please attach us the entire log file MIGRATE_DT_XXXXX_IMP.log

Regards,
Anand.

RolandKramer
Product and Topic Expert
Product and Topic Expert
0 Kudos

please consider this is not the SAP Incendent System, or I will close the Post. Thanks

Former Member
0 Kudos

We had a problem with our Indexserver - issue is solved and closing the thread,

Thanks

Dev

RolandKramer
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi, Check the Blog - DMO: optimizing system downtime ...

we already had a discussion about in another request.

Best Regards Roland

Former Member
0 Kudos

Dev,

Try this SAP Note 1900445 - HANA R3load import: (DB) ERROR: DDL statement failed

Regards,

Avinash

Former Member
0 Kudos

Thanks Avinash - Note seems not to be relevant for us.

Regards

Dev