invantive documentation
Invantive Support ForumsLog In / Sign Up

Release notes of Invantive Control for Excel

Release Note - Installer

Invantive Control for Excel 27.0, from 26.0

Build Date Description
26.0.4 22-03-2026 first build of release 26.0
27.0.92 09-11-2026 latest build of release 27.0 at the time of writing

The older state is the first build of release 26.0, not its last: later builds of 26.0 received ports of changes made for 27.0, so those changes are part of this step. The 27.0 line also contains the beta builds 26.1.x.

  • 184 enhancements
  • 163 bug fixes
  • 14 things to check before upgrading

Before You Upgrade

These changes ask for a check:

Top 25 Changes

  1. Settings files move from XML to JSON
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  2. More work is sent to the platform: row limit, grouping, selected columns and joins
    • Enhancement
    • A query with LIMIT or TOP is limited by the platform, COUNT, SUM and other group functions are answered by the platform on supported drivers, only the columns that a query needs are requested, join conditions are forwarded, an exists condition on a child table reaches the platform, and OData platforms get shorter filters with the IN operator. Fewer rows are transferred.
  3. Joins return the correct rows
    • Bug Fix
    • A left, right or full join written without the word OUTER was executed as an inner join and lost rows. A right outer join placed columns in the wrong order, a condition in ON removed rows, a cross join dropped its right-hand side, and a full outer join that could not be answered was not reported.
  4. Correlated subqueries are supported
    • Enhancement
    • A subquery can refer to columns of the outer query, as in EXISTS, IN and scalar subqueries. A subquery without outer references is evaluated once per statement and its answer is reused.
  5. DeepL driver
    • Enhancement
    • A new driver reads and writes DeepL: languages, billing, translation, writing assistance, documents, glossaries, style rules and translation memories.
  6. Parts of a PSQL block can run in parallel
    • Enhancement
    • PSQL gets a PARALLEL construct that runs branches and loop iterations side by side, SYNCHRONIZE accepts a parallel option, and the package dbms_atomic holds values that parallel branches share safely.
  7. Stop a lengthy formula calculation or synchronisation from Excel
    • Enhancement
    • A calculation of Invantive formulas that takes long can now be ended. A window with a stop button appears after five seconds, the Escape key also ends it, and a calculation ends by itself after a time limit that is set in a new user setting (30 seconds by default). Formulas that were not calculated show #N/A until the next calculation. The cancel button of a synchronisation now also stops the query in progress.
  8. The legacy Oracle driver and the Invantive Web Service driver are removed; Oracle 18 is the minimum
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  9. Exact Online companies outside the service area are no longer accepted
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  10. Loading of provider assemblies from a settings file is blocked
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  11. Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  12. QR code functions take one size value instead of width and height
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  13. Remove obsolete Invantive Script statements
    • Enhancement
    • action needed
    • Action needed before or after the upgrade.
  14. Data is loaded in the background while a session is idle
    • Enhancement
    • A connected session fills caches with predictable data, such as the tables read in the last fourteen days and the incremental tables of Exact Online, Freshdesk and Freshservice, using spare rate allowance. Four loads run in parallel, partitions can be chosen, and the connection monitor shows the loads.
  15. New platforms: Inspectlet, Matomo, Nextcloud and Tweede Kamer v5
    • Enhancement
    • Four new drivers read Inspectlet (websites and recorded sessions), Matomo web analytics with a package of PSQL procedures, a Nextcloud server (tables depend on the installed apps) and the Tweede Kamer open data on the new API. The earlier Tweede Kamer driver remains available. Each platform has a licence module and an icon.
  16. Invantive License Service: clearer messages, grace period and new modules
    • Enhancement
    • A licence key of the wrong type is explained, a licence service that is unavailable gets a specific message, and a licence that was valid stays in force for a grace period when the service cannot be reached. The check that prolongs a licence runs hourly. New licence modules exist for the Support Assistant, OEM use and subscription software, the built-in trial and open data keys use the new format, and text-mode products show tips about the licence in use.
  17. Data containers and credentials from Invantive Credentials Server
    • Enhancement
    • A database definition can point to Invantive Credentials Server, which supplies the data containers and sign-in credentials. The log-on window and the partition menu show these containers with their own icon, errors of the server are shown with their details, and a retrieval is repeated after a time-out.
  18. Big Data JSON reads files much faster and skips files that cannot match
    • Enhancement
    • Collections of NDJSON files, plain or Zstandard compressed, are streamed and only the needed columns are built. A directory gets an index with value ranges, Bloom filters and counts, so filters, counts and group-by statements read fewer files.
  19. Visma.net: new API specification, Visma Connect log-on and the Sales Order APIs
    • Enhancement
    • The Visma.net driver uses the API specification of 18 June 2026 and the new Visma Connect sign-in, and adds tables for the Sales Order APIs with server-side filtering, insert and update. Filters such as not in and not equal on a column with a fixed list of values are sent as requests for the remaining values.
  20. Exact Online incremental tables reload less often and are read faster
    • Enhancement
    • Incremental tables avoid full reloads caused by a rejected previous image or a row count guard, are read from the cache up to six times faster, and stop an incremental run when the deleted rows needed are older than the platform keeps them. The new table IncrementalEntityTypes lists the entity types that can be loaded incrementally.
  21. Filters no longer lose rows or evaluate wrongly
    • Bug Fix
    • A condition such as a and (b or c) could return too few rows, lower and upper case conversions and decimal constants were not sent correctly to SQL databases, NOT LIKE dropped rows that differ only in case, and x between 1 and 2 and y = 1 was read wrongly.
  22. Exact Online incremental data is no longer damaged or overwritten
    • Bug Fix
    • Users of one subscription replaced each other's incremental image, a request that ended while an image was saved could leave chunks of two versions, a refresh that only added rows was taken as unchanged, and incremental data could end up in the folder of other cache settings or ignore the disk cache settings of the statement.
  23. Avoid RPC_E_DISCONNECTED errors when Excel closes a workbook during start-up
    • Bug Fix
    • Errors with the text that the connection of the called object to its clients was lost no longer occur at start-up and during repeated use of a workbook. Work on Excel is now done on the thread of Excel, a workbook that has been closed is detected, and the caches no longer keep references to closed workbooks.
  24. Pipedrive platform
    • Enhancement
    • Pipedrive can be read as a new platform, with labels for custom fields, and the OAuth sign-in window understands its error answers.
  25. Scripts can run operating system commands with the new package dbms_os
    • Enhancement
    • The package dbms_os runs an operating system command with environment variables and a time limit, returns its output and exit code, and calculates a file hash. A command that runs too long is ended together with the programs it started. Files it writes are UTF-8 without byte order mark.

All Enhancements

Changes to behaviour, platforms, drivers and settings, grouped by area.

Importance: all | 2 and higher | 3 and higher | 4 and higher | 5

Platform: all | AccountView (1) | ActiveCampaign (3) | AFAS (1) | AFAS Online (3) | AFAS Profit (1) | Autotask (1) | Big Data JSON (1) | Brevo (2) | Bridge Online (4) | CBS (1) | Chargebee (1) | Crisp (4) | Data Cache (1) | DeepL (1) | Discourse (1) | Dropbox (1) | Dynamics 365 CRM (2) | Dynamics CRM (2) | Easyflex (1) | EDIFACT (1) | Exact Online (37) | File system (2) | Firebird (2) | Fortnox (1) | FoxPro (1) | Freshdesk (3) | Freshservice (2) | FTP (1) | Gripp (2) | Gripp CRM (2) | HubSpot (3) | IBM Db2 (1) | In-memory (2) | In-memory storage (1) | Inspectlet (2) | Invantive Bridge Online (1) | Invantive Business (1) | Invantive Credentials Server (1) | Invantive Estate (1) | Invantive Producer (1) | Invantive Vision (1) | Invantive Web Service (1) | ionBIZ (1) | Kadaster (1) | LinkedIn (1) | Logius COR (1) | Loket (1) | Loket.nl (3) | Magento (4) | MariaDB (1) | Matomo (2) | Mendix (1) | Microsoft Access (1) | Microsoft Dynamics CRM (1) | Microsoft Graph (1) | MySQL (10) | Nextcloud (1) | Nmbrs (2) | OData (1) | ODBC (3) | Odoo (4) | Open Archives (2) | Open Besluitvorming (1) | Oracle (21) | PayPal (2) | Pipedrive (1) | PostgreSQL (14) | Rabobank MT940 (1) | RDW (2) | Robaws (3) | Salesforce (1) | SFTP (1) | SnelStart (5) | SQL Server (13) | Stripo (2) | Stripo Email (1) | Teamleader (1) | Teamleader Focus (2) | TeamViewer (1) | Tixly (1) | Tweede Kamer (2) | Twinfield (7) | VIES (1) | Visma Severa (1) | Visma.net (5) | Wikipedia (2) | Windows WMI (2) | WMI (1) | XAA (1) | XAF (1) | Yuki (5)

Installation and platform

Settings files move from XML to JSON

A settings file in XML is converted to JSON when it is read. The user and installation settings, the cached list of databases and the databases of the user are also written in JSON, through an atomic write, and a damaged XML file is recovered where possible. From 27.0 the JSON file takes precedence; the XML file is still written for older releases on the same workstation and is planned to disappear.

What to Do

Settings files are converted from XML to JSON when they are read. From 27.0 the JSON file takes precedence and the XML file is removed in release 28.0: edit the JSON file from now on and keep a copy of the XML file until then.

  • action needed
  • importance 5
File names longer than 260 characters work on Windows

Where Windows allows it, file and folder paths up to 32,767 characters are accepted. The setup program declares support for long paths and the trace shows whether they work.

  • importance 3
Share user and installation settings with release 25.0 products on one device

Release 27.0 products read and write the user and installation settings in a way that does not conflict with release 25.0 products installed on the same device. Licence key settings of both generations are kept apart.

  • importance 3
The keychain and settings files are written safely

The keychain and settings files hold either the old or the new contents, also after a crash or a full disk, are guarded with a file lock when two programs use them, are written less often and open faster.

  • importance 3
Allow file names longer than 260 characters

The add-in now declares that it supports long file names on Windows, so files with paths longer than 260 characters can be used.

  • importance 2
Configuration errors point to the documentation of the setting

An error about an invalid configuration value now includes a hint that comes from the documentation of the setting.

  • importance 2
Sample configuration files are written with documentation of every setting

The product can write sample configuration files that list every setting with its description, default and example. The folder can be chosen with an environment variable.

  • importance 2
Separate folders for environment files, the keychain, databases and traces

The folders for environment files and for the Invantive Keychain can be set through environment variables, database definitions live in a sub-folder of the configuration folder, and traces go to a Trace folder there by default; the folder is created when missing.

  • importance 2

Licensing and sign-in

Data containers and credentials from Invantive Credentials Server

A database definition can point to Invantive Credentials Server, which supplies the data containers and sign-in credentials. The log-on window and the partition menu show these containers with their own icon, errors of the server are shown with their details, and a retrieval is repeated after a time-out.

  • Invantive Credentials Server
  • importance 4

Invantive Credentials Server, Concept of Invantive Credentials Server

Exact Online companies outside the service area are no longer accepted

Exact Online divisions of companies in a country on an exclusion list, or outside the service area, are no longer offered, except for a fixed list of companies that were allowed before. A log line states the exclusion.

What to Do

Companies in countries outside the service area are no longer available in Exact Online.

  • action needed
  • Exact Online
  • importance 4

Service area of Invantive Cloud

Invantive License Service: clearer messages, grace period and new modules

A licence key of the wrong type is explained, a licence service that is unavailable gets a specific message, and a licence that was valid stays in force for a grace period when the service cannot be reached. The check that prolongs a licence runs hourly. New licence modules exist for the Support Assistant, OEM use and subscription software, the built-in trial and open data keys use the new format, and text-mode products show tips about the licence in use.

  • importance 4

License Service

Accept the licence agreement and give a name from the command line

Command line options and environment variables accept the licence agreement for a named licence variant and supply the first and last name of the person. This lets the product start without a dialog.

  • importance 3
Invantive MCP Server is recognised as an application

The Invantive MCP Server is now a known application for licence checks and for the choice of client settings.

  • importance 3
Licence keys can be supplied through environment variables

A licence key can be given in the environment variables INVANTIVE_LIC_KEY and INVANTIVE_LICX_KEY, also with surrounding text or line breaks. This helps with unattended starts, for example in scripts and containers.

  • importance 3

Environment variables

OAuth redirect address unified for web platforms

Platforms that sign in with OAuth now use one redirect address under the invantive.com domain. Some used a separate address under invantive.eu.

  • Dynamics 365 CRM
  • Loket.nl
  • Dropbox
  • HubSpot
  • Fortnox
  • importance 3
Email addresses are accepted when the validation service does not answer

When Customer Service cannot validate an email address, because it fails or does not answer, the address is accepted as entered and the situation is traced. An invalid address reported by the service is still refused.

  • importance 2

A sign-in that fails because the user withdrew consent for the application now gives a specific error with a hint.

  • Exact Online
  • importance 2
Give a clearer message when an OAuth authorisation must be renewed

An authorisation error now advises to renew the authorisation, and problems of Teamleader are detected better.

  • Teamleader
  • importance 2
Obsolete Windows RSA properties removed from the system properties

Two obsolete properties about the Windows RSA service and an operating system update check are no longer listed in the system property view. Some descriptions now say text instead of string.

  • importance 1

Security

Loading of provider assemblies from a settings file is blocked

A provider that a settings file loads from an assembly file now fails with an error, because no files are on the allowed list yet. The EDIFACT provider no longer loads its template assembly from disk. Plan for this when a script or settings file relies on custom providers or EDIFACT templates.

What to Do

A provider loaded from an assembly named in a settings file now fails; no file is on the allowed list yet.

  • action needed
  • EDIFACT
  • importance 4
Prevent SQL injection through inlined values on MySQL and PostgreSQL

String values that are placed in generated SQL for MySQL are now escaped for backslashes as well as quotes. A PostgreSQL session now sets standard_conforming_strings to on and fails with an error when the server does not accept this.

  • MySQL
  • PostgreSQL
  • importance 3
Sensitive values are masked in traces, error data and OAuth logs

Passwords, secrets, tokens, API keys, cookies, authorisation headers and one-time codes are no longer written in clear text in traces, exception data and the log text of OAuth calls.

  • importance 3
Access to the local file system can be blocked in shared environments

On shared multi-user environments, statements that read or write local files are refused with a clear error, and a file name from outside cannot leave its folder. A single workstation, such as Query Tool, is not affected.

  • File system
  • importance 2
Add an environment variable to disable privacy mode

The environment variable INVANTIVE_DISABLE_PRIVACY_MODE switches privacy mode off, so that windows can be captured by screen-capture tools and automated tests. An explicit choice in the session wins.

  • importance 2
Find objects through synonyms and hide credentials in logged pass-through SQL

Object names from Oracle and PostgreSQL account for private synonyms. A logged pass-through statement that carries credentials is no longer shown in full.

  • Oracle
  • PostgreSQL
  • importance 2
IP address ranges in CIDR notation support IPv6

A range such as 192.168.0.0/16 or one with IPv6 addresses is now matched against IPv4 and IPv6 addresses in both notations. A range with an invalid address or prefix matches nothing.

  • importance 2
Update a component with a security advisory

A cryptography component used for XML signatures is updated to a version without a known security issue.

  • importance 2
Mail domain proguidex.com is blocked

Email addresses at the domain proguidex.com are refused.

  • importance 1

SQL engine

Correlated subqueries are supported

A subquery can refer to columns of the outer query, as in EXISTS, IN and scalar subqueries. A subquery without outer references is evaluated once per statement and its answer is reused.

  • importance 5
QR code functions take one size value instead of width and height

The functions that create a QR code and a QR code for a European payment (EPC) now take a single size per element instead of separate width and height. Existing statements that pass width and height must be changed. The QR code library has been replaced.

What to Do

Adjust statements that call the QR code functions with a separate width and height.

  • action needed
  • importance 4

Function BARCODE_QR

Add data dictionary views for keys and foreign keys

Two new data dictionary views list the primary keys and the foreign keys of tables, including keys of several columns. The columns view gets the original database data type and whether a value is required on update.

  • importance 3
Add technical documentation and more table and view properties to the data dictionary

The data dictionary lists technical documentation for tables. The view catalogue gains 13 columns, among them the supported operations, documentation, an example, whether the view is partition specific, and the estimated latency and throughput. Technical documentation was added to a number of Exact Online views.

  • importance 3
Add the DESCRIBE statement to show the columns of a select or table

The new statement DESCRIBE returns the columns that a select statement, a table, a view or a table function answers, without reading any row.

  • importance 3

[Describe statement](https://documentation.invantive.com/Invantive+UniversalSQL/Grammar/Statement+Types/Describe+Statement+(describeStatement%29)

Cancel queries, SYNCHRONIZE and PSQL loops faster and more reliably

A running query, synchronise, script loop or web request reacts to a cancel request sooner, and background threads are stopped.

  • Twinfield
  • importance 3
Cancel statements and log on more reliably

Cancelling stops statements between rows and between statements of a batch, and background work of a log on is stopped before its connection is closed. Parallel readers can be disposed more than once and no longer leak resources.

  • importance 3
Column references may carry a schema and table qualifier

A column can be written as column, qualifier.column or schema.table.column, as in SQL Server.

  • SQL Server
  • importance 3
Copying data keeps the original database data type

The data type as the database reports it is kept with a column and used for bulk insert and create table. Wide decimal columns keep their integer digits when copied to MySQL, Oracle or SQL Server.

  • Oracle
  • MySQL
  • SQL Server
  • importance 3
Division and office list is kept when the USE statement changes the selection

Selecting divisions or offices with the USE statement no longer discards the loaded list. The list is not retrieved again and the state of each entry is kept. Newly selected entries are added to the existing selection.

  • importance 3
HTTP functions can ignore web errors

The functions that fetch or post web content accept an extra argument to continue when the web server answers with an error, and the error text states the HTTP status code.

  • importance 3
Integer constants in SQL keep an integer type

A whole number written in a statement is now handled as an integer instead of a decimal number. Result types of expressions on such constants can differ from before.

What to Do

Check expressions that rely on whole numbers being decimal; the data type of the result can differ.

  • action needed
  • importance 3
Register the SQL functions REGEXP_COUNT and REGEXP_LIKE for licensing

The SQL functions to count and test regular expression matches are registered with the licence requirements of advanced calculation.

  • importance 3
Table function to split a text into runs of characters

A new table function returns the runs of a given length of a text, with their positions. It can be joined to find texts that resemble each other. Use of the function is controlled by a function right.

  • importance 3
number_to_speech supports more languages

The SQL function number_to_speech can spell numbers in English in addition to Dutch and now accepts exactly two arguments: the number and the language.

  • importance 3
Add SQL functions for text similarity

New SQL functions calculate the Levenshtein ratio, the trigram Dice coefficient and the n-gram Dice coefficient between two texts. The licence requirement for the translation workbench is registered as well.

  • importance 2
Allow cancelling of HTTP calls, waits and compression

Calls to web services, waits between retries and compression of data now stop when the user cancels, instead of running to the end.

  • importance 2
Clear error when a PostgreSQL connection has no host

A PostgreSQL connection string without a host now gives an error that says so, instead of a message about a null value.

  • PostgreSQL
  • importance 2
Clearer errors when a data container is missing

The error for a missing data container now names the table or the function that was called and gives a specific hint.

  • importance 2
Clearer messages for fields that are unknown or cannot be read

The message for a missing field now says whether the field name is unknown or the field is known but its value could not be read. Messages about a missing primary key name the table in full.

  • importance 2
Duplicate data container aliases are reported with an error

A settings file with two data containers that have the same alias now raises an error that names the alias and advises to check the settings file for duplicates.

  • importance 2
Duration columns in system views have a decimal type and more precise values

Durations in the session and execution views of the data dictionary are measured and stored with fractions of a millisecond. The columns now have a decimal number type instead of an integer type.

What to Do

Check queries that expect whole numbers in the duration columns of the session and execution views.

  • action needed
  • importance 2
Fill estimated latency and throughput of tables with defaults, including Exact Online

Tables and views of the drivers now carry an estimated latency and estimated rows per minute, so that a client can judge which table is cheapest to read. Exact Online uses different default figures for the standard, bulk, sync and incremental tables.

  • Exact Online
  • importance 2
Include the alias in the hint for a wrong column name

The hint on an unknown column name now includes the alias of the table, so the hint can be used as written.

  • importance 2
List views, functions and procedures in the data dictionary for SSMS 20 to 22

Clients such as the Object Explorer of SQL Server Management Studio 20 to 22 now list views, functions and procedures created with CREATE VIEW, CREATE FUNCTION and CREATE PROCEDURE, and can read the source text of these objects.

  • importance 2
Missing column error names the table that has the column

When a statement refers to a column that does not exist on a table alias, the error and hint now mention the table the alias refers to.

  • importance 2
Partition codes can be given as text in the persistent cache statements

In the statements that configure webhooks and download data for a persistent cache, the division or office can now be written as a text constant as well as an identifier.

  • importance 2
Pivot and group by accept binary columns

Pivot and group-by can be used on binary columns, with defined ordering of bytes.

  • importance 2
Suggest similar names for PSQL variables, shown with their alias

When a variable or column name is wrong in a PSQL block, the hint with similar names measures the name itself and shows the name with its alias.

  • importance 2
Clearer error messages for NDJSON, HTML, JSON and XML sources

The message on an empty value in NDJSON is clearer, and a spelling error in the message on empty columns is corrected.

  • importance 1
Clearer error when a function receives a wrong number of arguments

When a function accepts a fixed number of arguments, the error message now states that number instead of a range.

  • importance 1
Reject native-only databases with several data containers or fail-over

A database that bypasses the Invantive SQL engine is now rejected when it has more than one data container, a fail-over or a platform without native SQL.

  • importance 1
Show a clearer error when a regular expression times out on a very large value

A time-out of a regular expression on a value of one million characters or more is reported with its own message, so the cause is visible.

  • importance 1
Smaller generated SQL for database platforms

Filter groups in SQL sent to a database platform are no longer wrapped in superfluous brackets, which makes traces easier to read.

  • importance 1
The unimplemented ^ operator is removed from the SQL grammar

The ^ sign is no longer part of the SQL language. It was never implemented.

  • importance 1

Scripting

Parts of a PSQL block can run in parallel

PSQL gets a PARALLEL construct that runs branches and loop iterations side by side, SYNCHRONIZE accepts a parallel option, and the package dbms_atomic holds values that parallel branches share safely.

  • importance 5

Package dbms_parallel, Package dbms_atomic

Invantive Script statements are checked with a grammar, with better error messages

Statements of Invantive Script, such as local export results and local log on, are now read by a proper grammar. Keywords may be written in any case and options may follow in any order, while an option given twice or two contradicting options are refused. Errors name the problem more precisely. A few unused statements are withdrawn: the five results-clipboard statements and a variant of define encrypted.

  • importance 4
Remove obsolete Invantive Script statements

The statements to encrypt passwords, variable values and connection strings, define encrypted variables, deploy static files, show the keychain, run garbage collection, optimise the application, enable the event log, give feedback and import XML batches into Exact Online are no longer available. Scripts that use them must be changed.

What to Do

Remove the statements for encrypting passwords and variables, deploying static files and showing the keychain from scripts; they are no longer recognised.

  • action needed
  • Exact Online
  • importance 4
Scripts can run operating system commands with the new package dbms_os

The package dbms_os runs an operating system command with environment variables and a time limit, returns its output and exit code, and calculates a file hash. A command that runs too long is ended together with the programs it started. Files it writes are UTF-8 without byte order mark.

  • importance 4

Package dbms_os

A script can query its own execution profile

Runs of Invantive Script, their statements, started operating system commands, variables and exit codes are registered and can be queried with plain SQL through the new data container Script. The name of the profile log can be chosen, and statements register the memory they allocated.

  • importance 3
Extend the cloud_http package for web applications

The package offers functions for the public URL of a module, the origin and the query string of the request and a redirect. Functions record the release in which they appeared.

  • importance 3
Remove the compression level option from loading results from the clipboard

The statement that loads results from the clipboard no longer accepts a compression level, because compression is not relevant for the clipboard.

What to Do

Remove the compression level clause from statements that load a results clipboard.

  • action needed
  • importance 2
Row count variable is empty before the first statement

The row count of the previous statement is now empty (null) when no statement has been executed yet, instead of zero.

What to Do

Check scripts that compare the row count of the previous statement with zero before the first statement.

  • action needed
  • importance 2
Show messages of MySQL, Firebird and ODBC databases in dbms_output

Notifications from MySQL, Firebird and ODBC databases appear in dbms_output, also during log on.

  • MySQL
  • Firebird
  • ODBC
  • importance 2

Query Tool user interface

Stop a lengthy formula calculation or synchronisation from Excel

A calculation of Invantive formulas that takes long can now be ended. A window with a stop button appears after five seconds, the Escape key also ends it, and a calculation ends by itself after a time limit that is set in a new user setting (30 seconds by default). Formulas that were not calculated show #N/A until the next calculation. The cancel button of a synchronisation now also stops the query in progress.

  • importance 5
Ribbon follows a language change and Debug settings are checked on entry

After the language is changed in the preferences, the ribbon is now shown in the new language without a restart. On the Debug tab of the configuration the number of threads is limited to a valid range and the block code to debug is chosen from a list of the blocks of the active model.

  • importance 3
Show connection activity in the ribbon

The ribbon gets a button that shows what the connections are doing, with a tool tip and a window with details. A failure to add the button no longer disturbs the start of the add-in.

  • importance 3
Use the Query Tool for Windows from the ribbon and keep Excel names in queries

The Query Tool that opens from the ribbon is now the current Query Tool for Windows. Names that refer to Excel cells keep working in its queries.

  • importance 3
All host applications open the Query Tool for Windows; the old editor is removed

Studio, Data Loader, Invantive Control, the Outlook add-in and the snippet editors now open the same Query Tool window. The old menu-based editor is removed. Excel names in references resolve again from Invantive Control.

  • importance 1

Platforms and drivers

DeepL driver

A new driver reads and writes DeepL: languages, billing, translation, writing assistance, documents, glossaries, style rules and translation memories.

  • DeepL
  • importance 5
Add write support to AFAS Online

AFAS Online connectors that only write become tables per update connector. Objects below the main element, such as the lines of a financial entry, get a table of their own that can be inserted into within a transaction.

  • AFAS Online
  • importance 4
New platforms: Inspectlet, Matomo, Nextcloud and Tweede Kamer v5

Four new drivers read Inspectlet (websites and recorded sessions), Matomo web analytics with a package of PSQL procedures, a Nextcloud server (tables depend on the installed apps) and the Tweede Kamer open data on the new API. The earlier Tweede Kamer driver remains available. Each platform has a licence module and an icon.

  • Inspectlet
  • Matomo
  • Nextcloud
  • Tweede Kamer
  • importance 4
Pipedrive platform

Pipedrive can be read as a new platform, with labels for custom fields, and the OAuth sign-in window understands its error answers.

  • Pipedrive
  • importance 4
Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list

The LinkedIn driver and the SOAP-based Loket.nl driver are no longer part of the product. The Dynamics CRM driver no longer registers its predefined list of tables and columns.

What to Do

Statements on the LinkedIn driver and the SOAP-based Loket.nl driver no longer work.

  • action needed
  • LinkedIn
  • Loket.nl
  • Microsoft Dynamics CRM
  • importance 4
The legacy Oracle driver and the Invantive Web Service driver are removed; Oracle 18 is the minimum

The legacy Oracle driver is no longer registered and Oracle is handled by the managed driver, a log-on to a database older than version 18 is refused, and the Invantive Web Service driver and its data container are no longer offered.

What to Do

Check connections to Oracle databases older than version 18, and connections that name the legacy Oracle driver or the Invantive Web Service driver: they no longer work.

  • action needed
  • Invantive Web Service
  • Oracle
  • importance 4
Visma.net: new API specification, Visma Connect log-on and the Sales Order APIs

The Visma.net driver uses the API specification of 18 June 2026 and the new Visma Connect sign-in, and adds tables for the Sales Order APIs with server-side filtering, insert and update. Filters such as not in and not equal on a column with a fixed list of values are sent as requests for the remaining values.

  • Visma.net
  • importance 4
A lost connection to a relational database is set up again

A connection to a relational database that was lost is rebuilt and the application log-on is repeated on the new session, so the next statement does not fail. The pool of connections shrinks when it is not needed.

  • importance 3
Add company and deal attributes to the Brevo driver

The Brevo driver returns the attributes of companies and deals.

  • Brevo
  • importance 3
Bring the ActiveCampaign driver level with API v3

The driver gains columns and tables, such as notes, custom objects, custom field options, deal roles and bulk import of contacts. Writes that the platform could not carry out are withdrawn, and the request rate follows the limits that the platform reports.

  • ActiveCampaign
  • importance 3
Connection forms are described by the attributes of a driver

Provider attributes now state the kind of value, the accepted values and whether a value is required, for more numeric types. Two data dictionary views show these properties. A web service URL is requested at log on only for platforms where the user supplies it.

  • Bridge Online
  • Dynamics 365 CRM
  • Magento
  • Mendix
  • Nmbrs
  • importance 3
Crisp: 50 more tables, filters at the platform and procedures to clear fields

The Crisp driver offers about 50 additional tables, sends filters on conversation tables to Crisp and exposes more conversation data. New procedures clear a field of a people profile.

  • Crisp
  • importance 3
Exact Online XML tables follow the XML schema of 3 August 2026 and load faster

The XML tables are updated to the current schema, and the data model is read from a predefined list of fields instead of being derived from the schema on every start.

  • Exact Online
  • importance 3
Extend Gripp CRM with more tables and server-side filtering

Gripp CRM gets more tables, including tables for embedded lists, and more conditions are evaluated by Gripp itself, which reduces the rows transferred.

  • Gripp CRM
  • importance 3
Extend Magento with writes, packages and custom attributes

Magento gets a full data model with read, insert, update and delete, a package for operations that are no table rows, sample statements and one column per custom attribute of a product.

  • Magento
  • Robaws
  • importance 3
Extend the Twinfield driver with settings, runs and code lists

New table functions read office, user, VAT code and project rate settings, and payment and collection runs. Code lists of the platform are given in the column descriptions, and a browse that only counts rows asks for one column. Page size on wide transaction tables is limited.

  • Twinfield
  • importance 3
Gripp CRM tables now have a schema name

The tables of Gripp CRM are now placed in a schema. Statements that use the old table names may have to be changed.

What to Do

Adjust statements that use the old table names of Gripp CRM; the tables now have a schema name.

  • action needed
  • Gripp CRM
  • importance 3
Magento and Open Besluitvorming are production platforms; Yuki and Robaws leave run-out

Magento, Open Besluitvorming and Stripo are registered as production platforms, and Yuki and Robaws are production platforms again after they were marked as run-out.

  • Magento
  • Open Besluitvorming
  • Robaws
  • Stripo
  • Yuki
  • importance 3
PostgreSQL: setting fail-on-missing-tables

A new setting fail-on-missing-tables on the PostgreSQL driver controls the check that every primary key in the metadata has an accessible table or view. When off, the check is skipped.

  • PostgreSQL
  • importance 3
Read all read operations of the Yuki API

Yuki gets tables for the read operations of its published web services that were not available yet. Yuki stays read-only.

  • Yuki
  • importance 3
Refused Exact Online reads are remembered and listed

Calls that Exact Online refuses are remembered across sessions and no longer requested again and again. The new view RequestTablesWithoutRights lists the tables and companies for which a read was refused because of missing rights.

  • Exact Online
  • importance 3
SFTP connections are really supported and FTP calls are asynchronous

The SFTP driver now connects to an SFTP server with a password, with separate time-outs for connecting and for a single operation. Before, it could not perform the calls. The FTP driver was made asynchronous.

  • SFTP
  • FTP
  • importance 3
Set the idle period before SQL connections are closed

A new provider attribute sets after how many seconds an idle connection to a SQL database is closed. Server products keep connections for 300 seconds by default.

  • SQL Server
  • MySQL
  • PostgreSQL
  • Oracle
  • importance 3
SnelStart data model updated to the API definition of 27 May 2026

The SnelStart tables and columns follow the new API definition. More reference columns are included and decimal values are read as decimal numbers. One slow, experimental view stays disabled.

  • SnelStart
  • importance 3
Speed up SnelStart counts and read documents and long text filters

SnelStart gets a table for sales invoice lines from orders. Counts read only the key column. Document tables with an empty parent identifier no longer fail, and a filter on long text is narrowed with a prefix.

  • SnelStart
  • importance 3
Stripo Email platform

Stripo Email can be read and written as a new platform with emails, templates and modules.

  • Stripo
  • Stripo Email
  • importance 3
Support SQL Server geography, geometry and hierarchyid data types

Columns of the SQL Server types geography, geometry and hierarchyid can now be read through the SQL Server driver.

  • SQL Server
  • importance 3
Twinfield: more offices can be used with the Invantive client ID

The list of offices that may be used with the Invantive client ID has more offices, including office 00001, and the new setting additional-allowed-offices names further offices.

  • Twinfield
  • importance 3
Update Kadaster to the current OpenAPI specification

The tables of Kadaster follow the OpenAPI specification of the platform.

  • Kadaster
  • importance 3
Update Robaws to the latest API and add a package for operations

Robaws follows the API specification of 2026-11-01. A package offers operations that are no table row, such as archiving, locking, booking an invoice and downloading the PDF of a document.

  • Robaws
  • importance 3

Wikipedia gets tables for search, pages with content, the history and links of a page and files, and a parameter to choose the language wiki.

  • Wikipedia
  • importance 3
Update the Logius COR driver to the new host and API version 1

The driver uses the new Logius register host and API version 1. The old host no longer resolves. Error answers use the new format.

  • Logius COR
  • importance 3
Use the REST driver for Loket.nl formulas

Formulas for Loket.nl now use the REST driver instead of the SOAP driver.

  • Loket.nl
  • importance 3
Web calls wait and retry better

Timeouts apply as configured, a stalled connection is cut off and treated as temporary, retries wait longer each time with a random part and follow the Retry-After header, a session slows down before the minutely rate limit is used up, a token endpoint that does not answer is dropped after 30 seconds, and damaged compressed answers are read again.

  • Dynamics CRM
  • importance 3
Accept RFC 3339 dates of any precision and domain values with special characters

Dates with any number of fractional seconds and any offset are read. Domain values with spaces or other special characters give valid resource codes.

  • importance 2
ActiveCampaign: tracking events table can be queried

A query on the tracking events table of ActiveCampaign no longer fails. The table can only be used to insert data, so a query returns no rows.

  • ActiveCampaign
  • importance 2
Add the company name to the Exact Online balance lines per period view

The view with balance lines per period for all periods now returns the name of the company in a new column.

  • Exact Online
  • importance 2
Add vehicle columns to the RDW driver

The RDW tables get additional columns, among them mass, brake system and speed data.

  • RDW
  • importance 2
Chargebee: custom fields of type url are supported

Chargebee custom fields of type url are now read as text columns. An unsupported display type for a text field is logged.

  • Chargebee
  • importance 2
Check the minimum version of MySQL, MariaDB and other relational databases

The supported versions of a relational database are now checked against a minimum version instead of a list of releases, so newer releases are accepted. MariaDB has its own minimum.

  • MySQL
  • MariaDB
  • importance 2
Crisp: clearer error messages for rejected data

Crisp errors for an invalid email address now have their own message and name the value. The website setting is checked when it is set.

  • Crisp
  • importance 2
Describe Odoo errors that occur often

An Odoo server error 'Expected singleton' is reported with its own message code instead of a general code.

  • Odoo
  • importance 2
Exact Online: a supplier item note column can be empty

The column that indicates whether notes are copied for a supplier item is now optional.

  • Exact Online
  • importance 2
Exact Online: longer general ledger classification code

The maximum length of the general ledger classification code is extended from 30 to 60 characters.

  • Exact Online
  • importance 2
Failures of SQL databases get specific error codes and messages

Failed log-ons and statements on Oracle and other SQL databases are classified per cause, and the messages name the table or the cause.

  • Oracle
  • importance 2
Improve the hints and recovery of failing reads

An error states whether it is recoverable, an empty or invalid answer is retried after the cache entry is removed, and an HTML page with a 404 status is not hidden by the setting that ignores 404 errors.

  • importance 2
ODBC: better checks and messages for connections and drivers

An ODBC connection without data source name and driver is rejected with a clear message. A data source without a driver file is reported and the driver name is cleaned of braces before it is looked up.

  • ODBC
  • importance 2
Obsolete settings of Visma.net and Teamleader Focus are ignored

The Visma.net setting Use VNI and the Teamleader Focus setting api-group-authentication are marked as obsolete. Setting VNI to true no longer raises an error, since the setting is ignored. Remove both from settings files.

  • Visma.net
  • Teamleader Focus
  • importance 2
Rate limits can be shared across connections and are shown per data container

Drivers can share one rate limit across all connections to a platform. The data dictionary view with data containers gains 15 columns with the rate limit state of the container.

  • importance 2
Read tables with composite primary keys from SQL Server

Tables whose primary key has several columns are now known with all key columns.

  • SQL Server
  • importance 2
Recognise the managed Oracle driver after the legacy Oracle driver is dropped

Functions for Invantive Producer and Invantive Vision are now available on connections that use the managed Oracle driver, and no longer look for the legacy Oracle driver.

  • Oracle
  • Invantive Producer
  • Invantive Vision
  • importance 2
Register the number of rows of tables as statistic for SQL Server, MySQL and PostgreSQL

The row count that the catalogue of the database knows is registered per table, so that the engine can plan and report with it.

  • SQL Server
  • MySQL
  • PostgreSQL
  • importance 2
Report a maximum length of 60 for YourRef columns in Exact Online

The YourRef columns of several Exact Online entities now report a maximum length of 60 characters. Some of them reported 30 or no length before.

  • Exact Online
  • importance 2
SQL Server driver loading is checked and reported with a clear error

The SQL Server provider now uses the Microsoft SQL Server client library by name and reports an error when the driver cannot be loaded for the operating system or processor.

  • SQL Server
  • importance 2
Search RDW by registration number

The RDW tables accept the registration number with or without hyphens or blanks and filter on it at the server.

  • RDW
  • importance 2
Show the offending value and a translated message when a JSON field cannot be converted

When a value in a JSON response cannot be converted to the data type of the column, the error is a translated SQL error and shows the start of the value.

  • importance 2
Treat dates without offset as universal time and cache every successful answer

A date without a time zone offset from a platform is read as universal time unless a driver says otherwise. Answers with a successful status other than 200 are now kept in the memory and disk cache.

  • importance 2
Twinfield: clearer error when the cluster address is missing

A Twinfield request without an API address now fails with a specific error before the call is made.

  • Twinfield
  • importance 2
Understand the new ionBIZ error formats and return no rows without access

The ionBIZ driver reads one more error format. When ionBIZ refuses a table for the user, the statement returns no rows instead of an error.

  • ionBIZ
  • importance 2
Update Discourse and show the errors of the Discourse application

Discourse follows the current API specification and shows the error texts, error type and waiting time of a rate limit that Discourse returns.

  • Discourse
  • importance 2
Update Open Archives and answer counts with table function parameters

A count on Open Archives now carries the parameters of the table function. When a platform cannot do that, no aggregate is pushed down and the rows are counted by the engine.

  • Open Archives
  • importance 2
Update the WMI platform

The WMI platform can read a management class and returns nothing, instead of an error, when access is denied.

  • WMI
  • importance 2
Clearer error messages for Easyflex and Brevo

The Easyflex message tells the user to contact Easyflex about a licence issue. The Brevo message for an invalid parameter names the value that was rejected.

  • Easyflex
  • Brevo
  • importance 1
Clearer error messages from Odoo

More error types of Odoo are recognised and passed on with their own message.

  • Odoo
  • importance 1
Recognise more forms of the Exact Online invalid callback URL error

The message about an invalid callback address is recognised in more wordings and shows the address.

  • Exact Online
  • importance 1
Report the retrieval duration of the Exact Online row counts view with decimals

The column with the retrieval duration in milliseconds of the Exact Online row counts view now has a decimal data type instead of a whole number.

  • Exact Online
  • importance 1

Export and import

Export to HTML and Rich Text Format; the Excel export follows the settings

Results can be exported to HTML and RTF with the chosen columns, row range and row limit. The Excel export follows the settings for columns, rows and SQL statement and can put the SQL on a separate worksheet.

  • importance 3

Exporting results

UTF-8 files are written without a byte order mark by default

Exports, trace files, plug-in files and the input and output of operating system commands are written as UTF-8 without a byte order mark unless one is asked for.

What to Do

Check programs that read exported text files and expect a byte order mark.

  • action needed
  • importance 3
Invalid CSV settings are reported with a clear error

The CSV settings used to read or write CSV data are now validated. An invalid combination raises a specific error instead of failing later.

  • importance 2
Leave out empty result sets from the output when requested

An execution hint makes the output writer skip a result set that holds no rows.

  • importance 2
Write text files and model XML as UTF-8 without byte order mark

Text files and XML written by the add-in are now UTF-8 without a byte order mark by default.

  • importance 2

Performance

More work is sent to the platform: row limit, grouping, selected columns and joins

A query with LIMIT or TOP is limited by the platform, COUNT, SUM and other group functions are answered by the platform on supported drivers, only the columns that a query needs are requested, join conditions are forwarded, an exists condition on a child table reaches the platform, and OData platforms get shorter filters with the IN operator. Fewer rows are transferred.

  • ActiveCampaign
  • Bridge Online
  • Crisp
  • Exact Online
  • IBM Db2
  • Inspectlet
  • Invantive Bridge Online
  • Matomo
  • MySQL
  • ODBC
  • OData
  • Odoo
  • Oracle
  • PayPal
  • PostgreSQL
  • SQL Server
  • Tweede Kamer
  • importance 5
Big Data JSON reads files much faster and skips files that cannot match

Collections of NDJSON files, plain or Zstandard compressed, are streamed and only the needed columns are built. A directory gets an index with value ranges, Bloom filters and counts, so filters, counts and group-by statements read fewer files.

  • Big Data JSON
  • importance 4
Data is loaded in the background while a session is idle

A connected session fills caches with predictable data, such as the tables read in the last fourteen days and the incremental tables of Exact Online, Freshdesk and Freshservice, using spare rate allowance. Four loads run in parallel, partitions can be chosen, and the connection monitor shows the loads.

  • Exact Online
  • Freshdesk
  • Freshservice
  • importance 4
Exact Online incremental tables reload less often and are read faster

Incremental tables avoid full reloads caused by a rejected previous image or a row count guard, are read from the cache up to six times faster, and stop an incremental run when the deleted rows needed are older than the platform keeps them. The new table IncrementalEntityTypes lists the entity types that can be loaded incrementally.

  • Exact Online
  • importance 4
Bulk insert for Oracle and MySQL

Rows are inserted into Oracle with array binding and into MySQL with the bulk loader, which is faster than row-by-row inserts.

  • MySQL
  • Oracle
  • importance 3
Data Cache no longer runs forced garbage collection; three settings removed

The Data Cache driver no longer starts a full garbage collection after replications. The settings garbage-collection-physical-memory-load-threshold, garbage-collection-replication-interval-count and garbage-collection-replication-minimum-interval-sec are removed. Remove them from settings files that still set them.

What to Do

Remove the three garbage-collection settings of the Data Cache driver from settings files.

  • action needed
  • Data Cache
  • importance 3
Disable GSS (Kerberos) negotiation on PostgreSQL connections for faster log-on

Every new PostgreSQL connection first asked the server for Kerberos encryption, which servers without Kerberos refuse by closing the connection. The setting is now disabled by default, which makes opening connections faster.

  • PostgreSQL
  • importance 3
Faster log-on with many data containers

Translations are kept locally and fetched at most once a day, the keychain is read once when switching database, icons are downloaded in parallel, and discovery no longer waits for the slowest platform: a platform that is still busy is shown when it answers.

  • AFAS Online
  • CBS
  • Exact Online
  • HubSpot
  • Salesforce
  • importance 3
Lower memory use and faster processing

Encryption, compression, logging, translations, JSON reading, sorting, the in-memory driver and long-running sessions allocate less memory and use less CPU time. Creating a table from a large result streams the rows, and several string functions run faster.

  • Exact Online
  • In-memory
  • MySQL
  • Oracle
  • PostgreSQL
  • SQL Server
  • XAF
  • importance 3
Oracle is read faster and sends fewer extra statements

Data is fetched in larger batches from the first round trip, rows are limited and paged on the server, the output buffer is read only while something listens, and sessions send fewer statements for settings.

  • Oracle
  • importance 3
Zstandard compression for trace files, caches and SQL functions

Trace files, persistent caches, saved result sets and the disk cache of web answers are compressed with Zstandard, which is faster than gzip at a similar size. Two SQL functions compress and decompress with Zstandard, and a text file with gzip or Zstandard content is read as plain text.

  • importance 3
Close the model editor faster

The tree of the model editor is now released before its image list. Closing the editor of a large model no longer takes time per node.

  • importance 2
End slow web requests and long text comparisons when a run is cancelled

Cancelling a run now also stops calls to Invantive services that are slow to answer and long text comparisons. Decompression of crafted input can be cancelled.

  • importance 2
Keep one translations cache per language and reload translations less often

Translations are cached per language, so switching language or starting again downloads less. An empty or damaged cache file is detected and replaced.

  • importance 2
Load the labels of building blocks in parallel with a limit

The labels of the building blocks (array formulas) in the ribbon are fetched in parallel, with at most 32 at the same time.

  • importance 2
Retrieve data asynchronously and size parallel buffers dynamically

The engine starts to retrieve data asynchronously from drivers, which can lower waiting time for large result sets. The buffer between parallel readers and consumers now varies in size.

  • importance 2
Use fixed throughput figures per driver for planning and progress

Drivers carry static figures for rows per minute, so the engine can estimate duration before the first read. Figures of several drivers were extended.

  • importance 2
Cache Swagger specifications on disk for a day by default

Drivers based on a Swagger specification keep the specification for one day in the disk cache by default.

  • importance 1

Logging and diagnostics

Register every call to a platform in the connection activity

Calls of drivers to platforms, including database drivers, are registered with begin and end, rows and duration. The connection monitor shows them while they run and with the action of the user that caused them. Earlier, several calls were not registered or were counted twice.

  • importance 3
Error about a single-row fetch names the table and the value

Errors saying one row was expected name the table that was queried and the value looked for.

  • importance 2
More diagnostics: message codes, trace detail and monitoring

More failures have their own message code, trace records carry a severity name, spans with standard trace identifiers and an OpenAPI description, the trace shows memory and processors including container limits, and a failure to load an assembly is explained. A trace level below debug can be switched on separately.

  • importance 2
Register Oracle and WMI calls in the connection monitor and the usage figures

Calls such as reading the dbms_output buffer, reading the session environment and queries over WMI are now registered as session I/O. Before, they were missing from the connection monitor, the usage figures and Invantive Customer Service.

  • Oracle
  • Windows WMI
  • importance 2
Statistics show memory and CPU time per statement

The statistics of a statement include the heap allocations and the CPU time of its threads.

  • importance 2

Translations and texts

English labels for the tables and columns of more drivers

The labels of the tables and columns of the Yuki, Gripp, Magento, Wikipedia, Open Archives, AFAS Profit and incremental Exact Online views are added in English.

  • AFAS Profit
  • Exact Online
  • Gripp
  • Magento
  • Open Archives
  • Wikipedia
  • Yuki
  • importance 2
Improve the hint for objects with the same name

When several objects share a name, the hint now tells the user to state the fully qualified name instead of changing database privileges.

  • importance 2
More messages and hints in the language of the user

Error messages and hints of the engine and several drivers (OAuth, PostgreSQL, Tixly, Twinfield, Gripp, Crisp, Odoo) are available in more languages, Hindi is a known interface language, and singular units are used in durations.

  • Crisp
  • Gripp
  • Odoo
  • PostgreSQL
  • Tixly
  • Twinfield
  • importance 2
Add hints and translatable texts to errors of Excel table functions

Errors for cells with an error, a value of the wrong data type, a column without a name or a failed range copy now come with a hint on how to correct them, and the texts can be translated.

  • importance 1
Show the Oracle message about wrongly installed software in the language of the user

The Oracle error about software that is not installed correctly is now translated. Before, the text was always English.

  • Oracle
  • importance 1

Documentation

Help links, the splash screen, the default address of Customer Service and the links of data sources point to the invantive.eu domain.

  • Dynamics CRM
  • Microsoft Graph
  • PayPal
  • importance 3

The community forum link that is shown with hints is chosen per product and per supplier of the licence.

  • importance 2
Updated contact details in the privacy policy

The embedded privacy policy texts now give the current email address and contact page of the company.

  • importance 2
XML schema for the database settings files

An XML schema is available that describes the settings files with database connections. It documents the allowed elements and values.

  • importance 1

Other

Add rights for deleting databases and managing settings files in the database editor

The database editor has rights for deleting a database and for managing settings files, and a folder for databases. Command-line help texts are loaded through resource codes.

  • importance 2
Remove online assistance through TeamViewer

Online assistance through TeamViewer is no longer offered.

  • TeamViewer
  • importance 2
Remove the application optimiser, remote support downloads and advertorial dialogs

The application no longer offers to optimise itself after installation, and the diagnostics window no longer offers the TeamViewer and AnyDesk support modules or the GacUtil download. Advertorial dialogs have been dropped.

  • importance 2
Return proper HTTP status codes for refused dependencies and too many requests

Servers that host the engine answer HTTP 424 and 429 for the matching errors, and keep the status code that an error carries.

  • importance 2

All Bug Fixes

Defects of the older release that are repaired.

Installation and platform

Handle read-only workbooks, several Excel instances and a function library not replaced

A model is kept in memory when Excel refuses to store it in a read-only workbook, the error for several running Excel instances is only shown when it explains a locked file, and a function library that cannot be replaced is retried at the next start instead of being installed again with an error. The wait for the activation of the add-in is judged against measured times.

  • importance 3
Fix a null initialisation error at start-up in the dependency helpers

Internal helpers could be used before their global state had been created, which gave a null error during start-up. The state is now created on first use.

  • importance 2
Make sure the process exits even when the exit registration fails

When registering the exit or the clean-up raised an error, the process did not always end. The process now always exits.

  • importance 2
Avoid a possible hang when reading the installation identifier on Linux and macOS

The command used to read the installation identifier could block when its output filled a buffer. Output and errors are now read at the same time.

  • importance 1
Repair duplicate XML element names in the product installation settings

Several settings in the product installation settings file shared an XML element name, among them the last language hash, the licence key storage dates and the export file name. Each setting now has its own element name.

  • importance 1

Licensing and sign-in

Refresh Exact Online tokens correctly when requests of one session run concurrently

Platforms that renew refresh tokens, such as Exact Online, accept only the newest token. Concurrent requests of one session each held an older copy and failed with an error about an outdated refresh token. A renewed token is now shared by all connections in the process.

  • Exact Online
  • importance 4
Prevent failing entry of the password on the Exact Online sign-in page

Entering the user name and password on the Exact Online sign-in page failed from time to time. The sign-in window now waits for the fields and retries.

  • Exact Online
  • importance 3
Repeat authorisation also when an OAuth error is wrapped in another error

When a sign-in error was wrapped inside another exception, the automatic retry with a new authorisation did not start and the original error was shown. Wrapped OAuth errors are now recognised wherever they occur.

  • Exact Online
  • importance 3
A failure to write the backup copy of a settings file no longer blocks reading it

Reading a settings file failed when the last known good copy could not be written. The copy is now written separately and a failure is reported without stopping the log on.

  • importance 2
A system property returned the licence text under the name of the title

The system property with the licence agreement text had the name of the title property. The name is corrected.

  • importance 2
Credentials Server client does not retry a time-out and names itself

A transport time-out from the Credentials Server was retried three times over two minutes, which prolonged a deliberate lock-out. It is now not retried. The Credentials Server and Bridge Online clients identify themselves by their own name instead of a borrowed one.

  • Bridge Online
  • importance 2
Do not repeat the closing message in a second dialog

After the user messages window has shown the messages and said that the application closes, a second dialog with the same text no longer appears. The log-on is not handled further when the messages ended it.

  • importance 2
Keep one session identifier for the whole log on

The session identifier was replaced at the end of a log on. Components such as the data cache that had already registered the session then pointed to a session that no longer existed.

  • importance 2
Log on no longer fails with a collection-modified error while icons are downloaded

A log on of Invantive Estate could fail because the list of cached icons changed while its size was being added up. The list is now read safely and its size is no longer recalculated for every icon.

  • Invantive Estate
  • importance 2
Repair loading of a licence key in the licence helper

A licence key that was valid was handled as invalid, and the other way round, when a key was loaded through the licence helper. The condition has been corrected.

  • importance 2
Repair log on to Invantive Business with the sample database and Visma.net

Invantive Business refuses to open a database without a current user. The sample database and the Business variants of Visma.net and Xaf now supply a user log-on code, so log on works.

  • Invantive Business
  • Visma.net
  • importance 2
Repair reading of connection files that list failover before data containers

Connection files written before November 2019 could lose their data containers when read. Both element orders are now read in full.

  • importance 2
Fix licence keys that contain line endings of another platform

Line endings in a licence key were removed by looking for two specific characters. This is replaced by a platform-independent removal. Text meant for Windows is now generated with Windows line endings on every platform.

  • importance 1
Log on refused by a message of Customer Service gives one error instead of two

When a log on is refused after the user was told why, the session no longer raises an extra error.

  • importance 1

Security

XML from outside is no longer allowed to load external entities

Processing XML from external services, XSLT transformations and the XML of an RSA key no longer resolves DTDs or external entities.

  • Twinfield
  • VIES
  • Visma Severa
  • importance 3
Reject malformed encrypted data with a clear error

Decryption of damaged or incomplete encrypted data failed with a null-reference error or named the wrong block in its message. It now rejects the data with a correct error.

  • importance 2
OAuth events and TOTP rate limiters no longer grow without bound

The list of recorded OAuth events is capped at 100 entries and returns the newest ones. The administration kept for repeated failed one-time-password checks is cleaned up after it is idle.

  • importance 1

SQL engine

Joins return the correct rows

A left, right or full join written without the word OUTER was executed as an inner join and lost rows. A right outer join placed columns in the wrong order, a condition in ON removed rows, a cross join dropped its right-hand side, and a full outer join that could not be answered was not reported.

  • importance 5
Filters no longer lose rows or evaluate wrongly

A condition such as a and (b or c) could return too few rows, lower and upper case conversions and decimal constants were not sent correctly to SQL databases, NOT LIKE dropped rows that differ only in case, and x between 1 and 2 and y = 1 was read wrongly.

  • Microsoft Access
  • SQL Server
  • importance 4
Barcodes: PDF417 symbols are generated and EAN-13 text and short codes are correct

Generating a PDF417 barcode always failed, for numeric, text and binary content. Short numeric PDF417 codes got no padding or error correction, and the text under an EAN-13 barcode repeated a digit and left out the check digit. A code with fewer than 13 digits caused an error.

  • importance 3
Calling a pipelined table function could fail with error itgenclr009

Calling a pipelined table function in certain statements raised error itgenclr009. The call now passes all required arguments.

  • importance 3
Databases with the same name in different groups were confused

When two databases in a settings file have the same name in different groups and no explicit id, they got the same internal id. Stored data such as a cached sign-in token could then be used for the wrong database. The group name is now part of the id.

  • importance 3
Function date_trunc gave wrong dates for millennium, century and decade

Truncating a date to millennium, century or decade returned a date in the next year or a wrong date. The result is now the first day of the period, such as 2000-01-01.

  • importance 3
Function instr gave wrong results for reverse search and occurrences

The instr function returned wrong positions for a negative start position, for an occurrence higher than one and for a start beyond the text. The search was rewritten.

  • importance 3
Function normalize removed path separators that were allowed

The function that normalises file names removed the path separators even when they were allowed. It also now treats the forward slash like the backslash when shortening a name.

  • importance 3
HTTPDOWNLOAD failed with a null reference when it read a cached result

The function HTTPDOWNLOAD could fail with an unexpected error when its earlier result was read back from the memory cache. Cached results are now restored correctly.

  • importance 3
INTERSECT, EXCEPT and duplicate column names return the standard result

A chain of INTERSECT selects answered a intersect (b union c), SELECT * EXCEPT skipped columns that were not excluded, EXCEPT with several columns was read ambiguously, and a group function over a select list with duplicate column names failed.

  • importance 3
Repair and harden the REGEXP functions

REGEXP_INSTR returned a position one past the end and REGEXP_REPLACE started one character too early. Flags that contradict each other follow Oracle, and a pattern that takes more than one second now raises an error instead of hanging.

  • importance 3
Repeated and parallel CREATE OR REPLACE and IF NOT EXISTS statements work

Concurrent create or replace of functions and procedures, a function that kept calling its old body, and parallel create table if not exists or drop table if exists on the same table no longer fail.

  • In-memory
  • importance 3
Rows after the first page are read

Grids and collections that load rows in pages did not read rows beyond the part already loaded. All rows are returned now.

  • importance 3
Send the correct value for user functions in set-based updates

An update such as set modified_by = user, or with coalesce over the user, sent a null to the database instead of the name of the logged-on user. A not-null column then refused the update, for example on PostgreSQL.

  • PostgreSQL
  • importance 3
Aggregates pushed down to databases return the right data types

A count pushed down to a database platform came back with the type of that platform, which the engine did not accept for some platforms. A platform limited to one connection also refused a second statement on the same session. Both are handled.

  • SQL Server
  • Oracle
  • Firebird
  • importance 2
Allow partial data in the SessionIOs view

The columns with bytes received, bytes sent and round trips of the SessionIOs view now accept empty values, so the view can be read when only part of the data is available. Before, these columns were declared as not empty.

  • importance 2
Binary conversion functions return a binary type and httpget_text uses the given encoding

The functions ascii_to_blob and hex_to_blob declared a text result type although they return binary data. The function httpget_text now decodes the response with the requested encoding instead of always using UTF-8.

  • importance 2
Cast of a nullable value to a character failed

Converting a nullable character value to a character raised an error because the wrong type was used internally. The conversion works now.

  • importance 2
Enumeration already finished error in client-side filtering

Statements with a client-side filter could fail with the message that the enumeration was already finished (itgenclr003). The error is now raised with more detail on which step failed.

  • importance 2
Error about an unknown division or office was hidden by a formatting error

When a selected division or office did not exist, the expected error was replaced by a text formatting error. The expected error is shown again.

  • importance 2
Give a CASE expression the data type of its widest branch

The result type of a case expression followed the first branch with a known type. A narrow first branch, such as an integer, could cut off the value of a wider branch.

  • importance 2
HTTPDOWNLOAD crawl treated some URLs with a fragment as different

When HTTPDOWNLOAD removed the fragment (the part after #) of a link to check for duplicates, it also removed the character before it. Links that differ only in that character were taken as the same page.

  • importance 2
Keep the active data container registration when the data dictionary database opens

When data containers opened in parallel, the opening of the database behind the data dictionary could undo the registration of another data container, which gave log-on errors.

  • importance 2
Overflows and invalid limits no longer cause failures

Very large texts, huge buffer estimates, string functions with extreme arguments, long error texts in the event log and batch sizes of zero or less no longer cause overflow errors or endless loops.

  • importance 2
Repair errors of parallel background reads being missed

Errors in parallel reads were not always reported to the statement.

  • SQL Server
  • importance 2
Repair nullability of boolean expressions

A column that is created from a comparison got a nullable type, although it can never be null. The result is now not null.

  • importance 2
Repair wrong column alias after PIVOT

Pivoted columns could receive the alias of another source. The alias is now assigned consistently.

  • importance 2
Stop statistics of SQL execution steps from growing on every read

Reading the statistics of a statement doubled the tree of execution steps, so one input or output was reported thousands of times. The statistics now stay unchanged when read.

  • importance 2
Update on a datetimeoffset column and hints on nullable types are correct

An update that sets a column from a datetimeoffset column failed with a data type mismatch, and hints named a nullable type by an internal name. Both now show correct values.

  • importance 2
XML, JSON, NDJSON and HTML tables: clearer error on a null in a required column

A null in a column that does not allow null raised an unclear error (itgenrst007) late in the process. The check is made earlier, so the message states what is wrong.

  • importance 2
barcode_qr function rejected calls with two arguments

The SQL function barcode_qr required at least three arguments although the width and the text are enough. It now accepts two to four arguments.

  • importance 2
jsonencode of a null constant gives the right result

The function that encodes a value as JSON gave a wrong result for a constant null.

  • importance 2
unistr did not accept uppercase hexadecimal digits

The SQL function unistr failed on escape sequences with uppercase hexadecimal digits A to F. These are now accepted.

  • importance 2
Aggregate exceptions are interpreted on each inner exception

An error raised through several parallel tasks could show the wrong error, because only the outer exception was examined.

  • importance 1
Argument documentation in system views allows 8000 characters

The column with documentation of function arguments in the package function view was limited to 4000 characters. It now allows 8000.

  • importance 1
Finalizer of the connection manager no longer throws

An exception in the finalizer of a connection manager could end a process after its work was done.

  • importance 1

Scripting

An operating-system command that exceeds its maximum duration is now ended

A command started from a script that ran longer than its maximum duration was left running, and the failure showed as an unrelated internal error about a process that had not yet exited. The command and the programs it started are now ended and a message names the command and the limit.

  • importance 3
A PSQL block can create or replace the same in-memory table twice

Two create or replace statements for the same in-memory table in one PSQL block were rejected at compile time. They are accepted now.

  • In-memory storage
  • importance 2
Catch a validation error in PSQL when several named handlers precede WHEN OTHERS

An exception block with several handlers could skip the handler that matched, so the error left the block although a handler existed.

  • importance 2
Keep the order of table function parameters

After a parameter was removed from a table function or package procedure, a later parameter could land in the wrong position, so positional arguments reached another parameter.

  • importance 2
Raise a catchable error for very large files in PSQL; keep last error per worker

Reading a file larger than one byte array failed with a system error that only WHEN OTHERS could catch. The error is now a value error that scripts can handle. Workers of a parallel loop no longer overwrite each other's last error.

  • importance 2
Show the width in the local column statement template without quotes

The template for the local column statement showed the width between quotes, although the statement expects a number.

  • importance 1

Query Tool user interface

Avoid RPC_E_DISCONNECTED errors when Excel closes a workbook during start-up

Errors with the text that the connection of the called object to its clients was lost no longer occur at start-up and during repeated use of a workbook. Work on Excel is now done on the thread of Excel, a workbook that has been closed is detected, and the caches no longer keep references to closed workbooks.

  • importance 4
Avoid error 0x800AC472 when Excel does not take a call

A start with a read-only workbook from a network drive, or a busy Excel, no longer ends with an unknown error. Installing the function library waits until Excel is ready, and a worksheet that Excel refuses is skipped so the other worksheets remain available. Errors inside the window of the Query Tool in Excel reach the standard error window instead of the Office dialog.

  • importance 4
Fix three edge cases in upgrades of the function library and in change handling

An Excel function library of another release but with the same size is now replaced after an upgrade. A field with a negative scale, such as an Oracle number with a negative scale, no longer breaks change detection. Edits that could be lost because a new change got an existing number are now saved.

  • Oracle
  • importance 3
Avoid an error when the key Alt or F10 is pressed in the Query Tool

Pressing Alt or F10 could cause a 'Collection was modified' error. The error is ignored, because it affects only the refresh of the menu.

  • importance 2
Copying the SQL of a block no longer freezes Excel when the clipboard does not answer

Copying a query from the block and parameter editors to the clipboard now stops waiting after a short time and reports the problem, instead of blocking Excel.

  • importance 2
Fix errors when querying all partitions and relinking functions

Querying all partitions from Excel no longer fails on a thread problem. After an upgrade, all formulas are recalculated only when links were actually corrected, not at every start.

  • importance 2

Platforms and drivers

Exact Online incremental data is no longer damaged or overwritten

Users of one subscription replaced each other's incremental image, a request that ended while an image was saved could leave chunks of two versions, a refresh that only added rows was taken as unchanged, and incremental data could end up in the folder of other cache settings or ignore the disk cache settings of the statement.

  • Exact Online
  • importance 4
A write that is refused with HTTP 403 is reported as an error

An update or synchronize on Exact Online Employees reported rows updated while every write was refused with Forbidden. The refusal is now raised as an error for writes and is still ignored for reads.

  • Exact Online
  • importance 3
Close connections that remain open after a failed log-on

When one data container refused to log on, the data containers opened before it stayed open. Repeated attempts left idle connections on the database; 101 failed attempts left about 120 connections.

  • importance 3
Do not repeat an Exact Online XML write after a server error

A write that Exact Online answered with HTTP 500 was sent again, although Exact Online may have carried it out. A write is repeated only when the driver says it is safe.

  • Exact Online
  • importance 3
Exact Online: GLAccountClassificationsEx failed with itgendcr011

A statement on the table function GLAccountClassificationsEx with the parameter GLSchemeCode failed with itgendcr011 because the filter column was renamed. The renaming now applies only to the tables that use it.

  • Exact Online
  • importance 3
Exact Online: repeated error when reading account classifications

After a failed or cancelled retrieval of the account classifications, the same error (itgenshr062) was returned for every following request. The retrieval is now started again after a failure.

  • Exact Online
  • importance 3
Make WMI queries return rows with their values

Queries on WMI classes failed or returned empty values because of several defects, for example missing catalogue and schema names, columns taken from the first instance of a class and values stored in the wrong position. These are repaired. Selected columns and row limits are now passed to WMI, and seven more classes are available.

  • Windows WMI
  • importance 3
Oracle query could fail with a null reference error on .NET 10

A query on an Oracle database could stop with a null reference error when running on .NET 10. The logging of the executed statement is now done safely.

  • Oracle
  • importance 3
Oracle: errors when a SELECT with IN runs in parallel

A SELECT with an IN list on Oracle could fail with a null reference inside the Oracle driver. The Oracle driver now runs one native call at a time to avoid this.

  • Oracle
  • importance 3
Prevent a null reference error on Oracle selects with long IN lists run in parallel

A select with a filter on more than 1000 values could fail with a null reference error inside the Oracle managed driver, because several fragments of the result were read at the same time. Reads from one connection are now done one at a time.

  • Oracle
  • importance 3
Recover an Oracle session that lost its application log on after a connection loss

After a dropped Oracle connection, the rebuilt session lacked the roles of the application log on. The resulting errors were shown as a wrongly installed software without a retry. The statement is now retried after the session and its application log on are rebuilt. Looking up the columns of a table tries the name as given and in the casing recommended for Oracle.

  • Oracle
  • importance 3
Setting divisions failed when the Exact Online Premium connector is enabled

Selecting divisions did not work when the Exact Online Premium connector was enabled. The selection is now passed on to the Exact Online connection.

  • Exact Online
  • importance 3
Shorten the retry wait on HubSpot rate limit answers and use the 10-second window

HubSpot rate limiting now uses the window that the platform prescribes. After an HTTP 429 answer the driver retries a few times with a bounded wait. Before, one page request could wait over 30 minutes and then hide the real cause.

  • HubSpot
  • importance 3
Twinfield: no licence error for offices when a custom client ID is used

A user with an own Twinfield client ID could get error itgentfr280 for an office that is not on the Invantive list. The check now applies only to the Invantive client IDs.

  • Twinfield
  • importance 3
AFAS: page size check raised error itgengpr299 for valid page sizes

The check on the maximum page size was inverted. A valid page size could raise error itgengpr299.

  • AFAS
  • importance 2
Do not send virtual fields to the Exact Online REST API

Insert and update statements sent fields to Exact Online that do not exist at the platform.

  • Exact Online
  • importance 2
Download of a file no longer fails when its creation time cannot be set

A download or copy stopped with an error when the operating system refused to set the creation time of the file. The refusal is now traced and the file is kept.

  • importance 2
Duplicate table and column names in OpenAPI based drivers are numbered correctly

When an OpenAPI definition contains duplicate names, the added number was off by one. The numbering now starts at the intended value, so some generated names change.

  • importance 2
Exact Online: duplicate Budgets table definition removed

The Exact Online REST driver defined the table Budgets twice; the second definition had unrelated columns of CRM accounts. Only the correct definition is kept.

  • Exact Online
  • importance 2
Exact Online: primary key columns repaired on five tables

Five Exact Online tables had a missing or invalid primary key column. The primary key is now defined.

  • Exact Online
  • importance 2
Exact Online: views that need the XML API fail when the XML API is switched off

With use-xml-api set to false, views based on the Exact Online XML provider, such as FinancialYearsExtended, are now left out instead of failing when used.

  • Exact Online
  • importance 2
Fewer errors when a connection or a table is not available

Checks of Exact Online functions report that the connection is not open instead of failing, and a table that is not known gives a clear answer without an error where that is allowed.

  • Exact Online
  • importance 2
Fill the statement columns of lines in the Rabobank MT940 reader

Statement columns of the lines were registered under other names than the metadata declares. They now carry the prefix Statement.

  • Rabobank MT940
  • importance 2
Freshdesk: error itgenfpr045 since 28 May 2026 fixed

Since 28 May 2026 Freshdesk returned rate limit values that could not be read as whole numbers. They are now read as decimal numbers.

  • Freshdesk
  • importance 2
Freshdesk: survey identifiers are read as text

The identifier of Freshdesk surveys was read as a number. It is now read as text.

  • Freshdesk
  • importance 2
Give Freshservice its own database identifier

Freshservice used a database identifier that was already in use, which can mix up saved settings.

  • Freshservice
  • importance 2
Loket: payroll component description allows 30 characters

The description column of payroll components in Loket was limited to 14 characters. It now allows 30, which removes error itgenrst009 on longer values.

  • Loket
  • importance 2
MySQL columns of type enum and set can be read

Selecting from a MySQL table with an enum or set column failed with a message that the data type was not supported. Both types are now supported.

  • MySQL
  • importance 2
Oracle dbms_output reaches the DBMS Output tab

Text written with dbms_output in Oracle PL/SQL that is run natively, and with the native Oracle driver, now reaches the DBMS Output tab.

  • Oracle
  • importance 2
PostgreSQL: metadata of data types with missing names no longer fails

The driver for ADO.NET based databases no longer stops with error itgenase518 when a data type has no data type name, and it accepts a column name that differs only in casing, as Npgsql uses.

  • PostgreSQL
  • importance 2
Read DateOnly values from PostgreSQL on .NET

A date column of PostgreSQL raised an error in the .NET version of the product because the driver returns a DateOnly value. The value is now read as a date.

  • PostgreSQL
  • importance 2
Read XML Audit Files of companies without identifier

A company without an identifier in an XML Audit File is now found by its name.

  • XAA
  • importance 2
Read an empty country of the establishment address of SnelStart customers as NULL

On customers from SnelStart, the country identifier of the establishment address contained an all-zero GUID when empty. It is now returned as NULL, which removes error itgenjuy020.

  • SnelStart
  • importance 2
Repair Data Replicator session registration when the connection string is anonymised

Registering a session of the Data Replicator failed with error itgenase474 when the data container was not yet set. The message now tells what to configure, session start times are stored in UTC, and the process owner column of the sessions table is named process_owner.

  • importance 2
Repair a recursion failure on complex Exact Online queries

A very complex query on Exact Online ended in a recursion error (itgenoda061). It is now handled.

  • Exact Online
  • importance 2
Repair log on to Autotask when the zone cannot be determined

Log on to an Autotask account failed with HTTP 500 on the zone information call. The error is now handled.

  • Autotask
  • importance 2
Repair processing of messages with an action that is not a single character

Processing of data cache messages could fail when the action was missing or longer than the one character that the repository column holds. Such an action now stays empty instead of blocking the batch.

  • importance 2
Repair selecting the same partition twice

Selecting a partition that was already selected raised a duplicate key error. It is now accepted.

  • importance 2
Repair the Visma.net views with an except list

Views that exclude columns with except used a notation without brackets. They now use the correct notation.

  • Visma.net
  • importance 2
Report Oracle errors of the native client with their own error number

An invalid SQL statement sent through a native Oracle connection was reported as the generic unknown error instead of the Oracle error, such as ORA-00900. The Oracle error number and message are now used.

  • Oracle
  • importance 2
Respect the cache settings of the user on Nmbrs and Yuki

Nmbrs and Yuki used a fixed cache lifetime of 10 and 16 hours that overrode the settings of the user.

  • Nmbrs
  • Yuki
  • importance 2
Return dates of AccountView and FoxPro files as UTC dates

Dates read from FoxPro tables, which AccountView also uses, had no time zone and could shift in other time zones.

  • AccountView
  • FoxPro
  • importance 2
Return the file name instead of the MIME type for AFAS files

The column with the file name of an AFAS file contained the MIME type.

  • AFAS Online
  • importance 2
Row counts of Teamleader Focus and ANSI SQL databases were not registered

The number of rows read and affected was not registered for Teamleader Focus and for some ANSI SQL based databases. The row counts in session statistics are now filled.

  • Teamleader Focus
  • importance 2
SQL Server: driver update to Microsoft.Data.SqlClient 7.0.2

The SQL Server driver uses version 7.0.2 of the Microsoft client library, which repairs an issue with bulk insert and create table. The first 26.0 build used 7.0.0.

  • SQL Server
  • importance 2
Share the lock of SQL providers per provider instead of per process

Two connections to different SQL databases blocked each other while one of them opened.

  • importance 2
SnelStart: empty country id gave an error

SnelStart rows with an empty country identifier raised error itgenjuy020. Empty values are now stored as null for more tables and address types.

  • SnelStart
  • importance 2
SnelStart: purchase invoice number allows 60 characters

The invoice number of a purchase booking in SnelStart was limited to 25 characters. It now allows 60.

  • SnelStart
  • importance 2
Visma.net: scopes for the new sales orders endpoint

The scopes for the sales orders endpoint of Visma.net were added, so that the table can be read.

  • Visma.net
  • importance 2
Yuki: sessions of different domains no longer race

Concurrent log-ons of different Yuki domains could interfere. They are now serialised per session selection.

  • Yuki
  • importance 2
Delete batches of the data cache and wait limit of Bridge Online are checked

The number of table partition versions per delete is validated, and Bridge Online documents and applies its wait limit.

  • Bridge Online
  • importance 1
Place the last-resort provider last when showing users on Invantive Estate

The order in which providers are tried put the last-resort provider among the others.

  • importance 1
Reading the database version number is more robust

The major and minor digits of a database version are now read from the start of the version text, so extra text after the numbers no longer disturbs it.

  • importance 1

A list that had to be sorted on several keys was sorted on the last key only. Catalogue, schema and table names of Exact Online, and links read from a sitemap, now follow the intended order.

  • Exact Online
  • importance 1
Spelling error in a PostgreSQL error hint corrected

The hint of the error about unknown table columns on PostgreSQL contained a spelling error.

  • PostgreSQL
  • importance 1

Export and import

Apply export settings consistently and keep dates in universal time

Exports to HTML and RTF now use the same selection of columns, rows and row limit as other formats. A text date with a fixed format no longer shifts with the time zone of the machine. An export that cannot carry the SQL statement, such as CSV, refuses to omit it silently.

  • importance 3
Repair Excel export with empty user or company name and apply the output password

An Excel export no longer fails with an internal error when the user name or company name is empty. A workbook with an output password is now encrypted, and the footer shows the application name and version.

  • importance 3
Repair NDJSON output of several result sets

NDJSON output wrapped the result sets in an object. The rows now follow each other as lines, as the format requires.

  • importance 3
A file action that cannot be registered no longer fails the read, write or delete

Registering a file read, write or delete for the session overview threw an error when there was no session, which could make a successful file operation fail. A failed registration is now only recorded as a warning. Deleted files are registered as deletes.

  • Exact Online
  • importance 2
EXCELTABLE and Excel export no longer block garbage collection

Creating an Excel package could stall the process while memory was being cleaned up. The stall is avoided.

  • importance 2
Reading a file larger than 2 GB into memory gives a clear error

Reading a file that is too large to fit in one block of memory now stops with a message that names the file and its size and advises to process the file in parts. Before, the size was cut to a smaller number.

  • importance 2
Save PNG pictures without extra bytes

A picture saved as PNG from a grid had zero bytes after the end of the file. The file is now written with its exact length.

  • importance 2

Performance

Limit memory use of caches of Excel functions in long sessions

Cached results of formulas and the list of measurements of formula calls no longer grow without limit in a long Excel session. Cached results older than one day are removed every hour, and the measurements keep the newest entries instead of the oldest.

  • Exact Online
  • importance 3
Fix a continuous restart of the Customer Service sender and slow start-up

Sending of logging to Customer Service restarted continuously and started one retry loop per message, which slowed down Discovery. The sender is now restarted once, sends less often and does not probe itself at start-up.

  • importance 2
Fix writing HTTP response cache objects that contain IP addresses

Cache objects for HTTP responses could not be serialised when they contained an IP address. A converter for IP addresses is now used when the object is written.

  • importance 2
Memory held after closing database connections and reading process lists

Handlers on database connections of the Oracle and ANSI-based drivers and operating system handles used to list processes were not released. Memory use of long running sessions no longer grows because of them. The session list of the connection manager is no longer shared between instances.

  • Oracle
  • importance 2
Rare null reference error in parallel reading removed

A rare null reference error during parallel reading of sources could occur when the queue changed between two reads. The values are now read once.

  • importance 2
Windows, processes and the Data Loader no longer leak handles

Lists, summaries, search panels, message windows and started processes kept graphics, user and process handles open, which could exhaust the handles of a long session.

  • importance 2

Logging and diagnostics

A stack overflow while logging at start-up is prevented

Asking for information about the process while that information was being collected could repeat itself until the program stopped. The collection is now protected against re-entry.

  • importance 2
Correct the number of rows counted for Exact Online XML and for Excel, JSON and XML files

The number of rows reported in the statistics of these reads was not complete.

  • Exact Online
  • importance 2
Fix a serialisation error in session logging with the dummy driver

Logging a session of the dummy driver failed with error code itgenclr003 because some properties could not be written as XML. These properties are now excluded and the address is written in a separate XML field.

  • importance 2
Open the Diagnostics window without security errors for users without administrator rights

The Diagnostics window raised security exceptions in the trace when a user without administrator rights opened it. It reads the registration of the event log source without searching all logs.

  • importance 2
Show the correct operating system and runtime in the diagnostics window

The diagnostics window showed an unknown operating system, and on the current .NET runtime did not show the runtime version and process architecture. Windows 11 is now recognised by its build number.

  • importance 2
Trace files no longer fail when the trace folder name is long

A trace folder with a long name made the creation of the trace file fail with a path-too-long error. The folder part of the trace file mask is now determined without checking the full path length.

  • importance 2
Write the trace lines of the add-in

The add-in wrote none of its own trace lines, because a build setting replaced the compilation constant that switches tracing on. The trace now contains the lines of the add-in.

  • importance 2
Write traces from the Excel, Outlook and Word starters again

The starters wrote no trace at all, because a project setting replaced the compiler constant that enables tracing. Traces of the starters are available again, which helps when an add-in does not start.

  • importance 2
Fix lost logging of exceptions raised at the same time on several threads

An exception raised on one thread could be left out of the trace while another thread was still writing a record about an exception. Each thread is now handled on its own.

  • importance 1
Forward the messages printed at the end of an Invantive Data Hub run

Messages produced while Invantive Data Hub was ending were reported as not forwarded. They are now written straight to the trace output once the final flush starts.

  • importance 1
Keep the row count when result set information is copied

Information about a result set lost its row count when it was copied.

  • importance 1
Show the platform name in the message about a new OAuth token

The message that a new token was received showed the placeholder instead of the name of the platform.

  • importance 1

Translations and texts

Reload translations after the user changes the language

After the language is changed, the translations of the new language are loaded again.

  • importance 2
Show the message text instead of the resource key when a translation is missing

When a text had no translation, users saw the key, such as a resource name with a parameter, instead of the English default. The default text is now shown.

  • importance 2
Translations are kept when a download holds no entries

Texts of a language were emptied when the translations that were downloaded contained no entries. They are now left as they were.

  • importance 2
Translate resource markers in window titles of the Runtime

Window titles with a plug-in name showed the resource marker instead of the translated name in the title bar and task bar.

  • importance 1

Other

Tell the loaded add-in when Office shuts down

Office told only the starter that it was closing. The add-in loaded by the starter never learned of it, and so did not save its settings or close its connections. The starter now passes the shutdown on.

  • importance 3
Detect incomplete reads of files

Reading a file could silently return fewer bytes than the file holds. An error is now raised when the number of bytes read differs from the expected number.

  • importance 2
Fix reading managed text files that exist

Reading the text of a managed file checked whether a directory with that name existed instead of the file, so a present file could be reported as missing. The check now looks for the file.

  • importance 2
Fix the caching of DNS answers

A DNS answer was cached for a fixed hour, so a host that had moved was still reached at its old address. The lifetime reported by the name server is now used within limits.

  • importance 2
HTTP dates are always written in English

Dates in the RFC 850 format were written using the language of the computer. On a computer with a non-English culture this gave dates that servers could not read. They are now always written in English.

  • importance 2
Release the bitmap handle of file thumbnails correctly and copy the image safely

Creating a thumbnail of a file released the bitmap handle with a call meant for COM objects and built the image on memory that could already be released. The handle is now deleted correctly and the image is copied.

  • File system
  • importance 2
Fix a null reference when no installation identifier is available

Constructing the path for a Customer Service request failed with a null reference error when the installation identifier was not set. The identifier is now optional.

  • importance 1
Recognise .pot files as PowerPoint templates

The file extension of PowerPoint templates had a typing error and was not recognised.

  • importance 1
Retry calls to Office when the application is busy or has disconnected

Calls to Microsoft Office applications that are refused because the application is busy are tried again, and the refusal and disconnection codes of Excel are recognised.

  • importance 1

What It Builds On

Kind Name From To
invantive component Invantive Control for Excel 26.0.4 27.0.92
invantive component Invantive(R) Basics 26.0.4 27.0.92
invantive component Invantive(R) Excel Starter 26.0.4 27.0.92
invantive component Invantive(R) Producer GUI Base 26.0.4 27.0.92
invantive component Invantive(R) Producer Data Model 26.0.4 27.0.92
invantive component Invantive(R) Producer GUI 26.0.4 27.0.92
invantive component Invantive(R) SQL for Core 26.0.4 27.0.92
invantive component Invantive(R) SQL 26.0.4 27.0.92
invantive component Invantive(R) SQL for Windows 26.0.4 27.0.92
build tool Invantive Deploy 26.0.4 27.0.92
build tool change Installing and upgrading a .NET 10 product no longer runs the NGEN tool per assembly
build tool change Installer shows an error when another installation is already running
build tool change Final installer window shows the version link
build tool change Progress bar of the installer follows the measured duration of the installation stages
build tool change Installer windows flicker less when moving to the next step
build tool change Installer no longer stalls on an unreachable Customer Service and cancels reliably
build tool change Installer explains in a window why installation settings cannot be downloaded
build tool change Maintenance window checks that the product is still installed
build tool change Installer shows unexpected errors in its own window
build tool change Repair Office add-in name, optional email check and installs run as SYSTEM
build tool change Installs run as SYSTEM are attributed to the end user, not to the SYSTEM account
build tool change Each product gets one .NET 10 installer; the .NET Framework installer is no longer built
build tool change Installer includes the files .NET needs to find native libraries such as WebView2
build tool change Installer carries native runtime folders and Catalan, Hungarian and Romanian resources
build tool change Installer no longer includes the crash dump tool
build tool change Supported Windows versions in release information follow mainstream support dates
build tool change Installer writes its trace to the Invantive Trace folder when trace to file is on
build tool change Installer texts for new messages are available in all supported languages
build tool change Installer email step rejects example and test domains
third party summary

More Information

How This Note Was Made

  • For all products together 28 items whose changed lines are 50 to 70 % in the first build of 26.0 and 23 items that a content check would have left out were read against that build; the items that apply to this product are kept or left out on that reading.
  • Range: commits of origin/release-27.0 that are not reachable from the first build of release 26.0 (stamp 26.0.4, per repository). Commits that were ported to later builds of 26.0 are therefore included.
  • For a product that does not offer SQL to its users, items of the shared libraries outside the areas installation, licensing, security and diagnostics, and items about one platform, are left out and counted as internal.
  • The commits are the ones of the range that touch a project of the product; each commit was classified once, for all products, and the items of a product are the items that contain such commits.
  • Version stamp commits of the build pipeline are left out.
  • A change whose changed lines are for 70 % or more already in the first 26.0 build is left out; items between 50 % and 70 % and all such exclusions were checked by reading the code of that build.
  • A bug fix whose repaired lines were written by another commit of the same range is merged into its feature or left out.
  • Texts were written from the commit messages and from the changes themselves; items carry a confidence.
  • 1008 links between a change and a source commit are recorded.
  • 37 exclusions are recorded in the audit of the note.