---
title: "Release notes of Invantive Cloud"
description: "The enhancements and bug fixes of the Invantive products per release, with what to check before upgrading."
language: en
canonical: https://documentation.invantive.eu/en/release-notes/products?product=invantive-cloud
---

# Release notes of Invantive Cloud

**Products:** [Invantive Authenticator](/en/release-notes/products.md?product=invantive-authenticator&product=invantive-cloud) | [Invantive Bridge](/en/release-notes/products.md?product=invantive-bridge&product=invantive-cloud) | [Invantive Bridge Online](/en/release-notes/products.md?product=invantive-bridge-online&product=invantive-cloud) | [Invantive Bridge Online Samples](/en/release-notes/products.md?product=invantive-bridge-online-samples&product=invantive-cloud) | [Invantive Business for Windows](/en/release-notes/products.md?product=invantive-business-for-windows&product=invantive-cloud) | [Invantive Business Server](/en/release-notes/products.md?product=invantive-business-server&product=invantive-cloud) | **[Invantive Cloud](/en/release-notes/products.md)** (chosen) | [Invantive Connect](/en/release-notes/products.md?product=invantive-cloud&product=invantive-connect) | [Invantive Control for Excel](/en/release-notes/products.md?product=invantive-cloud&product=invantive-control-for-excel) | [Invantive Data Access Point](/en/release-notes/products.md?product=invantive-cloud&product=invantive-data-access-point) | [Invantive Data Hub](/en/release-notes/products.md?product=invantive-cloud&product=invantive-data-hub) | [Invantive Data Loader](/en/release-notes/products.md?product=invantive-cloud&product=invantive-data-loader) | [Invantive Estate for Windows](/en/release-notes/products.md?product=invantive-cloud&product=invantive-estate-for-windows) | [Invantive MCP Server](/en/release-notes/products.md?product=invantive-cloud&product=invantive-mcp-server) | [Invantive Optimizer](/en/release-notes/products.md?product=invantive-cloud&product=invantive-optimizer) | [Invantive Query Tool for Windows](/en/release-notes/products.md?product=invantive-cloud&product=invantive-query-tool) | [Invantive Query Tool Multi-Platform](/en/release-notes/products.md?product=invantive-cloud&product=invantive-query-tool-multi-platform) | [Invantive Runtime](/en/release-notes/products.md?product=invantive-cloud&product=invantive-runtime) | [Invantive Studio](/en/release-notes/products.md?product=invantive-cloud&product=invantive-studio) | [Invantive Support Assistant](/en/release-notes/products.md?product=invantive-cloud&product=invantive-support-assistant) | [Invantive UniversalSQL Server](/en/release-notes/products.md?product=invantive-cloud&product=invantive-universalsql-server)

**Releases:** [26.0 to 27.0](/en/release-notes/products.md?product=invantive-cloud&step=26.0-to-27.0) | [new in 27.0](/en/release-notes/products.md?product=invantive-cloud&step=new-in-27.0) | [25.0 to 26.0](/en/release-notes/products.md?product=invantive-cloud&step=25.0-to-26.0)

<div class="rn-block" id="invantive-cloud-26.0-to-27.0">

<div class="rn-head">

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.0.92` | 09-11-2026 | latest build of release 27.0 at the time of writing |

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

- **286** enhancements
- **180** bug fixes
- **10** things to check before upgrading

</div>

<div class="rn-layout">

<div class="rn-index">

**This Note**

- [Before You Upgrade](#invantive-cloud-26.0-to-27.0-before)
- [Top 25 Changes](#invantive-cloud-26.0-to-27.0-top)
- [All Enhancements](#invantive-cloud-26.0-to-27.0-new) 286
- [All Bug Fixes](#invantive-cloud-26.0-to-27.0-fixed) 180
- [What It Builds On](#invantive-cloud-26.0-to-27.0-builds)
- [More Information](#invantive-cloud-26.0-to-27.0-more)

**Enhancements**

- [Installation and platform](#invantive-cloud-26.0-to-27.0-e-installation-and-platform) 14
- [Licensing and sign-in](#invantive-cloud-26.0-to-27.0-e-licensing-and-sign-in) 23
- [Security](#invantive-cloud-26.0-to-27.0-e-security) 32
- [SQL engine](#invantive-cloud-26.0-to-27.0-e-sql-engine) 35
- [Scripting](#invantive-cloud-26.0-to-27.0-e-scripting) 6
- [Query Tool user interface](#invantive-cloud-26.0-to-27.0-e-query-tool-user-interface) 2
- [Platforms and drivers](#invantive-cloud-26.0-to-27.0-e-platforms-and-drivers) 79
- [Export and import](#invantive-cloud-26.0-to-27.0-e-export-and-import) 5
- [Performance](#invantive-cloud-26.0-to-27.0-e-performance) 22
- [Logging and diagnostics](#invantive-cloud-26.0-to-27.0-e-logging-and-diagnostics) 23
- [Translations and texts](#invantive-cloud-26.0-to-27.0-e-translations-and-texts) 2
- [Documentation](#invantive-cloud-26.0-to-27.0-e-documentation) 10
- [Other](#invantive-cloud-26.0-to-27.0-e-other) 33

**Bug Fixes**

- [Installation and platform](#invantive-cloud-26.0-to-27.0-b-installation-and-platform) 4
- [Licensing and sign-in](#invantive-cloud-26.0-to-27.0-b-licensing-and-sign-in) 21
- [Security](#invantive-cloud-26.0-to-27.0-b-security) 8
- [SQL engine](#invantive-cloud-26.0-to-27.0-b-sql-engine) 36
- [Scripting](#invantive-cloud-26.0-to-27.0-b-scripting) 4
- [Platforms and drivers](#invantive-cloud-26.0-to-27.0-b-platforms-and-drivers) 52
- [Export and import](#invantive-cloud-26.0-to-27.0-b-export-and-import) 6
- [Performance](#invantive-cloud-26.0-to-27.0-b-performance) 6
- [Logging and diagnostics](#invantive-cloud-26.0-to-27.0-b-logging-and-diagnostics) 16
- [Translations and texts](#invantive-cloud-26.0-to-27.0-b-translations-and-texts) 2
- [Other](#invantive-cloud-26.0-to-27.0-b-other) 25

</div>

<div class="rn-main">

<div class="rn-before" id="invantive-cloud-26.0-to-27.0-before">

### Before You Upgrade

These changes ask for a check:

- [Settings files move from XML to JSON](#CLD-27.0-E001)
  - 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](#CLD-27.0-E008)
  - 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](#CLD-27.0-E013)
  - Adjust statements that call the QR code functions with a separate width and height.
- [Integer constants in SQL keep an integer type](#CLD-27.0-E054)
  - 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](#CLD-27.0-E069)
  - 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](#CLD-27.0-E152)
  - 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](#CLD-27.0-E144)
  - 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](#CLD-27.0-E018)
  - 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](#CLD-27.0-E011)
  - 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](#CLD-27.0-E095)
  - Remove the three garbage-collection settings of the Data Cache driver from settings files.

</div>

<a id="invantive-cloud-26.0-to-27.0-top"></a>

### Top 25 Changes

<div class="rn-top">

1. [Settings files move from XML to JSON](#CLD-27.0-E001)
   - *Enhancement*
   - **action needed**
   - Action needed before or after the upgrade.
2. [More work is sent to the platform: row limit, grouping, selected columns and joins](#CLD-27.0-E005)
   - *Enhancement*
   - A query with LIMIT or TOP is limited by the platform, COUNT, SUM and other group functions are answered by the platform on supported drivers, only the columns that a query needs are requested, join conditions are forwarded, an exists condition on a child table reaches the platform, and OData platforms get shorter filters with the IN operator. Fewer rows are transferred.
3. [Joins return the correct rows](#CLD-27.0-B001)
   - *Bug Fix*
   - A left, right or full join written without the word OUTER was executed as an inner join and lost rows. A right outer join placed columns in the wrong order, a condition in ON removed rows, a cross join dropped its right-hand side, and a full outer join that could not be answered was not reported.
4. [Correlated subqueries are supported](#CLD-27.0-E002)
   - *Enhancement*
   - A subquery can refer to columns of the outer query, as in EXISTS, IN and scalar subqueries. A subquery without outer references is evaluated once per statement and its answer is reused.
5. [DeepL driver](#CLD-27.0-E004)
   - *Enhancement*
   - A new driver reads and writes DeepL: languages, billing, translation, writing assistance, documents, glossaries, style rules and translation memories.
6. [Parts of a PSQL block can run in parallel](#CLD-27.0-E003)
   - *Enhancement*
   - PSQL gets a PARALLEL construct that runs branches and loop iterations side by side, SYNCHRONIZE accepts a parallel option, and the package dbms_atomic holds values that parallel branches share safely.
7. [Exact Online companies outside the service area are no longer accepted](#CLD-27.0-E008)
   - *Enhancement*
   - **action needed**
   - Action needed before or after the upgrade.
8. [Loading of provider assemblies from a settings file is blocked](#CLD-27.0-E011)
   - *Enhancement*
   - **action needed**
   - Action needed before or after the upgrade.
9. [Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list](#CLD-27.0-E018)
   - *Enhancement*
   - **action needed**
   - Action needed before or after the upgrade.
10. [QR code functions take one size value instead of width and height](#CLD-27.0-E013)
    - *Enhancement*
    - **action needed**
    - Action needed before or after the upgrade.
11. [Data containers and credentials from Invantive Credentials Server](#CLD-27.0-E007)
    - *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.
12. [Data is loaded in the background while a session is idle](#CLD-27.0-E023)
    - *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.
13. [New platforms: Inspectlet, Matomo, Nextcloud and Tweede Kamer v5](#CLD-27.0-E016)
    - *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.
14. [Invantive License Service: clearer messages, grace period and new modules](#CLD-27.0-E009)
    - *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.
15. [Big Data JSON reads files much faster and skips files that cannot match](#CLD-27.0-E022)
    - *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.
16. [Visma.net: new API specification, Visma Connect log-on and the Sales Order APIs](#CLD-27.0-E021)
    - *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.
17. [Exact Online incremental tables reload less often and are read faster](#CLD-27.0-E024)
    - *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.
18. [Support filtering and sorting of the OData model used by MCP](#CLD-27.0-E019)
    - *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.
19. [IP address validation configurable with allow lists, deny lists and ranges](#CLD-27.0-E010)
    - *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.
20. [Proxy and load balancer set-up through a ForwardedHeaders section](#CLD-27.0-E006)
    - *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.
21. [Filters no longer lose rows or evaluate wrongly](#CLD-27.0-B005)
    - *Bug Fix*
    - A condition such as a and (b or c) could return too few rows, lower and upper case conversions and decimal constants were not sent correctly to SQL databases, NOT LIKE dropped rows that differ only in case, and x between 1 and 2 and y = 1 was read wrongly.
22. [Exact Online incremental data is no longer damaged or overwritten](#CLD-27.0-B006)
    - *Bug Fix*
    - Users of one subscription replaced each other's incremental image, a request that ended while an image was saved could leave chunks of two versions, a refresh that only added rows was taken as unchanged, and incremental data could end up in the folder of other cache settings or ignore the disk cache settings of the statement.
23. [Error answers follow the Accept header](#CLD-27.0-E025)
    - *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.
24. [Lock-out after failed log-ons ends correctly](#CLD-27.0-B002)
    - *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.
25. [Pipedrive platform](#CLD-27.0-E017)
    - *Enhancement*
    - Pipedrive can be read as a new platform, with labels for custom fields, and the OAuth sign-in window understands its error answers.

</div>

<a id="invantive-cloud-26.0-to-27.0-new"></a>

### All Enhancements

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

<div class="rn-filters">

Importance: [all](/en/release-notes/products?product=invantive-cloud#invantive-cloud-26.0-to-27.0-new) | [2 and higher](/en/release-notes/products?product=invantive-cloud&importance=2#invantive-cloud-26.0-to-27.0-new) | [3 and higher](/en/release-notes/products?product=invantive-cloud&importance=3#invantive-cloud-26.0-to-27.0-new) | [4 and higher](/en/release-notes/products?product=invantive-cloud&importance=4#invantive-cloud-26.0-to-27.0-new) | [5](/en/release-notes/products?product=invantive-cloud&importance=5#invantive-cloud-26.0-to-27.0-new)

Platform: [all](/en/release-notes/products?product=invantive-cloud#invantive-cloud-26.0-to-27.0-new) | [AccountView](/en/release-notes/products?product=invantive-cloud&platform=AccountView#invantive-cloud-26.0-to-27.0-new) (1) | [ActiveCampaign](/en/release-notes/products?product=invantive-cloud&platform=ActiveCampaign#invantive-cloud-26.0-to-27.0-new) (3) | [AFAS](/en/release-notes/products?product=invantive-cloud&platform=AFAS#invantive-cloud-26.0-to-27.0-new) (1) | [AFAS Online](/en/release-notes/products?product=invantive-cloud&platform=AFAS%20Online#invantive-cloud-26.0-to-27.0-new) (4) | [Autotask](/en/release-notes/products?product=invantive-cloud&platform=Autotask#invantive-cloud-26.0-to-27.0-new) (1) | [Big Data JSON](/en/release-notes/products?product=invantive-cloud&platform=Big%20Data%20JSON#invantive-cloud-26.0-to-27.0-new) (1) | [Brevo](/en/release-notes/products?product=invantive-cloud&platform=Brevo#invantive-cloud-26.0-to-27.0-new) (2) | [Bridge Online](/en/release-notes/products?product=invantive-cloud&platform=Bridge%20Online#invantive-cloud-26.0-to-27.0-new) (4) | [CBS](/en/release-notes/products?product=invantive-cloud&platform=CBS#invantive-cloud-26.0-to-27.0-new) (1) | [Chargebee](/en/release-notes/products?product=invantive-cloud&platform=Chargebee#invantive-cloud-26.0-to-27.0-new) (1) | [Crisp](/en/release-notes/products?product=invantive-cloud&platform=Crisp#invantive-cloud-26.0-to-27.0-new) (4) | [Data Cache](/en/release-notes/products?product=invantive-cloud&platform=Data%20Cache#invantive-cloud-26.0-to-27.0-new) (1) | [DeepL](/en/release-notes/products?product=invantive-cloud&platform=DeepL#invantive-cloud-26.0-to-27.0-new) (2) | [Discourse](/en/release-notes/products?product=invantive-cloud&platform=Discourse#invantive-cloud-26.0-to-27.0-new) (1) | [Dropbox](/en/release-notes/products?product=invantive-cloud&platform=Dropbox#invantive-cloud-26.0-to-27.0-new) (2) | [Dynamics 365 CRM](/en/release-notes/products?product=invantive-cloud&platform=Dynamics%20365%20CRM#invantive-cloud-26.0-to-27.0-new) (2) | [Dynamics CRM](/en/release-notes/products?product=invantive-cloud&platform=Dynamics%20CRM#invantive-cloud-26.0-to-27.0-new) (2) | [Easyflex](/en/release-notes/products?product=invantive-cloud&platform=Easyflex#invantive-cloud-26.0-to-27.0-new) (1) | [EDIFACT](/en/release-notes/products?product=invantive-cloud&platform=EDIFACT#invantive-cloud-26.0-to-27.0-new) (1) | [Exact Online](/en/release-notes/products?product=invantive-cloud&platform=Exact%20Online#invantive-cloud-26.0-to-27.0-new) (32) | [Firebird](/en/release-notes/products?product=invantive-cloud&platform=Firebird#invantive-cloud-26.0-to-27.0-new) (2) | [Fortnox](/en/release-notes/products?product=invantive-cloud&platform=Fortnox#invantive-cloud-26.0-to-27.0-new) (1) | [FoxPro](/en/release-notes/products?product=invantive-cloud&platform=FoxPro#invantive-cloud-26.0-to-27.0-new) (1) | [Freshdesk](/en/release-notes/products?product=invantive-cloud&platform=Freshdesk#invantive-cloud-26.0-to-27.0-new) (3) | [Freshservice](/en/release-notes/products?product=invantive-cloud&platform=Freshservice#invantive-cloud-26.0-to-27.0-new) (2) | [FTP](/en/release-notes/products?product=invantive-cloud&platform=FTP#invantive-cloud-26.0-to-27.0-new) (1) | [Gripp](/en/release-notes/products?product=invantive-cloud&platform=Gripp#invantive-cloud-26.0-to-27.0-new) (1) | [Gripp CRM](/en/release-notes/products?product=invantive-cloud&platform=Gripp%20CRM#invantive-cloud-26.0-to-27.0-new) (2) | [HubSpot](/en/release-notes/products?product=invantive-cloud&platform=HubSpot#invantive-cloud-26.0-to-27.0-new) (3) | [IBM Db2](/en/release-notes/products?product=invantive-cloud&platform=IBM%20Db2#invantive-cloud-26.0-to-27.0-new) (1) | [In-memory](/en/release-notes/products?product=invantive-cloud&platform=In-memory#invantive-cloud-26.0-to-27.0-new) (2) | [In-memory storage](/en/release-notes/products?product=invantive-cloud&platform=In-memory%20storage#invantive-cloud-26.0-to-27.0-new) (1) | [Inspectlet](/en/release-notes/products?product=invantive-cloud&platform=Inspectlet#invantive-cloud-26.0-to-27.0-new) (4) | [Invantive Bridge Online](/en/release-notes/products?product=invantive-cloud&platform=Invantive%20Bridge%20Online#invantive-cloud-26.0-to-27.0-new) (1) | [Invantive Business](/en/release-notes/products?product=invantive-cloud&platform=Invantive%20Business#invantive-cloud-26.0-to-27.0-new) (1) | [Invantive Estate](/en/release-notes/products?product=invantive-cloud&platform=Invantive%20Estate#invantive-cloud-26.0-to-27.0-new) (1) | [Invantive Web Service](/en/release-notes/products?product=invantive-cloud&platform=Invantive%20Web%20Service#invantive-cloud-26.0-to-27.0-new) (1) | [ionBIZ](/en/release-notes/products?product=invantive-cloud&platform=ionBIZ#invantive-cloud-26.0-to-27.0-new) (1) | [Kadaster](/en/release-notes/products?product=invantive-cloud&platform=Kadaster#invantive-cloud-26.0-to-27.0-new) (1) | [LibreOffice](/en/release-notes/products?product=invantive-cloud&platform=LibreOffice#invantive-cloud-26.0-to-27.0-new) (1) | [LinkedIn](/en/release-notes/products?product=invantive-cloud&platform=LinkedIn#invantive-cloud-26.0-to-27.0-new) (1) | [Logius COR](/en/release-notes/products?product=invantive-cloud&platform=Logius%20COR#invantive-cloud-26.0-to-27.0-new) (1) | [Loket](/en/release-notes/products?product=invantive-cloud&platform=Loket#invantive-cloud-26.0-to-27.0-new) (1) | [Loket.nl](/en/release-notes/products?product=invantive-cloud&platform=Loket.nl#invantive-cloud-26.0-to-27.0-new) (2) | [Magento](/en/release-notes/products?product=invantive-cloud&platform=Magento#invantive-cloud-26.0-to-27.0-new) (3) | [MariaDB](/en/release-notes/products?product=invantive-cloud&platform=MariaDB#invantive-cloud-26.0-to-27.0-new) (1) | [Matomo](/en/release-notes/products?product=invantive-cloud&platform=Matomo#invantive-cloud-26.0-to-27.0-new) (3) | [Mendix](/en/release-notes/products?product=invantive-cloud&platform=Mendix#invantive-cloud-26.0-to-27.0-new) (1) | [Microsoft Access](/en/release-notes/products?product=invantive-cloud&platform=Microsoft%20Access#invantive-cloud-26.0-to-27.0-new) (1) | [Microsoft Dynamics CRM](/en/release-notes/products?product=invantive-cloud&platform=Microsoft%20Dynamics%20CRM#invantive-cloud-26.0-to-27.0-new) (1) | [Microsoft Graph](/en/release-notes/products?product=invantive-cloud&platform=Microsoft%20Graph#invantive-cloud-26.0-to-27.0-new) (1) | [MySQL](/en/release-notes/products?product=invantive-cloud&platform=MySQL#invantive-cloud-26.0-to-27.0-new) (10) | [Nextcloud](/en/release-notes/products?product=invantive-cloud&platform=Nextcloud#invantive-cloud-26.0-to-27.0-new) (2) | [Nmbrs](/en/release-notes/products?product=invantive-cloud&platform=Nmbrs#invantive-cloud-26.0-to-27.0-new) (2) | [OData](/en/release-notes/products?product=invantive-cloud&platform=OData#invantive-cloud-26.0-to-27.0-new) (1) | [ODBC](/en/release-notes/products?product=invantive-cloud&platform=ODBC#invantive-cloud-26.0-to-27.0-new) (3) | [Odoo](/en/release-notes/products?product=invantive-cloud&platform=Odoo#invantive-cloud-26.0-to-27.0-new) (4) | [Open Archives](/en/release-notes/products?product=invantive-cloud&platform=Open%20Archives#invantive-cloud-26.0-to-27.0-new) (1) | [Open Besluitvorming](/en/release-notes/products?product=invantive-cloud&platform=Open%20Besluitvorming#invantive-cloud-26.0-to-27.0-new) (1) | [OpenBesluitvorming](/en/release-notes/products?product=invantive-cloud&platform=OpenBesluitvorming#invantive-cloud-26.0-to-27.0-new) (1) | [Oracle](/en/release-notes/products?product=invantive-cloud&platform=Oracle#invantive-cloud-26.0-to-27.0-new) (15) | [PayPal](/en/release-notes/products?product=invantive-cloud&platform=PayPal#invantive-cloud-26.0-to-27.0-new) (2) | [Pipedrive](/en/release-notes/products?product=invantive-cloud&platform=Pipedrive#invantive-cloud-26.0-to-27.0-new) (2) | [PostgreSQL](/en/release-notes/products?product=invantive-cloud&platform=PostgreSQL#invantive-cloud-26.0-to-27.0-new) (14) | [Rabobank MT940](/en/release-notes/products?product=invantive-cloud&platform=Rabobank%20MT940#invantive-cloud-26.0-to-27.0-new) (1) | [RDW](/en/release-notes/products?product=invantive-cloud&platform=RDW#invantive-cloud-26.0-to-27.0-new) (2) | [Robaws](/en/release-notes/products?product=invantive-cloud&platform=Robaws#invantive-cloud-26.0-to-27.0-new) (3) | [Salesforce](/en/release-notes/products?product=invantive-cloud&platform=Salesforce#invantive-cloud-26.0-to-27.0-new) (1) | [SFTP](/en/release-notes/products?product=invantive-cloud&platform=SFTP#invantive-cloud-26.0-to-27.0-new) (1) | [SnelStart](/en/release-notes/products?product=invantive-cloud&platform=SnelStart#invantive-cloud-26.0-to-27.0-new) (5) | [SQL Server](/en/release-notes/products?product=invantive-cloud&platform=SQL%20Server#invantive-cloud-26.0-to-27.0-new) (13) | [Stripo](/en/release-notes/products?product=invantive-cloud&platform=Stripo#invantive-cloud-26.0-to-27.0-new) (3) | [Teamleader](/en/release-notes/products?product=invantive-cloud&platform=Teamleader#invantive-cloud-26.0-to-27.0-new) (2) | [Teamleader Focus](/en/release-notes/products?product=invantive-cloud&platform=Teamleader%20Focus#invantive-cloud-26.0-to-27.0-new) (2) | [TeamViewer](/en/release-notes/products?product=invantive-cloud&platform=TeamViewer#invantive-cloud-26.0-to-27.0-new) (1) | [Tixly](/en/release-notes/products?product=invantive-cloud&platform=Tixly#invantive-cloud-26.0-to-27.0-new) (1) | [Tweede Kamer](/en/release-notes/products?product=invantive-cloud&platform=Tweede%20Kamer#invantive-cloud-26.0-to-27.0-new) (3) | [Twinfield](/en/release-notes/products?product=invantive-cloud&platform=Twinfield#invantive-cloud-26.0-to-27.0-new) (8) | [VIES](/en/release-notes/products?product=invantive-cloud&platform=VIES#invantive-cloud-26.0-to-27.0-new) (2) | [Visma Severa](/en/release-notes/products?product=invantive-cloud&platform=Visma%20Severa#invantive-cloud-26.0-to-27.0-new) (1) | [Visma.net](/en/release-notes/products?product=invantive-cloud&platform=Visma.net#invantive-cloud-26.0-to-27.0-new) (5) | [Visma.net Financials](/en/release-notes/products?product=invantive-cloud&platform=Visma.net%20Financials#invantive-cloud-26.0-to-27.0-new) (1) | [Wikipedia](/en/release-notes/products?product=invantive-cloud&platform=Wikipedia#invantive-cloud-26.0-to-27.0-new) (1) | [WMI](/en/release-notes/products?product=invantive-cloud&platform=WMI#invantive-cloud-26.0-to-27.0-new) (1) | [XAA](/en/release-notes/products?product=invantive-cloud&platform=XAA#invantive-cloud-26.0-to-27.0-new) (1) | [XAF](/en/release-notes/products?product=invantive-cloud&platform=XAF#invantive-cloud-26.0-to-27.0-new) (1) | [Yuki](/en/release-notes/products?product=invantive-cloud&platform=Yuki#invantive-cloud-26.0-to-27.0-new) (4)

</div>

<a id="invantive-cloud-26.0-to-27.0-e-installation-and-platform"></a>

#### Installation and platform

<div class="rn-item" id="CLD-27.0-E001">

##### 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.

<div class="rn-action">

**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.

</div>

<div class="rn-chips">

- **action needed**
- importance 5

</div>

</div>

<div class="rn-item" id="CLD-27.0-E006">

##### 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.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E026">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E027">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E028">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E107">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E108">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E109">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E110">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E111">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E112">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E237">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E238">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E239">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-licensing-and-sign-in"></a>

#### Licensing and sign-in

<div class="rn-item" id="CLD-27.0-E007">

##### 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.

<div class="rn-chips">

- importance 4

</div>

[Invantive Credentials Server](https://documentation.invantive.com/Invantive+Credentials+Server/Invantive+Credentials+Server), [Concept of Invantive Credentials Server](https://documentation.invantive.com/Invantive+Credentials+Server/Concept)

</div>

<div class="rn-item" id="CLD-27.0-E008">

##### 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.

<div class="rn-action">

**What to Do**

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

</div>

<div class="rn-chips">

- **action needed**
- Exact Online
- importance 4

</div>

[Service area of Invantive Cloud](https://documentation.invantive.com/Invantive+Cloud/Concepts/Service+Area)

</div>

<div class="rn-item" id="CLD-27.0-E009">

##### 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.

<div class="rn-chips">

- importance 4

</div>

[License Service](https://documentation.invantive.com/Environment+Variables/License+Service)

</div>

<div class="rn-item" id="CLD-27.0-E029">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E030">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E031">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E032">

##### 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.

<div class="rn-chips">

- importance 3

</div>

[Environment variables](https://documentation.invantive.com/Environment+Variables/Environment+Variables)

</div>

<div class="rn-item" id="CLD-27.0-E033">

##### 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.

<div class="rn-chips">

- Dynamics 365 CRM
- Loket.nl
- Dropbox
- HubSpot
- Fortnox
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E034">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E113">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E114">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E115">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E116">

##### 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.

<div class="rn-chips">

- Teamleader
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E117">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E118">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E119">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E120">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E240">

##### Cloud sessions last as long as the token allows

The expiry of a Cloud session is based on the moment the token was issued.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E241">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E242">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E243">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E244">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E245">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-security"></a>

#### Security

<div class="rn-item" id="CLD-27.0-E010">

##### 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.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E011">

##### 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.

<div class="rn-action">

**What to Do**

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

</div>

<div class="rn-chips">

- **action needed**
- EDIFACT
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E012">

##### 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.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E035">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E036">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E037">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E038">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E039">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E040">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E041">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E042">

##### 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.

<div class="rn-chips">

- MySQL
- PostgreSQL
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E043">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E044">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E121">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E122">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E123">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E124">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E125">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E126">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E127">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E128">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E129">

##### 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.

<div class="rn-chips">

- Oracle
- PostgreSQL
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E130">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E131">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E132">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E133">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E134">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E135">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E136">

##### 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).

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E137">

##### Update a component with a security advisory

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

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E246">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E247">

##### Mail domain proguidex.com is blocked

Email addresses at the domain proguidex.com are refused.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-sql-engine"></a>

#### SQL engine

<div class="rn-item" id="CLD-27.0-E002">

##### 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.

<div class="rn-chips">

- importance 5

</div>

</div>

<div class="rn-item" id="CLD-27.0-E013">

##### 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.

<div class="rn-action">

**What to Do**

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

</div>

<div class="rn-chips">

- **action needed**
- importance 4

</div>

[Function BARCODE_QR](https://documentation.invantive.com/Invantive+UniversalSQL/Grammar/SQL+Functions/BARCODE_QR)

</div>

<div class="rn-item" id="CLD-27.0-E045">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E046">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E047">

##### 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.

<div class="rn-chips">

- importance 3

</div>

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

</div>

<div class="rn-item" id="CLD-27.0-E048">

##### 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.

<div class="rn-chips">

- Twinfield
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E049">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E050">

##### 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.

<div class="rn-chips">

- SQL Server
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E051">

##### 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.

<div class="rn-chips">

- Oracle
- MySQL
- SQL Server
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E052">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E053">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E054">

##### 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.

<div class="rn-action">

**What to Do**

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

</div>

<div class="rn-chips">

- **action needed**
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E055">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E056">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E057">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E138">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E139">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E140">

##### 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.

<div class="rn-chips">

- PostgreSQL
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E141">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E142">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E143">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E144">

##### 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.

<div class="rn-action">

**What to Do**

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

</div>

<div class="rn-chips">

- **action needed**
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E145">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E146">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E147">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E148">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E149">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E150">

##### Pivot and group by accept binary columns

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

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E151">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E248">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E249">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E250">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E251">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E252">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E253">

##### The unimplemented ^ operator is removed from the SQL grammar

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

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-scripting"></a>

#### Scripting

<div class="rn-item" id="CLD-27.0-E003">

##### 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.

<div class="rn-chips">

- importance 5

</div>

[Package dbms_parallel](https://documentation.invantive.com/Invantive+UniversalSQL/Packages/dbms_parallel), [Package dbms_atomic](https://documentation.invantive.com/Invantive+UniversalSQL/Packages/dbms_atomic)

</div>

<div class="rn-item" id="CLD-27.0-E014">

##### 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.

<div class="rn-chips">

- importance 4

</div>

[Package dbms_os](https://documentation.invantive.com/Invantive+UniversalSQL/Packages/dbms_os)

</div>

<div class="rn-item" id="CLD-27.0-E058">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E059">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E152">

##### 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.

<div class="rn-action">

**What to Do**

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

</div>

<div class="rn-chips">

- **action needed**
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E153">

##### 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.

<div class="rn-chips">

- MySQL
- Firebird
- ODBC
- importance 2

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-query-tool-user-interface"></a>

#### Query Tool user interface

<div class="rn-item" id="CLD-27.0-E090">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E262">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-platforms-and-drivers"></a>

#### Platforms and drivers

<div class="rn-item" id="CLD-27.0-E004">

##### DeepL driver

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

<div class="rn-chips">

- DeepL
- importance 5

</div>

</div>

<div class="rn-item" id="CLD-27.0-E015">

##### 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.

<div class="rn-chips">

- AFAS Online
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E016">

##### 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.

<div class="rn-chips">

- Inspectlet
- Matomo
- Nextcloud
- Tweede Kamer
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E017">

##### 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.

<div class="rn-chips">

- Pipedrive
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E018">

##### 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.

<div class="rn-action">

**What to Do**

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

</div>

<div class="rn-chips">

- **action needed**
- LinkedIn
- Loket.nl
- Microsoft Dynamics CRM
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E019">

##### 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.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E020">

##### 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.

<div class="rn-chips">

- Invantive Web Service
- Oracle
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E021">

##### 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.

<div class="rn-chips">

- Visma.net
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E060">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E061">

##### Add company and deal attributes to the Brevo driver

The Brevo driver returns the attributes of companies and deals.

<div class="rn-chips">

- Brevo
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E062">

##### 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.

<div class="rn-chips">

- ActiveCampaign
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E063">

##### 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.

<div class="rn-chips">

- Bridge Online
- Dynamics 365 CRM
- Magento
- Mendix
- Nmbrs
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E064">

##### 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.

<div class="rn-chips">

- Crisp
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E065">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E066">

##### 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.

<div class="rn-chips">

- Gripp CRM
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E067">

##### 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.

<div class="rn-chips">

- Magento
- Robaws
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E068">

##### 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.

<div class="rn-chips">

- Twinfield
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E069">

##### 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.

<div class="rn-action">

**What to Do**

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

</div>

<div class="rn-chips">

- **action needed**
- Gripp CRM
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E070">

##### 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.

<div class="rn-chips">

- Magento
- Open Besluitvorming
- Robaws
- Stripo
- Yuki
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E071">

##### 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.

<div class="rn-chips">

- PostgreSQL
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E072">

##### 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.

<div class="rn-chips">

- Yuki
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E073">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E074">

##### 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.

<div class="rn-chips">

- SFTP
- FTP
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E075">

##### 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.

<div class="rn-chips">

- SQL Server
- MySQL
- PostgreSQL
- Oracle
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E076">

##### 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.

<div class="rn-chips">

- Inspectlet
- Tweede Kamer
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E077">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E078">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E079">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E080">

##### 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.

<div class="rn-chips">

- SnelStart
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E081">

##### 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.

<div class="rn-chips">

- SnelStart
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E082">

##### Stripo Email platform

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

<div class="rn-chips">

- Stripo
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E083">

##### 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.

<div class="rn-chips">

- SQL Server
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E084">

##### 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.

<div class="rn-chips">

- Twinfield
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E085">

##### Update Kadaster to the current OpenAPI specification

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

<div class="rn-chips">

- Kadaster
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E086">

##### 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.

<div class="rn-chips">

- Robaws
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E087">

##### 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.

<div class="rn-chips">

- Wikipedia
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E088">

##### 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.

<div class="rn-chips">

- Logius COR
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E089">

##### 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.

<div class="rn-chips">

- Dynamics CRM
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E154">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E155">

##### 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.

<div class="rn-chips">

- ActiveCampaign
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E156">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E157">

##### Add vehicle columns to the RDW driver

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

<div class="rn-chips">

- RDW
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E158">

##### 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.

<div class="rn-chips">

- Chargebee
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E159">

##### 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.

<div class="rn-chips">

- MySQL
- MariaDB
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E160">

##### 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.

<div class="rn-chips">

- Matomo
- Nextcloud
- Pipedrive
- OpenBesluitvorming
- Stripo
- VIES
- DeepL
- Inspectlet
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E161">

##### 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.

<div class="rn-chips">

- Teamleader
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E162">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E163">

##### 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.

<div class="rn-chips">

- Crisp
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E164">

##### Describe Odoo errors that occur often

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

<div class="rn-chips">

- Odoo
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E165">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E166">

##### Exact Online: longer general ledger classification code

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

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E167">

##### 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.

<div class="rn-chips">

- Oracle
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E168">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E169">

##### 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.

<div class="rn-chips">

- ODBC
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E170">

##### 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.

<div class="rn-chips">

- Visma.net
- Teamleader Focus
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E171">

##### Offer LibreOffice as a platform in the Cloud account pages

LibreOffice is added to the list of platforms that can be chosen.

<div class="rn-chips">

- LibreOffice
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E172">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E173">

##### Read tables with composite primary keys from SQL Server

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

<div class="rn-chips">

- SQL Server
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E174">

##### 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.

<div class="rn-chips">

- SQL Server
- MySQL
- PostgreSQL
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E175">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E176">

##### 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.

<div class="rn-chips">

- SQL Server
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E177">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E178">

##### 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.

<div class="rn-chips">

- RDW
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E179">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E180">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E181">

##### 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.

<div class="rn-chips">

- Twinfield
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E182">

##### 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.

<div class="rn-chips">

- ionBIZ
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E183">

##### 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.

<div class="rn-chips">

- Discourse
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E184">

##### 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.

<div class="rn-chips">

- Open Archives
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E185">

##### Update the WMI platform

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

<div class="rn-chips">

- WMI
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E186">

##### 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.

<div class="rn-chips">

- Visma.net Financials
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E254">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E255">

##### 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.

<div class="rn-chips">

- Easyflex
- Brevo
- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E256">

##### Clearer error messages from Odoo

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

<div class="rn-chips">

- Odoo
- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E257">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E258">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E259">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E260">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E261">

##### Update the number of Twinfield tables shown on the product page

The product page of Twinfield states the current number of tables.

<div class="rn-chips">

- Twinfield
- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-export-and-import"></a>

#### Export and import

<div class="rn-item" id="CLD-27.0-E091">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E092">

##### 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.

<div class="rn-chips">

- importance 3

</div>

[Exporting results](https://documentation.invantive.com/Invantive+Query+Tool/Exporting+Results)

</div>

<div class="rn-item" id="CLD-27.0-E093">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E187">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E188">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-performance"></a>

#### Performance

<div class="rn-item" id="CLD-27.0-E005">

##### 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.

<div class="rn-chips">

- 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

</div>

</div>

<div class="rn-item" id="CLD-27.0-E022">

##### 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.

<div class="rn-chips">

- Big Data JSON
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E023">

##### 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.

<div class="rn-chips">

- Exact Online
- Freshdesk
- Freshservice
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E024">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E094">

##### 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.

<div class="rn-chips">

- MySQL
- Oracle
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E095">

##### 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.

<div class="rn-action">

**What to Do**

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

</div>

<div class="rn-chips">

- **action needed**
- Data Cache
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E096">

##### 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.

<div class="rn-chips">

- PostgreSQL
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E097">

##### 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.

<div class="rn-chips">

- AFAS Online
- CBS
- Exact Online
- HubSpot
- Salesforce
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E098">

##### 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.

<div class="rn-chips">

- Exact Online
- In-memory
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- XAF
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E099">

##### 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.

<div class="rn-chips">

- Oracle
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E100">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E189">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E190">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E191">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E192">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E193">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E194">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E195">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E196">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E263">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E264">

##### 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.

<div class="rn-chips">

- Oracle
- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E265">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-logging-and-diagnostics"></a>

#### Logging and diagnostics

<div class="rn-item" id="CLD-27.0-E101">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E197">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E198">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E199">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E200">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E201">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E202">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E203">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E204">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E205">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E206">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E207">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E208">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E209">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E210">

##### Statistics show memory and CPU time per statement

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

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E211">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E266">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E267">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E268">

##### Heartbeat endpoint reports the uptime of the process

The heartbeat answer states the number of seconds since the process started.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E269">

##### Identifiers contain their moment of creation in Cloud

Identifiers of errors and security events created by Cloud are time-ordered (UUID version 7).

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E270">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E271">

##### Monitoring shows an error rate per node

The list of nodes in Cloud monitoring shows the percentage of requests that ended in an error.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E272">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-translations-and-texts"></a>

#### Translations and texts

<div class="rn-item" id="CLD-27.0-E212">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E213">

##### 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.

<div class="rn-chips">

- Crisp
- Gripp
- Odoo
- PostgreSQL
- Tixly
- Twinfield
- importance 2

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-documentation"></a>

#### Documentation

<div class="rn-item" id="CLD-27.0-E102">

##### 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.

<div class="rn-chips">

- Dynamics CRM
- Microsoft Graph
- PayPal
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E214">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E215">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E216">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E217">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E218">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E219">

##### Updated contact details in the privacy policy

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

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E220">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E273">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E274">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-e-other"></a>

#### Other

<div class="rn-item" id="CLD-27.0-E025">

##### 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.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-E103">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E104">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E105">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E106">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-E221">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E222">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E223">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E224">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E225">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E226">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E227">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E228">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E229">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E230">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E231">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E232">

##### Remove online assistance through TeamViewer

Online assistance through TeamViewer is no longer offered.

<div class="rn-chips">

- TeamViewer
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E233">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E234">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E235">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E236">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-E275">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E276">

##### Claude is listed first among the products for a platform

On connector pages the Claude connector is placed before the other products.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E277">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E278">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E279">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E280">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E281">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E282">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E283">

##### Product pages for using Claude through MCP

The Cloud site has pages that explain how to use each platform with Claude through MCP.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E284">

##### Unused monitoring client address setting removed

The setting for the address of the central monitoring client is no longer part of the monitoring settings.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E285">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-E286">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-fixed"></a>

### All Bug Fixes

Defects of the older release that are repaired.

<a id="invantive-cloud-26.0-to-27.0-b-installation-and-platform"></a>

#### Installation and platform

<div class="rn-item" id="CLD-27.0-B040">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B041">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B042">

##### Monitoring loops stop at shutdown

The monitoring loops waited on a token that never cancels. A server now stops them when it shuts down.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B151">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-b-licensing-and-sign-in"></a>

#### Licensing and sign-in

<div class="rn-item" id="CLD-27.0-B002">

##### 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.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-B003">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-B007">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B008">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B009">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B043">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B044">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B045">

##### 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.

<div class="rn-chips">

- Bridge Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B046">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B047">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B048">

##### 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.

<div class="rn-chips">

- Invantive Estate
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B049">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B050">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B051">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B052">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B053">

##### 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.

<div class="rn-chips">

- Invantive Business
- Visma.net
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B054">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B152">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B153">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B154">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B155">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-b-security"></a>

#### Security

<div class="rn-item" id="CLD-27.0-B004">

##### 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.

<div class="rn-chips">

- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-B010">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B011">

##### 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.

<div class="rn-chips">

- Twinfield
- VIES
- Visma Severa
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B055">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B056">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B057">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B058">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B156">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-b-sql-engine"></a>

#### SQL engine

<div class="rn-item" id="CLD-27.0-B001">

##### 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.

<div class="rn-chips">

- importance 5

</div>

</div>

<div class="rn-item" id="CLD-27.0-B005">

##### 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.

<div class="rn-chips">

- Microsoft Access
- SQL Server
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-B012">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B013">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B014">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B015">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B016">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B017">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B018">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B019">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B020">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B021">

##### 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.

<div class="rn-chips">

- In-memory
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B022">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B023">

##### 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.

<div class="rn-chips">

- PostgreSQL
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B059">

##### 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.

<div class="rn-chips">

- SQL Server
- Oracle
- Firebird
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B060">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B061">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B062">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B063">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B064">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B065">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B066">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B067">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B068">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B069">

##### Repair errors of parallel background reads being missed

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

<div class="rn-chips">

- SQL Server
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B070">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B071">

##### Repair wrong column alias after PIVOT

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

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B072">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B073">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B074">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B075">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B076">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B077">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B157">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B158">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B159">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-b-scripting"></a>

#### Scripting

<div class="rn-item" id="CLD-27.0-B078">

##### 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.

<div class="rn-chips">

- In-memory storage
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B079">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B080">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B081">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-b-platforms-and-drivers"></a>

#### Platforms and drivers

<div class="rn-item" id="CLD-27.0-B006">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 4

</div>

</div>

<div class="rn-item" id="CLD-27.0-B024">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B025">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B026">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B027">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B028">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B029">

##### 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.

<div class="rn-chips">

- Oracle
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B030">

##### 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.

<div class="rn-chips">

- Oracle
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B031">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B032">

##### 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.

<div class="rn-chips">

- HubSpot
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B033">

##### 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.

<div class="rn-chips">

- Twinfield
- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B082">

##### 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.

<div class="rn-chips">

- AFAS
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B083">

##### 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.

<div class="rn-chips">

- AFAS Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B084">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B085">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B086">

##### 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.

<div class="rn-chips">

- Dropbox
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B087">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B088">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B089">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B090">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B091">

##### 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.

<div class="rn-chips">

- Rabobank MT940
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B092">

##### 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.

<div class="rn-chips">

- Freshdesk
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B093">

##### Freshdesk: survey identifiers are read as text

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

<div class="rn-chips">

- Freshdesk
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B094">

##### Give Freshservice its own database identifier

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

<div class="rn-chips">

- Freshservice
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B095">

##### 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.

<div class="rn-chips">

- Loket
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B096">

##### 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.

<div class="rn-chips">

- MySQL
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B097">

##### 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.

<div class="rn-chips">

- Oracle
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B098">

##### 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.

<div class="rn-chips">

- PostgreSQL
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B099">

##### 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.

<div class="rn-chips">

- PostgreSQL
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B100">

##### Read XML Audit Files of companies without identifier

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

<div class="rn-chips">

- XAA
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B101">

##### 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.

<div class="rn-chips">

- SnelStart
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B102">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B103">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B104">

##### 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.

<div class="rn-chips">

- Autotask
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B105">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B106">

##### Repair selecting the same partition twice

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

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B107">

##### 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.

<div class="rn-chips">

- Visma.net
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B108">

##### 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.

<div class="rn-chips">

- Nmbrs
- Yuki
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B109">

##### 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.

<div class="rn-chips">

- AccountView
- FoxPro
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B110">

##### 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.

<div class="rn-chips">

- AFAS Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B111">

##### 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.

<div class="rn-chips">

- Teamleader Focus
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B112">

##### 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.

<div class="rn-chips">

- SQL Server
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B113">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B114">

##### 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.

<div class="rn-chips">

- SnelStart
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B115">

##### 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.

<div class="rn-chips">

- SnelStart
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B116">

##### 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.

<div class="rn-chips">

- Visma.net
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B117">

##### Yuki: sessions of different domains no longer race

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

<div class="rn-chips">

- Yuki
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B160">

##### 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.

<div class="rn-chips">

- Bridge Online
- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B161">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B162">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B163">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B164">

##### Spelling error in a PostgreSQL error hint corrected

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

<div class="rn-chips">

- PostgreSQL
- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-b-export-and-import"></a>

#### Export and import

<div class="rn-item" id="CLD-27.0-B034">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B035">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B036">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B118">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B119">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B120">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-b-performance"></a>

#### Performance

<div class="rn-item" id="CLD-27.0-B037">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B121">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B122">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B123">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B124">

##### 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.

<div class="rn-chips">

- Oracle
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B125">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-b-logging-and-diagnostics"></a>

#### Logging and diagnostics

<div class="rn-item" id="CLD-27.0-B038">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B126">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B127">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B128">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B129">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B130">

##### 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.

<div class="rn-chips">

- Exact Online
- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B131">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B132">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B133">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B165">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B166">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B167">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B168">

##### Keep the row count when result set information is copied

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

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B169">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B170">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B171">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-b-translations-and-texts"></a>

#### Translations and texts

<div class="rn-item" id="CLD-27.0-B134">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B135">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-b-other"></a>

#### Other

<div class="rn-item" id="CLD-27.0-B039">

##### 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.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="CLD-27.0-B136">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B137">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B138">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B139">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B140">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B141">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B142">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B143">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B144">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B145">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B146">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B147">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B148">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B149">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B150">

##### 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.

<div class="rn-chips">

- importance 2

</div>

</div>

<div class="rn-item" id="CLD-27.0-B172">

##### Apple icon files load on case-sensitive hosting

Apple icon files had upper-case extensions and are renamed so that their links work.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B173">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B174">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B175">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B176">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B177">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B178">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B179">

##### Recognise .pot files as PowerPoint templates

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

<div class="rn-chips">

- importance 1

</div>

</div>

<div class="rn-item" id="CLD-27.0-B180">

##### 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.

<div class="rn-chips">

- importance 1

</div>

</div>

<a id="invantive-cloud-26.0-to-27.0-builds"></a>

### 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 |  |  |  |

<a id="invantive-cloud-26.0-to-27.0-more"></a>

### More Information

- [Product manual](https://go.invantive.com/doc/invantive-cloud)
- [Product documentation](https://documentation.invantive.com/)
- [Questions and answers on the forum](https://forums.invantive.com/tag/invantive-cloud)
- [Downloads](https://go.invantive.com/download/)
- [All release notes](https://go.invantive.com/releasenotes/)

### How This Note Was Made

<div class="rn-small">

- 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.

</div>

</div>

</div>

</div>

