Sign Up for Training |
insightsoftware Company Site
Community
Downloads
Training
Submit a Request
Become a Jet Insider
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
    server_unavailable.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
    incorrect_server_name.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. (404) Not Found
    incorrect_instance.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: (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
    unable_to_connect.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:

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

    Complete text of error message is:

    The url 'http://[servername:port]/[NAV Server Instance]/WS/ CRONUS%20USA,%20Inc/Codeunit/Jet_Data_Source' is not valid.  The following 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.
    no_instance_entered.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.
  8. Company ' ' does not exist
    company_not_entered.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
  9. The codeunit '' does not exist
    codeunit_not_entered.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
  10. The underlying connection was closed
    ssl_enabled_issue.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.
      ssl_settings.png
      The settings MUST match
  11. (401) Unauthorized
    incorrect_username_password.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: (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. Office 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
    url_incorrect.png

    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
  13. 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...
  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
Was this article helpful?
1 out of 1 found this helpful

Comments