mibuso.com
Home› NAV Three Tier

Can't open RoleTailored version of NAV 2009 R2

anphilipanphilip Member Posts: 86
edited 2012-08-29 in NAV Three Tier
Hello Everyone,

Has anyone ever had an encounter that you can't open NAV 2009 R2 (RTC) but I manage to open in Microsoft Dynamics NAV 2009 R2 Classic with Microsoft SQL Server without any problem.

In return i get a few error message:
1. The Microsoft Dynamics NAV Server service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs.

2. A server was not found at "net.[url=tcp://localhost:7046/DynamicsNAV/Service]tcp://localhost:7046/DynamicsNAV/Service[/url]". Either the URL is incorrect or the server is currently not available.

3. The program could not create a connection to the server. Do you want to try again?

Even I try to use "NAV2009_NST_Management.exe" also failed.

Can anyone please help. Actually I would like to know how is NAV 2009 R2 works and how to open it cause I had no problem to open it in Microsoft Dynamics NAV 2009 R2 Classic with Microsoft SQL Server?

Thanks in advance

Regards,
Philip

Answers

  • postsauravpostsaurav Member Posts: 708
    Hi Philip,

    Post the message that you are getting in event viewer, then we would be able to assist you.
    Thanks & Regards,
    Saurav Dhyani

    Do you Know this About NAV?


    Connect - Twitter | Facebook | Google + | YouTube

    Follow - Blog | Facebook Page | Google + Page
  • anphilipanphilip Member Posts: 86
    postsaurav wrote:
    Hi Philip,

    Post the message that you are getting in event viewer, then we would be able to assist you.

    Here you goes...

    Log Name: Application
    Source: MicrosoftDynamicsNAVServer
    Date: 27/08/2012 12:13:29 PM
    Event ID: 0
    Task Category: None
    Level: Error
    Keywords: Classic
    User: N/A
    Computer: An-PC.ibizcs.my
    Description:
    Service:
    The service MicrosoftDynamicsNavServer$TOS failed to start. This could be caused by a configuration error. Detailed error information:Microsoft.Dynamics.Nav.Types.NavConfigurationException: Configuration file error:

    'Singapore' is an unexpected token. Expecting white space. Line 70, position 49. (C:\Program Files (x86)\Microsoft Dynamics NAV\60\ServiceTOS\Microsoft.Dynamics.Nav.Server.exe.Config line 70) ---> System.Configuration.ConfigurationErrorsException: 'Singapore' is an unexpected token. Expecting white space. Line 70, position 49. (C:\Program Files (x86)\Microsoft Dynamics NAV\60\ServiceTOS\Microsoft.Dynamics.Nav.Server.exe.Config line 70) ---> System.Xml.XmlException: 'Singapore' is an unexpected token. Expecting white space. Line 70, position 49.
    at System.Xml.XmlTextReaderImpl.Throw(Exception e)
    at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
    at System.Xml.XmlTextReaderImpl.ParseAttributes()
    at System.Xml.XmlTextReaderImpl.ParseElement()
    at System.Xml.XmlTextReaderImpl.ParseElementContent()
    at System.Xml.XmlTextReaderImpl.Read()
    at System.Xml.XmlTextReader.Read()
    at System.Configuration.XmlUtil.CopyXmlNode(XmlUtilWriter utilWriter)
    at System.Configuration.XmlUtil.CopyElement(XmlUtilWriter utilWriter)
    at System.Configuration.XmlUtil.CopySection()
    at System.Configuration.AppSettingsSection.DeserializeElement(XmlReader reader, Boolean serializeCollectionKey)
    at System.Configuration.ConfigurationSection.DeserializeSection(XmlReader reader)
    at System.Configuration.MgmtConfigurationRecord.CreateSection(Boolean inputIsTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentConfig, ConfigXmlReader reader)
    at System.Configuration.BaseConfigurationRecord.CallCreateSection(Boolean inputIsTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentConfig, ConfigXmlReader reader, String filename, Int32 line)
    --- End of inner exception stack trace ---
    at System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)
    at System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)
    at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
    at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
    at System.Configuration.Configuration.GetSection(String sectionName)
    at System.Configuration.Configuration.get_AppSettings()
    at Microsoft.Dynamics.Nav.Types.ConfigSettings.GetRawSetting(String settingName, Boolean& specified)
    --- End of inner exception stack trace ---
    at Microsoft.Dynamics.Nav.Types.ConfigSettings.GetRawSetting(String settingName, Boolean& specified)
    at Microsoft.Dynamics.Nav.Types.ConfigSettings.GetStringSetting(String settingName, String defaultValue)
    at Microsoft.Dynamics.Nav.Types.ConfigSettings.LoadServerInstance()
    at Microsoft.Dynamics.Nav.Types.ServerUserSettings.LoadSettings()
    at Microsoft.Dynamics.Nav.Types.ServerUserSettings.get_Instance()
    at Microsoft.Dynamics.Nav.WindowsServices.NavServiceBase.OnStart(String[] args).
    Event Xml:
    <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"&gt;
    <System>
    <Provider Name="MicrosoftDynamicsNAVServer" />
    <EventID Qualifiers="0">0</EventID>
    <Level>2</Level>
    <Task>0</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-08-27T04:13:29.000000000Z" />
    <EventRecordID>65616</EventRecordID>
    <Channel>Application</Channel>
    <Computer>An-PC.ibizcs.my</Computer>
    <Security />
    </System>
    <EventData>
    <Data>Service:
    The service MicrosoftDynamicsNavServer$TOS failed to start. This could be caused by a configuration error. Detailed error information:Microsoft.Dynamics.Nav.Types.NavConfigurationException: Configuration file error:

    'Singapore' is an unexpected token. Expecting white space. Line 70, position 49. (C:\Program Files (x86)\Microsoft Dynamics NAV\60\ServiceTOS\Microsoft.Dynamics.Nav.Server.exe.Config line 70) ---> System.Configuration.ConfigurationErrorsException: 'Singapore' is an unexpected token. Expecting white space. Line 70, position 49. (C:\Program Files (x86)\Microsoft Dynamics NAV\60\ServiceTOS\Microsoft.Dynamics.Nav.Server.exe.Config line 70) ---> System.Xml.XmlException: 'Singapore' is an unexpected token. Expecting white space. Line 70, position 49.
    at System.Xml.XmlTextReaderImpl.Throw(Exception e)
    at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
    at System.Xml.XmlTextReaderImpl.ParseAttributes()
    at System.Xml.XmlTextReaderImpl.ParseElement()
    at System.Xml.XmlTextReaderImpl.ParseElementContent()
    at System.Xml.XmlTextReaderImpl.Read()
    at System.Xml.XmlTextReader.Read()
    at System.Configuration.XmlUtil.CopyXmlNode(XmlUtilWriter utilWriter)
    at System.Configuration.XmlUtil.CopyElement(XmlUtilWriter utilWriter)
    at System.Configuration.XmlUtil.CopySection()
    at System.Configuration.AppSettingsSection.DeserializeElement(XmlReader reader, Boolean serializeCollectionKey)
    at System.Configuration.ConfigurationSection.DeserializeSection(XmlReader reader)
    at System.Configuration.MgmtConfigurationRecord.CreateSection(Boolean inputIsTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentConfig, ConfigXmlReader reader)
    at System.Configuration.BaseConfigurationRecord.CallCreateSection(Boolean inputIsTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentConfig, ConfigXmlReader reader, String filename, Int32 line)
    --- End of inner exception stack trace ---
    at System.Configuration.BaseConfigurationRecord.EvaluateOne(String[] keys, SectionInput input, Boolean isTrusted, FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult)
    at System.Configuration.BaseConfigurationRecord.Evaluate(FactoryRecord factoryRecord, SectionRecord sectionRecord, Object parentResult, Boolean getLkg, Boolean getRuntimeObject, Object& result, Object& resultRuntimeObject)
    at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
    at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
    at System.Configuration.Configuration.GetSection(String sectionName)
    at System.Configuration.Configuration.get_AppSettings()
    at Microsoft.Dynamics.Nav.Types.ConfigSettings.GetRawSetting(String settingName, Boolean& specified)
    --- End of inner exception stack trace ---
    at Microsoft.Dynamics.Nav.Types.ConfigSettings.GetRawSetting(String settingName, Boolean& specified)
    at Microsoft.Dynamics.Nav.Types.ConfigSettings.GetStringSetting(String settingName, String defaultValue)
    at Microsoft.Dynamics.Nav.Types.ConfigSettings.LoadServerInstance()
    at Microsoft.Dynamics.Nav.Types.ServerUserSettings.LoadSettings()
    at Microsoft.Dynamics.Nav.Types.ServerUserSettings.get_Instance()
    at Microsoft.Dynamics.Nav.WindowsServices.NavServiceBase.OnStart(String[] args).</Data>
    </EventData>
    </Event>
  • kinekine Member Posts: 12,562
    As you can see, you have somehow wrong configuration around "Singapore" value. Check that you didn't remove some tag or something like that. It looks like syntax error in the config.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • anphilipanphilip Member Posts: 86
    kine wrote:
    As you can see, you have somehow wrong configuration around "Singapore" value. Check that you didn't remove some tag or something like that. It looks like syntax error in the config.

    Hi Kine,

    I have change it but still fail to open RTC.

    add key="WebServicesDefaultTimeZone" value="UTC"
    add

    Thank you.
  • kinekine Member Posts: 12,562
    Can you post or send whole config file?
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • anphilipanphilip Member Posts: 86
    kine wrote:
    Can you post or send whole config file?

    Aldy send to your email. Please check. Thank you.
  • kinekine Member Posts: 12,562
    There is some disproportion: the error log is talking about value 'Singapore' on line 70, but there is UTC on line 70 in your config you send me.

    you must have different error in the log now...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • anphilipanphilip Member Posts: 86
    Hi Kine,

    Sure. May i have your email so i send to you the CustomSettings.config file

    Tq
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    I guess you tried
    <add key="WebServicesDefaultTimeZone" value=Singapore Standard Time></add>

    Or did you write Singapore Standard Time in "" ?

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • anphilipanphilip Member Posts: 86
    mohana_cse06 wrote:
    I guess you tried
    <add key="WebServicesDefaultTimeZone" value=Singapore Standard Time></add>

    Or did you write Singapore Standard Time in "" ?

    Hi mohana,

    I write in but now I change it back to UTC also failed.

    Microsoft Dynamics NAV

    The Microsoft Dynamics NAV Server cannot connect the Change Listener to SQL Server because of the following error: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
    OK

    even I did try "localhost:7046/DynamicsNAV" also failed

    Microsoft Dynamics NAV

    A server was not found at "net.[url=tcp://localhost:7046/DynamicsNAV/Service]tcp://localhost:7046/DynamicsNAV/Service[/url]". Either the URL is incorrect or the server is currently not available.
    OK

    Thinking of to re-install back my SQL server 2008 & NAV2009_NST_Management.exe but don't will it helps or not cause so many error is prompt from the system. I need to get my RTC up and running fast to simulate some process.

    Please help what is the best way or steps so I can follow it without any error.

    Thanks in advance
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    Follow below link to enable object change listener
    http://msdn.microsoft.com/en-us/library/dd568739.aspx

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • anphilipanphilip Member Posts: 86
    mohana_cse06 wrote:
    Follow below link to enable object change listener
    http://msdn.microsoft.com/en-us/library/dd568739.aspx

    USE MASTER
    CREATE LOGIN [ReplaceWithNAVServerAccount] FROM WINDOWS;
    GO

    I have this part which I don't know what to replace with [ReplaceWithNAVServerAccount]?
    It's referring to my SQL user ID login which is "sa" or other means?
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    There is a section in above link Determining If You Must Enable the Object Change Listener
    For certain installation configurations, you must manually enable the Object Change Listener. The following table explains the configuration options.

    Please check..

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • anphilipanphilip Member Posts: 86
    mohana_cse06 wrote:
    There is a section in above link Determining If You Must Enable the Object Change Listener
    For certain installation configurations, you must manually enable the Object Change Listener. The following table explains the configuration options.

    Please check..

    Hi mohana,

    Thanks for the help on above issue but now I face a new message.

    Microsoft Dynamics NAV

    The following SQL Server error or errors occurred: 17750,"42000",[Microsoft][ODBC SQL Server Driver][SQL Server]Could not load the DLL C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\xp_ndo.dll, or one of the DLLs it references. Reason: 193(%1 is not a valid Win32 application.).

    SQL:
    INSERT INTO [#$ndo$groups] {CALL [master]..[xp_ndo_enumusergroups](?,?)}
    OK

    What is wrong?

    Thanks in advance for your help.
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    Did you copy xp_ndo.dll to C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\xp_ndo.dll?
    if you are using 64 bit os copy xp_ndo_x64.dll

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • anphilipanphilip Member Posts: 86
    mohana_cse06 wrote:
    Did you copy xp_ndo.dll to C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\xp_ndo.dll?
    if you are using 64 bit os copy xp_ndo_x64.dll

    Hi mohana,

    Already copy xp_ndo.dll to C:\Program Files (x86)\Microsoft SQL Server\80\Tools\Binn\xp_ndo.dll and now is working fine.

    By the way how can I close case this case? Where to go?

    Thank you for you all guys help. :):D
  • mohana_cse06mohana_cse06 Member Posts: 5,504
    Edit your FIRST post and select solved in Attributes..(not sure 100%)

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
Sign In or Register to comment.