Skip to content

Files

Latest commit

v-thepetv-thepet
one more
May 25, 2022
8540f64 · May 25, 2022

History

History
80 lines (48 loc) · 2.88 KB

data-error-codes.md

File metadata and controls

80 lines (48 loc) · 2.88 KB
title description ms.author author ms.topic ms.date ms.service ms.custom
Data error codes - Azure Stream Analytics
Troubleshoot Azure Stream Analytics issues with data error codes, which occur when there's bad data in the stream.
sidram
sidramadoss
troubleshooting
05/25/2022
stream-analytics
kr2b-contr-experiment

Azure Stream Analytics data error codes

You can use activity logs and resource logs to help debug unexpected behaviors from your Azure Stream Analytics job. This article lists the description for every data error code. Data errors occur when there's bad data in the stream, such as an unexpected record schema.

InputDeserializationError

  • Cause: There was an error while deserializing input data.

InputEventTimestampNotFound

  • Cause: Stream Analytics is unable to get a timestamp for a resource.

InputEventTimestampByOverValueNotFound

  • Cause: Stream Analytics is unable to get the value of TIMESTAMP BY OVER COLUMN.

InputEventLateBeyondThreshold

  • Cause: An input event was sent later than configured tolerance.

InputEventEarlyBeyondThreshold

  • Cause: An input event arrival time is earlier than the input event application timestamp threshold.

AzureFunctionMessageSizeExceeded

  • Cause: The message output to Azure Functions exceeds the size limit.

EventHubOutputRecordExceedsSizeLimit

  • Cause: An output record exceeds the maximum size limit when writing to Azure Event Hubs.

CosmosDBOutputInvalidId

  • Cause: The value or the type of a particular column is invalid.
  • Recommendation: Provide unique non-empty strings that are no longer than 255 characters.

CosmosDBOutputInvalidIdCharacter

  • Cause: The output record's Document ID contains an invalid character.

CosmosDBOutputMissingId

  • Cause: The output record doesn't contain the column [id] to use as the primary key property.

CosmosDBOutputMissingIdColumn

  • Cause: The output record doesn't contain the Document ID property.
  • Recommendation: Ensure the query output contains the column with a unique non-empty string of no more than 255 characters.

CosmosDBOutputMissingPartitionKey

  • Cause: The output record is missing a column to use as the partition key property.

CosmosDBOutputSingleRecordTooLarge

  • Cause: A single record write to Azure Cosmos DB is too large.

SQLDatabaseOutputDataError

  • Cause: Stream Analytics can't write event(s) to Azure SQL Database due to issues in the data.

Next steps