Code Fix: A workflow containing a mathematical sum or minimum inline function goes into an error state
KB002572
PRODUCTK2 smartforms 4.7
LEGACY/ARCHIVED CONTENT
This article has been archived, and/or refers to legacy products, components or features. The content in this article is offered "as is" and will no longer be updated. Archived content is provided for reference purposes only. This content does not infer that the product, component or feature is supported, or that the product, component or feature will continue to function as described herein.
Issue Description
When running a K2 workflow configured with an Email event where the event contains a mathematical sum or minimum inline function with multiple values such as “100, 200”, the workflow goes into an error state.
Error Message
The error message states: “Input string was not in the correct format” or “Unable to cast result”.
Cause
This is due to the comma being used to separate each item in the array of values for inline functions.
Resolution
- Ensure you have K2 4.7 installed.
- Download and Install the K2 4.7 March 2018 Cumulative Update from K2 Partner and Customer Portal.
- Get the K2 4.7 March 2018 Cumulative Update FP18 from Regional Support.
- Install the K2 4.7 March 2018 Cumulative Update FP18 to apply the fix.
- It is recommended to refresh the browser cache.
- We now provide the ability to use a split inline function in the mathematical sum or minimum inline functions to be able to use the comma.
Considerations
For the fix to be applied you need to edit your workflow and edit the inline function. Remove the values from the value property and drag a split inline function into the value property. Set the values using the split inline function. Set the separator as a comma. Finish the configuration then deploy the workflow and start a new instance.
