20.10.1 - Initial Release

Release Documentation

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

Fixed in 20.10.2

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

Fixed in 20.10.3

• 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

Fixed in ODX 20.10.3

• 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

Fixed in 20.10.4

• 8980: Qlik Sense terminate execution issue

Fixed in ODX 20.10.4

• 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

Fixed in 20.10.5

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

Fixed in 20.10.6

• 9039: Issue with execution package with retries

Fixed in ODX 20.10.6

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

Fixed in ODX 20.10.7

• 9118: ODX upgrade issue

Fixed in TimeXtender 20.10.8 and ODX 20.10.8

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

Fixed in 20.10.9

• 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

Fixed in ODX 20.10.9

• 9259: Issue with setting process affinity for more than 16 cores
• 8266: ODX Config allows you to enter project names of invalid length

Fixed in ODX 20.10.10

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

Fixed in 20.10.11

• 9289: Database cleanup recognizes Semantic Security Table after schema change

Fixed in ODX 20.10.11

• 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

Fixed in 20.10.12

• 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

Fixed in ODX 20.10.12

• 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

Fixed in 20.10.13

• 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 Pool
  When 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 lookups
  The 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 DWH
  The 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 maximized
  The dialog could not be resized and did not have a maximize option

Fixed in ODX 20.10.13

• 8778: Improved messages at empty ODX Data Source Sync
  Reformulating 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 server
  Limit memory consumption by subdividing parquet extraction into multiple column groups.
• 9291: The ODX can now handle a lot of execution logs without becoming unresponsive
  Dialog 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 DW
  Building 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 type
  ODX 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 error
  ODX 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 2GB
  The 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.

Fixed in 20.10.14

• 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 Stared
  With 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 Layer
  In 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 transformations
  The 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 filters
  In 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 feature
  Updating the UI produced an error that effectively make resume execution impossible to perform.
• 9691: Drag and drop fields now supported for Data Export tables
  You can now drag and drop fields in the selection rules dialog
• 9695 Adjusting dialog input to actual field sizes
  Input 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 automatically
  When 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 extractions
  On large data sources with the application now allows the clean up process to be performed without timing out and producing an unspecified error.

Fixed in ODX 20.10.14

• 8504 Added extra info on dialog for Scheduled Tasks
  The 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 Real
  Using 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.

Fixed in 20.10.15

• 9816 Support translations for NAV adapter using BC365 connector
  This 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() function
  For 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 mode
  The icon is now aligns with the current UI styling
  
  

Fixed in ODX 20.10.15

• 9884: Stabilized ODX to DW transfer
  When 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.

Fixed in 20.10.16

• 9600: Issue with differential deployment for simple mode tables with . in name on data warehouse
  The differential deployment was fixed for tables with . in 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: Char
  The change reserves less space in SQL Server database and saving the user from adding data type overrides.
• 9927: Qlik Sense Desktop is not working
  This 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 key
  The 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 deployment
  The logic was fixed for detecting changes for deploying data cleansing with customizations enabled.
• 9985: Business Central Adapter - support tables and fields with same translations
  Duplicate naming issue is now handled for Business Central adapter.
• 9986: Incorrect display of execution setup type
  When displaying the execution setup type the result could be incorrect and displaying both full loaded and guarded.

Fixed in ODX 20.10.16

• 9758: Missing severity type in ODX Service Log dialog
  Added the severity type "System Service Info" to the filter option
• 9989: Test connection on add ODX Azure Data Factory source not working
  Added test connection logic to ODX Azure Data Factory source setup.

Fixed in 20.10.17

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

Fixed in ODX 20.10.17

• 9306: Support source databases where tables do not have a schema
  Cleaned up user interface to ensure that data sources with out schemas is handled too.
• 9555: Issue with synchronizing ODX task state after ODX shutdown
  During 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 memory
  Using 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 ODX
  It 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 user
  The application will now use the proper format for situations without any user/password authentication. E.g. Situations on internal SMTP servers.

Fixed in 20.10.18

• 10124: Editing a concatenated table in Qlik fails with a null reference error
  It is now again possible to edit a concatenated table in Qlik.
• 10257: Better handling of database objects with extended properties from other sources
  When 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 warehouse
  We 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 again
  After 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

Fixed in ODX 20.10.18

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

Fixed in 20.10.19

• 10500: We have added the TABLOCK hint to the insert operation for batch data cleansing
  When 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 endpoint
  The 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 field
  If 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 statements
  When 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 provider
  When 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

Fixed in ODX 20.10.19

• The ODX had some structural updates.

Fixed in 20.10.20

• 2994: Show uneven mappings under tables
  Show 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 authentication
  The provider now has support for OAuth authentication

• 10735: External SQL Connection data transfer cannot transfer TX System fields
  When 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 Synapse
  Setting 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."

Fixed in ODX 20.10.20

• 10761: Circular reference issue in ODX OleDb Engine
  Specific 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 name
  In 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.

Fixed in 20.10.21

• 10770: Scheduler can start the same execution package 2 times with a 2 minute delay
  In 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 Enums
  Fixed an issue where the synchronization would remove all enum tables

• 10918: Conditions are ignored on Semantic Selection rules
  Conditions 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

Fixed in ODX 20.10.21

• 10782: Deadlock on executions from ODX
  Fixed 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 Storage
  Applied correct escaping of single quote when extracting information about the table in the SQL Storage

Fixed in 20.10.22

• 11029: Deleted semantic fields don't remove all related semantic perspective items
  Fixed 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 DB
  Using dynamic variables when using an Azure SQL DB could sometimes cause execution to fail
• 11065: ScintillaNET issue loading SciLexer.dll from Temp directory
  Fixed an issue where ScintillaNET could not load SciLexer.dll from the user temp directory
• 11092: Missing encryption in global database repository table
  Fixed that some properties were not encrypted in the repository table dbo.GlobalDatabases

Fixed in ODX 20.10.22

• 11068: Issue with ODX Column Filter dialog
  Fixed issue where ODX Column Filter UI was not updating the list of rules
• 11074: ADF Concurrency -> ForEach BatchCount parameter
  Fixed issue where ODX Azure Data Factory concurrency setting was mapped incorrectly

Fixed in 20.10.23

• 11046: Field Transformation panel manipulates the input
  
  Fixed issue with input field sometimes wasn't updating the UI correctly for field transformation
• 11048: Mask passwords for global databases
  Updated global databases dialog so passwords are masked when typing them
• 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

Fixed in ODX 20.10.23

• 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

Fixed in 20.10.24

• 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
  An 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
  The 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

Fixed in ODX 20.10.24

• 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
• 12101: Segmentation of ODX ADF data source executions
  Improved execution with Azure Data Factory to better support data sources with a large amount of tables. Tables are now segmented into big groups.
• 12194: ODX Sandbox support
  Added support for Sandbox ODX
• 12100: Replace ODX direct synchronization on ADF data sources
  Improved the ODX Azure Data Factory logic so the ODX no longer need to connect directly to the data source when reading meta data

Fixed in 20.10.25

• 12494: Data Warehouse tables with incremental load and delete handling does not truncate the primary key table (_PK)
  This has been corrected.

Fixed in ODX 20.10.25

• 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".
• 12377: Add Shortcut to ODXServerConfiguration to windows start
  Added shortcut to Windows start to have easier access to the configuration tool.

Fixed in 20.10.26

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

Fixed in ODX 20.10.26

• 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.
• 12729: Option for batch size for ODX SQL Store
  It is now possible to select a batch size when creating or editing a SQL data storage.
• 12488: Schedule Dialog re-design
  The dialog got a brush-up.
• 12698: Issue with ODX Alert notification logic
  Fixed issue where some cloud secret and other connection errors would not generate mail notifications.

Fixed in 20.10.27

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

Fixed in ODX 20.10.27

• 12821: ADF supports changing of authentication type, but only one type is supported
  We removed the option so it will not confusion 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.
• 13577: Update oracle ADF data source meta selection scripts to support old oracle versions
  Updated ODX Oracle ADF data source to better support old versions of oracle.

Fixed in 20.10.28

• 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

Fixed in ODX 20.10.28

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

Fixed in 20.10.29

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

Fixed in ODX 20.10.29

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

Fixed in 20.10.30

• 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.
• 14049: Support for Service to Service authentication for Business Central 365 provider
  The provider now supports Service to Service authentication
• 14183: Mapping in custom measure issue
  Custom measures would lose their mapping on a project close if the mapping was a custom field.

Fixed in ODX 20.10.30

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

Fixed in 20.10.31

• 14467: Change request: "Show Execution logs" - display the newest logs
  The newest logs are now shown in the Execution logs
• 14480: Managed Deployment in Multiple Environment transfer doesn't show error message on error
  This has now been corrected.
• 14404: Global DB does not save changes for Oracle Data Source
  This has now been corrected
• 14756: Save as will not update distribution columns with their new id
  This has now been corrected.
• 14742: Out of memory exception after closing deploy and execute dialog
  This could happen when the dialog tree would contain a lot of nodes. This has now been resolved.
• 14736: Open Project stored procedure returns wrong project version when loading the deployed version of the project
  This has now been corrected.
• 14746: Missing wait dialog when adding objects to the execution queue
  This has now been implemented and it will not freeze up the application.
• 14301: Maintain the sort order after test connection in environment
  This has now been corrected

Fixed in 20.10.32

• 14595: Global DW database missing activity timeout for ADF transfer
  Fixed issue where transferring data from the ODX to an MDW with azure data factory would ignore the activity timeout setting. Additionally the setting was missing from the global database setup.
• 15108: Issue with validating numeric scale in data warehouse
  Fix the validation, when deploying a decimal field where the precision is larger than scale.
• 15302: Crash when starting and execution package in Execution Dialog
  An issue was fixed that could cause the application to crash if the Execution tree in the dialog is very large

Fixed in ODX 20.10.32

• 14595: Global DW database missing activity timeout for ADF transfer
  Fixed issue where transferring data from the ODX to an MDW with azure data factory would ignore the activity timeout setting. Additionally the setting was missing from the global database setup.

Fixed in 20.10.34

• 14845: Reading data source value for Separator fails in the UI for ADO and OLEDB
  Fixed issue with suggesting the separator value when setting up advanced settings for ADO and OLEDB data sources
• 15252: Issue with Qlik row level section access script when data warehouse has postfix tables
  Fixed issue with Qlik Section Access scripts when the tables had postfix enabled.
• 15520: Long warning message and no scrollbar
  Improved warning message handling when toggling field to raw-only
• 15540: It is possible to use Raw-only fields in hierarchy tables
  Fixed an issue where it was possible to use a raw-only field in hierarchy tables.
• 15553: Issue with changing snippets
  Fixed an issue when changing Snippets, that the change wasn't saved properly, and therefore upon reopening a project, the old snippet would still be shown as the selected snippet.
• 15608: Wrong decimal scale and precision error when using Direct Read
  Fixed an issue with wrong validation of scale and precision when using Direct Read as the transfer option when changing a field from varchar(max) to decimal.
• 14618: Memory leak when clicking update in the ODX Execution log
  Fixed potential memory leak when continuously refreshing specific logs
• 15633: SAP Table Adapter is not working with version 6.11.1.3 and later of Theobald XTract IS
  An issue was fixed where the value used for ColumnNameStyle changed behavior. This has now been corrected.
• 15702: UI issue: Sorting does not work in 'Synchronize view fields' - Field Mapping -> 2nd Column (Current Fields)
  Fixed issue where sorting "Current Fields" in the View Synchronization dialog on data warehouses didn't work

Fixed in ODX 20.10.34

• 14764: Error managing ODX security roles members
  Fixed an issue when trying to manage ODX security role members when using Data Lake as a storage container.
• 15230: ODX: Transfer data to a Data Lake while using a windows reserved folder name as data source name fails
  Fixed issue with transferring data to a data lake in the ODX when using a windows reserved file name as data source short name
• 15314: Integration Runtime not set for data flow transfers
  Fixed issue where Integration Runtime was ignored for transfers from the ODX to the MDW when transferring with Data Flows
• 15775: Execution failed: The underlying connection was closed
  Fixed performance issue with the Data Lake REST API (The underlying connection was closed)
  Added additional general optimizations for the AZURE REST APIs

Fixed in ODX 20.10.35

• 16438: ODX ServiceUserCache has concurrency issues
  An issue was fixed where registration of ODX users last activity could fail.
• 16465: Issue with ODX Execution items stays in "Pending" state
  This has been corrected

Fixed in 20.10.36

• 16822: Support for OAuth2.0 notification emails using Office365
  Basic authentication has been disabled by Microsoft for Office365. Office365 is now supported with OAuth2.0 authentication

Fixed in ODX 20.10.36

• 16600: Transfer Query Table with Column Select to data lake fails
  Fixed issue where using column selection to remove columns from query tables will fail execution when using a data lake
• 16822: Support for OAuth2.0 notification emails using Office365
  Basic authentication has been disabled by Microsoft for Office365. Office365 is now supported with OAuth2.0 authentication
• 16893: Preview ODX query tables makes incorrect selection query
  Fixed issue where previewing a query table in the ODX sometimes wouldn't suggest the query tables statement, but instead use Select * from...

Fixed in 20.10.37

• 16023: Multiple environment perspective deploy always includes all incremental loaded tables
  When deploying a perspective all incremental tables in the project was added to the deployment. This has now been corrected so it will only bring in the tables where the incremental load has a change that requires deployment.
• 16376: Selecting execution logs from repository takes a very long time
  This has been resolved.
• 17080: Backup Azure repository also upgrades the backup
  Fixed an issue during the upgrade of TimeXtender, where creating a backup of a repository placed on an Azure SQL server would cause the backup repository also to be upgraded to the new version.
• 17079: SMTP server does not support authentication
  If a user do not enter a password on the credential page, TimeXtender will send the mail as the SMTP server does not support authentication.
• 17142: Business Central and AX Adapter: Selecting or deselecting a new account can make the application crash
  In some cases when changing a setting on the adapter which will update many tables, the application can stall for a long time or crash. This issue has now been resolved.
• 17180: Issue with save project as when SQL Snippets uses SQL Snippets as parameters
  When using having as SQL Snippet view using other SQL Snippet views a Save as on the project could make the save as project in a state where it could not be opened. This has now been corrected.
• 17242: Changing setting in table setting can cause a wrong validation error: System field "Is TombStone" cannot be removed
  This has been resolved

Fixed in ODX 20.10.37

• 17072: Gets error about missing system.memory.dll when synchronizing a ADF data source
  Fixed an issue where synchronizing an ADF data source would fail because of a problem with System.Memory dll.
• 17075: Issue with System.Memory in the ODX causes transfer from ODX Data Lake to MDW to fail
  Fixed an issue where transferring data from ODX Data lake to an MDW would always fail because of a problem with System.Memory dll.
• 17079: SMTP server does not support authentication
  If a user do not enter a password on the credential page, TimeXtender will send the mail as the SMTP server does not support authentication.

Fixed in 20.10.38

• 17266: ODX DL to DW Azure Synapse Dedicated SQL Pool Incremental Load & hard delete results in valid table truncation
  There was an issue where incremental load from the ODX using data lake as storage to a Data Warehouse using Synapse Dedicated SQL Pool would not transfer primary keys when no new data exists in the ODX, which would cause the valid table to be truncated. This has now been fixed.

Fixed in 20.10.39

• 17494: Incorrect error message when sending a test mail notification
  An Error message will not show if a test mail returns 2.6.0 Queued mail for delivery

• 17521: Adding both pre and post steps on deployment for an incremental table will not redeploy the valid and incremental tables on "full load deploy"
  This issue has been corrected so the order of the deployment is correct when having pre and post steps on Step Table Structure Deploy.

• 17627: Business Central adapter - Merge extension tables option for SQL Server provider
  Added option to merge a table and its extension tables together as one table.

• 14818: Incremental load with hard deletes issue - Primary key validation error will remove all rows for the primary key in the valid table
  This has now been fixed

• 17614:  Test notification mail only accept response 2.0.0 and 2.6.0 as a success
  This has been corrected and response 2.x.x is now treated as a Success.

Fixed in 20.10.40

• 16442: Apostrophe in field name gives error in Synapse DW
  Fixed an issue where having an apostrophe in the name of an object in Synapse would cause issues with deployment and execution
• 17350: Controls not available in error message screen when resetting supernatural keys
  Fixed an issue where message for resetting the key store could extend the message box
• 17388: Username in work items are case sensitive
  Fixed comparing the username for work items to be case insensitive.
• 17855: Resume function skips Table Insert and Related Records
  This has now been corrected.
• 17789: Business Central adapter enhancements enabled/disabled options doesn't wok as expected
  Fixed an issue allowing wrong setting the dialog(s) for setting up Business Central adapter that would correct it self but be confusing for the end-user.
• 18175: Incorrect syntax using "Table Usage" on BC Adapter
  When setting up table usage for accounts in the BC Adapter to be None a data type statement was missing in the creation of the stored procedure used for moving data from the temp table to the raw table. This has been corrected.
• 18226: Error information are missing when notification test mail fails
  Fixed issue when the test mail function under notification fails and did not show the full error message.

Fixed in ODX 20.10.40

• 18085: Issue with Select Tables and Select Columns
  Fixed an issue where Select Tables and Select Columns in the ODX would fail because of a version problem with System.Memory dll.

Fixed in 20.10.41

• SQL Server 2022 support
  TimeXtender 20.10 now supports the latest and greatest major release of Microsoft SQL Server for use as a data warehouse or ODX data storage. 
• 18354: Error when opening Error view when using Keep Lookup values up to date
  Opening the Error view would result in an error in a specific setup involving the 'Keep field values up to date' option.
• 18414: Tabular processing is not showing error
  Changed the way processing of Tabular models is done - this will now show a more detailed exception when something goes wrong while processing a model.
• 18517: Notification email option changes - white space in to and cc mails is no longer allowed
  Fixed an issue where whitespaces in To and CC fields would fail the send of mail
• 18538: Open table settings dialog in business unit with full load enabled doesn't disable the incremental load settings
  This has been fixed

Fixed in ODX 20.10.41

• 18482: Batch count not set on ADF ODX to MDW transfer
  Fixed an issue where transfers with Azure Data Factory from the ODX to the MDW didn't set the batch count.

Fixed in 20.10.42

• 18613: Adapter BC SQL - Windows Authentication is not working
  This was fixed and the Windows Authentication option is now working again.

Fixed in 20.10.43

• 18636: Preview View is not working
  Fixed an issue where the preview command on a View in the MDW didn't show any data.
• 18659: Data Factory transfer from ODX to MDW is not unique across environments
  Fixed an issue where transferring data with Azure Data Factory from an ODX to the MDW would not create unique resources for different environments. The resources created will now have an identifier for what environment it belongs to when environments are set up.
• 18679: Application crash on add additional data source
  Fixed an issue where adding additional data sources could cause a memory issue in the UI.
• 18738: Background Execution property is not set if running new version of XtractIS
  Fixed an issue where SAP Table data sources would not activate background execution when running XtractIS version 7.1.1 and later
• 18761: Null reference error on copy connection string
  Fixed potential null reference error on copy connection string
• 18917: AX and BC adapter does not support Integration Services 2022
  Fixed an issue where AX and BC adapter could not Integration Services SSIS 2022
• 18920: Issue in BC Adapter wizard for SQL Provider when enhancements are not avaliable
  Fixed an issue where disabling enhancements in the wizard would not be remembered.
• 18946: Outdated SqlClient causes server connection to not list existing database when setting it up as Initial Catalog
  Fixed issue where SqlClient was not able to connect to an existing database after upgrade

Fixed in ODX 20.10.43

• 18659: Data Factory transfer from ODX to MDW is not unique across environments
  Fixed an issue where transferring data with Azure Data Factory from an ODX to the MDW would not create unique resources for different environments. The resources created will now have an identifier for what environment it belongs to when environments are set up.

Fixed in 20.10.44

(2023-09-18)

• 19064: Missing catch of Microsoft.Data.SqlClient.SqlExceptionin for SQL Engine 2022
  We fixed an issue where we didn't catch all exceptions during deployment.
• 19097: BC365 does not supply Flow Fields
  This has now been corrected.
• 19100: Business Central Adapter translation issue
  The translations for tables and fields extracted from BC can contain only space (one or more). The space(s) would become the table or field name in TimeXtender. Tables with the corresponding amount of spaces will be merged to one table containing all fields from all tables. This has now been corrected.
• 19137: Cannot deploy the data warehouse using authentication 'Active Directory Password Authentication'
  Fixed an issue where it wasn't possible to use the 'Active Directory Password Authentication' method to authenticate.
• 19158: Unable to deploy after upgrade
  We fixed an issue where the ConnectionStringProperties would be double encrypted where it wasn't supposed to.
• 19178: Error when deleting custom periods in Date Table
  This has now been corrected.
• 19273: Semantic model missing from deployment menu when using a perspective
  Fixed an issue where a Semantic Model wasn't shown in the deployment menu when added to a perspective and trying to deploy that perspective.
• 19279: ODX storage Command timeout cannot be set to infinite
  Fixed an issue where you could set the command timeout to infinite on the ODX ADLS storage. This isn't supported in the API, and therefor the option has been removed.
• 19311: Optimize StepRowCountLoggingExecute.cs (logging of rows)
  The logic behind the Step Row Count has been optimized.
• 19332: Error reading from BC Cloud
  Fixed an issue where you would get an execution error when deploying a simple mode table, where the name included a dot (.) in its name and where the schema for valid and raw was different.
  
  A table coming from a Business Central adapter that includes a dot (.) in its name, has different table usage or uses SSIS to transfer, will be redeployed because of inconsistency in the checksum.
  If you do not redeploy, you will still be able to just execute.

Fixed in ODX 20.10.44

(2023-09-18)

• 19314: Mapping same field to multiple fields in a MDW table from ADF not possible
  Using Azure Data Factory transfer from ODX to MDW doesn't support mapping the same column from the ODX to multiple fields on the same table in the MDW. We have added a validation that blocks this scenario in a deploy/execute scenario.

Fixed in 20.10.45

(2023-10-24)

• 18185: Migration tool
  You can now upgrade to the cloud-enabled version of TimeXtender without starting from scratch.
  This release can convert existing projects to cloud-based instances to minimize the work you need to do to move up. We're rolling this feature out slowly - please contact support if you want access right away.
• 19700: Incremental Load fails for Datetimeoffset last modified field
  Fixed issue with incremental load using datetimeoffset on business units
• 19614: External SQL connection with Cross database (local) allows server name input
  Fixed an issue where using an External SQL connection with Cross database (local) allowed for server name input, which shouldn't be possible.
• 19474: SSAS Access Control will always use deny set when using MDX
  Fixed an issue when using MDX on the dimension level, it would always apply the MDX on the Denied attribute, even though it was set to Allowed.
• 19545: Error when using Keep fields up-to-date and having XML data type fields
  Fixed an issue when using Incremental load and the option Keep field values up-to-date and having XML data type fields, where it would fail on deployment because data type XML isn't supported in UNION, INTERSECT or EXCEPT statements.

Fixed in ODX 20.10.45

(2023-10-24)

• 19612: Issue with incremental load and cleanup data with ODX SQL storage
  Fixed an issue with incremental load and clean-up data with ODX SQL storage, where a table would be dropped if it was empty, but later would be queried for the MAX value, resulting in an error.
• 19148: Pending ODX task is not removed and blocks the ODX Server
  We have fixed an issue where the ODX continued transferring data once a job was stopped in the ODX Execution Queue.

Changed in 20.10.46

(2024-02-06)

• Migration Tool - Merge Data Warehouse Instances
  It is now possible to merge two or more data warehouse instances by selecting a data warehouse destination that is not empty as the destination.
• Migration Tool - Migrate Data
  It is now possible to migrate the data from the old to the new data warehouse as part of the migration.

Fixed in 20.10.46

(2024-02-06)

• 19766: Migration Tool crash issue
  We fixed an issue where running the Migration Tool was crashing when reading data from an uninitialized SaaS ODX, and an issue when trying to convert a Default Schema on Transformation, it was not able to find the Business Unit ID.
• 19782: Migration Tool null issue
  We fixed an issue in the migration tool regarding mapping data sources when looking up a value in a field table from a project that was started before 20.1.0. A value could be Null this is not valid in SaaS 
• 19973: BC adapter with merge table option enabled in combination with soft/hard delete fails on extraction of primary keys
  This has been corrected
• 19977: Edit CData Source Feature issue
  The amount of CData Sources in a project was counted wrong when editing a CData Source.
  This has now been corrected.
• 20047: Migration Tool SemanticLayerDisplayFolderRelations issue
  We fixed an issue where it fails when trying to transfer SemanticLayerDisplayFolderRelations
• 20327: NAV Adapter - Table usage is not remove from additional adapters
  An issue was fixed where synchronization would corrupt the project when a table got removed if the BC adapter had additional BC adapters.
• 20330: Add New Table with Field Selection includes Raw Only field
  this has now been corrected
• 20335: Issues with varbinary and xml data types in Query Tool
  This has been fixed
• 20421: NAV Adapter synchronization issue
  Fixed issue where selection rules on aggregate tables where not cleaned up correctly after removing the table from source
• 20450: TX server config is missing assembly redirect
  Transferring a project from one environment to another sometimes failed due to a missing assembly binding redirect in the txserver configuration

Fixed in ODX 20.10.46

(2024-02-06)

Note: After installing ODX 20.10.46, you will need to update all custom data sources by Managing Data Source Providers

• 19911: SAP Issues
  Added support for DecimalFloatingPoint34 and DecimalFloatingPoint16 data types.
  Fixed issue where fields starting with '/' could not be added to incremental rules.
  Fixed issue where max. row setting was limiting number of data rows to be transferred.
  Improved logging.

Fixed in 20.10.47

Fixed

• Migration Tool duplicate key issue 
  Fixed issue where duplicate key was cast when trying to migrate Business units.
• Migration Tool external table issue
  Fixed issue where an 'ExternalTable' table was migrated. As 'ExternalTable' is it not supported in SaaS, the project failed to open.

Fixed in 20.10.48

Improved

• Improved the primary key logic for ODX when using a SQL storage. The primary key table will no longer transfer a copy of all primary keys on each execution, but will store the primary keys in a structure where it marks the primary keys with a "valid from" and "valid to" version to avoid unnecessary duplicates.
• Desktop Activation Folder Override.

Fixed

• Fixed an issue where preview in ODX Filter Rows would always select the first table.
• Migration Tool: We addressed an issue where migration failed due to spaces in Business Unit names.
• The MDW Field validation type "Is Empty" was marking empty string values as invalid.
• Refactor Primary Key table in ODX SQL Storage.
• Fixed an issue with custom views where a schema or name couldn't contain single quotation marks (')
• Fixed an issue where ODX transfer tasks were blocking other tasks from running concurrently during bulk inserts.
• Block protected project to be "Saved As"
• TimeXtender SAP Table Data Source: Added BackgroundJobTimeout setting

Fixed in 20.10.49

Fixed

• Fixed issue with incorrect extension references when using SQL provider on Business Central Adapter

Fixed in ODX 20.10.49

(2024-05-17)

• 21354: Fixed an issue were the ODX is missing support for Integration Services 2022

Fixed in 20.10.50

• 21343: SaaS Migration issues

  - Fixed an issue where the migration tool would create new data source connection in the MDW project for the same ODX data source. The ODX data source connection is now re-used.

  - Fixed an issue where converted Business Unit names would be come too long.

  - Optimized the calculation of the migration steps relating to having many business units and data sources in the same project.
• 21368: Business Central Adapter - Authentication issue when modifying the OAuth file location
  This has now been fixed

Fixed in ODX 20.10.50

(2024-05-22)

• 21303: Intermittent ADF IR transfer failures from ODX to DSA
  Fixed an issue where transfer failed with a timeout from ODX to Data Warehouse when using ADF with self-hosted Integration Runtime.

Fixed in 20.10.51