Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hello !
I am new using Dataiku and try to upload some nice dataset on my local computer.
With small files, I have no issue,
but I try with a 50M file and I get this error
com.dataiku.common.server.APIError.APIErrorException : NumberFormatException: empty String
See screen
I tried to put
[javaopts]
backend.xmx = 6g
in install.ini but does not solve ths issue.
Any idea ?
Thanks !
Hi,
Can you confirm you get the exact same error with and without the "Preserve numbers formatting" option?
I understand you cannot share the data itself. Maybe can you share a screenshot of the preview screen?
If that does not work, you may want to convert the file to another format such as CSV.
Cheers,
Alex
Hi,
Could you please attach a diagnostic of the DSS instance (Administration > Maintenance > Diagnostic tool) and send us the resulting file?
If the resulting file is too large for the community website (> 19 MB), you can use https://dl.dataiku.com to send it to us. Please don't forget to send the link that is generated when you upload the file.
Hi Alexis,
Thanks for sending this. We can isolate the problem to this particular Excel file. Could you please refresh the dataset preview, playing with the "Preserve numbers formatting" option?
Once you have a valid preview, you can retry the "Count of records" metric computation. If that does not work, we may need:
- a screenshot of the Format/preview page
- a full copy or sample of the Excel file for us to test
Hope it helps,
Alex
hello,
I got the same error.
I cant provide you with the Excel file as it is a customer file.
However,
everything is fine if I test an extraction of the file,
but the whole file (50M), I get the error.
Do you have an idea ? size of the file vs my laptop config or instance config ?
Regards
Hi,
Can you confirm you get the exact same error with and without the "Preserve numbers formatting" option?
I understand you cannot share the data itself. Maybe can you share a screenshot of the preview screen?
If that does not work, you may want to convert the file to another format such as CSV.
Cheers,
Alex
ok, it works as CSV.
thanks