on 06-08-2015 12:27 PM
Hello,
i´m trying to import a table into HANA studio but get "Completed with errors" message afterwards and can´t see any data except for the header.
Here´s what i´m doing. Sorry in advance .. i´m a beginner...
1. In ERP I open transaction SE16n and choose table IFLOT.
2. I choose export and then I tried local file or excel. Tried different encoding and so on.
3. In HANA Studio I go to File->Import-> SAP HANA Content -> Data from Local File.
4. I select the file, set the limiter and so on - see screenshot
5. Now I map the rows and press next.
6. Then the following error appears. Also I see the header meta data but no content.
Please help!
You seem to hit a number conversion error.
Show us the column type mapping you made - maybe this gives a hint on why the "EH" text should be interpreted as a number.
- Lars
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lars!
Thank you for your hint. I already found the error in the meantime. But there seem to be more errors like that in the table data... Is there a data type when mapping which allows every kind of input data? I tried NVCHAR and VARCHAR but this doesnt seem to help
EDIT: Nevermind. I have to correct the errors bit by bit 😕
Thanks again.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.