Versionshinweise zu Invantive Data Access Point, 25.0 bis 26.0
Anmerkungen zu dieser Version - Gehostet
Invantive Data Access Point 26.0, aus 25.0
| Build | Datum | Beschreibung |
|---|---|---|
25. |
08-10-2025 | last build of release 25.0 |
26. |
09-11-2026 | last build of release 26.0 |
The 26.0 line also contains the builds 25.1.x of the preceding beta period (2025-09-01 to 2026-03).
- 93 Verbesserungen
- 58 Fehlerbehebungen
- 3 Was Sie vor dem Upgrade überprüfen sollten
Dieser Hinweis
- Bevor Sie ein Upgrade durchführen
- Die 25 wichtigsten Änderungen
- Alle Verbesserungen 2
- Alle Fehlerbehebungen 2
- Worauf es aufbaut
- Weitere Informationen
Verbesserungen
Fehlerbehebungen
Bevor Sie ein Upgrade durchführen
Diese Änderungen erfordern eine Überprüfung:
- Saved credentials are stored in a new file that is the same on every system
- Check that saved credentials work after the first start; enter them again where a connection asks for them.
- Resolve whole numbers in SQL as integers instead of decimals
- Check expressions that rely on whole numbers being decimal; the data type of the result can differ.
- Take one size value in the QR code functions
- Adjust statements that call the QR code functions with a separate width and height.
Die 25 wichtigsten Änderungen
- Licence keys are validated by the Invantive License Service
- Verbesserung
- Licences are validated and renewed through the central Invantive License Service instead of the CryptoLicensing method of release 25.0. The licence window and the status text show the licence number, contract code and origin, and the service decides which platform modules a licence includes. A key of the old format gets a message that explains how to continue. A valid licence stays in force for up to 24 hours when the service cannot be reached.
- Parts of a PSQL block can run in parallel
- Verbesserung
- PSQL gets a PARALLEL construct that runs branches and loop iterations side by side. Failures of branches are collected and can be read afterwards. The new package dbms_atomic holds named values that parallel branches share safely.
- Left join without the word OUTER is no longer turned into an inner join
- Fehlerbehebung
- A statement written as left join, right join or full join, without the word outer, was executed as an inner join. Rows without a match on the other side were lost without any warning.
- Saved credentials are stored in a new file that is the same on every system
- Verbesserung
- erforderliche Maßnahme
- Action needed before or after the upgrade.
- Data containers can be defined on Invantive Credentials Server
- Verbesserung
- Connection details, licence checks and OAuth credentials are retrieved from Invantive Credentials Server instead of a local settings file. The connection list shows the server and database, log-on no longer asks for an alias for these data containers, a retrieval is repeated up to three times after a time-out, and the messages are clearer.
- Visma.net: new API generation, Visma Connect log-on, sales orders and time cards
- Verbesserung
- The Visma.net driver uses the current API specification, signs on through Visma Connect and respects the limit of 15,000 calls per hour by waiting when it is used up. It adds tables for Sales Order V3 and for time cards, including filtering, paging, insert and update. A filter such as not equal on a column with a fixed list of values is turned into requests for the remaining values.
- Add configuration for IP address validation: allow lists, deny lists and ranges
- Verbesserung
- Administrators can configure IP addresses and IPv6 ranges that are always allowed or always refused. Default lists can be left out and the check against Customer Service can be switched off. Configured addresses are checked first, before any lookup.
- Return more fields in API error responses; the natural key field is renamed to NaturalKey
- Verbesserung
- The JSON error answer of the API now also contains the time of the error, the URL, the IP address and port of the caller, the user agent, the module and action, the party and up to five message parameters. The natural key is returned as NaturalKey instead of NK, which callers that read the old name must adapt.
- Configure handling of reverse proxy headers and keep the forwarded prefix
- Verbesserung
- Handling of forwarded headers of a reverse proxy is configured in a configuration section: switch, headers, forward limit, known proxies and allowed hosts. Without enabling it the headers are not applied. The X-Forwarded-Prefix header is read separately and is not applied to the whole host.
- Exact Online incremental tables are no longer reloaded in full without need
- Fehlerbehebung
- Incremental tables could be reloaded in full when the row count check gave a false alarm, when a rejected earlier version was not rewritten and when old deletions held the starting point back. These causes are repaired. The disk cache setting of the execution no longer switches off the incremental cache.
- Require .NET 10 and drop .NET 8 and .NET 9 support in the web library
- Verbesserung
- The shared web library now targets .NET 10 only and lists .NET 10 or higher as software requirement. Servers that use it need the .NET 10 runtime. Libraries it depends on, such as ASP.NET Core and the Elastic APM agent, were upgraded.
- A script can query its own execution profile
- Verbesserung
- Runs of Invantive Script, their statements, started operating system commands and script variables are registered and can be queried with plain SQL through the new data container Script and the data dictionary. Duration, CPU use, rows touched, exit codes and output volume are available. Statement text can be anonymised and variable values masked.
- Accept the United States for the Invantive MCP Server
- Verbesserung
- The MCP Server now accepts requests from the United States, where the calling AI platforms run, even when other requests from that country are refused. A refusal for another reason stays.
- Case expression uses the widest data type of all branches
- Fehlerbehebung
- A case expression took the data type of the first branch with a type. A narrow first branch, such as a whole number, then cut the decimals of a wider branch evaluated later. The widest type of all branches is now used.
- Fix comparisons on the result of functions such as left, ltrim, rtrim and nvl
- Fehlerbehebung
- A comparison on the result of left or a similar function could return no rows, and nvl on a nullable number could answer null instead of the replacement value. The trimming of constants now removes blanks only, as it does for columns.
- Resolve whole numbers in SQL as integers instead of decimals
- Verbesserung
- erforderliche Maßnahme
- Action needed before or after the upgrade.
- Take one size value in the QR code functions
- Verbesserung
- erforderliche Maßnahme
- Action needed before or after the upgrade.
- More control and caching for MaxMind IP address lookups
- Verbesserung
- MaxMind lookups can be disabled, the database cache and memory cache can be switched off separately and a country-only query is prepared. When MaxMind has no credit left, earlier results are reused for a longer period and this is reported with its own error.
- Return a structured JSON error for refused requests and uniform API errors
- Verbesserung
- Requests refused by the firewall now get a JSON error with message code, unique identifier, request identifier, IP address, URL and time. The same error model is used for other API errors and the OData error model is shared. Error identifiers now contain their moment of creation.
- Exact Online XML tables load faster
- Verbesserung
- The XML tables of Exact Online can use a predefined list of fields instead of reading the schema first, controlled by the setting use-predefined-fields. Column positions are looked up once instead of per row.
- Lower memory use in long-running sessions
- Verbesserung
- Identical text and binary values in the result of a long query are shared within one execution, the history of query plan statistics is limited in size and age, and a program that writes many different files no longer uses more and more memory.
- More database data types are recognised; an unsupported type raises an error
- Verbesserung
- Reading from Oracle, SQL Server, PostgreSQL and other SQL databases recognises more data types, such as long, nclob, nvarchar2, sql_variant, interval types and anydata. An unsupported data type raises an error instead of being handled silently. Text columns have no precision and scale.
- Twinfield: more offices per session
- Verbesserung
- The maximum number of Twinfield offices that one session can use with an application supplied by Invantive is raised from 37 to 370. The new setting additional-allowed-offices names further offices that may be used.
- Answer requests from outside the service area with HTTP 451 and an explanation page
- Verbesserung
- A request from an IP address that is not accepted now gets the status 'Unavailable for legal reasons' (451) with an error page that has a message code and a hint. Before, such requests were sent to the access denied page.
- Gripp CRM: more tables and fields and better server-side filtering
- Verbesserung
- Gripp CRM gets additional tables, among them absence request lines and bulk prices. More filters are passed on to Gripp, which reduces the rows that are read.
Alle Verbesserungen
Änderungen an Verhalten, Plattformen, Treibern und Einstellungen, nach Bereichen geordnet.
Bedeutung: alle | 2 und höher | 3 und höher | 4 und höher | 5
Plattform: alle | ActiveCampaign (1) | AFAS Online (1) | Brevo (1) | Chargebee (1) | Crisp (2) | Data Cache (1) | DeepL (1) | Exact Online (19) | File system (1) | Fortnox (1) | Gripp CRM (1) | HubSpot (1) | Inspectlet (1) | Invantive Script (1) | ionBIZ (1) | LDAP (1) | LibreOffice (1) | Loket (1) | Matomo (1) | Microsoft Access (1) | MySQL (2) | Nextcloud (1) | Nmbrs (1) | OData (1) | Odoo (1) | Oracle (5) | Outlook (1) | Pipedrive (1) | PostgreSQL (6) | SnelStart (3) | SQL Server (4) | Teamleader (1) | Teamleader Focus (1) | Tweede Kamer (1) | Twinfield (3) | VIES (1) | Visma Severa (1) | Visma.net (2) | Yuki (3)
4 von 151 wird angezeigt.
Platforms and drivers
More database data types are recognised; an unsupported type raises an error
Reading from Oracle, SQL Server, PostgreSQL and other SQL databases recognises more data types, such as long, nclob, nvarchar2, sql_variant, interval types and anydata. An unsupported data type raises an error instead of being handled silently. Text columns have no precision and scale.
- MySQL
- Oracle
- PostgreSQL
- SQL Server
- Bedeutung 3
SQL Server driver uses the Microsoft client and reports a missing runtime clearly
The SQL Server driver now identifies itself with the current Microsoft client library instead of the older System library. When the client cannot be loaded on a computer, the driver raises a clear error instead of failing without a useful message.
- SQL Server
- Bedeutung 2
Alle Fehlerbehebungen
Fehler der älteren Version, die behoben wurden.
SQL engine
Filter with like and not like on SQL Server and Access gives correct rows
A like or not like filter evaluated on the client treated upper and lower case the wrong way round, so rows such as A%B were dropped. For Microsoft Access, a not-equal filter is now sent in the standard form that Access can read.
- SQL Server
- Microsoft Access
- Bedeutung 3
Platforms and drivers
Microsoft SQL Server: bulk insert and create table work with the updated driver
The SQL Server driver was updated to version 7.0.2 because version 7.0.0 had a problem with bulk insert and create table.
- SQL Server
- Bedeutung 3
Worauf es aufbaut
| Art | Name | Von | Bis |
|---|---|---|---|
| invantive component | Invantive Data Access Point | 25.0.44 | 26.0.383 |
| invantive component | Invantive(R) Basics | 25.0.233 | 26.0.383 |
| invantive component | Invantive(R) SQL for Core | 25.0.233 | 26.0.383 |
| invantive component | Invantive(R) SQL | 25.0.233 | 26.0.383 |
| invantive component | Invantive(R) Web Core Library | 25.0.232 | 26.0.383 |
| build tool | Invantive Deploy | 25.0.233 | 26.0.383 |
| third party summary |
Weitere Informationen
Wie dieser Zettel entstanden ist
- For all products together 22 items whose changed lines are 50 to 70 % in the last build of 25.0 and 22 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-26.0 that are not in origin/release-25.0 and have no equivalent patch there (git cherry).
- 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.
- 529 Verknüpfungen zwischen einer Änderung und einem Quell-Commit werden erfasst.
- 15 Ausschlüsse werden im Prüfbericht zu diesem Anleihewert erfasst.