How to fix Failed to check for changes in table 'TableName' due to exception: Microsoft.Data.SqlClient.SqlException

Kalyan Babu Basa 20 Reputation points
2025-03-12T12:40:32.9+00:00

We have enabled Change tracking on a table (say Table_A) and built Azure SQL Trigger function to track changes.

Few days later, we have added a new column (say Column_A) to the Table_A and re-deployed the Azure SQL Trigger function app.

This working for while with no issues for few days. After few days later, we receiving the below error

Failed to check for changes in table 'dbo.Table_A' due to exception: Microsoft.Data.SqlClient.SqlException. Exception message: Invalid column name 'Column_A'

To resolve this, we had to Disable change tracking, Drop GlobalState and Lease Table created in az_func schema, enable change tracking on the table and deploy the azure SQL Trigger function app.

Please help to identify what is causing the issue in the first place.

Thanks for help in advance.

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
5,531 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.