none
WCF-SQL Notification Service RRS feed

  • Question

  • Hi

    I'm having some issue with Notification capability of WCF-SQL adapter.

     

    I'm using SELECT statement to get the changed/update records inside the orchestration.  My orchestration is called and i'm getting Notification message(info,select and type) but when orchestration query the table it's show below error

    The query notification dialog on conversation handle '{07C4175E-CF06-E111-B490-0030482C1269}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8490</Code><Description>Cannot find the remote service &apos;SqlQueryNotificationService-a66d6e8f-3cbc-43eb-9b9e-5e575f3cb531&apos; because it does not exist.</Description></Error>'.

    I have created Queue and notification service in SQL Server (2008 R2) with guid then when i stop and start the application i'm getting above error with different guid.  Is there way to set static GUId in the WCf-Customer Adapter bindings?

    Any thoughts what i'm doing wrong.

    Friday, November 4, 2011 10:31 AM

Answers