Itgenprr002: Värdet på parametern med namnet 'company_metrics_employees' med nyckeln 'company_metrics_employees' måste stämma överens med datatypen 'System.Int32'

Vid körning av ett SQL-uttalande mot Crisp uppstår följande felmeddelande:

itgenprr002
Värdet för parametern med namnet ‘company_metrics_employees’ med nyckeln ‘company_metrics_employees’ måste matcha datatypen ‘System.Int32’.
Värdet har för närvarande datatypen ‘System.Decimal’.

Anropsstack:

   at 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, Nullable`1 isRecoverable, String poolIdentityId, String url, Nullable`1 partyUid, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)                                                                                                                                                                  at Invantive.Basics.InvantiveSystemException..ctor(GlobalState owner, ExecutionOptions executionOptions, String validationCode, String errorMessage, String kindRequest, String stackTrace, String nk, Exception innerException, Boolean inheritMessageCodeWhenPresent, Nullable`1 uid, Boolean isRecoverable, String poolIdentityId, String partitionCode, String tableName, String parameter1, String parameter2, String parameter3, String parameter4, String parameter5, String clientId)                           at Invantive.Data.Parameter.A(GlobalState, ExecutionOptions executionOptions, String, String, Object val, Boolean, Object tag, Boolean)                                 at Invantive.Data.Parameter..ctor(GlobalState owner, ExecutionOptions executionOptions, String name, String dotnetDataType, Object val, Boolean excludeFromLogging, Object tag, Boolean isDefaultValue)                                                                                                                                         at Invantive.Data.ParameterList.Add(GlobalState owner, ExecutionOptions executionOptions, String name, String dotnetDataType, Object val, Object tag, Boolean isDefaultValue, Boolean excludeFromLogging)                                                                                                                                       at Invantive.Sql.V1.SynchronizeStatementTree.CreateUpdateValues(GlobalState owner, ExecutionOptions executionOptions, ISparseArray sourceRow, ISparseArray targetRow, Dictionary`2 matchingFields, Int32 count, HashSet`1 doNotUpdateFields, HashSet`1 doNotForCompareUpdateFields, Boolean excludeDerivedValues, Boolean ignoreNullValues)     at Invantive.Sql.V1.SynchronizeStatementTree.InsertAndUpdateLeftAndRight(GlobalState owner, ExecutionOptions executionOptions, SqlExecutionStep sqlExecutionStep, IQueryStatePerExecution queryStatePerExecution, SparseArrayPool sparseArrayPool, ISparseArray[] leftRows, NullAcceptingDictionary`2 rightRowsIndexed, List`1 rowsToInsert, IDataProvider leftProvider, IDataProvider rightProvider, ObjectDefinition leftObjectDefinition, ObjectDefinition rightObjectDefinition, Boolean allFieldsMatch, Dictionary`2 matchingFieldsLeftToRightMinExcluded, Int32[] identifyingColumnsLeftSide, Boolean allowInsert, Boolean allowUpdate, List`1 resolveByColumnsIndexes, Dictionary`2 matchingFieldsRightToLeft, Dictionary`2 matchingFieldsLeftToRight, HashSet`1 doNotUpdateFieldsHashSet, HashSet`1 doNotForCompareUpdateFieldsHashSet, HashSet`1 excludedInsertFieldsHashSet, Int64& rowsInsertAttempted, Int64& rowsUpdateAttempted, Func`1 rowsTotalAttempted, ProjectionMeta beforeInsertOnLeftProjection, ProjectionMeta insteadOfInsertOnLeftProjection, ProjectionMeta afterInsertOnLeftProjection, ProjectionMeta beforeInsertOnRightProjection, ProjectionMeta insteadOfInsertOnRightProjection, ProjectionMeta afterInsertOnRightProjection, ProjectionMeta beforeUpdateOnLeftProjection, ProjectionMeta insteadOfUpdateOnLeftProjection, ProjectionMeta afterUpdateOnLeftProjection, ProjectionMeta beforeUpdateOnRightProjection, ProjectionMeta insteadOfUpdateOnRightProjection, ProjectionMeta afterUpdateOnRightProjection, ISparseArray pSqlVariableRow, Int32 beforeInsertOnLeftVariableCount, Int32 insteadOfInsertOnLeftVariableCount, Int32 afterInsertOnLeftVariableCount, Int32 beforeInsertOnRightVariableCount, Int32 insteadOfInsertOnRightVariableCount, Int32 afterInsertOnRightVariableCount, Int32 beforeUpdateOnLeftVariableCount, Int32 insteadOfUpdateOnLeftVariableCount, Int32 afterUpdateOnLeftVariableCount, Int32 beforeUpdateOnRightVariableCount, Int32 insteadOfUpdateOnRightVariableCount, Int32 afterUpdateOnRightVariableCount, List`1 errorsOverall, Int64& errorCntOverall, Int64& errorCntInsertLeft, Int64& errorCntInsertRight, Int64& errorCntUpdateLeft, Int64& errorCntUpdateRight, Nullable`1 errorCntOverallMax)
...

SQL-uttalande:

begin
crp_people.maintain_people_profile@crp
    ( false
    , ...email...
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , null
    , 3
    , null
    , null
    , null
    , null
    , null
    );
end;

I version 25.0.14 har en förbättring införts som gör att felmeddelandet itgenprr002 inte längre visas i onödan.