Failed to Locate a Column at Position x in the Output Event

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. I've switched on the error tracking in the Stream Analytics log and I'm getting the following error when i start the job:

Failed to locate column 'xxx' at position 4 in the output event

1 record gets loaded and then stops.

The table & columns were generated by the Stream Analytics job from the Azure SQL database. I've looked at the data in the Event Hub and the column is there.

Any help / suggestions are greatly appreciated :-)

Cheers

Answer 1

Hello @John Clifford ,

Thanks for the ask and also for using the forum .

If i were you I coud have tried the following .

1. Try to add a subset of the columns in the columns list , that way i will know which column is the one which is creating the issue .
2. I could also test the output to something else say BLOB , the reason being SQL is a structured there is some issue while the inserttion , if changing the output helps we can be sure that there is something wrong with the data being writtem to SQL ( as you have one row which was written )

Please let me know as to how it goes .

Thanks
Himanshu