RTC randomly fails to connect

bbrown

I set up a server, on our internal network, hosting several R2 service tiers. Each one is to give users RTC access to a different development database. users are randomly failing to connnect. They report that the RTC will just close. Sometimes with a message that the service is not running. The server's event log will have an entry like:

Service: MicrosoftDynamicsNavServer$NAV6
User: MYDOMAIN\THEUSER
Type: System.AccessViolationException
Message: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
StackTrace:
at Microsoft.Dynamics.Nav.Runtime.NativeMethods.AdapterOpenConnection(IntPtr databaseHandle, String serverName, NetProtocolType netType, String databaseName, Int32 clientConnectionType, DeadConnectionHandler deadConnectionHandler, String userTempDirectory, Printer[] printers, Int32 numberOfPrinters)
at Microsoft.Dynamics.Nav.Runtime.NavRuntimeAdapter.OpenConnection(IntPtr databaseHandle, NetProtocolType netType, String serverName, String databaseName, Int32 clientConnectionType, DeadConnectionHandler deadConnectionHandler, String userTempDirectory, Printer[] printers)
at Microsoft.Dynamics.Nav.Runtime.NavConnection.Open()
at Microsoft.Dynamics.Nav.Service.NSService.<>c__DisplayClass4.<OpenConnection>b__2(Connection connection)
at Microsoft.Dynamics.Nav.Service.NSService.ExecuteOperation[T](String operationName, ServiceOperation`1 operation, Connection connection, Boolean revertLanguageChanges, WindowsIdentity impersonationIdentity)
Source: Microsoft.Dynamics.Nav.Ncl

I've had an open case at MS for about a week. They seem to be scratching their heads. Any thoughts?

Alex_Chow

I'd try giving the user administrator permission to see if that problem happens again.

bbrown

Alex Chow wrote:

I'd try giving the user administrator permission to see if that problem happens again.

Thanks for the reply

Which user? The one runnign the RTC client or the account running the service?

And to what?

BTW - the couple of us that are Domain Admins have experienced this issue at times.

Alex_Chow

The user that's setup to run the Dynamics NAV service.

Alex_Chow

Sorry, didn't read it was internal sever. I'm assuming you followed this guide to setup multiple services?

http://msdn.microsoft.com/en-us/library/dd301437.aspx

I remember running into this problem because my CustomSettings.config file was not setup properly for each service. This caused my Dynamics NAV service to not start properly.

bbrown

Yes, on the setup. I think. I actually didn't do these myself. They were done by the person that does most of our client installs. We reviewed and couldn't find any issues.

I've got a meeting right now. I'll double check that document when I get a chance. Just to be sure.

fgudelj

Has anybody solved this issue?

I have same problem with my customer.
I even thought that it was Windows rights issue, but it still didn't solve my problem.

beran

Are there any entries with stack traces in the event log at the users?

fgudelj

I got this error:

Service: MicrosoftDynamicsNavServer$HAKOM
User: domain\domain user
Type: System.IndexOutOfRangeException
Message: Index was outside the bounds of the array.
StackTrace:
at Microsoft.Dynamics.Nav.Runtime.PermissionManager.PermissionCache.GetDictionaryForType(ObjectType objectType)
at Microsoft.Dynamics.Nav.Runtime.PermissionManager.InitializeFromCSide(IntPtr unmanagedExecutePermissions, Int32 numberOfElements, Boolean userHasAllPermissions)
at Microsoft.Dynamics.Nav.Runtime.NativeMethods.AdapterLoadExecutePermissions(IntPtr connectionHandle, ExecutePermissionBuilder executePermissionBuilderHandler, Int32 systemTableOrTableDataOnly)
at Microsoft.Dynamics.Nav.Runtime.NavConnection.Open()
at Microsoft.Dynamics.Nav.Service.NSService.<>c__DisplayClass4.<OpenConnection>b__2(Connection connection)
at Microsoft.Dynamics.Nav.Service.NSService.ExecuteOperation[T](String operationName, ServiceOperation`1 operation, Connection connection, Boolean revertLanguageChanges, WindowsIdentity impersonationIdentity)
Source: Microsoft.Dynamics.Nav.Ncl

clausl

1. Make sure that you have set "$ndo$navlistener" as Default Schema in SQL Management Studio for the database. See attached Screendump:

and

2. Make sure that you have on dbo.Object Tracking have marked Grant for the Select Permission for the Service account setup to run you Service. In my demo enviroment I use "NT AUTHORITY\NETWORK SERVICE". See attached Screendump:

/Claus Lundstrøm

fgudelj

Thanks everyone for reply, but I've already tried everything and nothing worked.

After a while and more testing and, I must say it like this, investigating my client system and infrastructure I've managed to find what was the issue.
It was UTP port on client's Blade Server. Fixing that port, solved this issue.

Here is a little explanation on blog: http://bsinsight.wordpress.com/2012/07/ ... m-crash-2/

Thanks everyone for your contribution.