Sign Up for Training |
Jet Global Company Site
Community
Downloads
Submit a Request
Give Feedback

Troubleshooting the Dynamics NAV Web Service Data Source


Moderate
- requires administrative access to Dynamics NAV

Related Articles...

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

    ws_error01.png

    Complete text of error message is:

    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

    ws_error02.png

    Complete text of error message is:

    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

    ws_error03.png

    Complete text of error message is:

    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. Unable to connect to the remote server

    ws_error04.png

    Complete text of error message is:

    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:

    Verify that the port number listed in the error is correct and also matches what is shown in the Dynamics NAV Administration Console.

    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).  Then, use 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:

     

  5. The Dynamics NAV web service is improperly configured.

    ws_error05.png

    Complete text of error message is:

    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.
  6. Company ' ' does not exist

    ws_error06.png

    Complete text of error message is:

    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
  7. The codeunit '' does not exist

    ws_error10.png

    Complete text of error message is:

    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
  8. The underlying connection was closed

    ws_error07.png

    Complete text of error message is:

    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
  9. (401) Unauthorized

    Complete text of error message is:

    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.

    First Step Troubleshooting:

    Jet Reports supports all five types of Dynamics NAV authentication

    1. Windows Authentication
    2. User Name Authentication
    3. NAV User Password Authentication
    4. Access Control Service Authentication
    5. Office 365 Authentication (also known as OAuth authentication)

    Additional Troubleshooting

    1. Check if user is a user in NAV
    2. Try using IP Address instead of Server name
    3. 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.
  10. Either the URL is incorrect or the server is currently not available

    Complete text of error message is:

    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
  11. Cannot interpret data as a URL

    Complete text of error message is:

    Cannot interpret data as a URL.

    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...

    hello

    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:
    Once all settings are correct, refresh the report and then attempt to drill down, again
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments