Forum Discussion
Solved
Conversion from number to string failed due to undersized character buffer
Starting yesterday afternoon, several of our datasets have failed to refresh with the below error. What is the reason for this error? Our datasets imports data from Databricks Spark Delta tables usin...
Thanks Anonymous! Now, it's working. Microsoft has now posted an awareness message to their support page about this:
Most likely the Double columns - I would cast those as Float in your view definition and retry the refresh.
Double-valued columns will have more precision (i.e. more significant digits) that overflow the character buffer when imported via the ODBC driver. Casting to Float reduces the number of digits and should prevent overflow.
Thanks a lot for the input gah113 . I changed all Double columns to Float, and so far the load has succeeded, so this might very well be the thing that did the trick. My total data volumes are still a bit smaller than before, so hopefully it will continue working, but so far it is looking good.