Options
  • State Verified Answer
  • Locked Locked
  • Replies 1 reply
  • Subscribers 11 subscribers
  • Views 3458 views
  • Users 0 members are here
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Property Calculator - AutoFill Property depending on other property

manovos

Greetings,

 

i'm trying to fill in property Department Managers (Choose from list (Multi-select) Employee) depending which department is set. It works fine when there's only one Department, but i'm getting errors if they are more Departments in Departments property which is on the document itself.

 

Relations between Department and Managers (Employees Objects):

 

Document Properties:

 

 

Department Properties:

 

 

I tried to use Property Calculator Mode Calculate Expression and Search Objects but i'm getting the following error when property Department Manager is Choose From List Single Select:

 

Calculate Expression:

 

  • Setup:

 

 

  • Error:

 

DocumentCache.cpp, 7509, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
DocumentCache.cpp, 19216, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCMethodCallWithRetry.h, 27, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCMethodCallWithRetry.h, 27, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperations.cpp, 11772, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperations.cpp, 5811, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
MCallInLoop.h, 712, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelper.cpp, 1939, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelperPrivate.cpp, 208, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelper.cpp, 9432, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelper.cpp, 10128, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultDBSessionEvents.cpp, 380, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultDBSessionEvents.cpp, 1690, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultScriptSessionTemplates.cpp, 275, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultScriptSessionTemplates.cpp, 340, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultScriptSessionTemplates.cpp, 340, The parameter is incorrect. (6-727, 106) (0x80070057)
VaultScriptSessionTemplates.cpp, 523, The parameter is incorrect. (6-727, 106) (0x80070057)
CoActiveScriptSite.cpp, 895, The parameter is incorrect. (6-727, 106) (0x80070057)
CoActiveScriptSite.cpp, 737, The parameter is incorrect. (6-727, 106) (0x80070057)
BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize, 22, The parameter is incorrect. (6-727, 106) (0x80070057)
CoDynamicCLRObjectWrapper.cpp, 552, The parameter is incorrect. (6-727, 106) (0x80070057)
CoDynamicCLRObjectWrapper.cpp, 322, The parameter is incorrect. (6-727, 106) (0x80070057)
ManagedError.cpp, 150, The parameter is incorrect. (6-727, 106) (0x80070057)
VaultApplicationBase.cs, 257 (IL:45), The parameter is incorrect. (6-727, 106) (0x80070057)
VaultApplicationBase.cs, 809 (IL:82), The parameter is incorrect. (6-727, 106) (0x80070057)
MethodInfo.cs, 224 (IL:105), The parameter is incorrect. (6-727, 106) (0x80070057)
CoreFunctionality.cs, 944 (IL:0), The parameter is incorrect. (6-727, 106) (0x80070057)
ObjVerEx.cs, 1616 (IL:56), The parameter is incorrect. (6-727, 106) (0x80070057)
PropertyCalculator 2.0.1: [MFilesAPI.ObjectVersionAndProperties SetAllProperties(MFilesAPI.ObjVer, Boolean, MFilesAPI.PropertyValues)], IL:-1, The parameter is incorrect. (6-727, 106) (0x80070057)
CoVaultObjectPropertyOperations.cpp, 978, The parameter is incorrect. (6-727, 106) (0x80070057)
CoVaultObjectPropertyOperations.cpp, 1004, The parameter is incorrect. (6-727, 106) (0x80070057)
CoVaultObjectPropertyOperations.cpp, 1080, The parameter is incorrect. (6-727, 106) (0x80070057)
ServerVaultObjectPropertyOperationsHelper.cpp, 415, The parameter is incorrect. (6-727, 106) (0x80070057)
RPCObjectOperationsHelper.cpp, 109, The parameter is incorrect. (6-727, 106) (0x80070057)
CoRPCOverCOM.cpp, 6808, The parameter is incorrect. (6-727, 106) (0x80070057)
RPCDocumentOperations.cpp, 7389, The parameter is incorrect. (6-727, 106) (0x80070057)
MCallInLoop.h, 712, The parameter is incorrect. (6-727, 106) (0x80070057)
RPCDocumentOperationsHelper.cpp, 4192, The parameter is incorrect. (6-727, 106) (0x80070057)
RPCDocumentOperationsHelper.cpp, 3724, The parameter is incorrect. (6-727, 106) (0x80070057)
RPCDocumentOperationsHelperPrivate.cpp, 7499, The parameter is incorrect. (6-727, 106) (0x80070057)
RPCDocumentOperationsHelperPrivate.cpp, 6947, The parameter is incorrect. (6-727, 106) (0x80070057)
RPCDocumentOperationsHelperPrivate.cpp, 8843, The parameter is incorrect. (6-727, 106) (0x80070057)
RPCDocumentOperationsHelperPrivate.cpp, 9621, The parameter is incorrect. (6-727, 106) (0x80070057)
RPCObjectTypesHelper.cpp, 2393, The parameter is incorrect. (6-727, 106) (0x80070057)
(M-Files 22.4.11321.4 2022-07-27T06:45:40.408Z)

 

Search Objects:

 

  • Setup:

 

 

  • Error:

 

DocumentCache.cpp, 7509, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
DocumentCache.cpp, 19216, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCMethodCallWithRetry.h, 27, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCMethodCallWithRetry.h, 27, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperations.cpp, 11772, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperations.cpp, 5811, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
MCallInLoop.h, 712, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelper.cpp, 1939, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelperPrivate.cpp, 208, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelper.cpp, 9432, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelper.cpp, 10128, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultDBSessionEvents.cpp, 380, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultDBSessionEvents.cpp, 1690, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultScriptSessionTemplates.cpp, 275, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultScriptSessionTemplates.cpp, 340, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultScriptSessionTemplates.cpp, 340, The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
VaultScriptSessionTemplates.cpp, 523, The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
CoActiveScriptSite.cpp, 895, The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
CoActiveScriptSite.cpp, 737, The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize, 22, The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
CoDynamicCLRObjectWrapper.cpp, 552, The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
CoDynamicCLRObjectWrapper.cpp, 322, The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
ManagedError.cpp, 150, The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
VaultApplicationBase.cs, 257 (IL:45), The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
VaultApplicationBase.cs, 809 (IL:82), The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
MethodInfo.cs, 224 (IL:105), The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
CoreFunctionality.cs, 965 (IL:96), The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
CoreFunctionality.cs, 1012 (IL:55), The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
CoreFunctionality.cs, 1062 (IL:210), The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
SearchFromVault.cs, 172 (IL:269), The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
SearchFromVault.cs, 196 (IL:152), The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
PropertyCalculator 2.0.1: [Void SetValue(MFilesAPI.MFDataType, System.Object)], IL:-1, The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
CoTypedValue.cpp, 328, The parameter is incorrect. (Multiple lookup values specified for a single lookup.) (0x80070057)
(M-Files 22.4.11321.4 2022-07-27T06:58:21.743Z)

 

I'm getting the following error if the Department Manager property is Multi Select using Calculate Expression:

 

DocumentCache.cpp, 7509, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
DocumentCache.cpp, 19216, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCMethodCallWithRetry.h, 27, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCMethodCallWithRetry.h, 27, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperations.cpp, 11772, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperations.cpp, 5811, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
MCallInLoop.h, 712, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelper.cpp, 1939, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelperPrivate.cpp, 208, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelper.cpp, 9432, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
RPCDocumentOperationsHelper.cpp, 10128, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultDBSessionEvents.cpp, 380, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultDBSessionEvents.cpp, 1690, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultScriptSessionTemplates.cpp, 275, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultScriptSessionTemplates.cpp, 340, Script execution failed. ((BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize: 1624-1)) (0x800408BB)
VaultScriptSessionTemplates.cpp, 340, Wrong data type for property definition "Department Manager". (0x8004009A)
VaultScriptSessionTemplates.cpp, 523, Wrong data type for property definition "Department Manager". (0x8004009A)
CoActiveScriptSite.cpp, 895, Wrong data type for property definition "Department Manager". (0x8004009A)
CoActiveScriptSite.cpp, 737, Wrong data type for property definition "Department Manager". (0x8004009A)
BeforeCheckInChangesFinalize::PropertyCalculator.MFEventHandlerBeforeCheckInChangesFinalize, 22, Wrong data type for property definition "Department Manager". (0x8004009A)
CoDynamicCLRObjectWrapper.cpp, 552, Wrong data type for property definition "Department Manager". (0x8004009A)
CoDynamicCLRObjectWrapper.cpp, 322, Wrong data type for property definition "Department Manager". (0x8004009A)
ManagedError.cpp, 150, Wrong data type for property definition "Department Manager". (0x8004009A)
VaultApplicationBase.cs, 257 (IL:45), Wrong data type for property definition "Department Manager". (0x8004009A)
VaultApplicationBase.cs, 809 (IL:82), Wrong data type for property definition "Department Manager". (0x8004009A)
MethodInfo.cs, 224 (IL:105), Wrong data type for property definition "Department Manager". (0x8004009A)
CoreFunctionality.cs, 944 (IL:0), Wrong data type for property definition "Department Manager". (0x8004009A)
ObjVerEx.cs, 1616 (IL:56), Wrong data type for property definition "Department Manager". (0x8004009A)
PropertyCalculator 2.0.1: [MFilesAPI.ObjectVersionAndProperties SetAllProperties(MFilesAPI.ObjVer, Boolean, MFilesAPI.PropertyValues)], IL:-1, Wrong data type for property definition "Department Manager". (0x8004009A)
CoVaultObjectPropertyOperations.cpp, 978, Wrong data type for property definition "Department Manager". (0x8004009A)
CoVaultObjectPropertyOperations.cpp, 1004, Wrong data type for property definition "Department Manager". (0x8004009A)
CoVaultObjectPropertyOperations.cpp, 1080, Wrong data type for property definition "Department Manager". (0x8004009A)
ServerVaultObjectPropertyOperationsHelper.cpp, 415, Wrong data type for property definition "Department Manager". (0x8004009A)
RPCObjectOperationsHelper.cpp, 109, Wrong data type for property definition "Department Manager". (0x8004009A)
CoRPCOverCOM.cpp, 6808, Wrong data type for property definition "Department Manager". (0x8004009A)
RPCDocumentOperations.cpp, 7389, Wrong data type for property definition "Department Manager". (0x8004009A)
MCallInLoop.h, 712, Wrong data type for property definition "Department Manager". (0x8004009A)
RPCDocumentOperationsHelper.cpp, 4192, Wrong data type for property definition "Department Manager". (0x8004009A)
RPCDocumentOperationsHelper.cpp, 3724, Wrong data type for property definition "Department Manager". (0x8004009A)
RPCDocumentOperationsHelperPrivate.cpp, 7499, Wrong data type for property definition "Department Manager". (0x8004009A)
RPCDocumentOperationsHelperPrivate.cpp, 6947, Wrong data type for property definition "Department Manager". (0x8004009A)
RPCDocumentOperationsHelperPrivate.cpp, 8843, Wrong data type for property definition "Department Manager". (0x8004009A)
RPCDocumentOperationsHelperPrivate.cpp, 9592, Wrong data type for property definition "Department Manager". (0x8004009A)
(M-Files 22.4.11321.4 2022-07-27T07:05:13.898Z)

 

For Search Objects Mode i'm getting the same error as when the property is Single Select.

 

The whole workflow works depending on that property and it's mandatory for me that this works.

 

Also all properties that i'm using with property calculator are MultiSelect data type.

 

 

 

 

Error details are in the attachment.

 

If additional information is needed, I am at your disposal.

  • +1

    With a little more troubleshooting, I saw that there was a problem with the Department Manager property, it was "broken" and did not "save" the settings that it was MultiSelect at all, even though the property itself said that it was MultiSelect.

    The solution that worked for me was that I deleted and created a new identical property and now it works without problems.

M-Files
M-Files Support


© 2025 M-Files, All Rights Reserved.