Skip to Content

Unable to Import Schema

Hi All,

I am trying to restore schema backups on the HANA Studio, and I am running into an error. I urgently need to restore a customer's schema for testing and I am unable to resolve the error code below:

Could not execute 'import "DRUMRODE"."*" from '/hana/shared/NDB/HDB00/Drumrode/2405/' with replace threads 10'

SAP DBTech JDBC: [2048]: column store error: table import failed; [0] No error

Any thoughts and suggestions.

Kind regards,

Vinolan Pillay

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 02, 2017 at 01:39 PM

    Hi, I have seen, that a similar issue occured here:

    https://archive.sap.com/discussions/thread/3550813

    Please check it out and see if the answers within help you.

    I also found this documentation, which might help you solve your issue, please have a look:

    https://blogs.sap.com/2016/12/14/all-you-need-to-know-about-sap-business-one-version-for-sap-hana-schema-export-and-import/

    Regards, Mynyna

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Mynyna,

      It is not nice to just share links, which the OP can themselves find if they search. It would be better if you can add to the information with your knowledge. And it is against community rules too :)

  • avatar image
    Former Member
    Jun 06, 2017 at 06:43 PM

    schema import/export is complex. it has a lot of rules that you need to know of. those rules below might help you, but it's just a part of the rules that you need to follow to have a working export/import without issue

    1. archive schema file on the linux server side. you can't archive the files by using samba/windows share through you windows. this is probably related to posix attributes lost, there is a sap note about this

    2. don't "with replace" except if you know what you are doing. for more that 4 years not sap has used the work "ignore existing". using with replace will replace the content of the SBO-COMMON that was exported at the same time as your b1 schema

    3. check the file system permission after you extract the archive on your destination server.

    4. always do a backup before importing, because that import may corrupt you bd even if it fail, like with the replace keyword.

    5. always delete a failed schema before trying to reimport

    there are others, but these are the one on top of my mind.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 08, 2017 at 07:04 PM

    That's an out of memory. When posting here please provide more information from log files ie: Indexserver trace file. We could help more if the error was more descriptive.

    Add comment
    10|10000 characters needed characters exceeded