Versionshinweise zu Invantive Data Loader, 25.0 bis 26.0
Anmerkungen zu dieser Version - Installationsprogramm
Invantive Data Loader 26.0, aus 25.0
| Build | Datum | Beschreibung |
|---|---|---|
25. |
08-07-2026 | 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).
- 71 Verbesserungen
- 60 Fehlerbehebungen
- 6 Was Sie vor dem Upgrade überprüfen sollten
Dieser Hinweis
- Bevor Sie ein Upgrade durchführen
- Die 25 wichtigsten Änderungen
- Alle Verbesserungen 4
- 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.
- Load results clipboard statement no longer accepts a compression level
- Remove the compression level clause from statements that load a results clipboard.
- Diagnostics window loses the tabs for processes, performance and Windows users
- Processes, performance counters and Windows users are not listed in the diagnostics window any more.
- Script editor menu and statement tips offer fewer local statements
- Some local statements are not offered in the script editor menu and tips any more; they still run when typed.
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.
- 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.
- 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.
- 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.
- Data Loader is built for .NET 10 only
- Verbesserung
- The Data Loader is no longer built for .NET Framework 4.8, .NET 8 or .NET 9. It is built for .NET 10 on Windows, and the splash screen and display scaling settings were adapted for it.
- 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.
- 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.
- Oracle: tables and views with mixed-case names can be queried
- Verbesserung
- Names of Oracle tables, views and owners that were created with a quoted mixed-case name are no longer forced to the standard casing. The name as typed and the name in the usual Oracle casing are both tried.
- 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.
- 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.
- SnelStart: data model follows the API definition of 27 May 2026
- Verbesserung
- The SnelStart tables and columns follow the newer API definition. More reference fields are available, decimal values are read as numbers and the purchase invoice number can have 60 characters.
- Better handling of OAuth token failures
- Verbesserung
- A stalled token endpoint is cut off after 30 seconds and treated as a temporary error. A refresh token that is refused without an error code now asks for new authorisation, and unknown answers are logged in anonymised form.
- Exact Online incremental tables are written more safely
- Verbesserung
- New chunks of an incremental table are written under a new generation, so the previous copy stays complete until the new one is listed and an interrupted load does not damage it. A new setting limits the age of deleted rows and raises message itgeneor878. The new table IncrementalEntityTypes lists the entity types that can be loaded incrementally.
- Safer handling of web requests
- Verbesserung
- Web requests no longer accept Brotli compressed answers, because the Brotli decoder of .NET before 10.0.14 has a memory write flaw. Values of security-sensitive headers are masked in diagnostic output, and reading an answer ends with a time-out error when it does not finish in time.
- Apply the Twinfield office limit only to Invantive client identifiers
- Fehlerbehebung
- The error about too many Twinfield offices was also raised when a customer used a client identifier of their own. The limit now applies only to Invantive's own client identifiers or when no identifier is known.
- Fix internal error and invalid file on Excel export
- Fehlerbehebung
- An internal null reference error on exporting to Excel is avoided, and the exported file no longer carries an application version that Excel rejects.
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 (6) | Outlook (1) | Pipedrive (1) | PostgreSQL (6) | SnelStart (3) | SQL Server (5) | Teamleader (1) | Teamleader Focus (1) | Tweede Kamer (1) | Twinfield (3) | VIES (1) | Visma Severa (1) | Visma.net (2) | Windows (1) | Yuki (3)
6 von 131 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
PostgreSQL: choose whether a missing table privilege stops the metadata load
A new connection attribute fail-on-missing-tables decides whether the metadata load fails when not all tables of the database are accessible. A failure now also reports the error codes of the underlying causes.
- PostgreSQL
- Bedeutung 2
PostgreSQL: clear errors for missing names during metadata discovery
Metadata discovery on PostgreSQL checks for a missing database, schema, table, catalog or primary key name and raises a specific error code (itgenpsr146 to itgenpsr155) instead of failing later.
- PostgreSQL
- Bedeutung 2
Performance
Connections to PostgreSQL start faster by switching off Kerberos negotiation
A connection to PostgreSQL no longer first asks the server for Kerberos encryption, which cost an extra round trip per connection. The setting can still be changed in the connection settings.
- PostgreSQL
- Bedeutung 2
Alle Fehlerbehebungen
Fehler der älteren Version, die behoben wurden.
Security
Prevent SQL injection through large value lists on MySQL and PostgreSQL
Text values placed directly in a statement for large IN lists are escaped correctly on MySQL and MariaDB. On PostgreSQL the session now enforces standard conforming strings and checks the setting.
- MySQL
- PostgreSQL
- Bedeutung 3
Platforms and drivers
Date columns of PostgreSQL no longer fail with itgenrst004 on current .NET
Reading a date column from PostgreSQL stopped with error itgenrst004 when the Npgsql driver returned a date without time. The value is now converted to the declared date and time type.
- PostgreSQL
- Bedeutung 3
Worauf es aufbaut
| Art | Name | Von | Bis |
|---|---|---|---|
| invantive component | Invantive Data Loader | 25.0.233 | 26.0.383 |
| invantive component | Invantive(R) Basics | 25.0.233 | 26.0.383 |
| invantive component | Invantive(R) Producer GUI Base | 25.0.233 | 26.0.383 |
| invantive component | Invantive(R) Producer Data Model | 25.0.233 | 26.0.383 |
| invantive component | Invantive(R) Producer GUI | 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) SQL for Windows | 25.0.233 | 26.0.383 |
| build tool | Invantive Deploy | 25.0.233 | 26.0.383 |
| build tool change | Windows installer now packages the .NET 10 build instead of the .NET Framework 4.8 build | ||
| build tool change | Installer rejects more placeholder e-mail addresses and phone numbers | ||
| build tool change | Log opened from the installer exit dialog ends with an 'End of File' line | ||
| build tool change | Installer picks up language folders for Catalan, Hungarian and Romanian | ||
| build tool change | List of supported Windows versions shown with the product is updated | ||
| 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.
- 491 Verknüpfungen zwischen einer Änderung und einem Quell-Commit werden erfasst.