---
title: "Release notes of Invantive MCP Server"
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-mcp-server
---

# Release notes of Invantive MCP Server

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

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

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

<div class="rn-head">

Release Note - Download

## Invantive MCP Server 27.0, from 26.0

| Build | Date | Description |
|---|---|---|
| `26.0.104` | 09-06-2026 | first build of release 26.0 |
| `27.0.54` | 01-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.

- **250** enhancements
- **147** bug fixes
- **10** things to check before upgrading

</div>

<div class="rn-layout">

<div class="rn-index">

**This Note**

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

**Enhancements**

- [Installation and platform](#invantive-mcp-server-26.0-to-27.0-e-installation-and-platform) 14
- [Licensing and sign-in](#invantive-mcp-server-26.0-to-27.0-e-licensing-and-sign-in) 19
- [Security](#invantive-mcp-server-26.0-to-27.0-e-security) 29
- [SQL engine](#invantive-mcp-server-26.0-to-27.0-e-sql-engine) 35
- [Scripting](#invantive-mcp-server-26.0-to-27.0-e-scripting) 6
- [Platforms and drivers](#invantive-mcp-server-26.0-to-27.0-e-platforms-and-drivers) 66
- [Export and import](#invantive-mcp-server-26.0-to-27.0-e-export-and-import) 4
- [Performance](#invantive-mcp-server-26.0-to-27.0-e-performance) 21
- [Logging and diagnostics](#invantive-mcp-server-26.0-to-27.0-e-logging-and-diagnostics) 23
- [Translations and texts](#invantive-mcp-server-26.0-to-27.0-e-translations-and-texts) 2
- [Documentation](#invantive-mcp-server-26.0-to-27.0-e-documentation) 7
- [Other](#invantive-mcp-server-26.0-to-27.0-e-other) 24

**Bug Fixes**

- [Installation and platform](#invantive-mcp-server-26.0-to-27.0-b-installation-and-platform) 4
- [Licensing and sign-in](#invantive-mcp-server-26.0-to-27.0-b-licensing-and-sign-in) 12
- [Security](#invantive-mcp-server-26.0-to-27.0-b-security) 7
- [SQL engine](#invantive-mcp-server-26.0-to-27.0-b-sql-engine) 36
- [Scripting](#invantive-mcp-server-26.0-to-27.0-b-scripting) 4
- [Platforms and drivers](#invantive-mcp-server-26.0-to-27.0-b-platforms-and-drivers) 50
- [Export and import](#invantive-mcp-server-26.0-to-27.0-b-export-and-import) 6
- [Performance](#invantive-mcp-server-26.0-to-27.0-b-performance) 6
- [Logging and diagnostics](#invantive-mcp-server-26.0-to-27.0-b-logging-and-diagnostics) 13
- [Translations and texts](#invantive-mcp-server-26.0-to-27.0-b-translations-and-texts) 2
- [Other](#invantive-mcp-server-26.0-to-27.0-b-other) 7

</div>

<div class="rn-main">

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

### Before You Upgrade

These changes ask for a check:

- [Settings files move from XML to JSON](#MCP-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](#MCP-27.0-E009)
  - 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](#MCP-27.0-E016)
  - Adjust statements that call the QR code functions with a separate width and height.
- [Integer constants in SQL keep an integer type](#MCP-27.0-E059)
  - 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](#MCP-27.0-E075)
  - 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](#MCP-27.0-E150)
  - 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](#MCP-27.0-E142)
  - 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](#MCP-27.0-E021)
  - 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](#MCP-27.0-E014)
  - 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](#MCP-27.0-E095)
  - Remove the three garbage-collection settings of the Data Cache driver from settings files.

</div>

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

### Top 25 Changes

<div class="rn-top">

1. [Settings files move from XML to JSON](#MCP-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](#MCP-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. [New Invantive MCP Server lets AI tools read data of an Invantive Cloud database](#MCP-27.0-E006)
   - *Enhancement*
   - Invantive MCP Server is a new server that connects AI tools such as Claude to a database in Invantive Cloud through the Model Context Protocol. Callers sign in through OAuth. The AI tool can list the entities it may read and read their records, and a third tool returns the signed-in user. The server only reads data.
4. [Joins return the correct rows](#MCP-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.
5. [Correlated subqueries are supported](#MCP-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.
6. [DeepL driver](#MCP-27.0-E004)
   - *Enhancement*
   - A new driver reads and writes DeepL: languages, billing, translation, writing assistance, documents, glossaries, style rules and translation memories.
7. [Parts of a PSQL block can run in parallel](#MCP-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.
8. [Exact Online companies outside the service area are no longer accepted](#MCP-27.0-E009)
   - *Enhancement*
   - **action needed**
   - Action needed before or after the upgrade.
9. [Loading of provider assemblies from a settings file is blocked](#MCP-27.0-E014)
   - *Enhancement*
   - **action needed**
   - Action needed before or after the upgrade.
10. [Remove the LinkedIn and Loket.nl SOAP drivers and the Dynamics CRM table list](#MCP-27.0-E021)
    - *Enhancement*
    - **action needed**
    - Action needed before or after the upgrade.
11. [QR code functions take one size value instead of width and height](#MCP-27.0-E016)
    - *Enhancement*
    - **action needed**
    - Action needed before or after the upgrade.
12. [Data is loaded in the background while a session is idle](#MCP-27.0-E026)
    - *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](#MCP-27.0-E019)
    - *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](#MCP-27.0-E010)
    - *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](#MCP-27.0-E025)
    - *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](#MCP-27.0-E024)
    - *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](#MCP-27.0-E027)
    - *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](#MCP-27.0-E022)
    - *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. [Data containers and credentials from Invantive Credentials Server](#MCP-27.0-E008)
    - *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.
20. [IP address validation configurable with allow lists, deny lists and ranges](#MCP-27.0-E013)
    - *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.
21. [Proxy and load balancer set-up through a ForwardedHeaders section](#MCP-27.0-E007)
    - *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.
22. [Filters no longer lose rows or evaluate wrongly](#MCP-27.0-B003)
    - *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.
23. [Exact Online incremental data is no longer damaged or overwritten](#MCP-27.0-B004)
    - *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.
24. [AI tools can select, filter and sort the records they read; platforms can be restricted](#MCP-27.0-E028)
    - *Enhancement*
    - The tool that reads records accepts a field selection, a filter, a sort order and a maximum number of rows, written as OData version 4 expressions. Administrators can limit which platforms are visible with allow and deny lists and set how long the generated entity model is cached.
25. [Error answers follow the Accept header](#MCP-27.0-E029)
    - *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.

</div>

<a id="invantive-mcp-server-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-mcp-server#invantive-mcp-server-26.0-to-27.0-new) | [2 and higher](/en/release-notes/products?product=invantive-mcp-server&importance=2#invantive-mcp-server-26.0-to-27.0-new) | [3 and higher](/en/release-notes/products?product=invantive-mcp-server&importance=3#invantive-mcp-server-26.0-to-27.0-new) | [4 and higher](/en/release-notes/products?product=invantive-mcp-server&importance=4#invantive-mcp-server-26.0-to-27.0-new) | [5](/en/release-notes/products?product=invantive-mcp-server&importance=5#invantive-mcp-server-26.0-to-27.0-new)

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

</div>

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

#### Installation and platform

<div class="rn-item" id="MCP-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="MCP-27.0-E007">

##### 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="MCP-27.0-E031">

##### 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="MCP-27.0-E032">

##### 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="MCP-27.0-E033">

##### 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="MCP-27.0-E110">

##### 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="MCP-27.0-E111">

##### 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="MCP-27.0-E112">

##### 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="MCP-27.0-E113">

##### Server stops within the grace period of a container stop

The server now finishes within about six seconds after a stop signal, so that a container stop with a ten-second grace period no longer ends in a forced kill during clean-up. Background logging steps stop together with the request they belong to.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E115">

##### 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="MCP-27.0-E219">

##### Command line option -agent is accepted

The server accepts the command line option -agent, which tells that an AI agent starts it, without the web framework taking it as a setting.

<div class="rn-chips">

- importance 1

</div>

</div>

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

##### 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="MCP-27.0-E221">

##### 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-mcp-server-26.0-to-27.0-e-licensing-and-sign-in"></a>

#### Licensing and sign-in

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

##### 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="MCP-27.0-E009">

##### 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="MCP-27.0-E010">

##### 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="MCP-27.0-E011">

##### Server publishes OAuth sign-in metadata so AI tools can find the identity provider

AI tools such as Claude find out how to sign in through a metadata document at the well-known OAuth protected-resource location. The document names the resource and the identity provider. A new setting lists the web origins that may call the server from a browser.

<div class="rn-chips">

- importance 4

</div>

</div>

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

##### Sign-in through Invantive Connect next to AWS Cognito

The server accepts tokens of Invantive Connect, the new authorisation server of Invantive, and names it in the document that tells clients where to sign in. A token is only valid for the database address it was issued for. AWS Cognito stays accepted by default, and can be switched off so that its settings are no longer needed.

<div class="rn-chips">

- importance 4

</div>

</div>

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

##### A database must be allowed for MCP in Invantive Cloud before an AI tool can use it

A database can only be used through the MCP Server when it has been allowed for MCP in Invantive Cloud. Otherwise the server refuses the request. The message names the database and asks the user to configure it in Invantive Cloud.

<div class="rn-chips">

- importance 3

</div>

</div>

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

##### 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="MCP-27.0-E036">

##### 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="MCP-27.0-E037">

##### 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="MCP-27.0-E038">

##### 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="MCP-27.0-E039">

##### 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="MCP-27.0-E116">

##### Clear error when the Cloud API does not know the application client of the server

When Invantive Cloud API refuses the application client of the MCP Server, users now see a message that names the client ID and says that it must be added to the Cloud API settings. Before, they were sent off to sign in again, which could not help.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E118">

##### 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="MCP-27.0-E119">

##### 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="MCP-27.0-E120">

##### Show first login, last login and login count per product on user pages

User and profile pages show the first login, last login and number of logins for Apps Online, MCP, UniversalSQL Server, Query Tool and GMR. Dates are shown without fractions of seconds.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E223">

##### 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="MCP-27.0-E224">

##### 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-mcp-server-26.0-to-27.0-e-security"></a>

#### Security

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

##### 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="MCP-27.0-E014">

##### 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="MCP-27.0-E015">

##### 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="MCP-27.0-E040">

##### 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="MCP-27.0-E041">

##### 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="MCP-27.0-E042">

##### 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="MCP-27.0-E043">

##### 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="MCP-27.0-E044">

##### 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="MCP-27.0-E045">

##### 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="MCP-27.0-E046">

##### 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="MCP-27.0-E047">

##### Requests from outside the service area are refused, with the United States accepted

The server now checks the country of the client address and refuses requests from outside the service area with HTTP status 451. The United States is accepted, because the AI platforms that call the server run there. Only a refusal on country alone is overridden; TOR, VPN and deny lists still refuse.

<div class="rn-chips">

- importance 3

</div>

</div>

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

##### 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="MCP-27.0-E049">

##### Sign-in tokens issued for another application of the identity provider are refused

The server checks that a sign-in token was issued for its own application at the identity provider. A token that is valid for the same user pool but was issued for a different application is no longer accepted.

<div class="rn-chips">

- importance 3

</div>

</div>

<div class="rn-item" id="MCP-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="MCP-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="MCP-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="MCP-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="MCP-27.0-E125">

##### 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="MCP-27.0-E126">

##### 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="MCP-27.0-E127">

##### Failed sign-ins are counted per user name as well as per address

Failed authentications are now aggregated per user name across Invantive products, in addition to the count per IP address.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E129">

##### 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="MCP-27.0-E130">

##### 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="MCP-27.0-E131">

##### 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="MCP-27.0-E132">

##### 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="MCP-27.0-E133">

##### 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="MCP-27.0-E134">

##### 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="MCP-27.0-E135">

##### 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="MCP-27.0-E225">

##### 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-mcp-server-26.0-to-27.0-e-sql-engine"></a>

#### SQL engine

<div class="rn-item" id="MCP-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="MCP-27.0-E016">

##### 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="MCP-27.0-E050">

##### 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="MCP-27.0-E051">

##### 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="MCP-27.0-E052">

##### 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="MCP-27.0-E053">

##### 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="MCP-27.0-E054">

##### 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="MCP-27.0-E055">

##### 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="MCP-27.0-E056">

##### 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="MCP-27.0-E057">

##### 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="MCP-27.0-E058">

##### 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="MCP-27.0-E059">

##### 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="MCP-27.0-E060">

##### 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="MCP-27.0-E061">

##### 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="MCP-27.0-E062">

##### 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="MCP-27.0-E136">

##### 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="MCP-27.0-E137">

##### 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="MCP-27.0-E138">

##### 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="MCP-27.0-E139">

##### 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="MCP-27.0-E140">

##### 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="MCP-27.0-E141">

##### 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="MCP-27.0-E142">

##### 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="MCP-27.0-E143">

##### 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="MCP-27.0-E144">

##### 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="MCP-27.0-E145">

##### 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="MCP-27.0-E146">

##### 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="MCP-27.0-E147">

##### 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="MCP-27.0-E148">

##### 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="MCP-27.0-E149">

##### 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="MCP-27.0-E226">

##### 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="MCP-27.0-E227">

##### 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="MCP-27.0-E228">

##### 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="MCP-27.0-E229">

##### 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="MCP-27.0-E230">

##### 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="MCP-27.0-E231">

##### 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-mcp-server-26.0-to-27.0-e-scripting"></a>

#### Scripting

<div class="rn-item" id="MCP-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="MCP-27.0-E017">

##### 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="MCP-27.0-E063">

##### 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="MCP-27.0-E064">

##### 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="MCP-27.0-E150">

##### 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="MCP-27.0-E151">

##### 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-mcp-server-26.0-to-27.0-e-platforms-and-drivers"></a>

#### Platforms and drivers

<div class="rn-item" id="MCP-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="MCP-27.0-E018">

##### 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="MCP-27.0-E019">

##### 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="MCP-27.0-E020">

##### 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="MCP-27.0-E021">

##### 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="MCP-27.0-E022">

##### 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="MCP-27.0-E023">

##### 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="MCP-27.0-E024">

##### 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="MCP-27.0-E065">

##### 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="MCP-27.0-E066">

##### 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="MCP-27.0-E067">

##### Administrators can set extra provider attributes per platform in the configuration

A new Databases section in the configuration lets an administrator give additional connection attributes to a platform after the log-on of a database. A repair prevents an error when a platform has no additional attributes configured.

<div class="rn-chips">

- importance 3

</div>

</div>

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

##### 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="MCP-27.0-E069">

##### 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="MCP-27.0-E070">

##### 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="MCP-27.0-E071">

##### 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="MCP-27.0-E072">

##### 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="MCP-27.0-E073">

##### 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="MCP-27.0-E074">

##### 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="MCP-27.0-E075">

##### 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="MCP-27.0-E076">

##### 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="MCP-27.0-E077">

##### 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="MCP-27.0-E078">

##### 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="MCP-27.0-E079">

##### 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="MCP-27.0-E080">

##### 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="MCP-27.0-E081">

##### 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="MCP-27.0-E082">

##### 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="MCP-27.0-E083">

##### 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="MCP-27.0-E084">

##### 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="MCP-27.0-E085">

##### 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="MCP-27.0-E086">

##### 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="MCP-27.0-E087">

##### 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="MCP-27.0-E088">

##### 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="MCP-27.0-E089">

##### 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="MCP-27.0-E090">

##### 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="MCP-27.0-E091">

##### 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="MCP-27.0-E152">

##### 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="MCP-27.0-E153">

##### 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="MCP-27.0-E154">

##### 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="MCP-27.0-E155">

##### 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="MCP-27.0-E156">

##### 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="MCP-27.0-E157">

##### 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="MCP-27.0-E158">

##### 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="MCP-27.0-E159">

##### 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="MCP-27.0-E160">

##### 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="MCP-27.0-E161">

##### 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="MCP-27.0-E162">

##### 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="MCP-27.0-E163">

##### 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="MCP-27.0-E164">

##### 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="MCP-27.0-E165">

##### 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="MCP-27.0-E166">

##### 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="MCP-27.0-E167">

##### 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="MCP-27.0-E168">

##### 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="MCP-27.0-E169">

##### 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="MCP-27.0-E170">

##### 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="MCP-27.0-E171">

##### 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="MCP-27.0-E172">

##### 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="MCP-27.0-E173">

##### 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="MCP-27.0-E174">

##### 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="MCP-27.0-E175">

##### 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="MCP-27.0-E176">

##### 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="MCP-27.0-E177">

##### 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="MCP-27.0-E178">

##### 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="MCP-27.0-E232">

##### 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="MCP-27.0-E233">

##### 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="MCP-27.0-E234">

##### 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="MCP-27.0-E235">

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

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

#### Export and import

<div class="rn-item" id="MCP-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="MCP-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="MCP-27.0-E179">

##### 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="MCP-27.0-E180">

##### 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-mcp-server-26.0-to-27.0-e-performance"></a>

#### Performance

<div class="rn-item" id="MCP-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="MCP-27.0-E025">

##### 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="MCP-27.0-E026">

##### 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="MCP-27.0-E027">

##### 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="MCP-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="MCP-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="MCP-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="MCP-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="MCP-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="MCP-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="MCP-27.0-E100">

##### Tables of the Exact Online XML API left out of the model offered to AI clients

The model that the server builds per database no longer holds the tables of the Exact Online XML API, except balances, matching and outstanding items that have no equivalent in the REST API. The model of one Exact Online database was about 93 MB of JSON and exhausted the memory of the server.

<div class="rn-chips">

- Exact Online
- importance 3

</div>

</div>

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

##### 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="MCP-27.0-E181">

##### 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="MCP-27.0-E182">

##### 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="MCP-27.0-E183">

##### Faster first requests after a start

The server now counts calls from the first one for runtime optimisation, so that the first requests after a start run on optimised code sooner instead of after seconds on unoptimised code.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E185">

##### Pre-emptive loading follows the setting of the database

The server starts pre-emptive loading of data for a session only when the owner of the database has switched it on. A session can still override it with a set statement.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E187">

##### 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="MCP-27.0-E188">

##### 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="MCP-27.0-E236">

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

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

#### Logging and diagnostics

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

##### 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="MCP-27.0-E189">

##### Client disconnects are no longer reported as errors

A caller that closes the connection, also while an answer is being written, is now traced as such and no longer as an internal error with a stack trace or a support ticket. On a staging node this removed about 55,000 error entries a day.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E191">

##### 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="MCP-27.0-E192">

##### 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="MCP-27.0-E193">

##### Error responses carry more diagnostic details

The details of an error response now include the request URL, the user agent of the caller, the request identifier, the billing identifiers, the module name and version and the pool identity. The request identifier replaces the earlier trace identifier.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E195">

##### 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="MCP-27.0-E196">

##### 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="MCP-27.0-E197">

##### 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="MCP-27.0-E198">

##### 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="MCP-27.0-E199">

##### 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="MCP-27.0-E200">

##### Start-up failures are reported with a message code and the standard failing exit code

When the server cannot start, it writes a message code and the error to the console and ends with the standard exit code for an unhandled exception. The application version is known earlier in the start-up.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### Start-up problems are explained on the console

When the server cannot start, the console shows the time and exit code and, for a missing or incompatible assembly, an explanation of the likely cause. The application title is printed at start, and output of the framework logging is written to the trace.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E203">

##### Trace identifiers of the calling AI tool are kept with log messages and error details

When the calling AI tool sends a trace parent header, the server records it as inbound correlation identifier. The identifier is part of the details of an error response.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E237">

##### 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="MCP-27.0-E238">

##### 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="MCP-27.0-E239">

##### 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="MCP-27.0-E240">

##### IWID of the signed-in user is attached to the session and to logged messages

The identity of the visitor (IWID) is read from the cookie and replaced by the identity of the signed-in user once known, so that log messages and sessions can be linked to the same person.

<div class="rn-chips">

- importance 1

</div>

</div>

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

##### Log messages have an explicit level and more events are logged

Trace messages carry a logging level, so that monitoring tools can filter them. Accepted-for-processing responses (HTTP 202) and the lookup of the database segment of a request are logged. The repeated waits of throttled calls are counted in the log.

<div class="rn-chips">

- importance 1

</div>

</div>

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

##### Tool error results include the request URL

The error result of a tool now names the URL of the incoming request.

<div class="rn-chips">

- importance 1

</div>

</div>

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

#### Translations and texts

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

##### 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="MCP-27.0-E206">

##### 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-mcp-server-26.0-to-27.0-e-documentation"></a>

#### Documentation

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

##### 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="MCP-27.0-E207">

##### Documented configuration settings and hints on configuration errors

Every setting of the server now has a description, an example and a default in the sample configuration. Errors about missing or invalid settings point to the documentation of the setting concerned.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-E209">

##### 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="MCP-27.0-E210">

##### 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="MCP-27.0-E243">

##### 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="MCP-27.0-E244">

##### 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-mcp-server-26.0-to-27.0-e-other"></a>

#### Other

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

##### New Invantive MCP Server lets AI tools read data of an Invantive Cloud database

Invantive MCP Server is a new server that connects AI tools such as Claude to a database in Invantive Cloud through the Model Context Protocol. Callers sign in through OAuth. The AI tool can list the entities it may read and read their records, and a third tool returns the signed-in user. The server only reads data.

<div class="rn-chips">

- importance 5

</div>

</div>

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

##### AI tools can select, filter and sort the records they read; platforms can be restricted

The tool that reads records accepts a field selection, a filter, a sort order and a maximum number of rows, written as OData version 4 expressions. Administrators can limit which platforms are visible with allow and deny lists and set how long the generated entity model is cached.

<div class="rn-chips">

- importance 4

</div>

</div>

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

##### 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="MCP-27.0-E030">

##### Shorter list from describe_entities; new tool describe_entity for one entity

An AI client now gets a compact list of entities and asks for one entity at a time to see its fields, keys, partitioning and speed figures. The same size limit therefore lists about twice as many entities. The answer for one entity is bounded by a new setting, MaxDescribeEntityResponseChars.

<div class="rn-chips">

- importance 4

</div>

</div>

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

##### Entity overview for AI tools is limited in size and gives descriptions and partitions

The overview of readable entities has a size limit so that it fits in the context of an AI tool. Administrators can set the maximum size of the answer, the maximum length of an entity description and the maximum number of partitions listed. When the answer is cut, the AI tool is told how to ask a narrower question.

<div class="rn-chips">

- importance 3

</div>

</div>

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

##### Error page and error answers follow the Accept header and the real HTTP status

A path that the server does not have is answered as 404 and no longer as a system error. Clients that do not ask for HTML get a JSON error answer; browsers get the error page, which now holds the error reference and trace parent to copy to the forum. The HTTP status of an error follows the exception, and 500 is used for internal errors only.

<div class="rn-chips">

- importance 3

</div>

</div>

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

##### 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="MCP-27.0-E107">

##### Server instructions for AI clients with database addresses, platforms and rate limits

When a client connects, the server sends instructions that name the real addresses of the database for MCP, SQL Server protocol, Bridge Online and App Online. They state which of these the user has activated, name the platforms that can be queried, the server version and where rate limits can be read.

<div class="rn-chips">

- importance 3

</div>

</div>

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

##### Tool errors tell the AI client what is wrong and what to do next

An invalid read request, such as an unknown field or a quoted number, is refused with a message and a hint that the client can act on, instead of an internal error. Every tool error carries a message code, a hint and, where known, the advice whether and when to try again. The message code follows the kind of failure, for example out of memory, and no longer the catch-all code of the tool.

<div class="rn-chips">

- importance 3

</div>

</div>

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

##### Tools show titles and read-only hints, return structured answers and describe their input

Each tool now has a readable title and is marked as read-only. Answers are returned as structured content with a declared schema. The tool descriptions were rewritten to match what the tools do, and an unused paging argument was removed. The sign-in metadata document is built and checked more strictly.

<div class="rn-chips">

- importance 3

</div>

</div>

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

##### 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="MCP-27.0-E212">

##### 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="MCP-27.0-E213">

##### 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="MCP-27.0-E214">

##### 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="MCP-27.0-E215">

##### 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="MCP-27.0-E216">

##### 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="MCP-27.0-E217">

##### Sessions end after an idle period and the data volume of requests is registered

The server keeps state per session and ends a session after 30 minutes of inactivity by default. A setting changes that period. The data volume of requests and of record reads is registered in the request statistics.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### Website analytics moved to Matomo Tag Manager; Crisp, Jimo and devtodev removed

The web pages of the server load Matomo Tag Manager from a configurable server, with a separate container for visitors who are recognised and for those who are not. Tracking by Friendly, Crisp, Jimo and devtodev is removed, and their settings no longer exist. Administrators must set the Matomo settings and remove the old ones.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### Apple app site association served as JSON; empty robots and security files handled

The file apple-app-site-association is now served with the content type JSON that Apple requires, also under the well-known path. The robots and security text files no longer fail when their content is empty.

<div class="rn-chips">

- importance 1

</div>

</div>

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

##### Home page and security.txt use invantive.eu addresses; Chamber of Commerce link fixed

Links on the home page and the policy line in security.txt point to invantive.eu. The Chamber of Commerce link goes to the company registration, and the footer no longer carries schema.org markup.

<div class="rn-chips">

- importance 1

</div>

</div>

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

##### 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="MCP-27.0-E248">

##### Start fails with a clear message when the default language is not a supported language

The server now checks at start that the default language is one of the supported languages and refuses to start with a message when it is not.

<div class="rn-chips">

- importance 1

</div>

</div>

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

##### Start page and icons show the Invantive MCP Server logo

The start page and the browser icons use the Invantive MCP Server logo instead of the logo of the product the server was derived from. A script that hid a notice about missing JavaScript was removed.

<div class="rn-chips">

- importance 1

</div>

</div>

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

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

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

### All Bug Fixes

Defects of the older release that are repaired.

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

#### Installation and platform

<div class="rn-item" id="MCP-27.0-B035">

##### 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="MCP-27.0-B036">

##### 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="MCP-27.0-B037">

##### 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="MCP-27.0-B126">

##### 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-mcp-server-26.0-to-27.0-b-licensing-and-sign-in"></a>

#### Licensing and sign-in

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

##### 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="MCP-27.0-B005">

##### 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="MCP-27.0-B006">

##### 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="MCP-27.0-B038">

##### 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="MCP-27.0-B039">

##### 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="MCP-27.0-B040">

##### 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="MCP-27.0-B041">

##### 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="MCP-27.0-B042">

##### 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="MCP-27.0-B043">

##### 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="MCP-27.0-B044">

##### 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="MCP-27.0-B127">

##### 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="MCP-27.0-B128">

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

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

#### Security

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

##### 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="MCP-27.0-B045">

##### GET on the MCP address answered and logged as 405

A GET request to the MCP address, for example from a connector with a wrong URL or a scanner, is now answered and logged as 405 Method Not Allowed. Before, it was re-run through the error page, ended as a 500 and cost a page render.

<div class="rn-chips">

- importance 2

</div>

</div>

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

##### 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="MCP-27.0-B047">

##### 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="MCP-27.0-B048">

##### 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="MCP-27.0-B129">

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

<div class="rn-item" id="MCP-27.0-B130">

##### security.txt lists the phone number only when a phone number is configured

The security.txt file tested the e-mail address instead of the phone number before writing the telephone contact line, so the line could be written empty or be missing.

<div class="rn-chips">

- importance 1

</div>

</div>

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

#### SQL engine

<div class="rn-item" id="MCP-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="MCP-27.0-B003">

##### 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="MCP-27.0-B008">

##### 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="MCP-27.0-B009">

##### 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="MCP-27.0-B010">

##### 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="MCP-27.0-B011">

##### 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="MCP-27.0-B012">

##### 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="MCP-27.0-B013">

##### 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="MCP-27.0-B014">

##### 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="MCP-27.0-B015">

##### 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="MCP-27.0-B016">

##### 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="MCP-27.0-B017">

##### 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="MCP-27.0-B018">

##### 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="MCP-27.0-B019">

##### 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="MCP-27.0-B049">

##### 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="MCP-27.0-B050">

##### 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="MCP-27.0-B051">

##### 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="MCP-27.0-B052">

##### 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="MCP-27.0-B053">

##### 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="MCP-27.0-B054">

##### 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="MCP-27.0-B055">

##### 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="MCP-27.0-B056">

##### 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="MCP-27.0-B057">

##### 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="MCP-27.0-B058">

##### 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="MCP-27.0-B059">

##### 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="MCP-27.0-B060">

##### 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="MCP-27.0-B061">

##### 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="MCP-27.0-B062">

##### 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="MCP-27.0-B063">

##### 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="MCP-27.0-B064">

##### 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="MCP-27.0-B065">

##### 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="MCP-27.0-B066">

##### 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="MCP-27.0-B067">

##### 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="MCP-27.0-B131">

##### 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="MCP-27.0-B132">

##### 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="MCP-27.0-B133">

##### 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-mcp-server-26.0-to-27.0-b-scripting"></a>

#### Scripting

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

##### 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="MCP-27.0-B069">

##### 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="MCP-27.0-B070">

##### 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="MCP-27.0-B071">

##### 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-mcp-server-26.0-to-27.0-b-platforms-and-drivers"></a>

#### Platforms and drivers

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

##### 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="MCP-27.0-B020">

##### 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="MCP-27.0-B021">

##### 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="MCP-27.0-B022">

##### 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="MCP-27.0-B023">

##### 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="MCP-27.0-B024">

##### 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="MCP-27.0-B025">

##### 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="MCP-27.0-B026">

##### 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="MCP-27.0-B027">

##### 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="MCP-27.0-B028">

##### 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="MCP-27.0-B029">

##### 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="MCP-27.0-B072">

##### 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="MCP-27.0-B073">

##### 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="MCP-27.0-B074">

##### 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="MCP-27.0-B075">

##### 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="MCP-27.0-B076">

##### 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="MCP-27.0-B077">

##### 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="MCP-27.0-B078">

##### 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="MCP-27.0-B079">

##### 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="MCP-27.0-B080">

##### 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="MCP-27.0-B081">

##### 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="MCP-27.0-B082">

##### 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="MCP-27.0-B083">

##### 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="MCP-27.0-B084">

##### 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="MCP-27.0-B085">

##### 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="MCP-27.0-B086">

##### 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="MCP-27.0-B087">

##### 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="MCP-27.0-B088">

##### 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="MCP-27.0-B089">

##### 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="MCP-27.0-B090">

##### 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="MCP-27.0-B091">

##### 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="MCP-27.0-B092">

##### 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="MCP-27.0-B093">

##### 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="MCP-27.0-B094">

##### 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="MCP-27.0-B095">

##### 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="MCP-27.0-B096">

##### 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="MCP-27.0-B097">

##### 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="MCP-27.0-B098">

##### 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="MCP-27.0-B099">

##### 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="MCP-27.0-B100">

##### 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="MCP-27.0-B101">

##### 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="MCP-27.0-B102">

##### 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="MCP-27.0-B103">

##### 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="MCP-27.0-B104">

##### 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="MCP-27.0-B105">

##### 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="MCP-27.0-B134">

##### 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="MCP-27.0-B135">

##### 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="MCP-27.0-B136">

##### 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="MCP-27.0-B137">

##### 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="MCP-27.0-B138">

##### 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-mcp-server-26.0-to-27.0-b-export-and-import"></a>

#### Export and import

<div class="rn-item" id="MCP-27.0-B030">

##### 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="MCP-27.0-B031">

##### 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="MCP-27.0-B032">

##### 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="MCP-27.0-B106">

##### 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="MCP-27.0-B107">

##### 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="MCP-27.0-B108">

##### 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-mcp-server-26.0-to-27.0-b-performance"></a>

#### Performance

<div class="rn-item" id="MCP-27.0-B033">

##### 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="MCP-27.0-B109">

##### 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="MCP-27.0-B110">

##### 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="MCP-27.0-B111">

##### 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="MCP-27.0-B112">

##### 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="MCP-27.0-B113">

##### 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-mcp-server-26.0-to-27.0-b-logging-and-diagnostics"></a>

#### Logging and diagnostics

<div class="rn-item" id="MCP-27.0-B034">

##### 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="MCP-27.0-B114">

##### 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="MCP-27.0-B115">

##### 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="MCP-27.0-B116">

##### 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="MCP-27.0-B117">

##### 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="MCP-27.0-B118">

##### 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="MCP-27.0-B139">

##### 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="MCP-27.0-B140">

##### 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="MCP-27.0-B141">

##### 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="MCP-27.0-B142">

##### 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="MCP-27.0-B143">

##### 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="MCP-27.0-B144">

##### 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="MCP-27.0-B145">

##### 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-mcp-server-26.0-to-27.0-b-translations-and-texts"></a>

#### Translations and texts

<div class="rn-item" id="MCP-27.0-B119">

##### 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="MCP-27.0-B120">

##### 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-mcp-server-26.0-to-27.0-b-other"></a>

#### Other

<div class="rn-item" id="MCP-27.0-B121">

##### 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="MCP-27.0-B122">

##### 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="MCP-27.0-B123">

##### 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="MCP-27.0-B124">

##### 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="MCP-27.0-B125">

##### 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="MCP-27.0-B146">

##### 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="MCP-27.0-B147">

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

<a id="invantive-mcp-server-26.0-to-27.0-builds"></a>

### What It Builds On

| Kind | Name | From | To |
|---|---|---|---|
| invantive component | Invantive MCP Server | 26.0.104 | 27.0.54 |
| 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-mcp-server-26.0-to-27.0-more"></a>

### More Information

- [Product manual](https://go.invantive.com/doc/invantive-mcp-server)
- [Product documentation](https://documentation.invantive.com/)
- [Questions and answers on the forum](https://forums.invantive.com/tag/invantive-mcp-server)
- [Downloads](https://go.invantive.com/download/)
- [All release notes](https://go.invantive.com/releasenotes/)

### How This Note Was Made

<div class="rn-small">

- 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.
- 1159 links between a change and a source commit are recorded.
- 82 exclusions are recorded in the audit of the note.

</div>

</div>

</div>

</div>

