Bij het uitvoeren van een SQL-statement tegen Crisp treedt de volgende foutmelding op:
itgenprr002
The value of the parameter with name ‘company_metrics_employees’ with key ‘company_metrics_employees’ must match the data type ‘System.Int32’.
The value currently has data type ‘System.Decimal’.
Call stack:
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 statement:
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;