I have a Service Order Management app that users can place Estimates and then, when approved, convert to an Order. A Work Order object has child references for Products and Materials. When the Estimate is switched to an Order, a Workflow is activated to update Allocated counts in the Inventory table for the associated Products and Materials
I am getting a puzzling error when this Workflow is processed. When I have only a single record in these child references, the updates DO occur as expected in the Inventory table but I still get this error. If there are multiple child records, only the first record is processed and no others. I believe the error is preventing further processing.
What could be causing this error? What am I missing?
Please let me know if you need more information.
Below is the error I am seeing from the log (similar error for each Products and Materials Action sets):
Audit Log Details:
Properties:
{
โAppIdโ: โea11df8a-9df1-4f29-afea-d6300774751bโ,
โAppTemplateVersionโ: โ1.000143โ,
โRuleNameโ: โOrder Placedโ,
โEventTypeโ: โChangeโ,
โInvokedByโ: โUpdateโ,
โServerโ: โprodu991100005Tโ,
โIgnoreSecurityFiltersโ: false,
โTableNameโ: โWorkOrdersโ,
โRuleTableNameโ: โWorkOrdersโ,
โOperationUpdateModeโ: โUPDATES_ONLYโ,
โEventMatchโ: โWorkflow event successfully matchedโ,
โConditionโ: โ=AND([_THISROW_BEFORE].[Work Type] = โEstimateโ, [_THISROW_AFTER].[Work Type] = โOrderโ)โ,
โMatchesConditionโ: โTrueโ,
โActionResultsโ: โCreated 1 ActionResultsโ,
โAction Typeโ: โTakeActionโ,
โAction Nameโ: โUpdate Allocation for Materials Usedโ,
โErrorsโ: "Error: โAction on a set of rowsโ โUpdate Materials Allocationโ for table 'Materials failed with exception Value cannot be null.\r\nParameter name: source ",
โAppTemplateNameโ: โServiceInsightBase-526414โ,
โOperationโ: โWorkflow actionโ,
โResultโ: โFailureโ
}
User | Count |
---|---|
36 | |
34 | |
27 | |
23 | |
18 |