Skip to Content

SAP HANA Express Edition load data failed

Nov 07, 2017 at 12:59 AM


avatar image


Hello Community!

I am a student and currently I work on a project, where we are using SAP HANA Express Edtion. Unfornatly we can't load CSV data from an open Source. We get this Error (see the image.fehler)

Can somnebody tell me what we are doing wrong?

fehler.jpg (166.3 kB)
10 |10000 characters needed characters left characters exceeded

Alright, we're back in the times where taking a screenshot literally means to photograph the screen.. oh my!

You can see the error message on the screen, so why don't you search for answers with this error message and the action (import...) you like to perform? Please try and work out the problem yourself and explain where you got stuck when posting a question.

For this specific problem, it should be possible to find possible explanations for why the error message occurs by going through the operations that need to be done in order to import a file into HANA.

An important step in solving problems also is to consult the HANA documentation (it's built into your HANA studio... press F1. Alternatively check

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

2 Answers

Michael Healy
Nov 07, 2017 at 12:21 PM

As Lars has explained, part of using different tech is troubleshooting. Whilst its important to learn how to use a certain piece of software, you must also learn how to search and troubleshoot will safe you an immense amount of time :).

I looked at the screen shot (an actual time use a screen grab, snipping tool, etc ;)) and its very clear that you're missing some privileges ie: the user you are using on the Express edition is missing some authorizations to carry out the task.

So here how you tackle it:

1: Google it :) - a quick search of the error itself with certain other key words (HANA, insufficient, etc) should bring you to the below recommended resources which will guide you in a) Troubleshooting authorizations with HANA b) Educate further on how it works so you will know know in the future when you begin to do more complex stuff.

a) How to troubleshooting HANA Authorization errors/issues

b) HANA Security Guide

To sum up, your missing the IMPORT privilege for your user.

10 |10000 characters needed characters left characters exceeded
Pratik Doshi Nov 07, 2017 at 11:32 AM

Hello ,

Please do check you have the insert privileges on the table.

10 |10000 characters needed characters left characters exceeded