on 02-22-2015 5:57 AM
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
Hello Dev,
Could you please attach us the entire log file MIGRATE_DT_XXXXX_IMP.log
Regards,
Anand.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, Check the Blog - DMO: optimizing system downtime ...
we already had a discussion about in another request.
Best Regards Roland
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dev,
Try this SAP Note 1900445 - HANA R3load import: (DB) ERROR: DDL statement failed
Regards,
Avinash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.