Skip to main content

Troubleshooting the Dynamics NAV Web Service Data Source

Moderate - requires administrative access to Dynamics NAV

Overview

Dynamics NAV's Web Services is a powerful tool that can be used in conjunction with the Jet Excel add-in to provide you with access to your NAV data.

Occasionally, something needs to be adjusted - and some of the error messages generated by Web Services can be a bit cryptic.

Here are a few key suggestions to help you in your initial stages of troubleshooting.

Messages

  1. Server Unavailable 

    Following is the error message:

    The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:

    The remote server returned an error: (503) Server Unavailable.

    Troubleshooting:

    Applicable to NAV 2013 Web Service

    Using the Dynamics NAV Administration Console , validate that the NAV Server Instance (shown in the error message) is running.

    1. Locate the correct NAV Instance
      1. If not running, restart
    2. Troubleshoot the code Units.  Check the codeunit, validate multiple codeunits that are published:
      1. Unpublish all codeunits and pages
      2. Republish just the Jet Codeunit and retest the connection
  2. Invoking the web service failed 

    Following is the error message:

    Invoking the web service failed with the following message:

    Unable to connect to the remote server.

    Troubleshooting:

    Applicable to NAV 2015 (and higher) Web Service

    Using the Dynamics NAV Administration Console , validate that the NAV Server Instance (shown in the error message) is running.

    1. Locate the correct NAV Instance
      1. If not running, restart
    2. Follow the steps for troubleshooting codeunits as listed in error #1
  3. The remote name could not be resolved 

    Following is the error message:

    The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:

    The remote name could not be resolved: 'servername'

    Troubleshooting:

    In the Jet Excel add-in...

    1. Access the Data Source Settings
    2. Go to the Web Services tab
      1. Verify that the name entered for the server is correct
      2. If not, correct it and then re-test
  4. (404) Not Found

    Following is the complete error message:

    The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:F

    The remote server returned an error: (404) Not Found.

    Troubleshooting:

    In the Jet Excel add-in...

    1. Access the Data Source Settings
    2. Go to the Web Services tab
      1. Verify that the name entered for the instance is correct
      2. If not, correct it and then re-test
  5. Unable to connect to the remote server

    Following is the complete error message:

    The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:

    Unable to connect to the remote server.

    Troubleshooting:

    1. Verify that the port number listed in the error is correct and also matches what is shown in the Dynamics NAV Administration Console
    2. Using the Dynamics NAV Development Environment , verify that the server name you are using in your Jet Data Source Settings is correct ( File | Database | Information ).
  6. (500) Internal Server Error

    Following is the complete error message:

    The url 'http://[servername:port]/[NAV Server Instance]/WS/ CRONUS%20USA,%20Inc/Codeunit/Jet_Data_Source' is not valid.  Thefollowing error was reported:

    The remote server returned an error: (500) Internal Server Error.

    Troubleshooting:

    Use the Development Environment's Object Designer to confirm that the Jet Codeunits are installed and are of the correct version for the version of the Jet Excel add-in you are using:

    codeunit_list_NAV_dev.png
  7. The Dynamics NAV web service is improperly configured.

    Following is the complete error message:

    The Dynamics NAV web service is improperly configured.  A web service server and instance name must be specified and the port number must be between 1 and 65535.

    Troubleshooting:

    In the Jet Excel add-in...

    1. Access the Data Source Settings
    2. Go to the Web Services tab
      1. Verify that the Instance field is populated with the correct information.
  8. Company ' ' does not exist

    Following is the complete error message:

    Company '' does not exist.

    Troubleshooting:

    In the Jet Excel add-in...

    1. Access the Data Source Settings
    2. Go to the Web Services tab
      1. Verify that the correct Company can be selected from the drop-down list
      2. If able to do so, select that company and re-test the connection
  9. The codeunit '' does not exist 

    Following is the complete error message:

    The codeunit '' does not exist.

    Troubleshooting:

    In the Jet Excel add-in...

    1. Access the Data Source Settings
    2. Go to the Web Services tab
      1. Verify that Codeunit Jet_Data_Source can be selected from the drop-down list
      2. If able to, select Jet_Data_Source (note: typing in the name of the codeunit will result in an error... it must be selected from the list)
      3. Select the correct Company from the drop-down list
      4. Save the settings and re-test the connection
  10. The underlying connection was closed

    Following is the complete error message:

    The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid. The following error was reported:

    The underlying connection was closed:  An unexpected error occurred on a send.

    Troubleshooting:

    1. Access the Data Source Settings
    2. Go to the Web Services tab
      1. Check whether or not Use SSL encryption is enabled or disabled
    3. Access the Dynamics NAV Administration Console
    4. Open the SOAP Services section for the specific NAV Service Instance being used
      1. Check whether or not Enable SSL is checked.

      The settings MUST match

  11. (401) Unauthorized

    Following is the complete error message:

    The url 'http://[servername:port]/[NAV Server Instance]/WS/SystemService' is not valid.  The following error was reported:

    The remote server returned an error: (401) Unauthorized.

    Troubleshooting:

    1. Ensure you are using one of the following five types of Dynameics NAV authentication supported by Jet Reports:
        1. Windows Authentication
        2. User Name Authentication
        3. NAV User Password Authentication
        4. Access Control Service Authentication
        5. Microsoft 365 Authentication (also known as OAuth authentication)
      For detailed information for each authentication type, please see NAV 2015 Authentication Types
    2. Check if user is a user in NAV
    3. Try using IP Address instead of Server name
    4. Ensure that the user is able to get the NAV.xml file to open by entering the server URL (shown in the error message) in Internet Explorer's address bar.

  12. Either the URL is incorrect or the server is currently not available

    Following is the complete error message:

    A server was not found at "net.tcp://[servername:port]/[NAV Server Instance]/Service".  Either the URL is incorrect or the server is currently not available.

    Troubleshooting:

    Issue encountered when attempting to connect to NAV 2013 R2 (or higher) RoleTailored Client (RTC).

    1. Confirm that the server shown in the error message is correct
    2. In the ‘Services.msc’ Management Console, confirm that SQL Server{SQLversion} and SQL Server Agent {SQLversion} are both ‘Started’
    3. In the Dynamics NAV Administration Tool, confirm that the status of the NAV Server Instance is ‘running’
      1. Unpublish all codeunits and pages
      2. Republish just the Jet Codeunit and retest the connection
  13. Cannot interpret data as a URL

    Complete text of error message is:

    Following is the complete error message:

    Troubleshooting:

    If Client Services port setting is incorrect, above error will occur.

    To located the necessary information:

    1. Access the NAV RTC.
    2. Click the blue drop-down arrow: .
    3. Click Select Server....
  14. To configure your drilldown settings:
    1. Access the Data Source Settings.
    2. Go to the Drilldown tab.
    3. Configure the RTC folder for the location where your RTC is installed.
    4. Configure the RTC Server , Client Service Port , and RTC Instance from the information you gathered from within NAV.
    config_drilldown.png

    Once all settings are correct, refresh the report and then attempt to drill down, again.

Related Articles

Was this article helpful?

We're sorry to hear that.