At Incremental.SalesOrdersV2Incremental, error code itgeneor328 repeatedly occurred:
itgeneor328
A required filter is missing.
Contact Invantive Support.
This endpoint has mandatory filtering applied.
A GET request for this endpoint must have a $filter parameter with one of the following fields in the URL: Timestamp.
This table is also present in other reports; these were updated earlier tonight without issues.
Since 6 August around 02:12 UTC, the following error message occurs in many Exact Online environments:
itgeneor328
A mandatory filter is missing.
The remote server returned an error:
(400) Bad Request.
Please contact Invantive Support:
This endpoint has mandatory filtering applied.
A GET request for this endpoint must have a $filter parameter with one of the following fields in the url:Timestamp.
The error message is not related to changes to Invantive Cloud (for stability reasons there is a summer freeze in effect), but is likely caused by an upgrade of Exact Online.
The issue appears to affect all Exact Online environments, both on-premises and Invantive Cloud, Get My Report, Valuta Tools, App Online, Bridge Online, as well as websites based on Invantive technology and products from partners.
Affected URLs, where “123456” may be the division code of one of your Exact Online administrations:
There is currently no solution available. A request has been submitted to Exact Online to escalate the issue and/or reverse the breaking change.
For small tables, it may be possible to replace the *Incremental with the corresponding bulk table or much slower DDL tables. However, this can increase the load time by up to a factor of 1,000 and the number of required API calls by hundreds of thousands per day.
Invantive Development is working to see if a patch can be made. The rollout within Invantive Cloud will take place first. However, the rollout by administrators of partners and users may take much longer because a sometimes large version jump is required, which can lead to new issues.
Impact
It currently affects several hundred organisations, and this number is expected to rise further if the incremental cache needs to be reinitialised. This may never occur, but it can also occur in some environments after just a few hours.
The use of a previously unused table can also trigger this error message, so new users will immediately encounter issues when using it.
Update
As more information becomes available, this topic will be updated.
Exact has indicated that the involved change will be rolled back during the night of 6 to 7 August. It will be reactivated at a later time, but with additional precautions to avoid a large-scale downtime situation.
Specifically for Invantive Cloud, a release is expected to be put into production during the course of 6 August that will no longer trigger the error message. For partners and on-premises users, there will also be a new release, but given the number of installations and the holiday period, the advice is to include this in an upgrade in due course, as the cause will disappear during the night of 6 to 7 August.
Exact has apparently not or not completely reversed the change. An upgrade of Invantive Cloud has resolved most issues. The problem still occurs with:
on-premises installations of versions older than 24.0.0756
Invantive Cloud when directly accessing sync* tables
For the latter, the recommended workaround is to use the associated *Incremental table. There will also be a new version in which the Sync tables are adjusted.