on 11-29-2016 9:00 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
110 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.