Skip to Content
0

SAP B1, version for HANA, restoring schema from backup with rename fails

Nov 29, 2016 at 09:00 AM

178

avatar image

Greetings,

We are trying to import a backup with schema rename and it fails.

The export command is:

export "DB1"."*" as binary into '/bc/DB1'

The import command we're using is:

import "DB1"."*" as binary from '/bc/DB1' WITH NO DEPENDENCIES REPLACE RENAME SCHEMA DB1 TO DB2

The following error occurs:

* 2048: column store error: table import failed: [30111] Import failed (could not execute create statement);object=UNI_TEST:B1_SnBOpenQtyViewen,invalid table name: Could not find table/view B1_SnBOpenQtyInnerView in schema UNI_TEST: line 1 col 456 (at pos 455) at ptime/query/catalog/catalog.cc:5303 SQLSTATE: HY000

We have tried importing with dependencies, but yet another error occurs. It seems like objects are created in the wrong order. Locating B1_SnBOpenQtyInnerView view definition and creating it by hand in SAP HANA Studio succeeds.

Any pointers?

Thanks in advance,

Dmitry

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Dmitriy Shalkhakov Nov 30, 2016 at 10:12 AM
0

Update: I've contacted support and the problem has been resolved.

The correct command for restoring company database with SAP B1, SAP HANA version is:

IMPORT “SCHEMA_NAME”.“*” AS BINARY FROM ‘import_path’ WITH IGNORE EXISTING THREADS 10 RENAME SCHEMA “SCHEMA_NAME” TO “NEW_SCHEMA_NAME”;

HANA-related import and export commands are described in SAP note 2134959.

Regards,

Dmitry

Share
10 |10000 characters needed characters left characters exceeded