Changes don't appear in Nav RTC with query notification

PureHeart
PureHeart Member Posts: 190
edited 2009-02-06 in NAV Three Tier
Hi guys I've opened a new post continuing this one viewtopic.php?f=32&t=31338
that has been marked as solved...
My problem is that i cannot see the changes applyed to object without restarting the NAV server if I have enabled the query notification...
I can see this error message in the event application log:

"An exception occurred while enqueueing a message in the target queue. Error: 15404, State: 19. Could not obtain information about Windows NT group/user 'NT AUTHORITY\NETWORK SERVICE', error code 0x54b."

but I don't really know how to fix it!!!! :(:(
Help please!!!
p.s.
I'm testing this feature even If I don't know what it really changes enabling query notification anyone could explain?

THANKS
Why don't you try my compare tool?
http://www.mibuso.com/dlinfo.asp?FileID=1123

Comments

  • kine
    kine Member Posts: 12,562
    Ad the query notification: se e.g. this: http://www.simple-talk.com/sql/sql-serv ... ification/
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • PureHeart
    PureHeart Member Posts: 190
    edited 2009-02-05
    Thanks Kine!
    I'm going to read that all now!
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • kine
    kine Member Posts: 12,562
    PureHeart wrote:
    Thanks Kine!
    I'm going to read that all now!
    p.s.
    on another matter your NAV 2009 Management application is very nice but on my machine crash as soon as I open it?do you want the error message?

    Try to download the newer version from my blog...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • PureHeart
    PureHeart Member Posts: 190
    Ok I've read it all but I can't see what I am missing... this is the result querying exec sp_helprotect NULL, [NT AUTHORITY\NETWORK SERVICE] on my db...

    dbo Object Tracking NT AUTHORITY\NETWORK SERVICE dbo Grant Select (All+New)
    dbo QueryNotificationErrorsQueue NT AUTHORITY\NETWORK SERVICE dbo Grant RECEIVE .
    . . NT AUTHORITY\NETWORK SERVICE dbo Grant CONNECT .
    . . NT AUTHORITY\NETWORK SERVICE dbo Grant Create Procedure .
    . . NT AUTHORITY\NETWORK SERVICE dbo Grant CREATE QUEUE .
    . . NT AUTHORITY\NETWORK SERVICE dbo Grant CREATE SERVICE .
    . . NT AUTHORITY\NETWORK SERVICE dbo Grant SUBSCRIBE QUERY NOTIFICATIONS .
    . . NT AUTHORITY\NETWORK SERVICE dbo Grant VIEW DEFINITION .

    Everything that should be there is there...Any Idea of what is missing? Does it matter that I am using SQL 2008 Express?
    I'm keeing having this error on the event log:

    The activated proc '[$ndo$navlistener].[SqlQueryNotificationStoredProcedure-cf0a3d07-3039-4421-a494-4308418de5e9]' running on queue 'Demo Nav 2009.$ndo$navlistener.SqlQueryNotificationService-cf0a3d07-3039-4421-a494-4308418de5e9' output the following: 'Could not obtain information about Windows NT group/user 'NT AUTHORITY\NETWORK SERVICE', error code 0x54b.'

    Thanks
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • PureHeart
    PureHeart Member Posts: 190
    Could it be that if the NAV server service uses as logon [NT AUTHORITY\NETWORK SERVICE] then you can't use the query notifications?
    Can someone please help?
    I'm running SQL 2008 Express as LocalSystem and my pc is part of a domain....does that matter?

    THANKS ](*,)
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • dmccrae
    dmccrae Member, Microsoft Employee Posts: 144
    Query Notifications will work with the NAV Server using NETWORK SERVICE so that is not the issue.

    Have you tried changing the account of your SQL Express service to something other than LocalSystem? Perhaps NETWORK SERVICE or a domain account. The error does not indicate a missing SQL permission but the inability to lookup the NETWORK SERVICE account for that machine.

    Are you running the NAV Server and SQL Server on the same machine?
    Dean McCrae - Senior Software Developer, NAV Server & Tools

    This posting is provided "AS IS" with no warranties, and confers no rights.
  • PureHeart
    PureHeart Member Posts: 190
    dmccrae wrote:
    Query Notifications will work with the NAV Server using NETWORK SERVICE so that is not the issue.

    Have you tried changing the account of your SQL Express service to something other than LocalSystem? Perhaps NETWORK SERVICE or a domain account. The error does not indicate a missing SQL permission but the inability to lookup the NETWORK SERVICE account for that machine.

    Are you running the NAV Server and SQL Server on the same machine?
    Same machine, Yes I understand that and I had already tried to change the SQL logon to the network service and also I've tried using my domain account!
    but nothing has changed.... any help? :(
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123
  • PureHeart
    PureHeart Member Posts: 190
    If I try to run this Query:

    EXECUTE AS USER = 'NT AUTHORITY\NETWORK SERVICE'

    I get the same error.... Any Ideas?
    Am I the only one with this Problem????
    Why don't you try my compare tool?
    http://www.mibuso.com/dlinfo.asp?FileID=1123

Categories