Share via

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

John Clifford 21 Reputation points
2020-11-02T13:11:27.533+00:00

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

Azure SQL Database
Azure IoT Central
Azure IoT Central
An Azure hosted internet of things (IoT) application platform.
354 questions
Azure Event Hubs
Azure Event Hubs
An Azure real-time data ingestion service.
568 questions
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
334 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,381 Reputation points Microsoft Employee
    2020-11-03T00:15:14.03+00:00

    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