The query: select avg(Dummy_Int32) from DUAL@DataDictionary raises: itgenrst004: The type of the actual data must match the data type of the column ‘AVG_DUMMY_INT32_’ in ‘’. Ensure that the actual data data type (currently ‘Double’) in row #1 is cast to the data type (currently ‘int32’). AVG_…

A new release has been made available that should solve this issue. The necessary changes are available with all releases after 25.0 and with all future BETA versions. This new release has been/will be taken into production on Invantive Cloud. For more information see: [image] …

Does this error also occur on: https://download.invantive.com/release/msi/Invantive%20Query%20Tool-24.0.733-net48.msi The bug has been signaled some weeks ago and a fix should have been shipped in recent release.

After testing, the error is still here in latest releases: 24.0.733-PROD 24.1.116-BETA

This question was automatically closed after at least 1 week of inactivity after a possible solution was provided. The last answer given has been marked as a solution. Please ask a new question via a separate topic if the problem occurs again. Please include a link to this topic in the new question…

Itgenrst004 error on avg() with Query Tool 24.0.658

Vragen (en)

forums 20 June 2025 17:06 4

Relates to Itgenrst004 op avg in BETA-release 24.1 (Dutch).

Needs retest.

Topic		Replies	Views
Itgenrst004 op avg in BETA-release 24.1 Vragen (alle) exact-online , invantive-sql	1	8	14 May 2025
Itgenrst004 foutmelding op STDDEV-groepfunctie Vragen (alle) invantive-sql	1	10	8 May 2025
Twinfield error 500 in Invantive query tool 25.0.127 (itgenoda035) Vragen (alle) invantive-query-tool , twinfield	2	16	11 April 2026
Itgenase474 Open SQL Server database met Data Replicator op Query Tool Vragen (alle) invantive-query-tool , microsoft-sql-server	1	21	18 June 2026
Itgenclr003 Enumeration already finished Vragen (alle) exact-online , invantive-data-hub	2	11	4 August 2026

Itgenrst004 error on avg() with Query Tool 24.0.658

Related topics