Unable to Import Schema

[vinolan94]

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

[mynynachau · Accepted solution]

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-sc...

Regards, Mynyna

[BenedictV · Accepted solution]

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 🙂

[former_member184713]

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.

[former_member183326]

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.