Release notes of Invantive Cloud
Release Note - Hosted
Invantive Cloud 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.
- 286 enhancements
- 180 bug fixes
- 10 things to check before upgrading
This Note
- Before You Upgrade
- Top 25 Changes
- All Enhancements 286
- All Bug Fixes 180
- What It Builds On
- More Information
Enhancements
- Installation and platform 14
- Licensing and sign-in 23
- Security 32
- SQL engine 35
- Scripting 6
- Query Tool user interface 2
- Platforms and drivers 79
- Export and import 5
- Performance 22
- Logging and diagnostics 23
- Translations and texts 2
- Documentation 10
- Other 33
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Support filtering and sorting of the OData model used by MCP
- Enhancement
- The OData data model that is built for MCP supports filtering and ordering, and carries annotations about what is supported. The model is cached and rebuilt from database metadata. Several edits during development repaired earlier edits of the same feature.
- IP address validation configurable with allow lists, deny lists and ranges
- Enhancement
- An administrator can now set the IP address validation of the web servers in the settings: use of the allow list, the deny list and Invantive Customer Service can each be switched off, extra addresses and address ranges can be allowed or denied, and the built-in default lists can be excluded. Addresses on an allow or deny list are decided before any look-up is made.
- Proxy and load balancer set-up through a ForwardedHeaders section
- Enhancement
- The way a server learns the client address behind a proxy or load balancer is now set in one section of the settings, with a choice between the Kestrel mechanism and the Invantive mechanism, the headers to follow, the number of hops, the known proxies and the allowed host names. The earlier setting that said that the server runs behind a proxy is removed. The start-up trace explains what was configured and what the framework applied.
- 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.
- Error answers follow the Accept header
- Enhancement
- An error answer is written as HTML, JSON, Markdown, plain text or XML, whichever the request prefers; with nothing acceptable it uses the default of the endpoint. A request abandoned by the caller is registered with status 499, and more paths of credential files and debug consoles are blocked.
- Lock-out after failed log-ons ends correctly
- Bug Fix
- After repeated failed password attempts, a repeated identical password is refused at once, a refusal no longer counts as a new failed attempt, and a successful log-on resets the counter. The maximum delay is 15 seconds instead of 30, below usual client time-outs.
- 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 (4) | Autotask (1) | Big Data JSON (1) | Brevo (2) | Bridge Online (4) | CBS (1) | Chargebee (1) | Crisp (4) | Data Cache (1) | DeepL (2) | Discourse (1) | Dropbox (2) | Dynamics 365 CRM (2) | Dynamics CRM (2) | Easyflex (1) | EDIFACT (1) | Exact Online (32) | Firebird (2) | Fortnox (1) | FoxPro (1) | Freshdesk (3) | Freshservice (2) | FTP (1) | Gripp (1) | Gripp CRM (2) | HubSpot (3) | IBM Db2 (1) | In-memory (2) | In-memory storage (1) | Inspectlet (4) | Invantive Bridge Online (1) | Invantive Business (1) | Invantive Estate (1) | Invantive Web Service (1) | ionBIZ (1) | Kadaster (1) | LibreOffice (1) | LinkedIn (1) | Logius COR (1) | Loket (1) | Loket.nl (2) | Magento (3) | MariaDB (1) | Matomo (3) | Mendix (1) | Microsoft Access (1) | Microsoft Dynamics CRM (1) | Microsoft Graph (1) | MySQL (10) | Nextcloud (2) | Nmbrs (2) | OData (1) | ODBC (3) | Odoo (4) | Open Archives (1) | Open Besluitvorming (1) | OpenBesluitvorming (1) | Oracle (15) | PayPal (2) | Pipedrive (2) | PostgreSQL (14) | Rabobank MT940 (1) | RDW (2) | Robaws (3) | Salesforce (1) | SFTP (1) | SnelStart (5) | SQL Server (13) | Stripo (3) | Teamleader (2) | Teamleader Focus (2) | TeamViewer (1) | Tixly (1) | Tweede Kamer (3) | Twinfield (8) | VIES (2) | Visma Severa (1) | Visma.net (5) | Visma.net Financials (1) | Wikipedia (1) | WMI (1) | XAA (1) | XAF (1) | Yuki (4)
Installation and platform
Settings files move from XML to JSON
A settings file in XML is converted to JSON when it is read. The user and installation settings, the cached list of databases and the databases of the user are also written in JSON, through an atomic write, and a damaged XML file is recovered where possible. From 27.0 the JSON file takes precedence; the XML file is still written for older releases on the same workstation and is planned to disappear.
What to Do
Settings files are converted from XML to JSON when they are read. From 27.0 the JSON file takes precedence and the XML file is removed in release 28.0: edit the JSON file from now on and keep a copy of the XML file until then.
- action needed
- importance 5
Proxy and load balancer set-up through a ForwardedHeaders section
The way a server learns the client address behind a proxy or load balancer is now set in one section of the settings, with a choice between the Kestrel mechanism and the Invantive mechanism, the headers to follow, the number of hops, the known proxies and the allowed host names. The earlier setting that said that the server runs behind a proxy is removed. The start-up trace explains what was configured and what the framework applied.
- importance 4
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
Modules behind a proxy know their public address from X-Forwarded-Prefix
A module can read the public path prefix that the proxy sends in X-Forwarded-Prefix. The setting to forward all headers no longer lets the framework consume this header, so pages keep linking to the public address.
- 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
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
Shared Cloud library requires .NET 10
The shared Cloud library now states Microsoft .NET 10.0 or higher as software requirement, where the first 26.0 build stated .NET 8.0.
- importance 2
Support the invantive.eu domain in texts, links and cookies
Links and texts in messages and pages refer to the invantive.eu domain. Cookies of the sign-in step are always marked as secure, and the identity cookie works on the new domain.
- importance 2
Web applications determine and report their environment folder
A web application now determines a default environment folder under its application data folder, unless a forced folder is set, expands variables in it and writes the result to the trace.
- importance 2
Cloud administrators can see the releases and their test results
A new screen in Cloud shows the releases and their test results, which the release build writes to the Cloud database.
- importance 1
Folder of the Invantive Keychain determined once for web hosts
A web host takes the folder of the Invantive Keychain from a forced setting or else from the configuration folder, and remembers it.
- importance 1
Minimum platform of the library stated as .NET 10
The product description now says that .NET 10.0 or higher is required. The library already targeted .NET 10 only.
- importance 1
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.
- 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
Allow use of a database per product
A database connection can be allowed or blocked per product: MCP Server, UniversalSQL Server, Bridge Online and Apps Online. MCP Server refuses a database that is not allowed for it.
- importance 3
Invantive Connect can sign users in to Cloud and exchange credentials
Cloud accepts users signed in through Invantive Connect next to AWS Cognito. The credentials of a BI tool for Bridge Online and UniversalSQL Server are exchanged for a token at Connect, and a refusal now says why. MFA can no longer be switched off by the user.
- 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
Sign-up checks the email address with Customer Service
At the first step of sign-up, the email address is also checked for disposable, relay and blocked domain names and for known spam addresses. Such an address is refused with the matching message.
- importance 3
Add a link to open the one-time password setup in an app
The page for setting up multi-factor authentication gets a link that opens the one-time password setup directly in an authenticator app, next to the secret key.
- importance 2
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
Prepare support for Invantive Credentials Server in the Cloud
Databases can be allowed for use with the Credentials Server and login statistics for it are registered. Credential list functions are added to the function catalogue.
- importance 2
Show serial code and time of licence date; fix the activation grid
The licence page shows the serial code for release 25.0 products that are used on the same device through the License Service. The date on which a licence was generated is shown with the time of day. The number of prolongations in the activation grid is shown as a number instead of a date.
- importance 2
Sign-in and sign-up through Invantive Connect use the language of the portal
The pages of the sign-in service open in the language of the portal, also from the link in the sign-up mail.
- importance 2
Warning after repeated wrong verification codes lists related forum topics
When a verification code for multi-factor sign-in is entered wrongly again, the warning also lists forum topics about the message code. They are not looked up on the first display.
- importance 2
Cloud sessions last as long as the token allows
The expiry of a Cloud session is based on the moment the token was issued.
- importance 1
Cloud shows the first and last log-on to Cloud separately
User details show the date of the first and the last Cloud log-on and the number of log-ons to Cloud.
- importance 1
Cloud tells a client whether the user has the system super user or support role
The user information that Cloud gives to a client now says whether the active session holds the system super user or the support role.
- importance 1
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
Register logins per Invantive application and the applications a database may be used with
The Invantive Cloud customer data model gets columns for the first and last login and the number of logins per application, a column for the external request identifier, and switches that allow use of a database with specific Invantive applications.
- importance 1
Registration of new Invantive products and connectors in licensing
The licensing and product lists know the Invantive MCP Server, Credentials Server, App Online and a Credentials API connector, with licence modules, documentation links and download addresses. Differences between Bridge Online personalities are registered too.
- importance 1
Security
IP address validation configurable with allow lists, deny lists and ranges
An administrator can now set the IP address validation of the web servers in the settings: use of the allow list, the deny list and Invantive Customer Service can each be switched off, extra addresses and address ranges can be allowed or denied, and the built-in default lists can be excluded. Addresses on an allow or deny list are decided before any look-up is made.
- 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
Stronger detection of abuse and forged forwarding headers
Attack prevention writes a first block at warning level and reports it centrally, blocks addresses that request many different unknown paths, and answers probes from Invantive servers without blocking them. Failed log-ons are counted across accounts and addresses, forged forwarding headers are reported once per hour, and personal form data is removed from error details.
- importance 4
Attack prevention blocks an address for 5 minutes by default
An address that requests a protected URL is now blocked for 5 minutes by default. Before, the default was 15 minutes.
- importance 3
Fewer paid country lookups, and search engines are recognised by their published addresses
The country of a new client address is looked up first and the more expensive details only when needed. Search engine crawlers are accepted on public content only when their address lies in the ranges that Google, Bing, Apple and DuckDuckGo publish; the new setting UseSearchEngineCrawlers controls this.
- importance 3
Filtered requests are answered with 403 instead of 500 by default
A request that a request filter rejects now gets HTTP status 403 unless a status is configured. Before, the default was 500. A refused IP address also passes its own status through the exception.
- importance 3
Harden session cookies and the check of sign-in tokens
Cookies of the portal and the API are marked as not readable by scripts and are not sent along with cross-site requests. The API now only accepts access tokens of a signed-in user that were issued for the Invantive Cloud application itself; tokens that were issued for another application of the same user pool are refused.
- importance 3
Limit repeated sign-up attempts from the same IP address
Repeated sign-up attempts from one IP address are delayed by 2 to 10 seconds, depending on how quickly they follow each other. When the wait is longer than 15 seconds, the request is refused with a message.
- importance 3
MCP Server accepts clients from the United States
The country restriction no longer refuses addresses in the United States for MCP Server, where the AI platforms that call it run. Other reasons for a refusal still apply.
- importance 3
MaxMind look-ups are cached, can be limited and survive an empty balance
Look-ups of the country and risk of a client address at MaxMind are done once per address at a time and are cached in memory and in the database. When the MaxMind balance is empty, older results are reused for longer and a separate error is reported instead of refusing clients. Administrators can switch look-ups off, query the country only, or disable the database cache.
- importance 3
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
Release builds no longer skip the geo-block for a Development environment
In a release build, a server started with the environment name Development no longer accepts addresses that are refused because of their country. The check for the development environment remains in debug builds only.
- 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.
- importance 2
Attack prevention recognises Invantive load balancers
A block caused by an Invantive load balancer is reported separately from a block of an outside party, and the health check of a load balancer no longer produces a warning on every call.
- importance 2
Attack prevention recognises more probe paths and can be switched on or off
The list of paths that scanners probe, such as environment files and cloud credential files, is much longer, and blocks are logged per IP address. Attack prevention gets an Enabled setting.
- importance 2
Blocked requests get a standard error answer with message, hint and reference
A request that attack prevention blocks is answered with the standard API error format: a translated message and hint, the request address and a reference to the block. The status stays 503 as a signal that a block is occurring, and the JSON includes empty values.
- importance 2
Check the service area of the IP address when signing in and calling the API
Sign-in, sign-up and Cloud API calls are checked against the service area of the IP address of the requester. A rejected request is flagged with a reason code and a hint, and the sign-up page names the country of the email address domain when it is outside the service area.
- importance 2
Clearer handling of repeated and failed MFA codes in Cloud
Cloud explains why a verification code failed, including a change of IP address between the two steps. It limits repeated attempts and tells a user about a successful log-on from a new country.
- importance 2
Client port and user agent are registered and forwarded between services
The client port and the user agent are registered with requests in monitoring, audit events and access control. When one Invantive service calls another, it now forwards the client port and no longer sends an empty forwarded address.
- importance 2
Country is also looked up for allowed IP addresses
An address on the list of allowed addresses was accepted at once without a location. Its country and other details are now looked up as well, so the information is complete.
- 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
Identical wrong passwords in sequence are not delayed again
A client that repeats the same wrong password is no longer delayed once more for each repetition. The monitoring also tells a program from a browser when it reports who cancelled a request.
- importance 2
More networks blocked by default
The default deny list now holds the addresses of a plagiarism-scanning service and the networks of several hosting providers that were named in press reports. The deny list can be excluded with the setting for default addresses.
- importance 2
Register IP address, port and user agent of requesters without trusting forwarded headers
The IP address, port and user agent of a requester are registered with API errors and audit events. Forwarded address headers are only used when configured; attack prevention and forwarding can be set in the Cloud API settings.
- importance 2
Specific hints for refused IP addresses, and correct client port behind a proxy
The answer to a refused IP address now explains the reason for more kinds of refusal, instead of a general hint about the country. The port of the client is read correctly when the forwarded-headers middleware has rewritten the request.
- importance 2
Test endpoint refuses a wrong secret for sensitive data
When a caller supplies a secret that does not match the configured one, the test endpoint now answers with an error and does not silently return the version without sensitive data.
- importance 2
The answer to a failed authentication carries the specific message code
The JSON answer to a refused log-on contains the message code of the refusal instead of the general code of every failed authentication (itgenclr781).
- 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
Cloud keeps the state of a failed password for only a few minutes
Cloud forgets an earlier failed password after three minutes, so the same wrong password is recognised only within that time.
- importance 1
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
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
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
Progress panel shows live row counts and real-time figures per step
The Progress panel of a running statement now follows the rows read and written while a step runs, and not only when it ends. Calls that are still busy show the rows and the bytes sent and received so far.
- importance 3
Packages are listed apart from tables in the object list of the SQL editor
The object list of the SQL editor groups the tables and the packages of a schema separately.
- 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
Support filtering and sorting of the OData model used by MCP
The OData data model that is built for MCP supports filtering and ordering, and carries annotations about what is supported. The model is cached and rebuilt from database metadata. Several edits during development repaired earlier edits of the same feature.
- 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.
- 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
Set up databases for Inspectlet and Tweede Kamer (v2)
New databases can be created for the platforms Inspectlet and Tweede Kamer (v2) from the portal, with their own pages and icons for Inspectlet, Matomo and Nextcloud.
- Inspectlet
- Tweede Kamer
- importance 3
Show the Credentials Server URL of a database and allow its use (beta)
On the page of a database, the address of the Credentials Server is shown with a setting to allow its use, marked as beta. The Cloud services can fetch OAuth tokens through the Credentials API.
- importance 3
Show the MCP Server URL of a database and allow its use (beta)
On the page of a database, the URL of the MCP Server is shown with a copy button, together with a setting to allow its use. The MCP Server is marked as beta.
- importance 3
Show the MCP Server URL of a database and allow its use (beta)
On the page of a database, the URL of the MCP Server is shown with a copy button, together with a setting to allow its use. The MCP Server is marked as beta.
- 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
- 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
Cloud offers set-up of connections for more platforms
The platform pages and set-up forms of Cloud now cover Matomo, Nextcloud, Pipedrive, OpenBesluitvorming, Stripo, VIES, DeepL and Inspectlet, and a product page for Drive.
- Matomo
- Nextcloud
- Pipedrive
- OpenBesluitvorming
- Stripo
- VIES
- DeepL
- Inspectlet
- importance 2
Cloud retries a short OAuth failure and explains a problem of Teamleader
A short failure when a platform is asked for a new token is recognised as temporary and the user gets another hint. A problem at Teamleader is detected by its own message code.
- Teamleader
- importance 2
Connector overview lists more platforms that are being gathered
More platforms from the planning list appear on the connector page, with their icons, so visitors can register interest.
- 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
Offer LibreOffice as a platform in the Cloud account pages
LibreOffice is added to the list of platforms that can be chosen.
- LibreOffice
- 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
Save all allowed-use settings of a database and allow Bridge Online by default
The settings that allow use of Bridge Online and the other services are saved and shown correctly. New databases allow use of Bridge Online by default.
- 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
Visma.net Financials set-up asks for the sales order permissions
Connecting to Visma.net Financials now requests the permissions of the sales order interface, so sales orders can be read and written.
- Visma.net Financials
- importance 2
Allow extra provider attributes after sign-in from the Cloud configuration
Extra provider attributes can be set for databases in the Cloud configuration; they are applied after login. A null value caused a failure and was repaired within this release.
- 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
Pre-emptive loading can be set on a data container
A database in Cloud has a setting for pre-emptive loading, which is passed to the data container.
- 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
Show all token events on the page of a data container
The page of a data container shows the authentication token events to every user who can open the page.
- importance 1
Update the number of Twinfield tables shown on the product page
The product page of Twinfield states the current number of tables.
- Twinfield
- importance 1
Export and import
Download the settings of a database as JSON
The settings of a database can be downloaded as a JSON file in addition to the XML file.
- importance 3
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.
- 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
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
Cached OData metadata distinguishes databases by start-up SQL and connection settings
The cache of the data model of a database now takes its start-up SQL and connection string properties into account. Two sessions with different settings no longer share one cached model.
- importance 2
Compress responses with Brotli and gzip, set cache control and preload key files
Responses are compressed, including SVG images. Static files get cache headers, and the portal tells the browser to load the logo and the translations early. Pages load faster.
- importance 2
Compress responses with Brotli and gzip, set cache control and preload key files
Responses are compressed, including SVG images. Static files get cache headers, and the portal tells the browser to load the logo and the translations early. Pages load faster.
- importance 2
End slow web requests and long text comparisons when a run is cancelled
Cancelling a run now also stops calls to Invantive services that are slow to answer and long text comparisons. Decompression of crafted input can be cancelled.
- importance 2
OData response cache version 1 removed; version 2 is the only cache
The old version of the OData response cache is removed. The remaining cache keeps its files and is registered under a new, shorter name.
- 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
Tables outside the selection are skipped when the data model is built
The data model is built only for the tables that are included, which saves time and memory for databases with many tables.
- 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
Fewer polls of DBMS output in the SQL editor
After a statement, lines still held back by the Oracle DBMS output are fetched, so they do not end up in the output of the next request.
- Oracle
- importance 1
Stop retrying a failed Cloud API request when the error is not recoverable
A request to the Cloud API is no longer repeated when the error response says that repeating cannot succeed. Before, such a request used all retries.
- importance 1
Logging and diagnostics
Register every call to a platform in the connection activity
Calls of drivers to platforms, including database drivers, are registered with begin and end, rows and duration. The connection monitor shows them while they run and with the action of the user that caused them. Earlier, several calls were not registered or were counted twice.
- importance 3
Correlation IDs of inbound requests are registered
Correlation identifiers sent by the caller are kept with the request, passed to Elastic APM and shown in the heartbeat and test answers, so that a request can be followed across services.
- importance 2
Durations are measured and reported with fractions of milliseconds
Durations of requests, sleeps and calculations are now kept as decimal numbers of milliseconds in monitoring and CloudWatch records, instead of whole milliseconds.
- importance 2
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
Filter session input and output by product
The session input and output page has filters for MCP Server, UniversalSQL Server, Data Access Point and Invantive Cloud.
- importance 2
Heartbeat and test endpoint report process identity, failures and unhandled exceptions
The heartbeat and test answers now include an identifier of the process lifetime, the number of failed calculations and, for unhandled exceptions, the average interval and the ratio to requests. This helps to tell a restart from a long-running process.
- importance 2
Identifiers contain their moment of creation
Identifiers in error responses, monitoring records and security events are now time-ordered (UUID version 7), which helps analysis.
- importance 2
Messages of the web host framework are written to the Invantive trace
Messages that the web host writes to standard output are also written to the Invantive trace, with a level based on the exception.
- importance 2
Monitoring history per node, per database and per request, with more detail
The monitoring history can be opened per node and per database, and from a request ID. Lines show the message code and message text, and also show requests of users whose sign-in failed or for which only a licence code is known.
- importance 2
Monitoring history per node, per database and per request, with more detail
The monitoring history can be opened per node and per database, and from a request ID. Lines show the message code and message text, and also show requests of users whose sign-in failed or for which only a licence code is known.
- importance 2
Monitoring history shows forum tips for message codes
Lines with an error in the monitoring history show tips with forum posts for the message code. The layout of error lines was adjusted a number of times.
- importance 2
Monitoring records node registration, failed requests with message codes and shorter SQL
New nodes register themselves with host name, module name and version in centralised monitoring. Failed requests, including those refused with HTTP status 429, are recorded with their message code and exception text, and SQL statements in monitoring are cut in the middle at 10,000 characters.
- 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
Request headers are traced at warning level only for error responses
The headers of a request and its response were traced as warning for every request. They are now a warning only when the request ends in an error and a debug message otherwise.
- 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
Trace messages of the web library carry an explicit logging level
All 173 trace messages of the web library now state a level: debug, warning, error or another. Before, they reached the log and the monitoring as unmapped or unknown.
- importance 2
Accept header and content type of the answer are registered
The monitoring record of a request, including the AWS CloudWatch record, now holds the Accept header and the content type of the response.
- importance 1
Files of the HTTP response cache are registered as managed files
Reads and writes of the metadata and data files of the response cache are registered as managed files of type HTTP output, also when they fail.
- importance 1
Heartbeat endpoint reports the uptime of the process
The heartbeat answer states the number of seconds since the process started.
- importance 1
Identifiers contain their moment of creation in Cloud
Identifiers of errors and security events created by Cloud are time-ordered (UUID version 7).
- importance 1
Monitoring keeps message, kind of request, natural key and partition of an error apart
A failed request is registered in monitoring with its message, kind of request, natural key and partition code as separate fields. Several errors in one request are merged instead of the last one overwriting the first, and a system error is no longer replaced by a general text.
- importance 1
Monitoring shows an error rate per node
The list of nodes in Cloud monitoring shows the percentage of requests that ended in an error.
- importance 1
Show the request ID on audit events and licence key activations
Pages with user audit events and licence key activation attempts show the request ID. Support can use it to find the matching log lines.
- importance 1
Translations and texts
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
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
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
Links to data model documentation point to the data models site
Links to the data model of each platform now point to the data models site instead of the older documentation site.
- importance 2
Product manuals page lists products in production first and marks ended products
The page with product manuals lists products in production first, in alphabetical order. Products that run out or have ended follow, with a text that says so.
- importance 2
Screenshots for the Claude, Tableau and sign-up guides in every language
The set-up guides for Claude and Tableau, and the sign-up steps, have screenshots in all supported languages.
- importance 2
Settings classes carry documentation of their properties
Settings of the web library, such as access control, rate limiting, attack prevention, forwarded headers, monitoring and CloudWatch logging, now describe each property, its default and an example.
- 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
Use the product catalogue for download links and move documentation links to go.invantive.com
Download links of products on the portal now come from the product catalogue instead of fixed addresses in the configuration. Links to the manuals, the SQL grammar and the Support Assistant download point to go.invantive.com.
- importance 2
Settings of access control, rate limits and key storage are described and bindable by name
The settings classes of access control, rate limits, web application settings, CloudWatch and key storage have explicit setting names and descriptions, and key storage has its own settings class.
- importance 1
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
Error answers follow the Accept header
An error answer is written as HTML, JSON, Markdown, plain text or XML, whichever the request prefers; with nothing acceptable it uses the default of the endpoint. A request abandoned by the caller is registered with status 499, and more paths of credential files and debug consoles are blocked.
- importance 4
Give API errors more detail and forward them to UniversalSQL Server
Error responses of the Cloud API carry more elements: recoverability, request URL, correlation ID, time of occurrence, requester address, user agent and tips. UniversalSQL Server receives these elements. Error messages for OData are extended likewise.
- importance 3
New error pages with icons, tips and the correct HTTP status
Error pages have a new design with an icon per kind of error, including 401, 429 and 451, show tips from the documentation, and return the matching HTTP status code. The access denied page also shows tips. The page for HTTP 451 offers a link to the start page.
- importance 3
Progress panel of the SQL editor: rotate, export as picture or flow chart, file reads
The progress panel of the SQL editor can be turned to another side, and exported as a picture or as a Mermaid flow chart. Reads over files show files and bytes read, and numbered steps are corrected. A progress reading is only available to the session that ran the statement.
- importance 3
SQL editor object tree shows packages, procedures and functions of native platforms
For a database that is queried natively, the object tree lists the packages, procedures and functions of the platform next to its tables. A routine with several signatures is listed once per signature.
- importance 3
A call of a path from a later release gets a specific answer
A request for a path that only a later release has is answered with a message code of its own instead of an empty not found.
- importance 2
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
Better indexing of the Invantive Cloud website by search engines
Pages with an unsupported language code are redirected instead of rendered, and the page shown after the interest form is closed to indexing. The sitemap is split without listing URLs twice, and setup pages now describe their steps as a how-to and refer to themselves as canonical page.
- importance 2
Cloud API answers errors in the format the client asks for
The Cloud API chooses the format of an error answer from the Accept header, and the Cloud pages keep their messages translated and declare the right content type.
- importance 2
Cloud error texts show larger parts of the kind and message of an error
Error pages and monitoring use the kind of request and the message of the error itself instead of a general text, and show tips and a hint for a failed log-on.
- importance 2
Error responses carry tips, a link to online help and a retry advice
An API error response can include tips from the online help, the address of the page with the full text of the first tip, and the number of seconds to wait before trying again when a retry is useful. The default message code of an unexpected error changed to itgenaee005.
- importance 2
HTTP status codes of authorisation errors follow the shared error classification
Authorisation errors of the portal and API take their HTTP status code from the shared classification of errors, and fall back to 500 only when it has none.
- importance 2
Improve the error pages of the Cloud web application
Error pages are redesigned with an image per situation and show the error code, request ID and requester IP address. New pages are added for HTTP 429 (too many requests) and 451 (unavailable for legal reasons). A not-found page is returned with a proper 404 response.
- importance 2
JSON is read more strictly
JSON handled by the web library now refuses duplicate property names and trailing commas. Existing default values of properties are kept and filled in when a document is read.
- importance 2
Let search engines crawl the public pages
Public pages of the portal can be crawled by search engines, error pages live under their own path prefix, and indexing is decided per host and environment.
- importance 2
Pages no longer identify users to the Jimo feedback tool
The setting and script that passed the signed-in user and language to Jimo are removed from the pages.
- importance 2
Remove online assistance through TeamViewer
Online assistance through TeamViewer is no longer offered.
- TeamViewer
- 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
Role badges in the title bar
The title bar shows badges for the roles of the user, such as super user, Invantive support, main user of the organisation and service account. A user with normal rights sees none.
- importance 2
Setup guides appear only for platform and product combinations that are offered
A setup guide for a platform that cannot be reached through the product now answers 'not found', like the product page itself. Before, the guide was still shown for such combinations.
- importance 2
UniversalSQL Server no longer marked as BETA in the database settings
On the database pages, the UniversalSQL Server host name and the option to allow its use no longer carry the label BETA.
- importance 2
Change the defaults of the price calculator and the order of subscription products
On the pricing page, the option for all other platforms is selected by default instead of the option for End-of-life Premium. The order in which subscription products are listed is changed.
- importance 1
Claude is listed first among the products for a platform
On connector pages the Claude connector is placed before the other products.
- importance 1
Cloud identifies visitors to Crisp chat
Cloud tells Crisp chat who a signed-in visitor is, signs the address and unbinds the session after sign-out.
- importance 1
Cloud site follows web standards and uses Matomo
The Cloud site has a llms.txt file, accessible names in light and dark mode, the correct product name in the page without JavaScript, and Matomo tracking by identity.
- importance 1
Content types of files and answers are stated correctly
JSON is served as application/json, text as UTF-8, and source maps as JSON. The Mermaid answer and downloads of licence and XML files state their types.
- importance 1
Icons for platforms and products
Icons were added for Claude, the Forums excerpt, Big Data JSON, DeepL, the dashboard and Stripo, and four missing platform icons were filled in.
- importance 1
Improve accessibility and dark-mode display of the portal
A heading appears when JavaScript is off, an image has the missing alternative text, contrast and dark-mode colours of the timeline are corrected, and some layout problems on the licence and setup pages are fixed.
- importance 1
Improve accessibility and dark-mode display of the portal
A heading appears when JavaScript is off, an image has the missing alternative text, contrast and dark-mode colours of the timeline are corrected, and some layout problems on the licence and setup pages are fixed.
- importance 1
Product pages for using Claude through MCP
The Cloud site has pages that explain how to use each platform with Claude through MCP.
- importance 1
Unused monitoring client address setting removed
The setting for the address of the central monitoring client is no longer part of the monitoring settings.
- importance 1
Visual Studio and Sumatra recognised as data tool in sign-up tracking
The sign-up questions offer Visual Studio as data tool. Visitors who arrive from the Visual Studio or Sumatra product pages are registered with that tool.
- importance 1
Website tracking server is configurable
The address of the server for website analytics is a setting. The container is only loaded when the server address and container identifier are set.
- 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
Monitoring loops stop at shutdown
The monitoring loops waited on a token that never cancels. A server now stops them when it shuts down.
- 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
Licensing and sign-in
Lock-out after failed log-ons ends correctly
After repeated failed password attempts, a repeated identical password is refused at once, a refusal no longer counts as a new failed attempt, and a successful log-on resets the counter. The maximum delay is 15 seconds instead of 30, below usual client time-outs.
- importance 4
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
First log-on, last log-on and number of log-ons are registered per product and overall
Log-ons with a password were counted as Bridge Online for every product, and some products were not counted at all. The calling product is now recognised, and the overall first and last log-on and the count cover all products, so service users that never use the web show them too.
- 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
Time spent waiting for a free request slot no longer counts as running time
The daily limit on the time spent on fresh data also counted the time a request waited in the queue for a free slot. A customer was refused with a limit exceeded by 58 million milliseconds. The waiting time is now excluded, and the cancellation of waiting requests and the translated message about waiting too long were improved.
- 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
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
Licence usage check treats the listed contract codes the wrong way round
The condition on the contract codes listed as included in the usage check was reversed. The listed codes are now subject to the check as configured.
- 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
Prevent errors on the licence page when the IP address details cannot be read; fix links
The licence page no longer fails when information about the country of an IP address is unavailable. Links on the licence key activation page point to the correct pages.
- importance 2
Prevent errors on the licence page when the IP address details cannot be read; fix links
The licence page no longer fails when information about the country of an IP address is unavailable. Links on the licence key activation page point to the correct pages.
- importance 2
Repair errors during sign-up
Sign-up failed with an error in some cases: when no user attributes were present, when the organisation record could not be read by the data model, and when the confirmation code link was resent. These cases now work.
- importance 2
Repair errors during sign-up
Sign-up failed with an error in some cases: when no user attributes were present, when the organisation record could not be read by the data model, and when the confirmation code link was resent. These cases now work.
- 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
One-time code input no longer raises a script error when the field is absent
Pages that ask for a one-time code contained a malformed selector and an unchecked call, which gave a script error on pages without that field. The selector is corrected and guarded.
- importance 1
Sign-up details page renders without a model
The sign-up details form is only drawn when it has data to show. Before, the page could fail when no data was available.
- importance 1
Security
Connection settings page shows labels and suitable fields and masks secret values
The page to change the settings of a data container showed the technical code of each setting, used a text box for every type, and showed secret values such as passwords in clear. It now shows the label and a fitting control, and masks values that the driver does not allow to be shown.
- importance 4
Security mail reaches users who have no separate audit address
Users who never set a separate audit email address received no security mail. The mail now goes to their ordinary address, and a trace is written when neither address exists.
- 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
Check of the multi-factor cookie uses the address of the visitor
The check of the multi-factor sign-in cookie compared the address stored in the cookie with the address of the server instead of the address of the visitor. It now uses the visitor address.
- importance 2
IP validation keeps working when the download of the SpamHaus lists fails
A download with no entries, or a failed one, left the list empty or made every IP check fail. The previous download or the built-in list is used instead, and errors no longer reach the caller.
- importance 2
Rate limit tells the right waiting time when the minute or hour limit is exceeded
After an hour or minute limit was exceeded, the advised delay was the time to the next second. It is now the time until the minute or hour counter resets.
- importance 2
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
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
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
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
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
Adding an AFAS Online database no longer ends in a bad request
The form to add an AFAS Online database did not carry its security token, so submitting it ended in an HTTP 400 answer. The form now includes the token, and a bad request is reported with a message code per cause.
- AFAS Online
- 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
Dropbox set-up chose the wrong kind of API when only one application is configured
When only the business or only the personal Dropbox application was configured, the set-up selected the other kind. It now selects the one that is configured.
- Dropbox
- 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
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
Performance
Memory use no longer grows without limit on busy servers
Four in-memory stores were never cleaned up: blocked IP addresses that did not return, the link between session identifiers and users, the cancellation source of every request, and the memory of duplicate events. They are now pruned or released, so a server under a scan or with many sessions keeps a stable memory use.
- importance 3
Failure to set a response header no longer fails the cached response
When a response header of the OData response cache cannot be set, the problem is now logged and the response continues. Before, the exception ended the request.
- importance 2
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
Logging and diagnostics
Heartbeat endpoint answers unhealthy when the application says so
When the application-specific test reported a failure, the endpoint still answered healthy because it recomputed the health from the application data alone. The failure is now kept.
- importance 3
A refused request no longer raises a second error for lack of a session
A request refused before the session was set up, such as one from a refused IP address, raised an additional error when the error logger built a data context. The logger now checks first whether there is a session.
- importance 2
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 display of columns in the monitoring history
Several columns of the monitoring history were wrong: the timeline order, the from-cache indicator, the referer header, the owner of an IP address when none exists, SQL parameters layout, and a failing link to a session that does not exist.
- importance 2
Correct display of columns in the monitoring history
Several columns of the monitoring history were wrong: the timeline order, the from-cache indicator, the referer header, the owner of an IP address when none exists, SQL parameters layout, and a failing link to a session that does not exist.
- 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
Return errors from outside controllers as proper JSON and handle early start-up errors
Errors raised outside the API controllers, for example by the sign-in check, are returned as correct JSON. Start-up failures of the API and the scheduler are reported with the exit code and the time.
- 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
Heartbeat answer named the wrong type in its metadata
The metadata type in the heartbeat answer named the type of the test answer. It now names the heartbeat type.
- 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
Original path of a failed request is found when the normal path is not available
When the path of a request cannot be read during error handling, the original path stored earlier for the request is used. Before, the path was empty in the error report.
- 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
Warnings about failed dependency injection were written on success
The trace warned that dependency injection of the state helpers failed when it had succeeded, and stayed silent when it failed.
- importance 1
Translations and texts
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
Other
Prevent an HTTP 500 on the start page and let the API start when its licence check fails
Some visitors received a bare HTTP 500 on the start page of the portal because the link to the start page in a language could not be built. The Cloud API now starts even if its licence check fails and answers every request with a normal error message.
- importance 3
A log-on registration changes only the log-on columns
A product registered a log-on by writing back the whole database record, which wiped the columns that an older product did not know. Only the log-on columns are written now.
- importance 2
A thread without request can ask whether its session still exists
Background work without an HTTP request can ask whether a session exists without creating it. This is the repair for message itgenshr062, which appeared when the owner named an ended session.
- importance 2
Connector pages of platforms being gathered no longer redirect to the home page
The generic product page of a platform whose interest is being gathered was excluded, which sent visitors to the home page. The page is kept so that visitors can register interest.
- importance 2
Correct the price calculation on the pricing page
The price calculator gave a wrong price at the lowest slider position. The behaviour of clicking an entry of the price list was changed too.
- importance 2
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
Error dialogs of the portal show the related forum topics
Error messages in dialogs never listed related forum topics, because the page read the wrong field of the answer. They now show the topics.
- importance 2
Fix adding an IP address on the database page and a wrong route parameter
Adding an IP address to the list of external clients on the page of a database edited the wrong list. The address of the Bridge Online segment lookup used a wrong parameter name.
- 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
Open product pages by connector with the generic layout instead of failing
Opening the page of a connector for a product variant that does not exist for that connector failed with an error. The generic variant is shown instead.
- importance 2
Pages no longer raise a script error in Safari on iOS because of the address markup
The corporate address in the footer and on the contact page was marked up in a way that made Safari on iOS stop with a script error. The markup is removed and the organisation is published as structured data instead.
- importance 2
Prevent errors at start-up and when reading a request URL
The Cloud API no longer fails at start-up when the data model views are not yet installed. A request URL that is read after the request has ended no longer causes an error. Sending response headers after the response has started is skipped.
- importance 2
Prevent errors at start-up and when reading a request URL
The Cloud API no longer fails at start-up when the data model views are not yet installed. A request URL that is read after the request has ended no longer causes an error. Sending response headers after the response has started is skipped.
- importance 2
Return errors of the SEPA payment QR code image as API errors
Requests for the SEPA QR code image of an invoice that failed were handled as web page errors and caused a second failure. The failure is now returned as a normal API error.
- importance 2
Apple icon files load on case-sensitive hosting
Apple icon files had upper-case extensions and are renamed so that their links work.
- importance 1
Chamber of commerce link points to the registration
In the footer and on the contact page, the link to the chamber of commerce used the text for office hours as address. It now uses the registration address.
- importance 1
Cloud sends the visitor back to log-on when the session of a grid has ended
A grid on a Cloud page showed an error when the session had timed out. The visitor is now sent to the log-on page.
- importance 1
Error page refuses a non-numeric status code in the address
The error page address accepts only a number as status code. Before, any text was accepted.
- importance 1
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
Message dialogs fit messages of a few paragraphs
The message dialog showed only 200 pixels of text before scrolling, so the last line of a longer message was missed. It now allows up to 60 per cent of the screen height, with a maximum of 420 pixels.
- importance 1
Pages no longer fail with 'translations is not defined' when the script does not arrive
When the translation script could not be loaded, for example on a poor network, the page itself raised an error. The check no longer fails, so the intended alert and monitoring message are shown.
- importance 1
Recognise .pot files as PowerPoint templates
The file extension of PowerPoint templates had a typing error and was not recognised.
- importance 1
Tooltips in forms are no longer cut off at the bottom edge
Tooltips at the bottom of a form were clipped. They can now extend beyond the bottom edge.
- importance 1
What It Builds On
| Kind | Name | From | To |
|---|---|---|---|
| invantive component | Invantive Cloud | 26.0.4 | 27.0.92 |
| invantive component | Invantive(R) Basics | 26.0.4 | 27.0.92 |
| invantive component | Invantive(R) Cloud API Shared | 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) Web Core Library | 26.0.4 | 27.0.92 |
| build tool | Invantive Deploy | 26.0.4 | 27.0.92 |
| third party summary |
More Information
How This Note Was Made
- 50 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 56 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 67 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 54 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 60 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 50 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 52 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 50 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 50 % of the changed lines are also in the first build of 26.0; verify that the change is new in 27.0
- 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.
- 1343 links between a change and a source commit are recorded.
- 55 exclusions are recorded in the audit of the note.