Release notes of Invantive Estate for Windows
Release Note - Installer
Invantive Estate for Windows 27.0, from 26.0
| Build | Date | Description |
|---|---|---|
26.0.4 |
22-03-2026 | first build of release 26.0 |
27. |
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.
- 198 enhancements
- 158 bug fixes
- 14 things to check before upgrading
This Note
- Before You Upgrade
- Top 25 Changes
- All Enhancements 198
- All Bug Fixes 158
- What It Builds On
- More Information
Enhancements
- Installation and platform 10
- Licensing and sign-in 11
- Security 10
- SQL engine 35
- Scripting 9
- Query Tool user interface 10
- Platforms and drivers 66
- Export and import 4
- Performance 19
- Logging and diagnostics 7
- Translations and texts 4
- Documentation 5
- Other 8
Bug Fixes
Before You Upgrade
These changes ask for a check:
- Settings files move from XML to JSON
- 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.
- UTF-8 files are written without a byte order mark by default
- Check programs that read exported text files and expect a byte order mark.
- The legacy Oracle driver and the Invantive Web Service driver are removed; Oracle 18 is the minimum
- 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.
- Exact Online companies outside the service area are no longer accepted
- Companies in countries outside the service area are no longer available in Exact Online.
- Remove obsolete Invantive Script statements
- Remove the statements for encrypting passwords and variables, deploying static files and showing the keychain from scripts; they are no longer recognised.
- Remove the compression level option from loading results from the clipboard
- Remove the compression level clause from statements that load a results clipboard.
- QR code functions take one size value instead of width and height
- Adjust statements that call the QR code functions with a separate width and height.
- Integer constants in SQL keep an integer type
- Check expressions that rely on whole numbers being decimal; the data type of the result can differ.
- Gripp CRM tables now have a schema name
- Adjust statements that use the old table names of Gripp CRM; the tables now have a schema name.
- Row count variable is empty before the first statement
- Check scripts that compare the row count of the previous statement with zero before the first statement.
- Duration columns in system views have a decimal type and more precise values
- Check queries that expect whole numbers in the duration columns of the session and execution views.
- Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list
- Statements on the LinkedIn driver and the SOAP-based Loket.nl driver no longer work.
- Loading of provider assemblies from a settings file is blocked
- A provider loaded from an assembly named in a settings file now fails; no file is on the allowed list yet.
- Data Cache no longer runs forced garbage collection; three settings removed
- Remove the three garbage-collection settings of the Data Cache driver from settings files.
Top 25 Changes
- Settings files move from XML to JSON
- Enhancement
- action needed
- Action needed before or after the upgrade.
- 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.
- 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.
- 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.
- DeepL driver
- Enhancement
- A new driver reads and writes DeepL: languages, billing, translation, writing assistance, documents, glossaries, style rules and translation memories.
- Estate requires connection pooling and no longer supports Oracle Legacy or the Web Service
- Enhancement
- Invantive Estate for Windows now only works with direct Oracle data containers that have connection pooling enabled. Databases reached through the Oracle Legacy provider or through the Invantive Web Service are no longer offered at log on. An administrator who has databases without pooling must enable it, otherwise Estate refuses to log on.
- 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.
- 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.
- Exact Online companies outside the service area are no longer accepted
- Enhancement
- action needed
- Action needed before or after the upgrade.
- Loading of provider assemblies from a settings file is blocked
- Enhancement
- action needed
- Action needed before or after the upgrade.
- Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list
- Enhancement
- action needed
- Action needed before or after the upgrade.
- QR code functions take one size value instead of width and height
- Enhancement
- action needed
- Action needed before or after the upgrade.
- Remove obsolete Invantive Script statements
- Enhancement
- action needed
- Action needed before or after the upgrade.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Faster log on and opening of screens through client-side icons and cached pick lists
- Enhancement
- Icons are now downloaded and cached by the client instead of being fetched by the database server, and the lists of values used in drop-down boxes are fetched in the background after log on and kept for reuse. Report menus, task categories and user data are read once instead of repeatedly. This shortens log on and the time to open edit screens, especially when the database server has a slow route to the internet.
- Long-running actions can be stopped and Estate closes faster
- Enhancement
- Synchronisation with Outlook, searches, loading of lists and report downloads can now be cancelled by the user, and closing Estate or Outlook stops the work that is still running in the background. Before, closing Estate straight after start-up could take about 16 seconds because pick lists were still being fetched. Trees with many nodes are also released faster.
- 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.
- 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.
- 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.
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 (35) | 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 (6) | Invantive Web Service (1) | ionBIZ (1) | Kadaster (1) | LinkedIn (1) | Logius COR (1) | Loket (1) | Loket.nl (2) | Magento (4) | MariaDB (1) | Matomo (2) | Mendix (1) | Microsoft Access (1) | Microsoft Dynamics CRM (1) | Microsoft Graph (1) | MySQL (11) | Nextcloud (1) | Nmbrs (2) | OData (1) | ODBC (3) | Odoo (4) | Open Archives (2) | Open Besluitvorming (1) | Oracle (22) | PayPal (2) | Pipedrive (1) | PostgreSQL (15) | Rabobank MT940 (1) | RDW (2) | Robaws (3) | Salesforce (1) | SFTP (1) | SnelStart (5) | SQL Server (14) | 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
Estate requires connection pooling and no longer supports Oracle Legacy or the Web Service
Invantive Estate for Windows now only works with direct Oracle data containers that have connection pooling enabled. Databases reached through the Oracle Legacy provider or through the Invantive Web Service are no longer offered at log on. An administrator who has databases without pooling must enable it, otherwise Estate refuses to log on.
- Oracle
- importance 5
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
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
Estate for Windows accepts command line options such as help
The program now reads its command line. Asking for help shows the usage without starting the application, and the program ends with an exit code that tells whether the usage could be shown.
- importance 2
Estate for Windows and the Outlook add-in accept file names longer than 260 characters
On Windows, Estate and the Outlook add-in can now work with paths longer than 260 characters.
- 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
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
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
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
Exact Online: a clear error when the user has withdrawn consent
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
Downloaded report names can no longer write outside the temporary folder
A file name proposed by a web server for a downloaded report or PDF is now checked, so that it cannot place the file outside the temporary folder. A generated name is used when the server proposes none.
- importance 4
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
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
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
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
Packages, procedures and functions of the database appear in the object list
A connection that sends statements natively to Oracle, MySQL, PostgreSQL or SQL Server now lists the stored packages, procedures and functions of that platform with their parameters, one entry per overload, with a sample statement. The packages of the engine itself are no longer listed on such connections.
- Oracle
- MySQL
- PostgreSQL
- SQL Server
- importance 4
Dark mode support in Estate screens
Estate screens now follow the dark theme: the dashboard tiles, the search results, lists, upload dialogs and the search button no longer show black text on a dark background or light panels.
- importance 3
Right-click menu on search results in Estate
A search result can now be opened, edited, copied, deleted, audited or viewed in its history from a right-click menu, with the same authorisation as the summary of that row. For a person, a new person can be started with the organisation already filled in, and a person result also offers to open the organisation.
- importance 3
Copying to the clipboard no longer waits indefinitely in Estate
Copying files or text to the clipboard now runs under a guard that gives up when the clipboard does not answer, and records the attempt in the trace. Before, an unresponsive clipboard could leave the window waiting.
- importance 2
Explanation of unavailable tabs on list tabs in Estate
A context menu on tabs of summaries explains why a tab is not available or cannot be edited for the current user. Several lists now name the rights that decide whether their buttons are available.
- importance 2
Keyboard navigation in the quick search results of Estate
The arrow keys now walk through the quick search results from the search box, and Enter opens the highlighted result once an arrow key has been used. Before, a result could only be opened by double-clicking it.
- importance 2
Less flicker when switching documents and nodes in Estate
The document preview and the tabs of the explorer no longer flash empty while they are rebuilt for a newly selected item.
- importance 2
Refreshed icons and seasonal logos in Estate
The icon set of Estate, including the seasonal logos for Christmas and New Year, was redrawn, and the splash screen and the trace buttons use new images. The trace button in the Outlook ribbon and the trace menu item show the trace icon instead of the debug icon.
- importance 2
Entity layer: background download, nullable keys and notifications on the window thread
Rows are downloaded in the background, an empty primary key is allowed where the model says so, and changes of an entity can be announced on the thread that owns the window.
- importance 1
Explain in summary windows which tabs are shown and why
A context menu on the tabs of a summary window explains why a tab is available or not, based on the rights of the user and the licence.
- 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
- 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
Update Wikipedia with search, pages, history, links and files
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
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
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
Allow connection pooling on Invantive Estate
Statements for the log on of an application can be replayed on every pooled connection, with checks that prevent pooling when it cannot work. This mainly concerns Estate and Producer.
- importance 1
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
Producer repository checks drop Oracle Legacy and the web service
Studio and Estate accept only the managed Oracle drivers for a Producer repository, and the restricted log-on needs connection pooling.
- Oracle
- 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
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
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
Faster log on and opening of screens through client-side icons and cached pick lists
Icons are now downloaded and cached by the client instead of being fetched by the database server, and the lists of values used in drop-down boxes are fetched in the background after log on and kept for reuse. Report menus, task categories and user data are read once instead of repeatedly. This shortens log on and the time to open edit screens, especially when the database server has a slow route to the internet.
- importance 4
Long-running actions can be stopped and Estate closes faster
Synchronisation with Outlook, searches, loading of lists and report downloads can now be cancelled by the user, and closing Estate or Outlook stops the work that is still running in the background. Before, closing Estate straight after start-up could take about 16 seconds because pick lists were still being fetched. Trees with many nodes are also released faster.
- 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
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
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
Invantive Estate and Studio read the repository and records less often
The result of the check for a Producer repository is cached per database, records are not read once per pane and Oracle access is lighter.
- Invantive Estate
- importance 1
Logging and diagnostics
Activity indicator for database traffic in Estate
A coloured dot beside the search box shows how busy the connections to the database are, including background traffic. Clicking it opens a window with the calls of the last hour and who asked for them. Searches and the right-click menu now name their action in this overview.
- importance 3
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
Unexpected errors in Estate windows are shown in the error window of the product
An error that escaped from a window used to be written to the trace only, so the user saw an application that silently ignored the failure. The error is now reported in the error window of the product, in the language of the user.
- 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
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
Links to documentation, forums and support use the invantive.eu address
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
Website links of Estate point to invantive.eu and the help falls back to the online manual
The website menu item no longer opens domains for German and Hindi that do not exist, and web addresses and icon downloads now use invantive.eu. When no local help file is installed, the help opens the online documentation instead of showing an error.
- importance 3
Error hints can link to the community forum of the product
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
New persons and organisations get a default language
A new person added at an organisation now receives the language of that organisation, and a new organisation receives the language from the system settings. Before, the language stayed empty.
- importance 3
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
Icons of fields can be read from a text value that holds a path or web address
A field that is defined as text but holds an icon path or an https address now shows that icon instead of writing a warning and showing none.
- importance 1
Invantive Estate edit windows: context on new, first empty field, background save
Edit windows open with a context for a new row, put the cursor in the first empty field, save in the background and have a tidier audit section.
- Invantive Estate
- importance 1
Invantive Estate: search results get a context menu and a search history
Search results can be edited, copied, deleted, audited or shown in history from a context menu, summaries of tabs offer Rights, and search boxes remember earlier searches.
- Invantive Estate
- importance 1
All Bug Fixes
Defects of the older release that are repaired.
Installation and platform
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
Preferences window opens for users without access to the system settings
Opening the preferences showed an authorisation error and left the Systemwide tab empty for users who did not hold the right behind that tab. The tab is now left out for those users and the settings open on the details right.
- importance 3
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
Search tab titles no longer show 'unknown' in Estate
Person and organisation search panels showed the word unknown as caption when no filter matched. They now show the normal label.
- 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
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
Repair the sort order of the object list of Exact Online and of sitemap links
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
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
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
Estate texts show their translation again instead of the bare key
Window titles, tree captions and other texts that are specific to Estate were shown as untranslated keys. Estate now fetches all translations at log on, including the ones that earlier were left out, so that these texts appear in the user language.
- importance 4
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
Quotation marks in the help text of calculated fields are shown correctly
Curly quotation marks in the example text of the rule editor for calculated fields were stored in a way that could be shown as garbage. They are now written as escape sequences.
- importance 1
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
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
Dragging mails from Outlook no longer hides the real error
When reading a dragged Outlook item failed, a second error about releasing an object that was never created hid the real cause. The release is now skipped for objects that do not exist.
- 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
Fix image cache serialization on current .NET in Invantive Estate
Images could not be stored in the image cache of Invantive Estate when it ran on current .NET. This works now.
- importance 1
Invantive Estate shows the logged-on user
The user and company shown in Invantive Estate are taken from the application log-on user.
- Invantive Estate
- importance 1
Invantive Estate: search tabs, calendar and labels
Search tabs of a fixed form showed Unknown instead of the label, and the calendar window opened incorrectly.
- Invantive Estate
- importance 1
Recognise .pot files as PowerPoint templates
The file extension of PowerPoint templates had a typing error and was not recognised.
- importance 1
What It Builds On
| Kind | Name | From | To |
|---|---|---|---|
| invantive component | Invantive Estate for Windows | 26.0.4 | 27.0.92 |
| invantive component | Invantive(R) Basics | 26.0.4 | 27.0.92 |
| invantive component | Invantive(R) Estate Data Model | 26.0.4 | 27.0.92 |
| invantive component | Invantive(R) Estate GUI | 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.
- 1065 links between a change and a source commit are recorded.
- 28 exclusions are recorded in the audit of the note.