Jet Analytics - Release Notes

Jet Analytics 24.4 Build 20.10.54.64

Release Date: November 19, 2024

New and Improved Features

Jet Analytics is now compatible with Business Central version 25. (6884)
The System.Data.SqlClient package is replaced with the Microsoft.Data.SqlClient package in Jet Data Manager. (8271)

Resolved Issues

Resolved an issue where non-standard BC tables were not merging with their extension tables, causing the extensions to be unavailable. (5388)

Jet Analytics 24.2 Build 20.10.50.64

Release Date: May 23, 2024

New and Improved Features

Updated Merge Options so that duplicate tables are not returned. (6605)
Jet Analytics is now compatible with Business Central version 24. (6731)

Resolved Issues

Corrected an issue where the trailing spaces in the environment while creating a data source adapter were resulting in a bad request error. (4526)
Improved performance of Jet Analytics while connecting to a BC data source. (6248)
Corrected an issue where the compound key consists of the Time field while processing a table over 100 L records. (625)
Corrected an issue where the property not found error is displayed while saving changes in the Advanced Dimension Editor. (6528)

Jet Analytics Build 20.10.45.64

Release Date: October, 2023

New and Improved Features

Improved performance of the Advanced Dimension Editor. (2623)
Jet Analytics is now compatible with Business Central version 23. (6068)
Updated logging feature to align with ISW coding practices and improve logging capabilities within Jet Analytics. (5409)
Updated support links inside the application to point to the new documentation site. (5221)

Resolved Issues

Corrected an issue with Business Central 2023 Wave 2 updates. (6295)
Corrected an issue in Jet Data Manager where fields were visible in the Table Preview but were not appearing during the data selection. (5532)
Corrected an issue where using the Advanced Dimension Editor plugin in JDM resulted in an object reference null error. (4474)
Corrected an issue in Jet Data Manager where Table Preview was not showing system columns when no columns were specified in the Table Preview. (3087)

Jet Analytics Build 20.10.42.64

Release Date: April 14, 2023

New and Improved Features

Upgraded .NET Framework versions (4886)
Jet Analytics is now compatible with Business Central version 22. (3892, 4624)
Enhanced the Jet Analytics install file by displaying the build number in the .zip file name. (3691)
Removed the Legacy BC Extension from the install folder and moved it to the BC Extension download folder. (3695)

Resolved Issues

Corrected an issue when the "Too Many Requests" error was returned when Jet Analytics sent too many requests to BC instead of retrying. (4000)
Corrected an issue where using OAuth authentication resulted in a null exception error. (4090)
Corrected an error message that occurred while performing authentication with Dynamics 365. (5051)

Jet Analytics Build 20.10.39

Release Date: December 20, 2022

New and Improved Features

3086, 3852, 3869,3870, 4082, 4267 : Implemented NAV Adapter to avoid duplicate tables
3982, 4144, 4396, 4435: Update BC Extension to Support latest version of BC

Resolved Issues

Corrected an issue where in some cases, users would encounter an error when executing and deploying a data table. (4139)
Corrected an issue where project execution would fail in cases where a user had multiple BC365 data sources configured to use OAuth authentication. (4143, 4170)
Corrected an issue in Business Central where running a report with a table that contained more than 100,000 records would cause an error to occur (4159)

Jet Analytics Build 20.10.33

Release Date: 8/09/2022

Please install the latest BC Extension (version 1.0.0.32) to utilize 20.10.33 version of Jet Analytics.
You can find the latest BC Extension in App Source for BC Public Cloud or on the insightsoftware downloads page for BC On Prem.
For More information about the BC Extension Update, see the table at the bottom of this page.

New and Improved Features

3692, 3693, 3696, 3697: Improved performance of Web Services when using Jet Analytics with Business Central.
3732: Modified on-premises versions of Business Central extensions per MS "Universal Code" initiative.
3848: Improved security related to Jet Analytics URLs.

Resolved Issues

Corrected an issue where managed deployment in multiple environment transfer would not display an error message upon receiving an error.
Corrected an issue where Global DB would not save changes for Oracle data sources
Corrected an issue where “Save As” would not update distribution columns with the updated id.
Corrected an issue where in some cases users would receive an out of memory error after closing the Deploy and Execute dialog.
Corrected an issue where in some cases, the wrong project version would open when loading the deployed version of a project.
Corrected an issue where the application would sometimes freeze up when adding objects to the execution queue.
Corrected an issue where in some cases the “sort order” would revert after testing connection in the environment.
Corrected an issue related to validating the numeric scale when deploying a decimal field in the data warehouse.
Correct an issue where in cases where the execution tree in the dialog was too large, the application would crash.

Resolved Issues (ODX)

Corrected an issue where the activity timeout setting was missing from the global database setup, and the setting was ignored when transferring data from the ODX to MDW with azure data factory.

Jet Analytics Build 20.10.30

Release Date: 5/05/2022

New and Improved Features

3312: Implemented a new authentication method called "Client Credentials" that does not use tokens that will eventually expire, thus eliminating the need for re-authentication at that time.
3637: The BC/NAV adapter (SQL Provider) will now work with versions prior to BC 16 (e.g. CRM tables).
3499: Made performance improvements:
- Updated algorithm to improve overall performance.
- Added logging to assist with troubleshooting.
- Updated the TCP Keepalive setting to mitigate risk of issues that could result from Microsoft updates.
14049: Support for Service to Service authentication for Business Central 365 provider. The provider now supports Service to Service authentication.
13577: Updated ODX Oracle ADF data source to better support old versions of oracle.
12729: It is now possible to select a batch size when creating or editing a SQL data storage.
12488: Schedule Dialog re-design
11048: Updated global databases dialog to increase password security
12377: Added shortcut to Windows start for easier access to the configuration tool.
12101: Segmentation of ODX ADF data source executions. Improved Azure Data Factory execution to better support data sources with a large amount of tables.
12194: Added ODX Sandbox support
12100: Replaced ODX direct synchronization on ADF data sources. Improved the ODX Azure Data Factory logic so the ODX no longer needs to connect directly to the data source when reading meta data

Resolved Issues

3761: Corrected an issue where in some cases data was returned with missing tables when the total number of fields (across all tables) in the BC instance exceeded 100,000.
3567: Corrected an issue where duplicate data was being uploaded to the staging table when the number of records being queried exceeded 100,000.
11046: Field Transformation panel manipulates the input
- Fixed issue with input field sometimes wasn't updating the UI correctly for field transformation
11322: Script parameter mapping does not pickup renamed mappings
- Renaming an object in a script and then dragging the same object into the script again, would cause the second mapping to ignore the rename and just add it as a new mapping with the original name instead of reusing the first mapping and use the renamed value. This has been fixed, so when dragging in an object for the second time, then it will always use the value of the first mapping.
11394: Notification should have the bell as an icon for eventlog types
- Fixed incorrect icon for event log notifications
11450: Wrong icon for raw only system fields
- Fixed issue where the wrong icon was used for raw only system fields
11478: Object-level security on raw only fields fails
- Fixed issue with raw only fields and object-level security
11523: Uneven mapping count issue
- Fixed issue with calculating mapping count for uneven mappings
11772: Encryption on Global DW and Stage ConnectionStringProperties causes a corrupt repository
- Fixed an issue where the upgrade from 20.10.21 to 20.10.22 would leave Global Staging and Global Data Warehouse databases in an invalid state
11556: CData engine uses incorrect quoting for query table & query tool
- Fixed issue with quoting in the query tool and query tables
11459: Use the "confirm password" pattern in ODX Configuration tool
- Updated the pattern of setting up passwords in the ODX configuration tool
11683: Issue with empty username in ODX notification
- It was not possible to leave the username empty in the notification dialog
11908: Synchronize ODX objects does not update indexes
- fixed issue with suggested indexes on Valid for tables mapped from an ODX
11583: MDW/SSL: It is possible to execute steps for old project versions in the execution queue
- Fixed issue where objects from old project versions could be deployed in the execution queue
12055: Task count ignores deployment step selection when choosing to only deploy modified tables and views
- Fixed issue where deploy/execute dialog has incorrect check states in object tree view
11695: Business Central 365 - can only execute with two web requests at a time
- This has now been fixed. It will follow the number of threads an execution package runs in but since the execution is multithreaded and an execution can contain multiple execution packages running at the same time the number of web requests will be the highest "Max. Threads". When an execution package completes then next "Max. Threads" will be used if more execution packages is running.
12243: Business Central 365 SQL Provider - Read object issue when server and database collation conflicts
- A collation issue was fixed when extraction database structure from a Business Central 365 SQL Server database
12067: SAP Data Source force DATS data type to datetime2
- This is now optional and it is possible to choose SQL DateTime2, SQL DateTime and SQL Date. Default is SQL DateTime2
11894: SAP Data Source adds 1 extra precision for decimal data types
- This has now been fixed. An option to force all decimal data types to a precision of 38 has been added.
11989: SAP Adapter does cannot set "Extract data in background job"
- This has now been corrected.
12035: Continue with Existing data deletes all records when table is Incremental loaded and with Use hard delete is enabled
- This has been corrected. The error that caused a failing data source is now added to the execution message which is used for notifications and it can also be found in the execution package log history.
11875: High memory usage when executing a Data Warehouse
- This was caused by the way foreign key relations was checked, dropped and created. This issue was also present if no relation with type "Error - with physical relation" was present in the project.
12253: Issue with TimeXtender.DataManager.TXForm.AdjustForInvisiblePanels()
- Fixed an issue where scaling a form would crash the application. (AdjustForInvisiblePanels())
11724: Staging database menu decreases in size every time you open it if you have Window sizes set to remember always
- This got fixed when the option to remember windows sizes was removed.
12004: Executing CData rest provider in multiple environment transfer dialog is not working
- Fixed issue with rest data source when execution a remote server project in the multiple environment transfer dialog
12045: Executing data export tables in the execution queue fails with null reference error
- Fixed issue where executing data export tables in the execution queue failed
12072: Issue with deploying data cleansing procedures in the multiple environment transfer dialog
- Fixed issue where conditional lookup fields were sorted incorrectly for data cleansing scripts when deploying objects in the multiple environment transfer dialog
11692: Plain text connection string is available when setting up data sources in property grid
- This is now hidden. An option import and export a connection string has been added.
12183: Issue when adding incremental rules to tables in a business unit
- When creating an incremental rule and you select a field and right after deselect the field, the table was not marked as incremental.
- This has been corrected
12248: Find (CTRL-F) does not search in Custom Table Insert scripts
- This has been corrected
11741: ODX email notification UI is acting strange
- Updated UI for ODX notifications on critical errors
11609: Error when opening properties of a ODX SQL store
- Fixed issue where reading database properties of ODX SQL storage failed
11992: SAP Table CDS ignores "Activate Background Extraction" setting when generating SSIS package
- This has now been corrected.
11731: ODX to Data Warehouse transfer never transfer batch numbers when using "Limit memory use" on the ODX
11681: Timer in ODX tasks resets after 24 hours
- This has now been corrected.
11952: Issue with incremental load on query tables without subquery enabled
- Fixed issue where query tables in the ODX didn't work with incremental load when use subquery is disabled
12494: Data Warehouse tables with incremental load and delete handling does not truncate the primary key table (_PK)
- This has been corrected.
12455: ADF version 8.1.0.0 is not supported in ODX versions prior to 20.10.24
- version 8.1.0.0 has been removed and version 9.0.0.0 has been introduced.
12109: Allow ignore of mail server certificate errors on "Notification on Critical Errors"
- This is now possible with the option "When using TLS" and setting this to "Allow invalid certificate".
12567: Incorrect Accent grave sign in General ODBC setup
- The Accent Grave type was character ' this has been changed to `. ODBC connections using the Accent Grave are update to use the new Single Quot.
12650: Scaling issue with 'Select fields'
- This has been corrected.
12563: SSIS settings are not remembered in ODBC data source
- This has been corrected.
12588: Field display is missing space in 'Project Variables'
- This has been corrected.
12607: Project Variable script window radio buttons - switch between 'Translation' and 'Value Translation' doesn't properly work
- This has been corrected.
12653: Scaling issue with ODX Query Tool
- This has been corrected.
12489: Add Data Source: Copy/Paste is not working correctly for Name / Short name
- This has been corrected.
12807: BC 356Support for multiple selection rules
- BC 365 provider now supports multiple selection rules.
12698: Issue with ODX Alert notification logic
- Fixed issue where some cloud secret and other connection errors would not generate mail notifications.
13038: Changing the source table of a table insert does not remove selection rules
- Fixed an issue where changing the source table of a table insert would not remove selection rules depending on the "old" source table.
12735: Setting simple mode on table does not clear L and M tables
- This issue has now been resolved.
12650: Scaling issue with 'Select fields' dialog
- Source table columns now scale correctly.
13513: Unreadable text in "Wait dialog"
- We updated the UI, and will not show the text and not a black line when the text is to long.
12881: Stored procedure missing in custom view and custom table insert menus selection area
- This has now been added.
13594: Failure when trying to delete a conditional lookup with dependencies to a custom selection rule on a data warehouse table mapping
- Fixed issue when trying to delete a conditional lookup that has dependencies to a custom selection rule on a data warehouse table mapping.
13049: "When transfer fails" setting is not returned correctly for AX and NAV adapter
- The setting was read from the wrong source and it has now been corrected.
12758: Custom Views: Table Parameter Variant is inconsistent
- The variant now default to 'Valid Table'.
13402: Import Connection String option is missing in Global Databases for CData sources, Any Source ADO and Any Source OLEDB
- Added option to import and copy connection string when setting up global ADO, OLEDB and CData data sources.
3101: Issue with Advanced Dimension editor
- When running the Advanced Dimension Editor the end user was meet with the error: Could not load file or assembly 'TimeXtender.Jet.API, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null'.......
- This was caused by a wrong build configuration of the product. This has now been corrected.
13423: It is possible to Import connection string when a global database is selected (CData ,Any Source ADO, Any Source OLEDB)
- Fixed UI error when import connection string was enabled when using global databases.
13055: Notifications on errors do not work when happening on an additional data source
- This has now been fixed.
13396: Pre/Post scrips fails to load when applied to Step Transfer for a custom tables with customized SSIS package on business unit
- When deleting a custom SSIS package from a custom table on a business unit the pre- and post scripts was not removed from the Deploy and Execute transfer steps. This has now been corrected.
13529: Inconsistency in Global Database Any Source OLEDB
- Fixed issue with global OLEDB data source where changing the provider or connection string value would not updated the UI correctly.
13336: AX and NAV adapter sync. problem
- An issue was resolved when a field used as primary key was removed during synchronization of the adapter.
- When the error occurred a message was displayed saying "Deleted row information cannot be accessed through the row."
13135: Wrong FiscalDayOfYear in Date Table
- This has now been corrected.
12821: ADF supports changing of authentication type, but only one type is supported
- We removed the option so it will not confuse the end user.
12284: Timeout missing for data factory transfers
- It's now possible to set the timeout as hours, days or weeks. Default is 7 days.
13403: Import Connection String option is missing in database addition wizard on ODX
- Added option to import connection string when adding ADO, OLEDB and CData data sources in the ODX.
13200: Issue with batch number in ODX to data warehouse transfer
- Fixed issue with cleaning up duplicate data in raw table when moving from an ODX data lake to an on-premise SQL database with azure data factory with selection rules in the data warehouse destination table.
13230: Issue with Json version in configuration of TXIntegrationServices
- Fixed issue with Json version used for transferring SSIS data for sap data sources in the ODX.
13031: ODX Configuration Tool is setting wrong proxy password on rerun
- The correct proxy password is now used.
12729: ODX: issue with log size when using SQL storage
- It is now possible to select a batch size when creating or editing a SQL data storage. Fixed issue where a SQL storage would be created with a wrong collation and recovery mode.
13465: Uneven mappings fails when using a dot in table name with two or more source tables
- An issue was fixed where a data warehouse table with two or more source tables and with an uneven mapping of the source tables would create a wrong bulk copy view. Execution of the table would fail in data transfer when SSIS and Direct Read is not used as transfer method
13810: ADF version 9.1.0.0 doesn't work with older versions of TimeXtender (Prior to 20.10.27)
- This issue was resolved. Note: The option to use ADF in version 20.10.27 is no longer available.
13571: Frame does not align with grid in Add/Edit CData data source
- The data grid in the 'Edit CData Data Source' window now scales along with the frame.
13800: Scaling issue in Add field dialog
- Checkboxes in the 'Add Field' window should now be scaled correctly between 100-250%. The window should now also become a little taller in order to accommodate all checkboxes.
13852: Scaling issue in Advanced Settings in Add/Edit Data Warehouse dialog
- The activity timeout 'numeric up down' component should now scale correctly when going at 250% windows scaling or above.
14125: Scheduler sometimes starts packages twice
- There have been issues with the scheduler where it would start the same execution package within a few minutes. This should now be fixed so it's not possible anymore.
13857: First Character transformation is limited to 100 characters
- Updated First and Last characters in field transformation to support up to 2147483647 (int max) characters instead of the limit of 100
13672: Issue with deletes in additional data sources in BC Adapter
- Fixed an issue where additional connections would not get their _PK table truncated and therefore data that should have been deleted was still present.
13962: SAP Table Adapter - wrong conversion of D16D, D16R, D34D and D34R data types
- An issue was fixed where the interpretation of SAP data types D16D, D16N, D16R, D16S, D34D, D34N, D34R and D134S was wrong. They are now the corrected to be mapped to binary data type.
13974: Issue with filtering corrupt data when moving data from ODX SQL Storage to Data Warehouse
- Fixed issue with filtering of batch number when moving data from an ODX SQL Storage to a Data Warehouse
13878: Issue with ODX Execution items staying in "Pending" state
- Fixed issue where stopping an execution in the ODX execution queue would not update the UI.
14283: BC adapter SIFT option issue when using BC365 provider
- When changing the provider from a SQL provider to a BC365 provider the SIFT option gets disabled and left with the value from when the provider was a SQL provider. This has now been fixed.
14219: Incremental selection rule values are not updated correctly with +1 incremental rule
- Fixed an issue where having multiple incremental selection rules would result in data in the _I table to become incorrect.
14286: Out of memory exception when doing differential deployment on large projects
- If a lager number on tables are marked as modified and the differential deployment resolves them as not modified could cause the update of the tree view to fail with and out of memory exception. This has now been fixed.
14262: Sap - Wrong conversion of data type RAW
- An issue was fixed where SAP raw data type would double the length causing the SSIS package to fail on execution.
14183: Mapping in custom measure issue
- Custom measures would lose their mapping on a project close if the mapping was a custom field.
13861: Data source column names can become too long
- Fixed an issue where using a SQL Data Storage and having a data source with column names longer than 128 characters, would result in an error, as the maximum column name in a SQL server is limited to 128 characters.

Jet Analytics Build 20.10.26

Release Date: 12/09/2021

New and Improved Features

2113: Added OR clauses when more than one data selection rule is used.

Resolved Issues

3396: Able to synchronize data source with non-standard collation without error.

Jet Analytics 21.2.3 Build 20.10.22.64

Release Date: 08/25/2021

New and Improved Features

Added the ability to select OAuth2 Authentication for BC Adaptor (2240)

Resolved Issues

2632: Corrected an issue when using a direct SQL connection to show all enumeration option values for option tables and any extensions that have added custom enumerations.

3232: Corrected an error when Executing a table which includes fields where the “Display Name” differs from the “Database name”

3280: When viewing available translations on a new data source, the translations window populates with available languages.

8606: Business Central adapter: Username and password cannot be changed

8765: Cannot deploy primary key delete SSIS package when the data source is bit specific

8767: 32/64 bit execution engine stalls on deployment and execution when failing on initializing communication.

8811: Data Source Excel leaves out columns with type LongVarWChar - text column with more than 255 characters

8863: Error generating Super Natural Key on SQL Data Warehouse

8889: Oracle slow synchronization - affects all bit specific data sources

8892: Timextender memory leak - an issue on data source explorer

8925: SQL Data Warehouse has slow performance with identity insert, when using insert into a table - Data Cleansing

7884: "Cloud Repository is corrupt" is reported if the ODX is unable to reach the cloud repository

8850: "Specified cast is not valid" exception is thrown when the backlog was successfully created but the firewall blocked the request to add a project

8907: Azure Data Factory transfer to Data Lake can give an error: "Token has expired"

8911: Incremental load on decimal datatype is not working

8980: Qlik Sense terminate execution issue

8551: Oracle fails when using date fields as incremental load in ODX on OLE DB version

8907: ADF to ADLG2 token expiry issue

8959: Parquet and datetime2 issue

9017: Execution package with retries can return "Broken pipe" error

9039: Issue with execution package with retries

9033: ODX Parquet transfer can use all memory on large transfers

9118: ODX upgrade issue

9115: Table transfer from ODX to DWH fails when ODX table contains a DWH system field name

8659: Error when opening the errors menu when a table contains Geography data

8719: ODX tab closes on F5 (refresh)

9238: Having a Tag on a field mapped to ODX and ODX synchronizes will cause an error

9259: Issue with setting process affinity for more than 16 cores

8266: ODX Config allows you to enter project names of invalid length

9274: Azure access tokens are sometimes not refreshed and expire after an hour causing transfers to fail

9289: Database cleanup recognizes Semantic Security Table after schema change

9287: Azure access token timeout when transferring from Lake to DWH

9337: ADF SQL source incremental load value loses precision for datetime2 where precision is above 3

9344: Incremental load loses precision for datetime data type when the source is an ADF type

Numerous issues with windows and UI elements, that did not scale correctly with display scaling set to more than 100%, has been fixed. The application should now be fully DPI aware and usable on modern systems that default to a higher display scaling factor.

9228: Increase TIMEXTENDERTABLESCHEMA.FIELDHELPTXT to nvarchar(4000)

9428: NAV BC365 wrong conversion of DATE data type

9453: Nav query table - data type varbinary becomes unknown data type

9481: TimeXtender crash if you rename an execution package to an existing name

8969: ODX SAP DeltaQ delta load

9291: ODX get unresponsive when having a lot of execution logs

9457: ODX - temp folder is used for generating file names and will eventually get filled up

9001: Application secret is now obscured in the Global Database settings of the DWH Application secret in the user dialog for Global Database setting for DWH was in clear text

9538: SQL DWH - Conditional lookup is now correctly cast to the destination data type

The Data Cleansing script for MDW Tables on Analytics SQL Pool was missing an explicit data type cast on conditional lookup fields when the Lookup Aggregate option was set to None. This is important due to the use of CTAS pattern and table switching employed on this specific platform.

9550: Updated logic to support table inserts from views on Analytics SQL PoolWhen inserting data into a table from a view the databases on the Analytics SQL Pool platform do not support default values. Therefore the script has been adjusted to include getutcdate() as the value for [DW_TimeStamp] if such a column does not exist in the view.

9539: SQL DWH - Grouped None aggregated conditional lookups would look up the first lookup field for all lookupsThe Data Cleansing script for MDW Tables on Analytics SQL Pool with multiple lookup files would only lookup the first field when the Lookup Aggregate option was set to None.

9575: Supernatural keys based on transformed values now works on SQL DWHThe Data Cleansing script for MDW Tables on Analytics SQL Pool has been adjusted to apply custom transformation before applying supernatural keys. Before this, the script would result in an empty insertion.

9596: Custom Semantic Measure dialog can now be resized and maximizedThe dialog could not be resized and did not have a maximize option

8778: Improved messages at empty ODX Data Source SyncReformulating the system messages when setting up data sources and synchronization to help users take proper action when synchronization returns with empty results. It now includes a hint that filters on the data source could be too restrictive.

9033: Added an option to reduce memory consumption when transferring data from parquet files to SQL MDW through the ODX serverLimit memory consumption by subdividing parquet extraction into multiple column groups.

9291: The ODX can now handle a lot of execution logs without becoming unresponsiveDialog updated in wrong thread to inform the user of excessive log messages available.

9372: More robust error handling to fix issue with unsuccessful transfers from ODX to DWBuilding ODX failure handling more robust in case a data source transfer completed unsuccessfully, leaving the file Model.json in an invalid or missing state. The new routine will try to reestablish the old file or seeking out the last working version of the data source before the failed transfer.

9556: Improved incremental load on ODX to work with string data typeODX generated extraction script now applies the right MAX criteria to the query when extracting an incremental load based on a string data type. This would generate empty extractions previously.

9561: ADF Date datatype and Synapse transfer errorODX now identifies Date types as a native parquet data format and generates the proper table format for Polybase transfer in Analytics SQL Pool MDW.

9580: ODX can now creating a parquet file larger than 2GBThe variable containing the file position of the parquet file when we upload the data is an integer, but should be of type long. This meant that a file larger than 2147483647 bytes would overflow to a negative value and the upload will fail.

8537: Improve display of very large custom transformations etc.Very large custom transformation is now handled in the user interface to ensure a fast and stable workflow. This is done by limiting the quick tooltips.

9442: Faster repository loading through the dialog for administration of repositories The script for fetching the repositories and matching versions have been optimized to allow for faster retrieval and the general timeout setting for the repository has been added to this command execution too. This will allow even larger version history to be easy to load and maintain in the dialog.

9456: Optimizing the appearance of the dialogue Get StaredWith certain display setting the dialog would appear exceptionally large. This is optimized to ensure at more proportional displaying.

9603: Fully qualified names in Custom measure script in Shared Semantic Access LayerIn some instances the fully qualified names was not displayed in the custom measure scripts even though it was set to do so. This has been improved to handle these instances and insure the proper code is generated for the endpoint.

9654: Improving data cleansing script generation for custom transformationsThe situation with similar column names in lookup tables could generate invalid transformations scripts for databases running in Synapse Analytic SQL Pool. Proper aliasing is now applied to the script to allow for this situations to be handled safely too.

9658: Any source OLE DB and Any source ADO - improved adding and editing filtersIn some cases adding and editing filter models on this data source would not save the changes. This is now improved to safely capture all your changes.

9659: Removed a programming glitch from Resume Execution featureUpdating the UI produced an error that effectively make resume execution impossible to perform.

9691: Drag and drop fields now supported for Data Export tablesYou can now drag and drop fields in the selection rules dialog

9695 Adjusting dialog input to actual field sizesInput validation have been adjusted to ensure proper data length and eliminate issues due to overflowing in some extreme case.

9708: DB/2 data sources (IBM Managed) would produce error when trying to connect.This have been changed to avoid unnecessary connection attempts that would result in errors.

9725: Updating a project variable refreshes displayed custom transformation automaticallyWhen a custom transformation on a table field uses a project variable a value change in this variable is now instantly displayed in the user interface for this custom transformation.

9726: Allow long running cleanups of old metadata extractionsOn large data sources with the application now allows the clean up process to be performed without timing out and producing an unspecified error.

8504 Added extra info on dialog for Scheduled TasksThe name of the data source have been added to help the user identify the individual tasks in the dialog. This have become even more relevant now that the requirement of uniqueness for task names have been lifted.

9663 ODX supports passthrough of data type RealUsing ADF to populate the data lake now supports the data type Real natively in Parquet files. This makes it possible to move this data type directly in to Synapse Analytics SQL Pool via Polybase for high throughput cases.

9816 Support translations for NAV adapter using BC365 connectorThis new functionality will provide translations in a user defined language for table names, field names and option values

7265: New UX behavior when setting hash distribution column for DW in Synapse SQL pool (SQL DW)The logic for automatically setting a column for HASH distribution will skip DW_ID as default because identify columns are not allowed for HASH distribution.

8262: SQL script editors now also recognize min() functionFor code markup the min() function will now show up in the proper color in the code editor.

8449: New icon for tables running in simple modeThe icon is now aligns with the current UI styling

9884: Stabilized ODX to DW transferWhen TX moves data from a ODX Data Lake to the MDW using ODX for the transfer, having a selection rule on incremental data, and update/delete, then the the operation could fail due to an attempt to delete a temporary table twice.

9600: Issue with differential deployment for simple mode tables within name on data warehouseThe differential deployment was fixed for tables within the name.

9815: CData data source - Setting up incremental load fails with "There is already an object named '<table name>_I' in the database"This happens when editing an additional CData data source and subsequently deploying a increment load table from the data source.

9902: Oracle data source returns double character length for character columns using Units: CharThe change reserves less space in SQL Server database and saving the user from adding data type overrides.

9927: Qlik Sense Desktop is not workingThis was caused by outdated Qlik SDK- The Qlik SDK was updated.

9968: Custom Hash fields are included in the Clustered index when set to primary keyThe custom hash fields are no longer included in the clustered index. This will speed up insert and updates on tables with custom hash fields set to primary key.

9981: Custom transformation view on a table keeps re-deploying with differential deploymentThe logic was fixed for detecting changes for deploying data cleansing with customizations enabled.

3119/9985: Business Central Adapter - support tables and fields with same translationsDuplicate naming issue is now handled for Business Central adapter.

9986: Incorrect display of execution setup typeWhen displaying the execution setup type the result could be incorrect and displaying both full loaded and guarded.

9758: Missing severity type in ODX Service Log dialogAdded the severity type "System Service Info" to the filter option

9989: Test connection on add ODX Azure Data Factory source not workingAdded test connection logic to ODX Azure Data Factory source setup.

8706: Securable view override

Reusing the same secure column on the same table now overwrites the first secured view ensuring that you will only have one view pr. table per secure column.

9759: Resolve issue with SMO 2019 having dependency to SMO 2016 Updated the system DLLs and object changes to support SMO 2019 without references to the older version. This will simplify installation for a 2019 SQL environment.

9916: UI: Wrong icon for inactive dimension level on parent-child-dimension

Inserted the proper icon for inactive dimension level on parent-child-dimension.

9937: Wrong field mapping to conditional lookup fields

When dragging fields from and ODX data source a mix-up of conditional lookup fields and data movements was possible to generate in case when field names was similar. There is now implemented a check to prevent this.

9983: Primary Key violation ScheduledJobLogs on version rollback

The data model for storing your work in TimeXtender is now changed to handle the rare case of rolling back to an older version of a project and then triggering an execution that would generate an execution with and already existing execution number.

10050: Change data source from SQL to Any Source ADO.Net fails with data source already exists error

It is now again possible to switching from a SQL source to an Any Source ADO.net without getting and error saying that the source already exists.

10102: Application crash in validate model on semantic layer

Well, now it don't.

10114: Editing a Qlik view tables affix setting does not update the user interface

This action now triggers the user interface to update and show the changes.

10131: OLAP icon inconsistent in Script Commands

Inserted the proper icon in the Script Commands

10135: Issue with deploying write back table for cube

Added the checksum calculation that was missing on updates so now it will deploy again.

10206: Preview table from custom data source does not work (including query tool)

You can now preview any table from a Custom data source on the source level and use the query tool for any table from a Custom Data source which supports it on the source level.

10257: Null reference exception when deploying extended properties in SQL DB

Deployment will now ignore extended properties that are not strictly TimeXtender maintained and no conforming to our formats.

9306: Support source databases where tables do not have a schemaCleaned up user interface to ensure that data sources with out schemas is handled too.

9555: Issue with synchronizing ODX task state after ODX shutdownDuring startup the ODX server will now update any tasks left in a previous running state after an unscheduled shutdown.

9904: ODX ADLS to DW transfer fails when transferring more than one file with limit memoryUsing the new feature for partitioned parquet file extraction could lead to errors if more that one file engaged the limited memory features at the same time.

10213: Retry execution package in ODXIt is now possible to activate retry on ODX tasks. There are 2 events that can trigger the retry: Task failed and Task finished with errors. The user can configures between 1 and 5 retries and a delay between 1 and 60 minutes. A delayed retry is canceled if ordinary scheduling of the task will start earlier than the retry.

10309: ODX Alert mail server tries to authenticate empty userThe application will now use the proper format for situations without any user/password authentication. E.g. Situations on internal SMTP servers.

10124: Editing a concatenated table in Qlik fails with a null reference errorIt is now again possible to edit a concatenated table in Qlik.

10257: Better handling of database objects with extended properties from other sourcesWhen deploying we examine the extended properties of database object which could result in errors if they didn't conform to the TimeXtender data types. Now we will ignore extended properties that are not directly managed by TimeXtender.

10288: Fixed the cases where the execution overview sometimes would double entries.This was only a display problem that had no impact on actual execution.

10296: Validation for DW_Id field mapping when mapped from another data warehouseWe have improved the validation of DW_Id field mapping that is imported from another data warehouse to avoid getting the exception: Column 'DW_Id' does not allow DBNull.Value.

10311: Selecting SIFT tables on Business Central Adapters are now possible againAfter implementing the BC adaptor logic the ability to add SIFT tables was lost. This is now fixed.

10435: Failing to load parameters for custom selection rules on table mappings.Custom selection rules were unable to map the parameters to datafields. This is now corrected

10295: Improved handling varbinary field for Incremental loading on Custom SQL Data Source

We have added an improved datatype conversion for varbinary fields on the above data source allowing the ODX to handle much bigger integer values than previously.

10432: Speeding up preview of data using data lake.In the internal data handling has been optimized to speed up the transfer from ODX to Desktop Application when the user request a preview of the data contents in the ODX data lake.

10500: We have added the TABLOCK hint to the insert operation for batch data cleansingWhen inserting data into the valid table we suggest to the server that it should take out a TABLOCK.

10576: SQL Database Cleanup Tool now recognize security tables for SSL tabular endpointThe SQL Database Cleanup Tool would wrongly suggest to drop the security tables for SSL tabular endpoint. They are now recognized as belonging to the project.

10583: Unable to delete business unit lookup fieldIf a lookup field is used in a selection rule on another table, deletion of the lookup field fails and throws an error.

10619: OLAP Roles can now have different MDX statementsWhen setting up Olap Roles with the use of MDX expressions it was not possible to use different expressions. It is now.

10678: Some tables are excluded from the Business Central SQL providerWhen a none account dependant table contains a $ sign in its name it would be excluded if it did not start with the account template name. This has now been fixed

The ODX had some structural updates.

2994: Show uneven mappings under tablesShow Uneven mappings can be enabled or disabled in the menu View -> Uneven mappings. When enabled the number of mappings will be displayed on the table and its fields if the table is unevenly mapped.

10684: Business Central Adapter - BC 365 provider support for OAuth authenticationThe provider now has support for OAuth authentication

10735: External SQL Connection data transfer cannot transfer TX System fieldsWhen pointing an External SQL connection to a data warehouse database and selecting to transfer data, the mapping of TX system fields would fail because of wrong naming. This has been fixed so the mapping works again.

10743: Error Deploying Permissions based on Schema on SynapseSetting up security on a schema in Synapse would result in an error when trying to deploy the security. This was due to an incorrect syntax when trying to apply the security to the schema."

10761: Circular reference issue in ODX OleDb EngineSpecific method calls on an OleDb data source would trigger a circular reference, that would eventually cause the program to crash. This circular reference has been fixed.

10763: Issue with synchronizing ODX data source name overwrites the unique short nameIn specific cases, the ODX data source name would overwrite the unique short name on synchronization. This has been fixed so it's not possible anymore.

10770: Scheduler can start the same execution package 2 times with a 2 minute delayIn very rare cases where the connection to a repository database in the cloud was unable to be established, the scheduler could start the same execution package 2 times within 2 minutes. This have been fixed, so it's no longer possible.

10788: Error synchronizing AX Adapter EnumsFixed an issue where the synchronization would remove all enum tables

10918: Conditions are ignored on Semantic Selection rulesConditions on selection rules in a semantic layer were being ignored. This has been fixed, so conditions are now taking into consideration in the selection rule.

10954: Deploy using an External SQL connection throws "Object reference not set to an instance of an object"A recently added validation check for field mapping count caused an object null reference when trying to deploy a table from an External SQL connection

10782: Deadlock on executions from ODXFixed potential deadlock issue when using an ODX SQL Storage and using the same database as the data warehouse database in the MDW.

10907: ODX - Support for tables containing single quote in schema or/and name for SQL StorageApplied correct escaping of single quote when extracting information about the table in the SQL Storage

11029: Deleted semantic fields don't remove all related semantic perspective itemsFixed an issue where deleting a semantic field that is used in a perspective did not get remove from the perspective

11034: Errors when using dynamic variables in Azure SQL DBUsing dynamic variables when using an Azure SQL DB could sometimes cause execution to fail

11065: ScintillaNET issue loading SciLexer.dll from Temp directoryFixed an issue where ScintillaNET could not load SciLexer.dll from the user temp directory

11092: Missing encryption in global database repository tableFixed that some properties were not encrypted in the repository table dbo.GlobalDatabases

11068: Issue with ODX Column Filter dialogFixed issue where ODX Column Filter UI was not updating the list of rules

11074: ADF Concurrency -> ForEach BatchCount parameterFixed issue where ODX Azure Data Factory concurrency setting was mapped incorrectly

Jet Analytics 2020 (20.10.1)

March 27, 2021

New and Improved Features

Data Lake-optimized ODX storage implementation including file format change to Parquet

Automatic incremental load from the ODX into a data warehouse

Alerts and e-mail notifications on critical errors in the ODX service

New ODX tab where you can browse the data storage, see information on storage on the table level and select tables for the data warehouse

Data source explorer with functionality for confirming that selection rules, incremental load rules etc. work as expected

Independent synchronize and transfer tasks to make task schedules more transparent

Project lock to prevent multiple ODX servers from using the same ODX project

Safe shutdown of ODX server to make upgrading easier

Improved logging UI and less logging of redundant information

Ability to connect to initializing ODX server from the Jet Analytics application

Fixed

7021: Unable to remove pending tasks in ODX Execution Queue

7821: SQL Server Logins results in error on Azure SQL DB

8403: SSL: Format string defaulting to Invariant Language

8575: Project variables object null reference when edited without opening the script editor