Skip to Content
-2

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

Apr 18, 2017 at 02:49 PM

1.8k

avatar image

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

10 |10000 characters needed characters left characters exceeded

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

1
* Please Login or Register to Answer, Follow or Comment.

4 Answers

avatar image
Former Member Apr 25, 2017 at 11:13 AM
1

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 29, 2017 at 05:34 PM
-1

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

Thank you

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Anthony,

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

regards.,

0
avatar image
Former Member Sep 04, 2017 at 09:47 AM
0

Hi Former Member

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.


screenshot-4.png (11.8 kB)
Show 4 Share
10 |10000 characters needed characters left characters exceeded

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

0
Former Member

hi,

this one only right?

it was already allowed but still im getting same thing.

thanks

sai kumar

0
Former Member

Hi @manuel_marhold

this one only right?

it was already allowed but still im getting same thing.

thanks

sai kumar

0

Hi Former Member,

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

0
avatar image
Former Member
Mar 29 at 12:08 PM
0

Run the following command to make it writable.

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

Share
10 |10000 characters needed characters left characters exceeded