Hi,
I have a workflow which does various tasks based on the state of a particular field. Quite commonly it has to set other fields to particular values. However, although the log is showing that the workflow is attempting to set the values, the record does not change.
I've had various issues with this in the past, but for this Workflow I pretty much replicated an existing WF which does work.
I know it's hard to troubleshoot without seeing the entire workflow but I'll try to explain.
Firstly, it runs as a scheduled workflow off a saved search. The saved search is returning records and the WF is initiating, also the relevant records have populated "Active Workflows" and "Workflow History" tabs.
When I look at the log for the relevant state, it says something like this:
09-APR-2013 16:07:28.922 Initiated workflow
09-APR-2013 16:07:28.936 Running ONENTRY trigger(Original trigger: BEFORELOAD)
09-APR-2013 16:07:29.012 Validate Extended Time Entry Dates
09-APR-2013 16:07:29.166 SETFIELDVALUE: custrecord_ct_hr_ext_datastatus=3
09-APR-2013 16:07:29.216 SETFIELDVALUE: custrecord_ct_hr_approvalstatus=6
09-APR-2013 16:07:29.265 SETFIELDVALUE: custrecord_ct_hr_ext_rejectreason=1
That first "Validate Extended Time Entry Dates" is a custom action run in another previous action, with a return variable that then allows the subsequent action to run, which sets those field values.
However, those values apparently don't get written to the record. The record in question is not locked. The WF runs as administrator. All those fields are select fields. This kind of action has worked fine on other workflows. The last three actions are in a group, set to Before Record Load. I've also tried setting to Entry. Neither works.
I've a horrible feeling it's something really simple I've overlooked but it's driving me crazy now. Does anyone have any insight into this? What else would you need to know?