Release Notes of Invantive® Studio 24.0.161

Invantive® Studio

Platform-independent base for Invantive Producer graphical products such as the Query Tool and Studio.

These release notes describe all bug fixes and enhancements on Invantive® Studio per released version. The release number consists of three elements: major version, minor version and patch version. The latest version is listed on top of the list, with older releases further down. Notes are listed per patch release for the current minor release. Changes from patch releases are bundled for previous minor releases. The release notes include all changes deemed informative for use outside the product development team. Refactoring, logging, translations and internal code-only changes are not included in these external release notes. A change is considered a bug fix when it solves a problem with previously released functionality. A change is considered an enhancement when the software change extends previously released functionality.

This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Version: 24.0.161

Released: 28-04-2024 15:29:24 (UTC)

State: Production

Manufacturer: Invantive Software B.V.

Brand: Invantive

Operating systems:

  • Microsoft Windows 10
  • Microsoft Windows Server 2016 (64-bit)
  • Microsoft Windows Server 2019
  • Microsoft Windows Server 2022

Permissions:

  • Requires Internet access.
  • Requires all required Operating System updates applied at most 1 month ago.

Software Requirements:

  • Microsoft .NET 4.8 or higher.
  • Screen resolution 1280x1024 or higher.
  • User license for databases used and/or business applications.

Limitations: For use in service area within important safety and usage conditions.

Category: Business

Email: sales@invantive.com

MSI Product ID: f4efe587-47df-463a-785f-a5c238deea6f

Included Components:

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.