Itgenrst004 issue with nativeplatformscalarrequests@eol

Running Query tool 24.0.11-PROD-4601:

insert into exactonlinerest..nativeplatformscalarrequests@eol
( url
( '/api/v1/[eol_division]/sync/Financial/TransactionLines/$count'

Then asking results by:

select * 
from   exactonlinerest..nativeplatformscalarrequests@eol

Gives an itgenrst004 error:

itgenrst004: The type of the actual data must match the data type of the column 'DURATION_MS' in ''.
Ensure that the actual data data type (currently 'Int64') in row #1 is cast to the data type (currently 'int32').
Message ID: f71e5f9d-4167-4b18-8557-4dd22cd2f2ad
Occurred (UTC): 20/03/2024 16:15:10
select * from exactonlinerest..nativeplatformscalarrequests@eolValidationException
   à Invantive.Basics.ValidationException..ctor(GlobalState owner, ExecutionOptions executionOptions, String messageCode, String errorMessage, String kindRequest, String localStackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable, String poolIdentityId, String url, Nullable`1 partyUid, String partitionCode, String tableName)
   à Invantive.Data.SqlUtility.CheckRow(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IProviderManager manager, ISparseArray row, DatabaseColumnDefinitionCollection fields, Nullable`1 rowNumberContext, ObjectDefinition objectDefinition, String sqlStatement, Boolean isFromDml, String operationType, String fullTableNameOverrule, Rst004Mode rst004Mode, Boolean disableRst007, Boolean disableRst009, Boolean disableRst011AndOrRst013)
   à Invantive.Sql.V1.QueryPlan.EH.MoveNext()
   à Invantive.Data.ExtensionMethods.IteratorWithFinally`1.IteratorWithFinallyEnumerator.MoveNext()   à System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
   à System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)...

The error itgenrst004 is a bug that was present in early 24.0 releases when using NativePlatformScalarRequests.

It is recommended to upgrade to the latest 24.0-release of Invantive Query Tool available from

IMPORTANT! Please manually enter the folder into which the software must be installed. This is typically C:\Program Files (x86)\Invantive Software BV\Invantive Query Tool 24.0.

Sorry, thanks indeed 24.0.40 solves the issue.

1 Like

Dit topic is 7 dagen na het laatste antwoord automatisch gesloten. Nieuwe antwoorden zijn niet meer toegestaan.