OutputDataConversionError in Stream Analytics

Question

Hi all

I'm running an export job out of IOTCentral for measurements data and that is going into an Event Hub. I'm then using Stream Analytics to move the data into an Azure SQL table. Trouble is, i'm getting the following error when i start the job:

Source table_name had 1 occurrences of kind
'OutputDataConversionError. TypeConversionError' between processing times '2020-10-30T21:13:34.5845011Z' and '2020-10-30T21:13:34.5845011Z'.

1 record gets loaded and then stops.

It was originally a datetime data type so i changed it to datetime2 (and other dattime data types) and still have the problem. If i changed to a nvarchar() data type, it works. The table & columns were generated by the Stream Analytics job.

Other export / import jobs work fine, it's just this one that i'm having trouble with.

Any help / suggestions are greatly appreciated :-)

Cheers

Answer 1

Hi @John Clifford ,

Welcome to Microsoft Q&A Platform. Thanks for posting the query.

I looked at the previous issues reported from Customers on the same and please find below observations.

• Error message is misleading and does not convey the accurate details and it always need not be with the date column as well. Please enable the Diagnostics log to look at detailed error. This document has the detailed instructions.
• I would recommend to upvote the idea in feedback forum to improve the error messages. The ideas submitted in the feedback forum are closely monitored by the product team and will be implemented in future releases.

Hope this helps! Please let us know if these details does not help to resolve the error and we will be glad to assist further.

Reference: outputdataconversionerror-typeconversionerror-writing-to-azure-sql-db-using-stre

--------------------------------------------------------------------------

• Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
• Want a reminder to come back and check responses? Here is how to subscribe to a notification.