SAP HANA EXPORT/IMPORT PROBLEM

[former_member230865]

Hi Experts,

Need help re export/import schema in SAP HANA.

I was able to export the schema by using this script

export "DBNAME"."*"  as binary INTO '/BACKUPLOCATION''

but when I was trying to restore it error occurred

IMPORT "DBNAME"."*" AS BINARY FROM '/BACKUPLOCATION/' WITH REPLACE THREADS 10 RENAME SCHEMA "DBNAME" TO "NEWDBNAME"

Could not execute 'IMPORT "DBNAME"."*" AS BINARY FROM '/BACKUPLOCATION' WITH REPLACE THREADS 10 RENAME ...' in 769 ms 48 µs .

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

TIA.

Norman

[duncanspeidel]

Below is a list of notes related to import functionality

https://service.sap.com/sap/support/notes/1981315 - HANA import fails with error "not found in the import directory"

https://service.sap.com/sap/support/notes/1951219 - Cannot import schema into SAP HANA due to OGAR_TMP table not found

https://service.sap.com/sap/support/notes/1944485 - Cannot import schema into SAP HANA if data staging is enabled

https://service.sap.com/sap/support/notes/1854130 - Cannot find company DB in the company list after importing a schema backup to SAP HANA if B1A solution is installed on original HANA server but not on new HANA server

https://service.sap.com/sap/support/notes/2134959 - Schema Export and Import Guide for SAP Business One, version for SAP HANA

https://service.sap.com/sap/support/notes/2122157 - SAP HANA_Import fails due to missing table/view PAL_TRIPLE_SMOOTH_ORIGINAL_INPUT

Best regards,

Duncan

[Private_Member_145664]

Hi,

please check note http://scn.sap.com/thread/3680438

This will drop the trigger first.

Regards

Ingo

[Former Member]

What note? You reply with the url of this very discussion

Thank you

[former_member184146]

Hi,

     Use the below command

import <Schema>.”*” as binary from ‘<backup_folder>’ with replace;

from the error it seems like the backup folder path is not correct , make sure your Backup folder path is correct.

Regards,

Manish

[kothandaraman_nagarajan]

Hi,

Please refer point 2.2, SAP note 2083727 - SAP Business One, version for SAP HANA Best
Practices

Thanks & Regards,

Nagarajan