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

[danny_heynssens]

I try to import a schema from one system to another and I get following error:

Could not execute 'import "SAP920HVD"."*" as binary from '/usr/sap/NDB/HDB00/work' with replace' in 222 ms 365 µs .
SAP DBTech JDBC: [2048]: column store error: table import failed: [0] No error

[pfefferf]

Just with that provided information no real answer is possible. Did you check the server logs for more information?

[Former Member]

Try making your "Index" and "Export" files writable. That may solve this issue.

[former_member251984]

Run the following command to make it writable.

# chmod -R 777 <the directory contains export and index>

[Former Member]

hi, I have the same issue, did someone solve this problem ?

Thank you

[Former Member]

Hi Anthony,

This is a folder permission issue. Just give the folder the write permission and it will restore the schema.

regards.,

[TuongHoang]

Issued, i changed chmod -R 777

[former_member490610]

Hi sowmisowmi

I'm also getting same error (SAP DBTech JDBC: [2048]: column store error: table import failed: [0] No error)

how can i make "Index" and "Export" files writable.

screenshot-4.png

can you please guide me with it.

Thank you,

sai kumar.

[manuel_marhold]

Hi @sai_kumar,

in Linux you have to change the permissions of the files.

I have done it this way in UI: right click on the backup-folder -> properties. in tab permissions set "File access" to "Read and write" in all three cases and press the button "Apply Permissions to Enclosed Files".

I am sure there is also a way via terminal with command "chmod"...

I don't know if the permissions are need in all three caeses (owner, group and others), but that worked for me on a testsystem.I now get different errors, but that seem to be realted to HANA permissions.

Hope this helps,

Manuel Marhold

[former_member490610]

hi,

this one only right?

it was already allowed but still im getting same thing.

thanks

sai kumar

[former_member490610]

Hi manuel_marhold

this one only right?

it was already allowed but still im getting same thing.

thanks

sai kumar

[manuel_marhold]

Hi sai_kumar,

it ssems like you are using windows to change the permissions. I don't know if that works, but the permission itself seems correct. I used the UI in linux to change it.

I hope this helps,

Manuel Marhold