Skip to Content
avatar image
Former Member

SAP HANA EXPORT/IMPORT PROBLEM

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



Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 14, 2015 at 05:39 AM

    Hi,

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

    Thanks & Regards,

    Nagarajan

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 05:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 14, 2015 at 02:55 PM

    Hi,

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

    This will drop the trigger first.

    Regards

    Ingo

    Add comment
    10|10000 characters needed characters exceeded

  • May 07, 2015 at 03:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded