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]

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();

[ItsKhuramShahzad]

Ok Thank you so much for reply, i have resolved this by just deleting trigger of each table and as well as Database trigger for those tables

…

On Thu, Oct 22, 2020 at 5:03 PM vesna111 ***@***.***> wrote: I have the same problem. For some reason previous triggers were not deleted and they are causing this error. You can solve it by deleting those triggers, but it is just temporary solution. — You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub <#214 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AJAEULYQU6I7727EJMCR72LSMANRRANCNFSM4SLBTFSQ> .

--