The conversation handle "1FBDE14B-0A07-EB11-B81C-3CECEF20BFDC" is not found

1

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<OrderTrigger>(DBConnection.GetOnlineConnectionString(), "Order");
            _sqlTableDependencyOrders.OnChanged += OnDatabaseEventChanged;
            _sqlTableDependencyOrders.Start();
c#
sql-server
sqldependency
asked on Stack Overflow Oct 10, 2020 by Khuram Shahzad • edited Oct 10, 2020 by Khuram Shahzad

0 Answers

Nobody has answered this question yet.


User contributions licensed under CC BY-SA 3.0