Release Notes of Invantive Query Tool 24.0.161

Version 24.0.161, released 2024-04-28.

Enhancements:
- Add all new icons Available Objects.
- Add PSQL objects to available objects in SQL editor.
- Add SQL execution information to SQL history
- Describe new object types in QT.
- Differentiate itgencuy015 for easier fixing by end users.
- Improve sample SQL/PSQL.
- Improved build for multiple target platforms.
- Increase default window sizes from 1000x600 to 1500x1000.

Bug fixes:
- Fix itgenpis002 when changing to Bokmal in Business.
- Improve finding package functions when data container alias is specified.
- Increase width of definition.
- QT: Remove inapplicable fields on procedures/functions.
- Show deviating images for procedures and functions in available objects.
- Translate function documentation.
- Use default export settings when exporting.


Details of Release Notes:


Version 24.0.161:
Add SQL execution information to SQL history
#	src/Invantive.Producer.Windows.Forms/QueryTool/QueryTool.cs

Version 23.1.242-BETA, released 2023-12-06.

Enhancements:
- Ad print logo's.
- Add Teamleader Orbit provider.
- Add Teamleader Orbit Reporting icons.
- Change splashscreen to 'support.invantive.com'.
- Enable complex translations in other languages than the default.
- Enable Control upload on ANSI database with connection pooling.
- Extend logging by Thread ID and Task ID.
- Postpone metadata refresh until query is completed.
- Remove Google Analytics from Manual.
- Teamleader Orbit: auto-fill username and password.

Bug fixes:
- Avoid double escaping on Invantive Control and Invantive Composition.

Version 22.1.295-BETA, released 2022-09-20.

Enhancements:
- Add all new provider WPF icons.
- Add Business dummy icons.
- Add Easyflex icons.
- Add Elastic variables.
- Add Gripp icons.
- Add HubSpot, YouTrack, Tweede Kamer & PipeDrive.
- Add IONbiz icons.
- Add Legalsense.
- Add minox icons.
- Add Mollie icons.
- Add Polish, Czech and Korean.
- Add Tixly icons.
- Add Tl Orbit & Jortt.
- Add Tweede Kamer Public Data driver.
- Add YouTrack icons.
- Allow providing product specific translations.
- Avoid replacing settings file when Customer Service can not validate email address.
- Clarify message itgenarn021/itgenarn065.
- Control: Raise error when logging on to Exact Online with XML or REST API disabled.
- Correct file names.
- Correct message itgenuty512 to include message code.
- Differentiate message Query Tool execution completed.
- Enable action button on user messages.
- EOL: implement logging on using One Exact Identity.
- Fix business dummy icons.
- Handle B2C Exact Online error more gracefully
- Improve error handling during object discovery
- Improve error message itgenarn022.
- Improve performance by logging on multiple data containers at once.
- Improve performance by retrieving metadata in the background on startup.
- Improve user interface language defaulting.
- Log output of 'local host' statement to DBMS output.
- Make new document file name in Query Tool translateable.
- Move to .NET 4.8.
- Port project to .NET Core.
- Provider attribute category translations.
- Runtime: Allow parameters of several numeric types other that decimal.
- Support Zoom in QT.
- Upgrade from .net Framework 4.7.2 to 4.8.0.

Bug fixes:
- Add label on empty schema/catalog.
- Avoid itgenclr000 in Show user messages.
- Avoid itgenclr006 ObjectDisposedException on new timer.
- Avoid itgenrvl008 on unsupported type byte for Invantive Runtime plugins.
- Avoid jumping left border when switching from/to XML layout.
- Avoid NRE in count timer.
- Avoid NRE in OAuth window.
- Correct ${outcome} sample.
- Correct link to release notes of Invantive Runtime.
- Disable A-record validation.
- Disable submit on TL OAuth to prevent failed log in. No solution to submit yet.
- Display on delete strategy for referential constraints.
- Ensure only relevant tables are shown in Data Loader.
- Fix automatic log on on Exact Online.
- Fix empty table parameters list not being rendered correctly.
- Fix entry in Runtime parameters.
- Fix itgengpr015 on Invantive Composition/Invantive Control edit parameters.
- Fix label on empty schema/catalog.
- Fix message code on user messages with exception.
- Fix NRE on .NET Core.
- Fix OAuth refresh token flow from Data Hub and QueryTool.
- Fix object disposed on timer.
- Fix object name being incorrectly escaped.
- Fix overwriting new OAuth tokens with old values from log on screen.
- Fix partition selection in Control and Query Tool.
- Fix password entry.
- Fix STA error on user messages.
- Fix Teamleader automatic log in entry on Windows products.
- Fix text of translation of itgenqtl115.
- Fix typo in local host template statement.
- Ignore failed setting of partitions on service providers, like Outlook. It is possible partitions aren't loaded , for example because Outlook hasn't started yet.
- Improve check on Edge Runtime for newer Windows versions.
- Improve speed of determining available objects on creating/deleting in-memory table.
- Memorize partitions also when the same datacontainer ID is opened twice in a database.
- On UI products, do not exit application on fatal user messages, instead log off, rendering the software unusable.
- Only append non-null text to dbms_output.
- Prevent NRE.
- Remove empty ribbons in Query Tool.
- Remove maximum length on password.
- Shorten and obfuscate asterisks for security sensitive data.
- Show multiple user messages in desktop products.
- Use commercial name instead of technical name for partitions list.
- Use correct user name field name on Zoom to auto fill.


Details of Release Notes:


Version 22.1.293:
Handle B2C Exact Online error more gracefully
#	src/Invantive.Producer.Windows.Forms/OAuth/OAuthUIProvider.cs
#	src/Invantive.Producer.Windows.Forms/OAuth/OAuthViewModel.cs

Version 22.1.161:
Improve error handling during object discovery
#	src/Invantive.Producer.Windows.Forms/QueryTool/AvailableObjectsList.cs

Version 22.0.3, released 2022-01-21.

Enhancements:
- Display alternative database names on itgenlom013.

Version 20.2.205, released 2021-11-05.

Enhancements:
- Add "when contains at least x rows" in "local export results" Invantive Script statement.
- Add .net 6 support.
- Add forums buttons to various ribbons and make online assistance configurable.
- Add NDJSON export format.
- Allow logging in using an OAuth access token.
- Change execution log and native call logging to NDJSON format.
- Checkbox in log on screen for boolean provider attributes.
- Detect expired password on Exact Online.
- Differentiate error handling when the user did not verify his email address on the cloud platform.
- Differentiate error on invalid callback OAuth URL.
- Do not display itgenuty729 on first use.
- Enable multi-line entry of license key on Data Hub.
- Enable new Exact Online SSO log in page.
- Extend size of parameter value entry.
- Further differentiate on OAuth errors in log on window.
- Give hint on running Data Hub interactive on itgenlic251.
- Improve Data Hub messages on log on.
- Improve headless printing of message type.
- Improve license handling in case of no license configured.
- Improve message on invalid settings*.XML.
- Improve parameter value entry.
- Memorize answer on itgenlom45.
- Numeric control in log on screen for integer provider attributes.
- Performance improvements.
- Reduce memory pressure.
- Replace itgenuty726 when possible by actual error code.
- Show Keychain statistics in Data Hub.
- Switch to IPv6.

Bug fixes:
- Deduplicate message code in pop-up.
- Do not display message code besides in title also in message box.
- Fix auto log on for Exact Online Spain.
- Fix compilation, StackOverflow exception.
- Fix partition error on startup of Loket, Visma.NET and others.
- Improve file handling of session IO log.
- Restore Find and Replace in QueryTool.
- Retrieve OAuth token from URLs that are not accessible.
- Save when agreement accepted on Data Hub.
- Set OAuth scopes for Atlassian.
- Store provider attribute values when logging in.

Version 20.1.538-BETA, released 2020-10-03.

Enhancements:
- Add "local host" Invantive Script statement.
- Add channels to dbms_output.
- Add handler for problems with getting enabled setting of Split Button.
- Add main category to providers.
- Add menu with pre-defined scripting variables to Query Tool.
- Add new SID types.
- Add option to close application on console menus.
- Add registration of 'on error default' applications.
- Add Robaws icons.
- Add Save KeyChain.
- Add source to email address validation.
- Add timeout on "local host" and "${local:host...}" variables.
- Allow selection of output type when creating Data Hub batch script.
- Also sort databases by name in log on window after sorting on order.
- Better clean email addresses.
- By default enable dbms_output in Query Tool.
- DBMS output.
- Default user settings from installation user data.
- Differentiate discovered database per version.
- Differentiate logging for Invantive Script.
- Differentiate translation cache file formats.
- Display license window even when trial keys are corrupt.
- Do not replace connection string settings of data container on log on by memorized value.
- Enable custom I18N files using the environment variable INVANTIVE_I18N_FOLDER.
- Enable overrule of UI language by environment variable INVANTIVE_ALLOWED_LANGUAGE_CODES.
- Ensure the web view control is installed.
- Extend email address verification.
- Extend license agreement configuration options in Data Hub.
- Fix 32px icon teamleader.
- Flash OAuth dialog when not having focus.
- Ignore error on invalid logon types when listing Windows users.
- Improve data container ID determination.
- Improve DBMS output on Query Tool.
- Improve error handling during boot on GUI products.
- Improve error message itgenarn021.
- Include non-primary key field value of 'field' in update on ActiveCampaign contact custom field.
- Increase maximum width of columns in grids.
- Make changing refresh token from settings.xml file take effect in logon.
- Make locker readonly.
- Make many early compatibility checks fatal.
- Memorize chosen partitions by a hashed key of user and data container ID and database instead of solely database.
- Memorize last action.
- Memorize last output of OS statement.
- Memorize last used partitions on a database for Query Tool.
- Print time for messages when in headless mode.
- Reduce size of log on messages on console.
- Re-enable data tab in object browser.
- Register date of creation of settings files.
- Register date/time of occurrence of dbms_output.
- Rename Open Data to Public Data.
- Replace OAuth window by new version which embeds Chrome to improve support.
- Return stderr, stdout and exit code to caller of local host unless an error occurred.
- Save and restore selected partitions.
- Save refresh token in Invantive KeyChain.
- Separately handle kind request and natural key in message windows.
- Show an error on 'local host' when it exited with code unequal 0.
- Show discovery button more prominently.
- Simplify text-based preferences form.
- Straighten XML configuration file serialization
- Switch object size resolution from KB to bytes.
- Translate.
- Upgrade from Teamviewer 10 to Teamviewer 15.

Bug fixes:
- Add new line to output of dbms_output.
- Avoid display of itgenube151 on Data Hub when there are no messages.
- Avoid duplicate inclusion of message code in errors.
- Avoid error on describe tab data when no data container aliases are used.
- Avoid InvalidOperaitonException in license window.
- Avoid NRE on 'local exit 0' in Query Tool.
- Avoid NRE on reconnect with WebView2.
- Avoid NullReferenceException due to bug in Microsoft Excel library implementing ribbon split menu.
- Avoid NullReferenceException on Teamviewer version determination.
- Avoid parse errors with old SQL history files.
- Change error dialog caption to include version and message code.
- Control: Add check workbook structure tool button to check if all required worksheets are registered.
- Default extension to SQL for query tool
- Display correct connector attributes when there is no alias on multiple data containers.
- Do not select all text when opening a previously used file in Query Tool.
- Do not throw exception when no summary form is available to open item.
- Enable display of itgentln003 error.
- Exact Online: Select all divisions on consent to prevent errors.
- Fine-tune get container form title need.
- Fix "itgenmcl005: Source not set." error.
- Fix "itgenouy003: Unsupported partition chooser type" error when selecting "All" states, cities, etc.
- Fix ArgumentNullException on email address checks.
- Fix calculation of number of physical cores.
- Fix changed indicator on new documents.
- Fix data retrieval in multi-data container virtual database.
- Fix determining the data type of loaded data into the data tab.
- Fix edit indicator text.
- Fix error generating SQL on proxy column Logo$$image.
- Fix error on OriginalRefreshToken attribute when logging on to Data Hub.
- Fix icon on details pane.
- Fix infrequent occurring itgendid058 during log on.
- Fix invoke error.
- Fix issue where unescaped redirect URL causes error message as if there was a log on failure.
- Fix itgenclr008 on saving user settings.
- Fix missing label translation column values.
- Fix not being able to close server license dialog.
- Fix Producer repository log on using managed Oracle driver.
- Fix retrieving and saving of partition selection.
- Fix saving user settings.
- Fix storing open Query Tool documents.
- Fix superfluous itgenube015 error on Online Assistance.
- Fix typo in 'is64bitoperatingysstem' to read 'is64bitoperatingsystem'.
- Handle byte values returned for Windows user data.
- Improve Data Replicator event log window.
- Improve handling of expired trials with Invantive Data Hub.
- Improve performance, layout describe panels.
- Improve provider attribute handling when default value is not null.
- Make last NK in error dialog selectable.
- Make OAuth working in Control.
- More logical sorting of actions.
- OAuth: Clear cookies on log in to prevent credentials to be carried over. Automate log in on Visma.NET.
- QT/Control: Fix partition selection.
- Raise error when a data container on a database with multiple data containers has no alias.
- Re-establish Execute All button in Query Tool.
- Rewrite Office partitions dropdown.
- Show license dialog without asking when license is invalid.
- Try to prevent ArgumentException on opening forms.

Version 17.33.340-BETA, released 2020-01-29.

Enhancements:
- Add Invantive Script statements.
- Add Mac OSX support.
- Add Runtime samples.
- Aggregate errors across tab during opening a summary form.
- Allow disk cache root folder to be specified as execution option.
- Allow translating labels from plugins.
- Auto close discovery when forced.
- Auto-close discovery when running a required discovery
- Auto-discovery for multi-platform products.
- Default save file dialog to a good location.
- Differentiate between successful and erroneous execution all steps in Query Tool.
- Display documentation of parameters of Producer Plugins in list.
- Display log on user in Data Hub console window title to ease user navigation.
- Display warnings in Data Hub in yellow instead of red.
- Don't translate image name for errors.
- Download Anydesk using HTTPS instead of HTTP.
- Exclude existing databases from the discovery databases file.
- Exclude non-user visible partition tags from partition choosers.
- Improve language determination for Mac.
- Improved detection of invalid databases.
- Include global state in event arguments to improve window ownership.
- Include license contract code in error window to ease support.
- Increase limit on number of rows selected by defaulted on Invantive SQL.
- Indicate that encrypted value is a license key instead of the default 'password' text on decryption failure.
- Install Invantive Producer Runtime plugin samples on upgrade.
- Make bulk insert batch size configurable.
- Online assistance in license window.
- Performance optimization of queries for list search a null value in a required field.
- Prevent Open, Edit and Copy dialogs to close the child form when closing the parent form.
- Print expiry date message in Data Hub when loading a time-limited license.
- Prioritize database definitions when multiple are found.
- Refactor TOTP to allow generation of shared keys.
- Show relevant hint when exporting to a file in a non-existing folder.
- Signal HTTP 404 in error messages when logging in to OAuth connector.

Bug fixes:
- Add edit plugins for Producer Runtime.
- Always enable main tab, don't show license dialog when function is not licensed.
- Avoid database access when querying for null value in required column.
- Avoid non-persistent file access error when changing Producer Runtime plugins
- Avoid NullReference when a problem occurs with Teamleader interactive log in.
- Avoid superfluous question when last statement in batch fails in interactive mode.
- Avoid suppressing of error window in Invantive Control for Excel in specific situations.
- Correct functionality of cancel button in register product window.
- Default user interface language for Producer Runtime.
- Discovery is re-run on every execution [ITGEN-4429].
- Estate: Fix no license issue
- F4 raises itgencmr010 IsApplicationRunning [SUP-1439].
- Fix describe of tables with non-Invantive Producer.
- Fix empty columns in SQL history with UTC dates.
- Fix evaluation of Invantive Script system variables upon first use.
- Fix issue owner Studio [ITGEN-4393].
- Fix itgencmr010 on describe table.
- Fix possibe NullReference when no primary key value is included for lists.
- Fix progress indicator [ITGEN-4403]
- Fix spacing for log in button [ITGEN-4402]
- Fix threading issue Auto Discovery window.
- Fix threading issue.
- Fix XAF 3.1 plugins for Invantive Runtime not appearing.
- Highlight which user specification fields are required for use of Invantive products.
- Improve error message itgenube042.
- Improve message when window helper is missing on edit/add connection [ITGEN-4311].
- Make insensitive for seldom occurring problem during OK pressing in error window.
- Move support button to left side to avoid accidental application.
- Only display available plug-ins in Producer Runtime.
- Reduce impact of error during retrieval of available object in Windows forms.
- Reduce impact when initialisation of search panel fails.
- Reduce number of translation requests for better performance.
- Reduce unnecessary discovery scans when switching between lower and higher versions.
- Register correct database name when not using Invantive Keychain.
- Return exit code from Data Hub on exit from generated batch script instead of 0.
- Set minimum and maximum length for char columns in Windows grids.
- Show confirmation window after requiting to be called.
- Silently ignore when another product used database not available on this product.
- Sort available datas type in edit parameter form of Invantive Query Tool.
- Thread safety.
- Use correct timestamp in UTC instead of local TZ for Teamviewer and Anydesk download.

Version 17.31.125-BETA, released 2019-05-03.

Enhancements:
- Add edit Producer Runtime plugin [ITGEN-4132].
- Add version running on Mac OSX, Linux and Windows.
- Aggregate exception on utility startup.
- Changes due to adding support for Linux/Unix/Mac OS on Invantive Producer products.
- Display partition code in error message [ITGEN-3990].
- Display personal information in preferences even when gender code is invalid or missing.
- Enable high-dpi with Infragistics 19.1 [ITGEN-4220].
- Generically solve problem of footer being overflown when elements are hidden. Now changed to CSS flex for web.
- Improve performance by reduced use of DateTime.Now.
- Include natural key in verbose progress messages.
- Include SQL fragment causing error in error message.
- OAuth for Loket.nl REST
- Print final error to console for console apps when the exit code is not equal to 0.
- Reduce frequency of Office version checks.
- Restrict number of audit events maintained not only to a specific age, but also to maximum number of 100 entries.
- Reuse TeamViewer 10 download across support sessions for reduced bandwidth needs.
- Support for Linux/Unix/Mac OS.
- Use .NET 4.7 auto scaling for high DPI [ITGEN-4219].

Bug fixes:
- Add vertical scrollbars to various locations when screen is too small or Windows renders incorrectly.
- Allow use of unencrypted passwords again.
- Avoid confusing error window when closing Excel when Invantive Control is still starting.
- Broken license window [ITGEN-4227].
- Correctly hand over owner of a window [ITGEN-3704].
- Don't repeatedly ask for personal information [ITGEN-4270].
- Ensure Data Container ID is available for use with open recent entries.
- Execute early compatibility checks at most once.
- Fix Alt+F4 in Query Tool.
- Fix DateTime metadata issue.
- Fix itgentwn001 error in Invantive Estate when editing in a form.
- Fix System.Runtime not found exception [ITGEN-3857].
- Improve .NET Core compliance.
- Improved opening and closing logic. Loads documents from internal cache.
- Include email address entered from step 1 in step 2 of registration process.
- Only ask whether to save SQL editor contents when it has any contents.
- Only memorize search results that can be opened later.
- Prevent losing current Office-based partition selection when opening Query Tool from Office product.
- Query Tool MDI: prevent Escape to close the window [ITGEN-4005].
- Query Tool: Add save documents.
- Query Tool: Don't hide progress notifier.
- Remove natural key since we have no meaningful value [ITGEN-4024].
- Repair F4 on table functions in Query Tool [ITGEN-3732].
- Restore adding product properties to exceptions.
- Restore close command in License window.
- Search window wrong owner [ITGEN-4206].
- Set WF as owner for WPF windows.
- Set WPF window as owner for WF form.
- Some console colors turn black on SSH using Putty [ITGEN-3768].

Version 17.29.65-BETA, released 2018-12-27.

Enhancements:
- Add automatic time correction based upon Internet time of Invantive servers.
- Add documentation on 'stat:' scripting variable name space.
- Add more context parameters [ITGEN-3560].
- Add new splash screen image with larger text, 256 colors and thicker border.
- Add short one-line description to database groups and databases for better human recognition of groups and databases with codes as names.
- Add splashscreen.
- Allow drag/drop license file to license window.
- Background for Company Info logon screen.
- Better error message when trying to unprotect a sheet that is locked with another password than known by Invantive Control.
- Clarify message when export documents to disk.
- Correctly handle changed parameter value, do not keep using the default value. [ITGEN-3562].
- Different controls on parameters based on their .NET data type.
- Display clearer message when user tries to save a file under a name already in use by a folder.
- Ignore errors on isolated settings*.xml files during discovery.
- Improve error message when distributed database has no aliases.
- Improve handling of ANSI upper-case SQL identifiers for Invantive Producer-based products.
- Improved start up performance when using providers with over 1 million columns with each a long translation to be made.
- No longer write out settings files besides discovery
- Only show partition chooser in Office add-ins when there is something meaningful to list.
- Raise clearer error when a user is not authorized to log on on Exact Online since the client ID is unpublished and based upon another subscription.
- Reduce likelihood of needing loaded Producer Windows assembly early on.
- Retrieve plugins from %USERPROFILE%\invantive\plugins folder and display in gray area. Extension: *.ipn. [ITGEN-3517].
- Return clearer error message when a plugin can not be loaded.
- Several layout improvements on Invantive Producer Runtime.
- Support conditions for Producer Runtime.
- Theme for Company Info XAML.
- Tool button, Discovery Ribbon Company Info.
- Updates to OAuth dialog for Visma.NET.
- Upgrade data model.
- XAML theme for Company Info.

Bug fixes:
- Control/Composition/Business: Solve grouping issue with a lot of partitions.
- Display message box during initialization even when initial display fails.
- Enable export of grouped grid contents.
- Fix auto logon from Visma NET
- Fix casting errors in Query Tool parameter definition window.
- Fix crash
- Fix editing issue Producer Runtime.
- Fix Null reference when an error occurs and no error policy is set in Invantive Script.
- Fix selective column export for Excel when create multiple Excel sheets in one go.
- Hide online assistance in Preferences wizard when online assistance is not licensed.
- itgenclr003: The calling thread cannot access this object because a different thread owns it. [ITGEN-3620]
- Only display partition choser in Query Tool when there are at least 2 partitions.
- Render unknown image as placeholder when PDF file can not be rendered into thumbnail in Query Tool.
- Replace title and move user to bottom. Remaining gray area is reserved for script tiles [ITGEN-3516].
- Show correct icon in Producer Runtime pop-ups [ITGEN-3576].
- Show correct icon on progress warning messages instead of always Error icon.

Version 17.28.1, released 2018-10-22.

Enhancements:
- Add workarounds for Globe audit files.
- Make standardization with SQL identifier escape optional.

Bug fixes:
- Show actual error instead of NulLReferenceException when Invantive Web Services returns itgencmr008.

Version 17.27.46-BETA, released 2018-09-14.

Enhancements:
- Add icons to Invantive Business for Exact Online.
- Add plugin parameters.
- Add support for JSON flattened output. Traditional JSON format renamed to jsondataset.
- Improve addition of double quotes across line feeds in CSV export when using another line feed as record separator.
- Increase maximum size of result set to above 4 billion rows.
- Limit number of entries in SQL history to 2.500.
- Memorize most recent SQL and LOG folder in Query Tool.
- Memorize SQL statements even when Query Tool is terminated before completion of SQL.
- Raise warning when user runs on Office 2010.
- Update translations.

Bug fixes:
- Add proper escaping of reserved words across all SQL platforms.
- Ask whether to save changed contents in Query Tool before opening a recent file.
- Display missing database name in Query Tool when connected using refresh token.
- Do not close Data Loader main window when solely ESC is pressed [ITGEN-3152].
- Reconnect after disconnecting in the license dialog [ITGEN-3134].
- Reduce chance of read lock blocking reading files through OS provider.
- Reduce minimum height of facts window to half of current value [ITGEN-3141].

Version 17.26.9, released 2018-09-03.

Enhancements:
- Add functionality to open web-based release notes.
- Prepare release.
- Print active data containers on text-mode log on.
- Retrieve cookies from logon dialog.
- Run discovery on software version change to automatically update provider attribute 'apiurl' to 'api-url'.

Bug fixes:
- Differentiate for callback URL between implicit grant and code grant flow when logging in interactively using OAuth.
- More often show a WPF error window instead of default box [ITGEN-3130].
- Show excluded Invantive SQL components in License Components tab.

Version 17.25.30-BETA, released 2018-08-10.

Enhancements:
- Add "alter data dictionary set ..." PSQL statements.
- Add alter persistent cache set backing connection string [ITGEN-1678].
- Add execute native PSQL statement [ITGEN-2963].
- Add explanation of tool tip to license window button text for ease of use.
- Allow ignore errors from File Access Information determination to avoid itgenube078 errors in Query Tool on restricted Windows environments.
- Expand first group and select first database on first open.
- Improve performance by streaming row checks.
- Improvements on Exact Online import for Twinfield.
- itgensdf054 Detect adding worksheets in Invantive Control where not allowed [ITGEN-821].

Bug fixes:
- Describe not working on table functions [ITGEN-1877].
- Display default user name when the log on mode is read-only.
- Enable running export to Excel even when the previous export was canceled.
- Exclude ClickOnce checks for desktop file access.
- Only show partition selector when there are any partitions.
- Open SQL through menu from query tool doesn't do anything [ITGEN-2880].
- Remove unsupported data containers data dictionary, os, mail, ... on native connections [ITGEN-2597].

Version 17.24.28, released 2018-06-26.

Enhancements:
-  Extensive rewrite of logon dialog styling to allow scrolling the database properties [ITGEN-2629].
- Allow specifying the timeout on a specific SQL back-end provider action through execution option.
- Always require an alias in an Invantive SQL query when using distributed database [ITGEN-2870].
- Enable use of $C, $X, $P, $R in where clause of pick list for Excel cells [ITGEN-2842].
- Separate use of Invantive Keychain and save password.
- Set default target folder of 'local export results' statement to the current working directory for Data Hub and Query Tool.

Bug fixes:
- Avoid argument exception on block code.
- Correct source of Use Invantive Keychain log on option.
- Dragging a nullable boolean column to a group crashes the grid [ITGEN-2957].
- Filter failure itgendid048 The value %123123% is not a valid integer [ITGEN-2860].
- Fix 22P04: missing data for column "dc7373f753c9d25181c009f6217177" [ITGEN-2825].
- Improve performance of large IN clauses by sharing comparers.
- Make order of fields for translations editing more logical.
- Regression bug itgenugs035 [ITGEN-2861].

Version 17.23.59-BETA, released 2018-04-28.

Enhancements:
- Add Invantive Keychain tools window.
- Add pagination to Online SQL Editor [ITGEN-2640].
- Add support for table or view synonyms in available objects [ITGEN-2604].
- Add use of encrypted Invantive Script variable values [SECURITY].
- Allow filtering on data container ID when downloading feeds on Data Replicator.
- Allow specification of label and unencrypted value in Invantive Script.
- Clear credentials on request.
- Data Hub: Set data container credentials.
- Data Hub: Set provider attributes through command line.
- Display alias and display name in partition choser of Invantive Query Tool.
- Do not display >, >> when at last page. Do not display <, << when at first [ITGEN-2639].
- Enable specification of days retention for forwarded incoming messages in text mode.
- Enable toggle of save logon settings in text mode applications.
- Enforce specification of export password for Invantive Keychain.
- Expand provider attribute category when having at least one attribute with a value.
- Hide error message window area when it has no contents [ITGEN-2261].
- Hide log on information in tooltip on connect for Control and Composition when not connected.
- Implement 2FA token generator.
- Implement safer way to write default values to the console.
- Improve configure provider attributes question in Data Hub when there are some provider attributes already set.
- Improve defaults for saving of encrypted connection string.
- Improve upgrade scenarios for Data Replicator new not-null columns.
- Improved logon dialog -> Update auto discovery.
- Increase limit to 1000 due to increased limits for all enterprise drivers when used in free product.
- Inherit message code of inner error when running queries in Query Tool.
- Log on to EOL using client Id and long term token for developers ITGEN-1761.
- Make hamburger menu have same margin all around on mobile in landscape.
- Memorize and use multiple credentials per data container alias.
- Move providers.xml to settings.xml.
- No description paragraph when no description is given.
- Obfuscate settings not honored [ITGEN-2608].
- Remove superfluous precision below day from name of log file for generated Data Hub scripts.
- Save credentials new logon dialog.
- Save log on settings in Invantive Keychain for interactive products.
- Shorten column for picture Base64 string [ITGEN-2641].
- Show also explanation on provider attributes on logon.
- Show tool tip in logon screen.
- Simplify partition choser when there are no meaningful options for state, city and owner.
- Support encryptedtoken in settings.xml, include some tips on use in generated settings.xml of Invantive Cloud. -> We support encryptedConnectionString now [ITGEN-2480].
- Use new syntax for Data Hub command line arguments.

Bug fixes:
- Avoid itgenrst009 on klm_nk for platforms with column names exceeding 61 characters.
- Avoid NullReference when opening Preferences window through Diagnostics before connecting.
- Avoid runaway when email address is not valid and running in headless mode (itgenuty545).
- Changed garbage collection output into a report message instead of error window.
- Current thread must be set to single thread apartment (STA) mode before OLE calls can be made. Ensure that your Main function has STAThreadAttribute marked on it [ITGEN-2568].
- Ensure the WPF application context isn't closed halfway the program. This is possibly due some changes in .NET 4.7.x.
- Error itgencun016: Could not determine Data Replicator messages [ITGEN-2487].
- Fix can't find resources.xaml error [ITGEN-2492].
- Fix issue with missing fields on insert from clipboard.
- Fix length of ftn_code in Invantive Producer to meet new function codes.
- Guard against NullReferenceException in Invantive SQL pseudo-code.
- Hide data containers with no selectable partitions in Query Tool partition selector.
- Hide Query Tool partition chooser on platforms with no partitions such as Oracle.
- Incorrect code inserted on double click in available objects [ITGEN-2610].
- Place cursor focus on first enterable field (user name or whatever) on login [ITGEN-2571].
- Reduce memory footprint [ITGEN-2582].
- Right-align numbers in Diagnostics [ITGEN-1020].
- Unsupported partition chooser type [ITGEN-2634].

Version 17.20.1, released 2018-04-10.

Bug fixes:
- Avoid itgenlow002 error when there is no KeePass driver licensed [ITGEN-2467].
- Disable new database discovery window for production release.

Version 17.18.42-BETA, released 2018-03-30.

Enhancements:
- Add support for force native to Invantive Web Service definition [ITGEN-2429].
- Add test button to Data Cache connection string in editor window [ITGEN-2271].
- Adjust exporting to accommodate related changes to export formats.
- Allow both lower and upper case input in text mode on Yes/No questions.
- Change min. height for login screen.
- Data Loader: Add partition chooser.
- Display audit fields (read-only) ID, created by / on / date on Database editor WPF window [ITGEN-2221].
- Editable Connection Pooling and Rewrite property on Data Container [ITGEN-2209].
- Expand/collapse query for mobile landscape, maximum height for query input, better padding and width of query input for landscape.
- New version of Online SQL Editor, including all necessary changes since the more rigid ResultSet checks.
- Send all logging in one go instead of one each time [ITGEN-1161].
- Teamleader fill in credentials.
- Teamleader: log off before connecting.

Bug fixes:
- Correct escaping of & in WPF partition chooser.
- Correct version label in Online SQL Editor.
- Data Loader: Fix selected divisions.
- Enable use of Invantive Studio across Invantive Web Service.
- Fix error on double clicking available objects in Query Tool.
- Fix partition chooser in Invantive Control [ITGEN-2362].
- Jumping context in log on database chooser [ITGEN-1930].
- Partition chooser no longer working in Online SQL Editor [ITGEN-2430].
- Settings-xxx.xml is overwritten by Invantive software instead of being only merged [ITGEN-2451].

Version 17.17.87-BETA, released 2018-01-28.

Enhancements:
- Add "local column xxx heading" syntax for GUI applications.
- Add 'local on error ignore' and exit with error on 'local on error continue' when an error occurs.
- Add requested fields.
- Add statistics on my incoming messages for Data Replicator.
- Added Data Loader in Query Tool menus.
- Added documentation panel to available objects overview.
- Added more fields in table describe.
- Added tabs for Data Replicator and table function parameters.
- Allow space in actions with local export documents statement.
- Data Cache: event log panel in Query Tool.
- Include documentation column on providers in Data Dictionary.
- Load license file from text mode configure license form.
- Query Tool: Add general tab in describe windows when pressing F4 in the query editor.
- Raise no longer an error on export of empty data set.
- Replace 32x32 partition icon with 64x64 image.
- Support executing a file through @@ in Query Tool as in Data Hub. Also add support for it to Data Access Point [ITGEN-2009].

Bug fixes:
- Add missing picture to Invantive Data Loader.
- Avoid error on describe window pop-up when columns can not be determined.
- Correctly generate environment variable INVANTIVE_LOG_FILE_OVERWRITE value when set to false.
- Describe not working on table functions [ITGEN-1877].
- Do not allow use of data containers with connection pooling on Invantive Studio.
- Do not freeze parent window of Data Loader due to repairing parent window.
- Fill required fields of Invantive Producer provider.
- Fix Invantive Data Loader started from Excel.
- Improve performance of function license checks.
- Improve performance of Oracle Invantive Producer-based products by reducing audit trail when running on platform with no audit trail.
- Only show supported databases in log on window, depending on product.
- Reduce duration of audit events in configuration files from 100 to 7 days for better performance.
- Show correct count of rows processed in Data Loader. It was off by 1.
- Updated partitioning in Control and Composition to allow selection of the partition when having multiple data containers opened, like two Exact Online accounts.

Version 17.15.2-RC, released 2017-12-11.

Enhancements:
- Check that Windows Update has installed updates at most 180 days ago.
- Extend export options by TSV format in menus and Invantive Script.

Bug fixes:
- Avoid UI error when exporting CSV to a file from within Query Tool [ITGEN-2062].
- Fix creating multiple files with export results without split column specification.

Version 17.14.0-RC, released 2017-12-08.

Bug fixes:
- Enable user language to be set from windows products before connecting.

Version 17.13.8, released 2017-12-04.

Enhancements:
- Open documents from Exact Online and other sources in Invantive Composition.

Bug fixes:
- Prevent crash when entering wrong user name or password on OAuth providers.
- Prevent errors in logon window on STA applications such as Query Tool.

Version 17.11.27-RC, released 2017-11-08.

Enhancements:
- Allow deviating license contract code for authentication on Customer Service on behalf of Data Replicator.

Bug fixes:
- Correct layout of Data tab in Diagnostics. Numbers fit again.
- Diversify errors on early compatibility checks.
- Show error on multiple statement execution in the correct format.
- Trim composed labels after translation to ensure readable labels even when the prefix translates to empty string.

Version 17.10.172-RC, released 2017-10-31.

Enhancements:
- Add additional domains and values for Exact Online.
- Add create or replace table support for ANSI SQL providers: PostgreSQL and SQL Server.
- Add date of event occurrence for Data Replicator in server local time.
- Add domain tables for Exact Online.
- Add extensive GL Account information on Exact Online GL transaction lines.
- Add EZ-Base provider.
- Add fixed days to run methods for Exact Online plus new LOV IntrastatTypes.
- Add GLAccountClassificationMappings for Exact Online [ITGEN-1891].
- Add option to export technical headers (column names) instead of user-friendly labels [ITGEN-1937].
- Add table function regexp_split_row to split text according to regular expressions.
- Add unique entry ID to every XML element [ITGEN-1898].
- Add view maintenance: install business views on PostgreSQL and SQL Server [ITGEN-1918].
- Added Accountancy endpoints to Exact Online provider.
- Allow configuration after how many days the table partition version metadata is dropped from Data Replicator.
- Allow Data Replicator messages from feed to be deleted.
- Allow download feed from Data Cache menu in Data Hub.
- Allow use of COMPRESS as a column name [ITGEN-1936].
- Cache HTTP requests on disk when requested.
- Change default of maintain partition views to false.
- Clarify error message itgenprr005 with actual string value.
- Collect garbage after dropping in memory storage provide table.
- Correct calculation of century and era in calendar of Data Dictionary.
- Correct outcome of equals sign when selecting on code in accounts in Exact Online REST [ITGEN-104].
- Display metadata droppable days in Data Cache text form.
- Enable data model upgrade without restarting Data Replicator.
- Enable group functions on Open Data and with premium license in Invantive Query Tool.
- Fill new fields on Exact Online transaction lines / bulk with GL account information.
- Force garbage collection on disconnect to database.
- Improve error message on 403 Forbidden for Exact Online XML by including division number.
- Improve hints on password manager suggestions on log on.
- Improve speed of HTTP cache.
- Improve suggestions for user names from password manager.
- Instrument software with measurements, available in SystemProperties@datadictionary.
- Invantive SQL: Return correct return type for parameters.
- Log downloaded messages in event log for Data Replicator.
- Optimize memory usage when joining with an empty row in a left outer join.
- Reduce length of call stack printed in console window for Data Hub.
- Reduce memory footprint by trimming sparse arrays.
- Reduce memory footprint of OData EDM data types.
- Reduce memory footprint of results.
- Show in diagnostics whether a 32-bit application is large address aware (3 GB addressable).
- Show number of messages downloaded by trickle loading after download feed in Data Replicator.
- Show URL to configure webhooks for trickle loading in console user interface.
- Store in-memory table directly from result set to improve performance.
- Updated ExactOnline REST metadata.
- Upgrade Data Replicator data model to support date occurrence at server local time.

Bug fixes:
- Allow connection string to be empty for trivial providers such as ECB.
- Avoid error on Invantive Web Service trying to rewrite connection string.
- Avoid NullReference in Data Hub for provider attribute with null default value.
- Avoid NullReferenceException when the KDBX database could not be decrypted.
- Clarify error message in Data Hub and Query Tool when Exact Online wrong password entered.
- Date subtract gives wrong outcome by factor -24 [ITGEN-1910].
- Enable more than 100 rows result sets with full Invantive SQL license in Query Tool.
- Ensure vital messages are sent to the customer service on a failing program.
- Fix data type error on column ALLOW_DISPLAY for query for SystemProviderAttributes.
- Fix invalid parameter binding Invantive Studio on log on [ITGEN-1863].
- itgenemd007: An element with the key 'P_ACCOUNT_CODE' already exists in the dictionary [ITGEN-1939].
- itgenmsy001 The index position 525 is not in use. The last index used is 304 [ITGEN-1906].
- itgenoda093: At least one division is missing in your filter. Missing divisions: [ITGEN-1907].
- Lower-case views for partition and overall storage in Data Replicator.
- Merge Open Data license and free license on Invantive Query Tool.
- NullReferenceException on query when not adding alias to default/first provider [ITGEN-1948].
- Offer discovery in Data Hub when an undefined connection is specified.
- Raise error when a settings.xml has no version defined.
- Reduce length of call stacks.
- Remove temporary code that caused bulk insert on SQL Server to fail.
- Return fields in the correct order when passing select fields to the OData/ODataProvider.Fetch method.
- Slow or OutOfMemoryException on parameter pick lists [ITGEN-1940].
- Stability improvements to the SQL engine. Calculations with DateTime return the right data type now.


Details of Release Notes:


Version 17.10.115:
Add create or replace table support for ANSI SQL providers: PostgreSQL and SQL Server.
Include bulk insert from result set of query.

Version 17.10.115:
Allow configuration after how many days the table partition version metadata is dropped from Data Replicator.
Upgrades Data Replicator / Data Cache repository to version 4.

Version 17.10.37:
Improve suggestions for user names from password manager.
Define INVANTIVE_EXCLUDE property on KDBX entry to exclude it.
Define INVANTIVE_HINT property or tags with matching texts to make it more likely to match.

Version 17.10.172:
Reduce length of call stack printed in console window for Data Hub.
Also delay a few seconds after an error to allow the user to read it.