Jet from insightsoftware

Error: Error opening connection to BC Cloud: System.ApplicationException: Invalid response from Business Central calling API GetLanguage
Error: Error opening connection to BC Cloud: System.ApplicationException: Invalid response from Business Central calling API GetLanguage Symptoms When attempting to connect to an online tenant of Business Central using the BC provider you encounter the following error: Error: Error opening connection to BC Cloud: System.ApplicationException: Invalid response from Business Central calli...
Error - The underlying connection was closed: An unexpected error occurred on a send.
Error - The underlying connection was closed: An unexpected error occurred on a send. Overview When connecting to a Dynamics Business Central SaaS data source (public cloud), the following error is received: Complete text of error message is: The underlying connection was closed: An unexpected error occurred on a send. Cause: ...
Error: You do not have the following permissions on TableData What's New Notified: Read
Error: You do not have the following permissions on TableData What's New Notified: Read Overview When connecting with a 'Dynamics 365 Business Central public cloud (Web Services)' data source, an error can be displayed: Complete text of error message is: You do not have the following permissions on TableData What's New Notified: Read To view details about y...
Error: You are not authorized... You must sign-in using your Microsoft 365 credentials
Error: You are not authorized... You must sign-in using your Microsoft 365 credentials Overview When attempting to access your Dynamics 365 Business Central data using either Jet Reports or Jet Reports Financials, a message is displayed: You are not authorized to access this data source. You must sign-in using your Microsoft 365 credentials for authorization.Cause: This error message ...
Login Failed with Dynamics NAV 2013-2018 or Business Central SQL Server Data Source
Login Failed with Dynamics NAV 2013-2018 or Business Central SQL Server Data Source Overview When defining a SQL Server data source connection to Dynamics NAV 2013-2018 or Business Central on-premise, the following error message is displayed: The data provider returned the following error:Login failed for user 'DOMAIN\USER'.Cause: The current Windows user does not have sufficient perm...
Error: You do not have permission to run the 'Jet Adapter Setup' Report
Error: You do not have permission to run the 'Jet Adapter Setup' Report The information in this article applies only to NAV versions 4.0SP1 through 2009R2 The information in this article is applicable to Dynamics NAV partners . If you are an end user, please contact your Dynamics NAV partner to have your NAV license updated. Symptom Before installing the Jet...
Error: The Jet Service Tier is not running on host
Error: The Jet Service Tier is not running on host Overview The Jet Service Tier is a group of Windows programs (typically running on a server) which enable communications between insightsoftware applications (on users' computers), the Jet Services Database (on a server), and an organization's data sources. In order for the Jet application to communicate with the Jet Service Tier, th...
Error: Please specify a drilldown server in the data source settings
Error: Please specify a drilldown server in the data source settings This issue applies to data source connections to Dynamics NAV 2013 and higher Overview When attempting to perform a drilldown, an error message is displayed Complete text of error message is: Please specify a drilldown server in the data source settings. Cause: ...
Error: Incompatible version of Dynamics NAV detected
Error: Incompatible version of Dynamics NAV detected Symptoms When attempting to synchronize a NAV 2013 or later database within a Jet Data Manager project, the following error is presented: Complete text of error message is: Incompatible version of Dynamics NAV detected.  Please ensure that the NAV data source is NAV 2013 or later.Cause This error message indicates that th...
Error: Invoking the web service failed
Error: Invoking the web service failed Overview When accessing Dynamics NAV through NAV Web Services, it is possible for the the error Invoking the web service failed to occur. Example text of error message: Invoking the web service failed with the following message:The filter "01/01/2021..12/28/2021" is not valid for the the Date field in the Accounting table.  The value "...
Error: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found
Error: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found Issue Under certain conditions, an error may be displayed when testing a Jet Remote Data Service (JRDS) data source. If the data source is accessing a JRDS installed on a server with the Dynamics NAV database, Microsoft IIS, and SQL Server 2012, the following error may be dis...
The country code in the license file does not correspond to the country code (XX) in the STX file
The country code in the license file does not correspond to the country code (XX) in the STX file The information in this article applies to Microsoft Dynamics NAV 2009R2 and earlier. Overview Dynamics NAV's C/Front utility (which handles the vast majority of communications between older versions of Dynamics NAV and the Jet Excel Add-In) needs to confirm its licensing and region...
Error: The pivot table could not be inserted for the following reason: Initialization of the data source failed
Error: The pivot table could not be inserted for the following reason: Initialization of the data source failed Symptoms When creating a pivot table against the OLAP cubes in Excel the following error is encountered: Complete text of error message is: The pivot table could not be inserted for the following reason:Initialization of the data source failed.Check the database serv...
JRDS Error - An error has occurred processing your request / Provider cannot be found
JRDS Error - An error has occurred processing your request / Provider cannot be found Overview When using the Jet Excel Add-In with SQL Server 2012/2014, and testing the connection to a Jet Remote Data Service ("JRDS")  data source, the following error message is displayed: An error has occurred processing your request to the data source. When a Jet Excel Add-In Log file ...
The Metadata Table Object 14125606 Was Not Found (DEPRECATED)
The Metadata Table Object 14125606 Was Not Found (DEPRECATED) This information applies to older versions of the Jet Data Manager. Newer versions do not require the NAV Adapter . Please upgrade to the latest release of Jet Analytics Overview When importing and running the NAV Adapter in NAV 2013 R2 an error may appear stating: The Metadata Table Object 14125606 Was Not Found ...
Error: The objects in this file are from a different version of Microsoft Dynamics NAV Classic
Error: The objects in this file are from a different version of Microsoft Dynamics NAV Classic Symptoms When attempting to import the NAV adapter object into the NAV database, you may encounter the following message: Complete text of error message is: The objects in this file are from a different version of Microsoft Dynamics Classic.  If you continue, the objects ...
Error: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception
Error: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception Issue When user a 'Dynamics NAV 2013 and later (SQL Server)' data source in the Jet Excel Add-In, a non-admin user can receive the following error: Complete text of error message is: An unexpected error has occurred: The type initializer for 'System.Data.SqlClient.SqlConnection' threw an e...
Troubleshooting the Dynamics NAV Web Service Data Source
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...
Error: The URL must have exactly five forward slash (/) characters...
Error: The URL must have exactly five forward slash (/) characters... This issue applies to Dynamics NAV 2013 (and higher) Issue When attempting to perform a drilldown, the following error message is displayed: Complete text of error message is: The URL must have exactly five forward slash (/) characters before an optional question mark (?) character.Cause This...
Error: Jet Could Not Verify Your License Status
Error: Jet Could Not Verify Your License Status This information applices to Dynamics NAV 2009R2 and earlier Symptoms When configuring a data source connection to Dynamics NAV 2009 R2 or earlier, you may receive the following error message: Complete text of error message is: Jet could note verify your license status for the following reason:A Dynamics NAV license file c...
Error: There are errors in the text conversion (text no. 1965-0 does not exist in the .stx file). Internal error: 47-1 (DEPRECATED)
Error: There are errors in the text conversion (text no. 1965-0 does not exist in the .stx file). Internal error: 47-1 (DEPRECATED) This information applies to older versions of the Jet Data Manager. Newer versions do not require the NAV Adapter Please upgrade to the latest release of Jet Analytics Symptoms When attempting to run the NAV adapter the following error occurs: ...
Error: The Required Dynamics NAV Client Executable (finsql.exe) Could Not Be Found
Error: The Required Dynamics NAV Client Executable (finsql.exe) Could Not Be Found Symptoms When configuring a Dynamics NAV 2009 R2 or earlier data source you may receive the following error message: Jet could not verify your license status for the following reason: The required Dynamics NAV Client executable (finsql.exe) could not be found in <FilePath> Please chec...
Limitations of the Dynamics NAV 2013 and later (Web Services) Data Source
Limitations of the Dynamics NAV 2013 and later (Web Services) Data Source NL(Picture) In the 'Dynamics NAV 2013 and later (Web Services)' Data Source, NL(Picture) does not work when Calc Filters, Link Filters, or manual sorts are present in the NL(Picture) formula. DateFormula Field Values/Filters DateFormula field values use unit abbreviations such as D for Day, WD for Week...
Error: Provider cannot be found. It may not be installed properly.
Error: Provider cannot be found. It may not be installed properly. Symptoms When attempting to set OLAP security in the Jet Data Manager, or when attempting to connect to a SQL Server Analysis Services database from Excel you may receive the following error: Provider cannot be found. It may not be properly installed. Resolution To resolve...
Testing the Dynamics NAV Web Service
Testing the Dynamics NAV Web Service Overview When configuring the Jet Excel add-in to work with Dynamics NAV 2013's Web Service, it can be helpful to test the setup to make sure the Web Service is working as expected. In this Microsoft article , Microsoft provides an easy test. Below is an excerpt from that article. Publishing a Page as a Web Servic...
You do not have permission to run the 'System9110' system
You do not have permission to run the 'System9110' system Overview When using Jet Reports to connect to a data source for Dynamics NAV 2009R2 (or earlier), the following error appears: Complete text of error message is: You do not have permission to run the 'System9110' system.Cause The majority of communications between Microsoft Dynamics NAV and the Jet Excel Add-In are h...
Internal Error 1005 in Module 19
Internal Error 1005 in Module 19 Overview When attempting to connect to a data source for Dynamics NAV 2009R2 or earlier, the following error is displayed: Complete text of error message is: Internal error 1005 in module 19.Cause This message indicates that the field being queried was not found in the database. Note: Errors in Module 19 are C/Front errors....
Internal error 1123 in module 19
Internal error 1123 in module 19 Overview When using the Jet GL("Budget") function with a data source for Dynamics NAV 2009R2 or earlier, the following error is displayed: Complete text of error message is: Internal error 1123 in module 19.Cause This error indicates that the user (whose credentials are being used to connect to the database) does not have permissions to t...
Language Warning - Navision Language Module Could Not be Loaded
Language Warning - Navision Language Module Could Not be Loaded Overview If you select a language code in the Data Source Settings for a language which has no exported language module, you will receive the following error upon selecting the "Test Connection..." button: Complete text of error message is: The Dynamics NAV Language Module could not be loaded, table and field captions...
Internal Error 1407 in Module 19
Internal Error 1407 in Module 19 Overview When using Jet Reports to access a data source for Dynamics NAV 2009R2 or earlier, the following error is displayed: Complete text of error message is: Internal error 1407 in module 19.Cause This error is most often a permissions issue in the NAV database.  It is often seen when accessing a table via the Jet Excel Add-In where the user ...
First Page
Back
For an optimal Community experience, Please view on Desktop