Jet from insightsoftware

Error: Root element is missing
Error: Root element is missing Overview When starting the Jet Data Manager, the following error message is displayed: Complete text from error message: An error occurred while reading the settings file. Root element is missing. Do you want to make another attempt reading the settings? If you answer no, be aware the application will exit and any changes canno...
Error: Retrieving the COM class factory for component with CLSID
Error: Retrieving the COM class factory for component with CLSID Expert Overview When attempting to synchronize the data source or Deploy a table in the project, the following error message is displayed: Complete text of error message is: Failed to refresh information schema. Error during execution of for SSIS Package; InformationSchema_provide...
Change StringStoresCompatibilityLevel
Change StringStoresCompatibilityLevel The resolution for this issue requires SQL Server Analysis Services 2012 or higher on your database/cubestore server. Overview When executing a large dimension, the following error message is displayed: File system error: A string store or binary store with a compatibility level of '1050' is at the maximum file size of 4 gigabytes. To stor...
Method not found '!!0[]System.Array.Empty()'.
Method not found '!!0[]System.Array.Empty()'. Expert When Deploying or trying to Edit a database in the JDM project, you get an error message such as: Complete text of error message is: Error in command: 'Deploy'Method not found:  '!!0[]System.Array.Empty() Cause: This error message is caused by ...
There is already an object in the database
There is already an object in the database Expert Overview When Deploying the project, you get an error message that contains " There is already an object name 'table name' in the database ." Applicable text of error message is: ...  There is already an object named 'table name' in the database...Before taking these steps, it is strongly advise...
Error: Common Language Runtime detected an invalid Program
Error: Common Language Runtime detected an invalid Program Overview When attempting to add in dimensions from the Advanced Dimension Editor, you get the following error: Complete text of error message is: Common Language Runtime detected an invalid program. Cause: This error is being caused by a bug in the 64-bit e...
Dashboard Import - Troubleshooting
Dashboard Import - Troubleshooting The Dashboard Builder feature has been deprecated. Overview When opening a dashboard in Dashboard Builder for the first time after importing it, you are directed through the Change Data Source dialog. If the Change Data Source process has issues importing some parts of a dashboard, it displays a data warning which you can export as a loca...
Error: Type String Cannot be Converted to Type Nvarchar of the Specified Target Column
Error: Type String Cannot be Converted to Type Nvarchar of the Specified Target Column Symptoms When synchronizing or executing a NAV data source, the following error message may appear. "The given value of type String from the data source cannot be converted to type nvarchar of the specified target column." Resolution When using the NAV Adapter data source type, this error m...
Error: No license for feature 'Additional Data Sources'
Error: No license for feature 'Additional Data Sources' Symptoms When attempting to setup or synchronize an 'Any Source ADO' data source connection, you may encounter the following message: "No license for feature 'Additional Data Sources'." Resolution This message has been linked to the earliest iterations of the Jet Data Manager 2016 version.  Please upgrade your Jet Data Ma...
Error: No license for feature 'Add Prioritization'
Error: No license for feature 'Add Prioritization' Symptoms When attempting to add Prioritizations within the Jet Data Manager, you may encounter the following message: "No license for feature 'Add Prioritization'." Resolution As prioritizations are a new feature beginning with JDM 2016, there is a feature that must be enabled on your license.  Please contact support ...
Error: An error occurred while loading a list of projects from the database. The given key was not present in the dictionary
Error: An error occurred while loading a list of projects from the database. The given key was not present in the dictionary Symptoms While attempting to open or save a project, the following error is returned: "An error occurred while loading a list of projects from the database. The given key was not present in the dictionary." Resolution This error is caused by a corrupted ...
Error: File system error: The following file is corrupted (Analysis Services)
Error: File system error: The following file is corrupted (Analysis Services) Symptoms When deploying or executing a Jet Data Manager project, the following error message is presented: "Cannot show requested dialog.Additional Information:File system error: The following file is corrupted: Physical file: \\?\C:\Program Files\Microsoft SQL Server\MSASXX.MSSQLSERVER\OLAP\Data\{database ...
Error: An error occurred while loading a list of projects from the database
Error: An error occurred while loading a list of projects from the database Symptoms When attempting to open the Project Repository database from within the Jet Data Manager, the following error message is displayed: "An error occurred while loading a list of projects from the database.  Adapter with id:xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx  and version xxx could not be loaded.  Faile...
Error: Error in Command: TimeXtender.DataManager.ActivationCommandObject
Error: Error in Command: TimeXtender.DataManager.ActivationCommandObject Symptoms When attempting to activate the Jet Data Manager offline via the 'Manual Activation' method, the following error message is displayed: " Error in command: TimeXtender.DataManager.ActivationCommandObject reference not set to an instance of an object." Cause: This error message is caused w...
Error: Error in command: Exception of type 'System.OutOfMemoryException' was thrown
Error: Error in command: Exception of type 'System.OutOfMemoryException' was thrown Symptoms When attempting to Deploy and Execute a project, or when attempting to open the Jet Data Manager application, one of the following error messages is displayed: Error message when opening the Jet Data Manager: Unhandled exception has occurred in a component in your application.  If you ...
Error: Either the user does not have permission to alter the object, or the object does not exist.
Error: Either the user does not have permission to alter the object, or the object does not exist. Symptoms When working within the Jet Data Manager (or within SQL Server Analysis Services), the following error message is displayed: " Either the '{user name}' user does not have permission to alter the '{name of object}' object, or the object does not exist."Cause: The user...
Error: Could Not Load File or Assembly 'Microsoft.SqlServer.DTSRuntimeWrap...'
Error: Could Not Load File or Assembly 'Microsoft.SqlServer.DTSRuntimeWrap...' Symptoms When deploying a SSIS package using the Jet Data Manager, an error similar to the following occurs: " Could not load file or assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=XX.0.0.0, Culture=neutral, PublicKeyToken={token}' or one of its dependencies. The system cannot find the file ...
How to Resolve an Issue with Closing Entries Being Flagged Improperly for NAV
How to Resolve an Issue with Closing Entries Being Flagged Improperly for NAV Symptoms: After upgrading to version 14.2.5 or later of the Jet Data Manager there are no longer any financial transactions that have a Closing Entry flag set to 1 (flagging the transaction as a closing entry). Filtering on the Closing Entry field in the Finance Transactions table in the data warehouse or sett...
Error: Column 'SeqNo' does not allow nulls.
Error: Column 'SeqNo' does not allow nulls. Overview When attempting to download a project from the CubeStore, you receive the following error message (or similar): "Column 'SeqNo' does not allow nulls." Cause: This error message is caused by using a version of the Jet Data Manager which is older than the currently released version. ...
Error: Error creating enhancements! Connecting to the Integration Services service on the computer "localhost" failed with the following error: "Access is denied."
Error: Error creating enhancements! Connecting to the Integration Services service on the computer "localhost" failed with the following error: "Access is denied." Symptoms When synchronizing a data source in the Jet Data Manager, an error about creating enhancements appears and indicates "Access is denied" when connecting to Integration Services. " Error creating enhancement...
Error: Show Details cannot be executed when multiple items are selected in a report filter field or in a slicer
Error: Show Details cannot be executed when multiple items are selected in a report filter field or in a slicer Overview When attempting to drill-down on a measure you may receive the following message: "Show Details cannot be executed when multiple items are selected in a report filter field or in a slicer. Select a single item for each field in the report filter area and for each slice...
Error: The sort order specified for distinct count records is incorrect. Errors in the OLAP storage engine
Error: The sort order specified for distinct count records is incorrect. Errors in the OLAP storage engine Symptoms When deploying and executing the OLAP Server or cubes you may encounter the following error: The sort order specified for distinct count records is incorrect. Errors in the OLAP storage engine: An error occurred while processing the 'Inventory Transactions Docu...
How to Prevent an Execution Package from Failing Because an Excel File is Open
How to Prevent an Execution Package from Failing Because an Excel File is Open Overview When using Excel files as a data source in the Jet Data Manager, it is possible that a user has the Excel file open while an execution package is running. This will cause the execution package to fail due to the user having an exclusive lock on the file. This exclusive lock prevents other users (includin...
Error "Item Has Already Been Added" Opening Server Properties on Analysis Services
Error "Item Has Already Been Added" Opening Server Properties on Analysis Services Overview The error occurs when the user attempts to open the server properties for SQL Server Analysis Services within SQL Server Management Studio Cause There is a known issue when using SQL Server 2012 , 2008 R2 , or 2008 with the following operating systems: Windows 8 ...
Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered
Error: The 'Microsoft.ACE.OLEDB.12.0' provider is not registered Overview When working with an Excel data source, you may encounter error messages that indicate the Microsoft ACE OLE DB provider is not registered. This error can be presented in many forms. Examples: "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.""The requested OLE DB provid...
Error: Error getting Engine for Microsoft Analysis Services.
Error: Error getting Engine for Microsoft Analysis Services. Symptoms When deploying OLAP user rights, the following error is encountered: or "Error getting Engine for Microsoft Analysis Services. The reason can be that the version of Analysis Services is unsupported or the components for connecting to the Server is missing on the system." Resolutions To resolve th...
Error: Error during execution of package for JetNavStage_Currency Exchange Rate
Error: Error during execution of package for JetNavStage_Currency Exchange Rate Symptoms During the execution of the Currency Exchange Rate table, you encounter the following error: " Error during execution of package for JetNavStage_Currency Exchange Rate"Cause The cause of this error is that the Relational Exch. Rate Amount field in Dynamics NAV's Curr...
Error: Your License does not permit you to use the language ENU
Error: Your License does not permit you to use the language ENU Symptoms When running the NAV Adapter you receive the following error message: " Your license does not permit you to use the language ENU." Resolution From the Object Designer, navigate to the Reports page and find object ID 1415100 and select Design. With the report design...
Error: Error Creating DTS package for. Exception from HRESULT: 0XC0048021
Error: Error Creating DTS package for Symptoms When deploying and executing a table in the Jet Data Manager, the following error occurs: " Error Creating DTS package for <table>. Exception from HRESULT: 0XC0048021"Cause: This error will occur when the Jet Data Manager is being used on one machine and the SSIS packages are being deployed to another machine. Resolution...
Timeouts on Databases
Timeouts on Databases This article explains what timeout types there are, and how you can change timeout settings to prevent timeout errors. By adjusting the settings, you can make sure that there is a good balance between how long the application needs to wait for actions to complete before triggering an error. Use the links below to jump to the corresponding section: The two type...
First Page
Back
For an optimal Community experience, Please view on Desktop