Skip to Content

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

HANA IMPORT error after REPLACE SCHEMA

Hello,

I have used IMPORT "SBODB1"."*" .... REPLACE SCHEMA SBODB2.

Then I deleted SBODB1. Everything worked fine.

Two month later, I tried to update from SBO 9.1 PL03 to PL04. The update failed.

I tried to restore the database manually with

IMPORT "SBODB2"."*" AS BINARY FROM '/usr/sap/NDB/HDB00/backup/data' and I get an error

SAP DBTech JDBC: [2048]: column store error: table import failed:  [30151] Object not found in the import directory;object=SBODB1:ETL_Sen

The error is pointing to the old SCHEMA.

I searched in the export folders and found several finalize.sql and saved_configuration.cfg using the schema name SBODB1.

For example creating trigger to ODIM to the old SCHEMA.

[I tried to rename in the export folder all old SCHEMA to the new SCHEMA, only got another error message

SAP DBTech JDBC: [2048]: column store error: table import failed:  [30151] Object not found in the import directory;object=SBODB2:OOCR_trackingen]

Now, I am not able to use the database in PL4. No restore. A new update failes, because the database in in an in the middle status.

I tried also to restore on another HANA box. Same. I created in SBO a new schema SBODB1 in hope, but this does not help either.

[all with HANA V74.3]

Thank you

Regards

Ingo Neufert

Tags:
Former Member

Helpful Answer

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