Running Query tool 24.0.11-PROD-4601:
insert into exactonlinerest..nativeplatformscalarrequests@eol
( url
)
values
( '/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)...