Last post Mar 31, 2015 04:13 PM by kmcnet
Feb 19, 2015 01:08 PM|kmcnet|LINK
Hello everyone and thanks for your help in advance. I am developing a SignalR application utilizing SQL Notification. The application is in test deployment and works approximately 90% of the time. However, occasionally, clients will not update, then after
another database update, will being functioning properly. All clients are using Windows 8.1 with IE 11. Failed request logs show multiple 101 response codes taking approximately 4 seconds. I'm not really sure where to start looking. Any help would be appreciated.
Feb 22, 2015 06:29 AM|Kevin Shen - MSFT|LINK
Thanks for your post here.
It is hard for us to reproduce your issue ,since it happens occasionally.
I suggest that you should check if you have done some action before the sporadic update issue.
Feb 23, 2015 02:36 PM|kmcnet|LINK
Mar 27, 2015 06:10 PM|Ruchira|LINK
I am developing a SignalR application utilizing SQL Notification.
So you should be using SqlDependency? If that's the case, it's a known fact that SqlDependency is not that reliable (Not trigger out the database changes sometimes). Usually I would have a timer job running in the background to pick up the updates incase
SqlDependency misses any.
Please 'Mark as Answer' if this post helps you
Mar 27, 2015 09:17 PM|kmcnet|LINK
Thanks for the response. Got an example?
Mar 27, 2015 09:31 PM|Ruchira|LINK
Got an example?
Sorry, I don't.
jQuery AJAX to send a request to the server. Depending on how critical the updates are, you can decide the interval value. Call a server side method from AJAX, which respectively checks for the updates in database.
Mar 28, 2015 11:15 PM|kmcnet|LINK
Thanks again. I really hadn't heard about SQL Notifications not being reliable. Could the 101 response have anything to do with the drops?
Mar 28, 2015 11:22 PM|Ruchira|LINK
Could the 101 response have anything to do with the drops?
I don't think so.
Mar 31, 2015 04:13 PM|kmcnet|LINK
Thanks for the response. I appreciate it.