.NET Core display database change notification using signalR not working

186 Views Asked by At

By following display database change notification using signalR

Everything works well in updating the UI in realtime, but then shows an error on every DML in the database like:

UPDATE Jobs 
SET [Status] = 1,
    [Result] = '' 
WHERE [CertificateId] = 4108890 

Msg 592, Level 16, State 1, Procedure tr_dbo_Jobs_78e1a4fd-604c-464f-87ec-341a981ede5c_Sender, Line 44 [Batch Start Line 3]
Cannot find object ID 1637580872 in database ID 8

After investigation, I found it creates a stored procedure

[dbo].[dbo_Jobs_78e1a4fd-604c-464f-87ec-341a981ede5c_QueueActivationSender]

Note: there is no reference to 1637580872 in the stored procedure created

0

There are 0 best solutions below