cancel
Showing results for 
Search instead for 
Did you mean: 

Hana Import failed invalid table name: Could not find table/view DB_STATE in schema

DieterLorenz
Active Participant
0 Kudos

Hello everybody,

migrate SAP ERP 6 EHP 7 from MaxDB/Windows to HANA.

R3load is the same than the export.

Export works fine but Import is a problem:

E:\usr\sap\HTD\SYS\exe\uc\NTAMD64\R3load.exe -i SAPAPPL1_2_1.cmd -dbcodepage 4103 -k XXXXXXXXXXXXXXXXXXXXXX -l SAPAPPL1_2_1.log -c 100000 -loadprocedure dbsl -rowstorelist C:\Program Files\sapinst_instdir\BS2013SR1\ERP607SR1\HDB\COPY\SYSTEM\STD\AS-ABAP\rowstorelist.txt

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

patchinfo (patches.h): (0.017) R3load conversion of REPOTEXT (note 1925533)

DBSL patchinfo (patches.h): (0.022) Get database version via dbsl call (note 1976918)

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

process id 4728

(DB) INFO: connected to DB

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

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

ERROR : Prepare/Read for get Log Writing failed(dbrc=103).

  (SQL error 259)

  error message returned by DbSl:

invalid table name:  Could not find table/view DB_STATE in schema SAPHTD: line 1 col 22 (at pos 21)

E:\usr\sap\HTD\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)

Please help !

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member182302
Active Contributor
0 Kudos

Is the table DB_STATE is present in SAPHTD schema did you check?

Regards,

Krishna Tangudu

DieterLorenz
Active Participant
0 Kudos

No, I check this:

Could not execute 'select * from "SAPHTD"."DB_STATE"' in 3 ms 177 µs .

SAP DBTech JDBC: [259] (at 23): invalid table name:  Could not find table/view DB_STATE in schema SAPHTD: line 1 col 24 (at pos 23)

How can I create this table ?

former_member182302
Active Contributor
0 Kudos

You can check the DDL corresponding to it, and execute the DDL from HANA studio.

Regards,

Krishna Tangudu

DieterLorenz
Active Participant
0 Kudos

In another HANA System there is no DB_STATE table ! The are 3 Tables with DB_STATE colum name.

And there is no .STR file which contains DB_STATE as a table - very strange !