The conversation handle "1FBDE14B-0A07-EB11-B81C-3CECEF20BFDC" is not found. An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.
ItsKhuramShahzad opened this issue · 1 comments
I have used SQL Service broker and SQL Table Dependency and started SQL table dependency in a table for notifications on table data change. I have given all the permission to the database listed in the SQL table Dependency document. After some time, maybe in idle state, it is giving status as "Waiting for notification.
I am getting this error.
When I change in the table (inserting new record), status is not changing (From waiting for notification) and gives error as
ErrorSystem.Data.SqlClient.SqlException (0x80131904): The conversation handle "1FBDE14B-0A07-EB11-B81C-3CECEF20BFDC" is not found.
An error was raised during trigger execution. The batch has been aborted and the user transaction, if any, has been rolled back.
Here is my Code:
_sqlTableDependencyOrders = new SqlTableDependency(DBConnection.GetOnlineConnectionString(), "Order");
_sqlTableDependencyOrders.OnChanged += OnDatabaseEventChanged;
_sqlTableDependencyOrders.Start();