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_DUMMY_INT32_ (Double, metadata int32): 25
Error seems similar to Itgensql151 on QueryTool Beta 24.1.113 on loading Fortnox inmemory table.
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:
Relates to Itgenrst004 op avg in BETA-release 24.1 (Dutch).
Needs retest.
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:
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 by pasting its URL into the text.
Dit topic is 3 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.