Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
RTC Object Listener Issue
Mauddib
Member Posts: 269
Hi all.
So I read the great post on trouble shooting the Object Listener on this blog post here.
In it the writer says "A slightly cryptic message was recorded in the SQL Server Log every time an object was changed in Object Designer." but does not say what this message was.
My Problem:
Similar to many others, I have the issue with changes made in Object designer not reaching the client users, unless the service tier is restarted. But with two strange quirks:
1) My users are connecting through 5 different service tiers to which they have been assigned randomly. 4 out of 5 of these see the change, while a 5th will not.
2) Which one that 5th is appears random, so it is not that the issue lies with one of the services.
3) It does not happen all the time. 99% of the time it is fine. Then suddenly one change will not reach one service, and all users connected to that service, until it is restarted.
The only "cryptic" message I see in my SQL Server logs has appeared 5 times in the course of this year, and I have not the data to say it lines up with my problem time wise. But the error is:
10/22/2014 13:52:33,spid16s,Unbekannt,The query notification dialog on conversation handle '{81D9E9E1-5759-E411-977F-001B783A139E}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="schemas.microsoft.com/.../Code><Description>Cannot find the remote service 'SqlQueryNotificationService-58e997b0-e6d9-41bb-b4ab-d4d755fb836b' because it does not exist.</Description></Error>'.
Is this connected? Or can anyone else suggest (aside from simply switch to polling) what the causes or solutions to this might be?
So I read the great post on trouble shooting the Object Listener on this blog post here.
In it the writer says "A slightly cryptic message was recorded in the SQL Server Log every time an object was changed in Object Designer." but does not say what this message was.
My Problem:
Similar to many others, I have the issue with changes made in Object designer not reaching the client users, unless the service tier is restarted. But with two strange quirks:
1) My users are connecting through 5 different service tiers to which they have been assigned randomly. 4 out of 5 of these see the change, while a 5th will not.
2) Which one that 5th is appears random, so it is not that the issue lies with one of the services.
3) It does not happen all the time. 99% of the time it is fine. Then suddenly one change will not reach one service, and all users connected to that service, until it is restarted.
The only "cryptic" message I see in my SQL Server logs has appeared 5 times in the course of this year, and I have not the data to say it lines up with my problem time wise. But the error is:
10/22/2014 13:52:33,spid16s,Unbekannt,The query notification dialog on conversation handle '{81D9E9E1-5759-E411-977F-001B783A139E}.' closed due to the following error: '<?xml version="1.0"?><Error xmlns="schemas.microsoft.com/.../Code><Description>Cannot find the remote service 'SqlQueryNotificationService-58e997b0-e6d9-41bb-b4ab-d4d755fb836b' because it does not exist.</Description></Error>'.
Is this connected? Or can anyone else suggest (aside from simply switch to polling) what the causes or solutions to this might be?
0