ECC to HANA DB Migration, DMO error with invalid tables

[Former Member]

Hello Migration Experts,

I am facing one issue during the uptime migration phase in DMO. Some of the Export and Import jobs are failing, and i see they are failing due to invalid tables. I have checked in HANA,those table are not imported in to HANA schema.

Should i be adding those tables as described in the BW first guidance document ?

Since the tables doesn't exist in HANA schema , what flag i should be using while adding the tables ?

Content from the first guidance doc

If you encounter critical or invalid tables you can do the following workaround:

Edit the file \\server\sapmnt\CIH\SUM\abap\bin\EUCLONEDEFS_ADD.LST (create if not available)

and add the affected tables here, depending the option you want to take, e.g.

/BIC/AZSPOB10300   noclone (Table seems not to exist)

TBTCS  igncount (Table count will be ignored)

TST01  igncount

DBABARL  nocontent (Table doesn’t exist on HANA)

REPOSRC  ignlargercount (Table might change during cloning)

I have also found OSS Notes 1747673 - R3load on SAP HANA: SQL error: SQL syntax error: near ";" which advises to repalce DDLHDB.TPL, but my kernel is higher than the note says, Can i still try ?

Please advise

Thanks in advance,

GR

Below are some of my error logs

Import Job One

R3load: START OF LOG: 20140906205313

R3load: sccsid @(#) $Id: //bas/741_REL/src/R3ld/R3load/R3ldmain.c#11 $ SAP

R3load: version R7.41/V1.9 [UNICODE]

Compiled Aug 16 2014 00:13:51

R3load -pipe -decluster -i /usr/sap/ECS/SUM/abap/migrate_ut/MIGRATE_UT_00032_IMP.CMD -datacodepage 4103 -dbcodepage 4103 -l /usr/sap/ECS/SUM/abap/migrate_ut/MIGRATE_UT_

00032_IMP.LOG -loadprocedure fast -table_suffix ~ -k 1gegdUM50D801eqteAAv1A94

-------------------- Start of patch information ------------------------

patchinfo (patches.h): (0.048) R3load stops in the dependency loop while creating tasks (note 2044380)

DBSL patchinfo (patches.h): (0.031) New DBCON syntax for HANA (note 1983389)

--------------------- End of patch information -------------------------

process id 17232

(DB) INFO: connected to DB

(DB) INFO: NewDB Kernel version 1.00.80.00.391861

                         SQLDBC 1.00.82.00.0394270

(GSI) INFO: dbname   = "DEV/00                                                                                                                          "

(GSI) INFO: vname    = "HDB                             "

(GSI) INFO: hostname = "saphana                                                         "

(GSI) INFO: sysname  = "Linux"

(GSI) INFO: nodename = "SAPECCBOX"

(GSI) INFO: release  = "3.0.13-0.27-default"

(GSI) INFO: version  = "#1 SMP Wed Feb 15 13:33:49 UTC 2012 (d73692b)"

(GSI) INFO: machine  = "x86_64"

(RTF) ########## WARNING ###########

        Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(RDI) INFO: /usr/sap/ECS/SUM/abap/migrate_ut/MIGRATE_UT_00032_IMP.STR has format version 2

(RDI) INFO: /usr/sap/ECS/SUM/abap/migrate_ut/SAPDOKCLU.STR.logical has format version 2

(DCL) INFO: found logical cluster description for DOKCLU in /usr/sap/ECS/SUM/abap/migrate_ut/SAPDOKCLU.STR.logical

(DB) INFO: loading data in table "DOKCLU" with mass loader for LOBs #20140906205313

(DB) INFO: DOKCLU deleted/truncated

ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed

(DELETE FROM "DOKTL"WHERE   ('HY' < "ID" OR ("ID" = 'HY' AND 'SIMGISPAM_BELEGARTEN' < "OBJECT")  OR ("ID" = 'HY' AND "OBJECT" = 'SIMGISPAM_BELEGARTEN' AND 'D' <  "LANG

U") OR ("ID" = 'HY' AND "OBJECT" = 'SIMGISPAM_BELEGARTEN' AND  "LANGU" = 'D' AND 'E' < "TYP") OR ("ID" = 'HY' AND "OBJECT" =  'SIMGISPAM_BELEGARTEN' AND "LANGU" = 'D' A

ND "TYP" = 'E' AND '0013' <  "DOKVERSION")) AND ("ID" < 'TX' OR ("ID" = 'TX' AND "OBJECT" <  'SMP2ALR0000134') OR ("ID" = 'TX' AND "OBJECT" = 'SMP2ALR0000134' AND  "LAN

GU" < 'E') OR ("ID" = 'TX' AND "OBJECT" = 'SMP2ALR0000134' AND  "LANGU" = 'E' AND "TYP" < 'E') OR ("ID" = 'TX' AND "OBJECT" =  'SMP2ALR0000134' AND "LANGU" = 'E' AND "T

YP" = 'E' AND "DOKVERSION"  <= '0001')))

DbSlExecute: rc = 103

Another import Job

(RTF) ########## WARNING ###########

        Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(RDI) INFO: /usr/sap/ECS/SUM/abap/migrate_ut/MIGRATE_UT_00063_IMP.STR has format version 2

(RDI) INFO: /usr/sap/ECS/SUM/abap/migrate_ut/SAPTERCL3.STR.logical has format version 2

(DCL) INFO: found logical cluster description for TERCL3 in /usr/sap/ECS/SUM/abap/migrate_ut/SAPTERCL3.STR.logical

(DDL) ERROR: no DDL for TERCL3

(build_ddl_stmt).

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: TERCL3 merged #20140906205315

(DDL) ERROR: no DDL for TERMC3

(build_ddl_stmt).

(IMP) INFO: a failed DROP attempt is not necessarily a problem

DbSl Trace:   prepare() of C_0002, rc=1, rcSQL=259

DbSl Trace: PREPARE C_0002 on connection 0, rc=259

ERROR HDBexistsRow: Prepare/Read failed (dbrc=103).

  (SQL error 259)

  error message returned by DbSl:

invalid table name:  Could not find table/view TERMC3 in schema SAPECS: line 1 col 58 (at pos 57)

(RDI) INFO: /usr/sap/ECS/SUM/abap/migrate_ut/SAPTERCL3.STR.logical has format version 2

(DCL) INFO: found logical cluster description for TERCL3 in /usr/sap/ECS/SUM/abap/migrate_ut/SAPTERCL3.STR.logical

(SQL) INFO: Searching for SQL file SQLFiles.LST

(SQL) INFO: found SQLFiles.LST

(SQL) INFO: Trying to open SQLFiles.LST

(SQL) INFO: SQLFiles.LST opened

(SQL) INFO: Searching for SQL file SSEXC.SQL

(SQL) INFO: SSEXC.SQL not found

(DB) INFO: TERCL3^0 dropped

(DB) INFO: TERCL3^0 created #20140906205315

(SQL) INFO: Searching for SQL file SDOCU.SQL

(SQL) INFO: SDOCU.SQL not found

ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed

(ALTER TABLE "TERMC3" DROP CONSTRAINT "TERMC3^0")

DbSlExecute: rc = 103

  (SQL error 259)

  error message returned by DbSl:

invalid table name: TERMC3: line 1 col 13 (at pos 12)

(IMP) INFO: a failed DROP attempt is not necessarily a problem

ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed

(ALTER TABLE "TERMC3" ADD CONSTRAINT "TERMC3^0" PRIMARY KEY ( "SPRAS", "TERM", "LINENUMBER" ) )

DbSlExecute: rc = 103

  (SQL error 259)

  error message returned by DbSl:

invalid table name: TERMC3: line 1 col 13 (at pos 12)

(RDI) INFO: /usr/sap/ECS/SUM/abap/migrate_ut/SAPTERCL3.STR.logical has format version 2

(DCL) INFO: found logical cluster description for TERCL3 in /usr/sap/ECS/SUM/abap/migrate_ut/SAPTERCL3.STR.logical

(DDL) ERROR: no DDL for TERCL3

(build_ddl_stmt).

(IMP) INFO: a failed DROP attempt is not necessarily a problem

(DB) INFO: TERCL3 unloaded #20140906205315

(DDL) ERROR: no DDL for TERMC3

(build_ddl_stmt).

(IMP) INFO: a failed DROP attempt is not necessarily a problem

ERROR exec_ddl_stmt: (DB) ERROR: DDL statement failed

(                                           ALTER TABLE "TERMC3" enable persistent merge )

DbSlExecute: rc = 103

  (SQL error 259)

  error message returned by DbSl:

invalid table name: TERMC3: line 1 col 56 (at pos 55)

(DB) INFO: disconnected from DB

[Reagan]

You just need to maintain an exception list as mentioned in this document.

Check pages 52 and 56 of the document.

This was discussed before

Regards

RB

[Former Member]

Dear RB,

Thanks for quick response.

I have tried creating EUCLONEDEFS_ADD.LST in abap/bin folder, Tried adding one table first to see it works. Below is the content i added

TERMC1 igncount

But still the same issue.

What am i missing , please help

Thanks

[Reagan]

Your problem looks like an issue with the cluster tables and I don't think the solution to ignore the tables using the EUCLONEDEFS_ADD.LST file apply here like mentioned in the article.

Check whether these SAP notes applies

1900445 - HANA R3load import: (DB) ERROR: DDL statement failed

1792686 - Error during system copy on HDB after update

If possible supply (attach) the complete error logs.

Regards

RB

[Former Member]

I looked at those notes and tried replacing the DDLHDB.TPL file, but the issue was same. I have ignored these error's in task files for now, migration is resumed as of now, not sure what will be the impact. I have listed the tables which were having issues, may be useful to cross check if migration is successful.

I did not follow 1792686 - Error during system copy on HDB after update as it says "Take note that you cannot complete the already started copy because the export tasks must be regenerated" . My migration import process was already started hence ignored

Thanks a lot for your quick response and idea's.

Hope it goes well

[Reagan]

I would consider replacing the R3load and see if that helps.

You may raise an OSS message and check whether the tables that you have skipped are relevant or not for the HANA database. Don't forget to given us an update on it.

Good Luck

RB

[Former Member]

Result of that table issue fix is that migration went ahead, finished both uptime and downtime run. Now i am trying to login to SAP and system is unable to log me in as DOKTL doesnt exist at all

But i see another table called DTELDOKTL in HANA, which same as DOKTL but no entries in it.

I have created a message to SAP , But what should i be doing now ?

Can i create this table in HANA ?

Can i do export/import of table ? Table structure should be there in system already for this option i guess.

Would i be able to replicate this table if i setup SLT ?

Please advise

C Mon Sep  8 11:02:30 2014

C  *** ERROR =>   prepare() of C_0341, rc=1, rcSQL=259

[dbsdbsql.cpp 1397]

C  {root-id=00505680721D1EE48DE09241702FF193}_{conn-id=00000000000000000000000000000000}_0

C  *** ERROR => PREPARE C_0341 on connection 0, rc=259

[dbslsdb.cpp  9138]

C  SQLCODE    : 259

C  SQLERRTEXT : invalid table name:  Could not find table/view DOKTL in schema SAPECS: line 1 col 97 (at pos 96)

C  sc_p=7f28f48cfac8,no=341,idc_p=7f28f3f87388,con=0,act=0,slen=254,smax=256,#vars=5,stmt=7a45980,table=DOKTL

C  stmtid = <0/SAPMSYST                                /50334994/20140907170329>

C  SELECT "ID" , "OBJECT" , "LANGU" , "TYP" , "DOKVERSION" , "LINE" , "DOKFORMAT" , "DOKTEXT" FROM "DOK\

C  TL" WHERE "LANGU" = ? AND "ID" = ? AND "OBJECT" = ? AND "TYP" = ? AND "DOKVERSION" = ? ORDER BY "ID"\

C   , "OBJECT" , "LANGU" , "TYP" , "DOKVERSION" , "LINE" ;

B  ***LOG BZA=> table DOKTL does not exist on database R/3 [dbdbslst     3580]

M  ThPerformDeleteThisSession: switch of statistics

D  GuiStatus clear generate inline ts >20140908030105,195<

M  ***LOG R47=> ThResFreeSession, delete () [thxxmode.c   1078]

M  *** WARNING => ThrtGuiDeleteScreen: rscpGetUserLoginLang failed (128), use system language [thrtGuiHandl 469]

Thanks,

GR

[Reagan]

Try creating the missing tables in the database and see if that helps.

[Former Member]

Yes,i did that,  i have created table from studio and got in to SAP. SAP Help F1 texts are missing after upgrade. I think that is due to DOKTL.. i am still checking

[Former Member]

FYIpl

Another run of migration went well with out any table issues. We had issues with uptime creation last time I guess.