Last post Aug 13, 2014 03:14 PM by felickz
Jul 25, 2014 01:03 PM|pdagosta|LINK
I am receiving this error, "An unexpected SqlNotificationType was received. Details: Type=Change, Source=Data, Info=Update" periodically when Sending messages from outside of the Hub class.
Here is what I have tracked it down to:
SQL Server Message Bus
SQL Server 2008 (2008 (100) Compatibility) with Service Broker *enabled*
The error is raised as part of the Send but is actually generated during the "poll".
The SQL Notification is expecting an Insert but is receiving an Update.
I set up a test project to monitor SQL Notifications.
I used the "UPDATE ... OUTPUT ... INTO ..." to model signalr event generation.
My test project only received "Update" notifications even though the resulting action was an Insert.
I am perplexed that this has not occurred to anyone else before, so this may be something environmental that may just need to be documented as a requirement to make this configuration work.
Jul 25, 2014 05:14 PM|pdagosta|LINK
I am confident that this is a bug that was introduced on Mar 18 with this
commit. The send.sql used to use a temp table to perform Inserts into Messages_X, but now uses an Update Output Into clause.
This bug could be fixed by either
a) reverting this change and returning to an explicit Insert statement
b) changing ObservableDbOperations.cs at ~ line 258
if (e.Info == SqlNotificationInfo.Insert)
if (e.Info == SqlNotificationInfo.Update)
Aug 13, 2014 03:14 PM|felickz|LINK