Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ECC to HANA DB Migration, DMO error with invalid tables

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

Former Member
Not what you were looking for? View more on this topic or Ask a question