Hello -
I am getting an error when importing into SPICE for a dataset and the import is failing because there are over 10,000 rows leading to a data tolerance exception. Most of the errors that I am getting are “UNDEFINED” and so there is not really any detail as to what I need to fix in order to get the records to import correctly. I review the documentation on error codes, but there isn’t really anything in there on how to troubleshoot the error. What I noticed is that most of the failed records are related to columns that are null. They are not typed “NULL”, they are true null values for the record. Also, all of the fields that are failing are datetime or timestamp data types. One thing I already tried was casting the data types to be more explicit, but that didn’t help. Is there anything that I should consider trying to get these records to import correctly?
Hi @dannyr-08,
It sounds like it may be recognizing your null values as an empty string so it will not accept.
What if you tried adding this to the SQL:
case when datefield = '' then NULL else datefield end as date
If you continue to have issues and the above does not help resolve, I would suggest creating a support ticket for more account specific assistance!
I tried that and it gives me an error saying invalid syntax for datetime = “”. I will submit a support ticket, thanks!
1 Like
Hi @dannyr-08
Thanks for confirming. Since there is no pending actions, I will proceed to close/archive this topic.
1 Like