Avoid warnings on Azure stream anayltics outputs when the same data is injected to all outputs.

Question

Currently I have the below situation
There are 5 inputs(A,B,C,D,E) for the same eventhub with 5 different consumer groups.
There are 5 outputs(M,N,O,P,Q) to SQL database having 5 different tables.

There are 5 queries written in the job that selects the fields from one input to one output like A->M, B->N .....
But when a event occurs into the eventhub say 'x' which belongs to output 'M', then the event gets processed correctly ,but there is a warning on the other 4 outputs saying "TypeConversion error".

So, how could we avoid these warnings?

Note : I'm not using any partitions

Answer 1

Hello @VikasRajareddy-9365 ,

Thanks for the question and using MS Q&A platform.

You will experience the OutputDataConversionError.TypeConversionError - when a column can't be converted to a valid type in the output. For example, the value of column is incompatible with constraints or type defined in SQL table.

To avoid this warning, make sure to the value of the columns should contain compatible with constraints or type defined in SQL Table.

For more details, refer to Azure Stream Analytics data errors - OutputDataConversionError.TypeConversionError.

Hope this will help. Please let us know if any further queries.

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

• Please don't forget to click on or upvote button whenever the information provided helps you. 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
• If you are interested in joining the VM program and help shape the future of Q&A: Here is jhow you can be part of Q&A Volunteer Moderators