Workflow error stale data

hello guys,

do you have any idea what’s the stale data error is in workflow? or how to debug it??
this is the error message
workflow 271441867474731010 step 48 execution failed: stale data

thanks in advanced

The cause

Stale data occurs if you try to update something, but the resource you’ve sent up is not the current latest version stored in the database.

For example:
Step 1 fetches the record
Step 2 updates some values
Step 3 updates the record

Step 4 updates some other fields
Step 5 updates the record

This series of steps should return the stale data error (unless step 3 updates the workflow variable that holds the resource).

The fix

Opt 1

This is the easiest solution; simply update the workflow variable that holds the resource; for example:

See how I assign the result of the update function to the same variable I used in the call.

Opt 2

Defer the update call to the very end of the workflow.
Use expression steps to update any values you wish to update and then at the very end use the update function to store the update.

@tjerman this is interesting

still wonder how Corteza handle parallelism execution
my scenario is like this,

I have a trigger after create
I take the created record and do fork operation
so each fork to fill different fields of the record and save it

now regarding option 1, I did assign the record as the target in the result of the update function but didn’t work. option 2 not usable in my logic

do we have some documentation on corteza parallelism?

does it handle them on application level or DB level?
and two different workflows which have same trigger(i.e. afterCreate)
will we have stale data condition or the Corteza will syncronize them?

Could you show me the workflow?
I’m having a hard time imagining what it does and why the second option wouldn’t work for you.

Do make sure that your workflow doesn’t cause infinite execution cycles

On the application level.

If multiple workflows would be executed by the same event, they are executed in some order.
The order isn’t really defined nor can you control it so we don’t recommend doing that.

In such a case, the output (if any) of the first workflow would use the parameters passed into the second workflow.

The recommended approach is to have one automation per event (one trigger that would be executed by some record creation) and have that automation handle everything it needs to.

@tjerman here you go

{
  "workflows": [
    {
      "handle": "sary_order_lookup_fields",
      "enabled": true,
      "meta": {
        "name": "sary_order_lookup_fields",
        "description": "",
        "visual": null
      },
      "keepSessions": 0,
      "steps": [
        {
          "stepID": "246",
          "kind": "termination",
          "ref": "",
          "arguments": null,
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "246",
              "parent": "1",
              "value": null,
              "xywh": [
                4464,
                2760,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "247",
          "kind": "function",
          "ref": "composeRecordsLookup",
          "arguments": [
            {
              "target": "module",
              "value": "User",
              "type": "Handle"
            },
            {
              "target": "namespace",
              "value": "crm",
              "type": "Handle"
            },
            {
              "target": "record",
              "expr": "order.values.user",
              "type": "ID"
            }
          ],
          "results": [
            {
              "target": "user",
              "expr": "record"
            }
          ],
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "247",
              "parent": "1",
              "value": "Fetch order",
              "xywh": [
                4824,
                2560,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "248",
          "kind": "expressions",
          "ref": "",
          "arguments": [
            {
              "target": "order",
              "expr": "record",
              "type": "ComposeRecord"
            }
          ],
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "248",
              "parent": "1",
              "value": "rename",
              "xywh": [
                4144,
                2560,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "249",
          "kind": "expressions",
          "ref": "",
          "arguments": [
            {
              "target": "user",
              "expr": "record",
              "type": "ComposeRecord"
            }
          ],
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "249",
              "parent": "1",
              "value": "rename",
              "xywh": [
                4144,
                2960,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "250",
          "kind": "iterator",
          "ref": "composeRecordsEach",
          "arguments": [
            {
              "target": "module",
              "value": "Order",
              "type": "Handle"
            },
            {
              "target": "namespace",
              "value": "crm",
              "type": "Handle"
            },
            {
              "target": "query",
              "expr": "\" user = \" + user.recordID",
              "type": "String"
            }
          ],
          "results": [
            {
              "target": "order",
              "expr": "record"
            }
          ],
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "250",
              "parent": "1",
              "value": "fetch users",
              "xywh": [
                4824,
                2960,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "251",
          "kind": "gateway",
          "ref": "excl",
          "arguments": null,
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "251",
              "parent": "1",
              "value": "has user?",
              "xywh": [
                4464,
                2560,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "252",
          "kind": "gateway",
          "ref": "excl",
          "arguments": null,
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "252",
              "parent": "1",
              "value": "feild changed ?",
              "xywh": [
                4464,
                2960,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "253",
          "kind": "expressions",
          "ref": "",
          "arguments": [
            {
              "target": "order.values.user_phone",
              "expr": "user.values.user_phone",
              "type": "String"
            }
          ],
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "253",
              "parent": "1",
              "value": "set field",
              "xywh": [
                5144,
                2760,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "254",
          "kind": "function",
          "ref": "composeRecordsUpdate",
          "arguments": [
            {
              "target": "record",
              "expr": "order",
              "type": "ComposeRecord"
            }
          ],
          "results": [
            {
              "target": "order",
              "expr": "record"
            }
          ],
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "254",
              "parent": "1",
              "value": "update",
              "xywh": [
                5424,
                2760,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "270",
          "kind": "termination",
          "ref": "",
          "arguments": null,
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "270",
              "parent": "1",
              "value": null,
              "xywh": [
                4464,
                3368,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "271",
          "kind": "function",
          "ref": "composeRecordsLookup",
          "arguments": [
            {
              "target": "module",
              "value": "User",
              "type": "Handle"
            },
            {
              "target": "namespace",
              "value": "crm",
              "type": "Handle"
            },
            {
              "target": "record",
              "expr": "order.values.user",
              "type": "ID"
            }
          ],
          "results": [
            {
              "target": "user",
              "expr": "record"
            }
          ],
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "271",
              "parent": "1",
              "value": "Fetch order",
              "xywh": [
                4824,
                3168,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "272",
          "kind": "expressions",
          "ref": "",
          "arguments": [
            {
              "target": "order",
              "expr": "record",
              "type": "ComposeRecord"
            }
          ],
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "272",
              "parent": "1",
              "value": "rename",
              "xywh": [
                4144,
                3168,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "273",
          "kind": "expressions",
          "ref": "",
          "arguments": [
            {
              "target": "user",
              "expr": "record",
              "type": "ComposeRecord"
            }
          ],
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "273",
              "parent": "1",
              "value": "rename",
              "xywh": [
                4144,
                3568,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "274",
          "kind": "iterator",
          "ref": "composeRecordsEach",
          "arguments": [
            {
              "target": "module",
              "value": "Order",
              "type": "Handle"
            },
            {
              "target": "namespace",
              "value": "crm",
              "type": "Handle"
            },
            {
              "target": "query",
              "expr": "\" user = \" + user.recordID",
              "type": "String"
            }
          ],
          "results": [
            {
              "target": "order",
              "expr": "record"
            }
          ],
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "274",
              "parent": "1",
              "value": "fetch users",
              "xywh": [
                4824,
                3568,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "275",
          "kind": "gateway",
          "ref": "excl",
          "arguments": null,
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "275",
              "parent": "1",
              "value": "has user?",
              "xywh": [
                4464,
                3168,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "276",
          "kind": "gateway",
          "ref": "excl",
          "arguments": null,
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "276",
              "parent": "1",
              "value": "feild changed ?",
              "xywh": [
                4464,
                3568,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "277",
          "kind": "expressions",
          "ref": "",
          "arguments": [
            {
              "target": "order.values.user_name",
              "expr": "user.values.user_name",
              "type": "String"
            }
          ],
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "277",
              "parent": "1",
              "value": "set field",
              "xywh": [
                5144,
                3368,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "278",
          "kind": "function",
          "ref": "composeRecordsUpdate",
          "arguments": [
            {
              "target": "record",
              "expr": "order",
              "type": "ComposeRecord"
            }
          ],
          "results": [
            {
              "target": "order",
              "expr": "record"
            }
          ],
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "278",
              "parent": "1",
              "value": "update",
              "xywh": [
                5424,
                3368,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "293",
          "kind": "termination",
          "ref": "",
          "arguments": null,
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "293",
              "parent": "1",
              "value": null,
              "xywh": [
                4456,
                3976,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "294",
          "kind": "function",
          "ref": "composeRecordsLookup",
          "arguments": [
            {
              "target": "module",
              "value": "User",
              "type": "Handle"
            },
            {
              "target": "namespace",
              "value": "crm",
              "type": "Handle"
            },
            {
              "target": "record",
              "expr": "order.values.user",
              "type": "ID"
            }
          ],
          "results": [
            {
              "target": "user",
              "expr": "record"
            }
          ],
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "294",
              "parent": "1",
              "value": "Fetch order",
              "xywh": [
                4816,
                3776,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "295",
          "kind": "expressions",
          "ref": "",
          "arguments": [
            {
              "target": "order",
              "expr": "record",
              "type": "ComposeRecord"
            }
          ],
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "295",
              "parent": "1",
              "value": "rename",
              "xywh": [
                4136,
                3776,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "296",
          "kind": "expressions",
          "ref": "",
          "arguments": [
            {
              "target": "user",
              "expr": "record",
              "type": "ComposeRecord"
            }
          ],
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "296",
              "parent": "1",
              "value": "rename",
              "xywh": [
                4136,
                4176,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "297",
          "kind": "iterator",
          "ref": "composeRecordsEach",
          "arguments": [
            {
              "target": "module",
              "value": "Order",
              "type": "Handle"
            },
            {
              "target": "namespace",
              "value": "crm",
              "type": "Handle"
            },
            {
              "target": "query",
              "expr": "\" user = \" + user.recordID",
              "type": "String"
            }
          ],
          "results": [
            {
              "target": "order",
              "expr": "record"
            }
          ],
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "297",
              "parent": "1",
              "value": "fetch users",
              "xywh": [
                4816,
                4176,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "298",
          "kind": "gateway",
          "ref": "excl",
          "arguments": null,
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "298",
              "parent": "1",
              "value": "has user?",
              "xywh": [
                4456,
                3776,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "299",
          "kind": "gateway",
          "ref": "excl",
          "arguments": null,
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "299",
              "parent": "1",
              "value": "feild changed ?",
              "xywh": [
                4456,
                4176,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "300",
          "kind": "expressions",
          "ref": "",
          "arguments": [
            {
              "target": "order.values.user_id",
              "expr": "user.values.user_id",
              "type": "Integer"
            }
          ],
          "results": null,
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "300",
              "parent": "1",
              "value": "set field",
              "xywh": [
                5136,
                3976,
                200,
                80
              ]
            }
          }
        },
        {
          "stepID": "301",
          "kind": "function",
          "ref": "composeRecordsUpdate",
          "arguments": [
            {
              "target": "record",
              "expr": "order",
              "type": "ComposeRecord"
            }
          ],
          "results": [
            {
              "target": "order",
              "expr": "record"
            }
          ],
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "301",
              "parent": "1",
              "value": "update",
              "xywh": [
                5416,
                3976,
                200,
                80
              ]
            }
          }
        }
      ],
      "paths": [
        {
          "expr": "order.values.user ? true : false",
          "parentID": "251",
          "childID": "247",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "258",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": "#1 - If"
            }
          }
        },
        {
          "parentID": "251",
          "childID": "246",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "259",
              "parent": "1",
              "points": [],
              "style": "exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;",
              "value": "#2 - Else (if)"
            }
          }
        },
        {
          "parentID": "248",
          "childID": "251",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "260",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },

the purpose of this workflow is to keep the module fields up to date
as I need to do export and filter on the fields inside a different module, the workflow copy them

@tjerman attach this to the above

        {
          "expr": "(oldRecord.values.user_phone != user.values.user_phone)",
          "parentID": "252",
          "childID": "250",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "261",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": "#1 - If"
            }
          }
        },
        {
          "parentID": "247",
          "childID": "253",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "262",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "parentID": "253",
          "childID": "254",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "263",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "parentID": "249",
          "childID": "252",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "264",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "parentID": "250",
          "childID": "253",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "265",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;",
              "value": "Body"
            }
          }
        },
        {
          "parentID": "252",
          "childID": "246",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "266",
              "parent": "1",
              "points": [],
              "style": "exitX=0.5;exitY=0;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;",
              "value": "#2 - Else (if)"
            }
          }
        },
        {
          "parentID": "250",
          "childID": "246",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "267",
              "parent": "1",
              "points": [],
              "style": "exitX=0.5;exitY=0;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;",
              "value": "End"
            }
          }
        },
        {
          "expr": "order.values.user ? true : false",
          "parentID": "275",
          "childID": "271",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "281",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": "#1 - If"
            }
          }
        },
        {
          "parentID": "275",
          "childID": "270",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "282",
              "parent": "1",
              "points": [],
              "style": "exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;",
              "value": "#2 - Else (if)"
            }
          }
        },
        {
          "parentID": "272",
          "childID": "275",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "283",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "expr": "(oldRecord.values.user_name != user.values.user_name)",
          "parentID": "276",
          "childID": "274",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "284",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": "#1 - If"
            }
          }
        },
        {
          "parentID": "271",
          "childID": "277",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "285",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "parentID": "277",
          "childID": "278",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "286",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "parentID": "273",
          "childID": "276",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "287",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "parentID": "274",
          "childID": "277",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "288",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;",
              "value": "Body"
            }
          }
        },
        {
          "parentID": "276",
          "childID": "270",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "289",
              "parent": "1",
              "points": [],
              "style": "exitX=0.5;exitY=0;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;",
              "value": "#2 - Else (if)"
            }
          }
        },
        {
          "parentID": "274",
          "childID": "270",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "290",
              "parent": "1",
              "points": [],
              "style": "exitX=0.5;exitY=0;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;",
              "value": "End"
            }
          }
        },
        {
          "expr": "order.values.user ? true : false",
          "parentID": "298",
          "childID": "294",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "304",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": "#1 - If"
            }
          }
        },
        {
          "parentID": "298",
          "childID": "293",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "305",
              "parent": "1",
              "points": [],
              "style": "exitX=0.5;exitY=1;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;",
              "value": "#2 - Else (if)"
            }
          }
        },
        {
          "parentID": "295",
          "childID": "298",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "306",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "expr": "(oldRecord.values.user_id != user.values.user_id)",
          "parentID": "299",
          "childID": "297",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "307",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": "#1 - If"
            }
          }
        },
        {
          "parentID": "294",
          "childID": "300",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "308",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0.5;entryY=0;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "parentID": "300",
          "childID": "301",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "309",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "parentID": "296",
          "childID": "299",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "310",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
              "value": null
            }
          }
        },
        {
          "parentID": "297",
          "childID": "300",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "311",
              "parent": "1",
              "points": [],
              "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;",
              "value": "Body"
            }
          }
        },
        {
          "parentID": "299",
          "childID": "293",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "312",
              "parent": "1",
              "points": [],
              "style": "exitX=0.5;exitY=0;exitDx=0;exitDy=0;entryX=0.5;entryY=1;entryDx=0;entryDy=0;",
              "value": "#2 - Else (if)"
            }
          }
        },
        {
          "parentID": "297",
          "childID": "293",
          "meta": {
            "name": "",
            "description": "",
            "visual": {
              "id": "313",
              "parent": "1",
              "points": [],
              "style": "exitX=0.5;exitY=0;exitDx=0;exitDy=0;entryX=1;entryY=0.5;entryDx=0;entryDy=0;",
              "value": "End"
            }
          }
        }
      ],
      "triggers": [
        {
          "resourceType": "compose:record",
          "eventType": "afterCreate",
          "constraints": [
            {
              "name": "namespace.handle",
              "op": "=",
              "values": [
                "crm"
              ]
            },
            {
              "name": "module.handle",
              "op": "=",
              "values": [
                "Order"
              ]
            }
          ],
          "enabled": true,
          "stepID": "248",
          "meta": {
            "description": "",
            "visual": {
              "edges": [
                {
                  "childID": "248",
                  "meta": {
                    "description": "",
                    "label": "",
                    "visual": {
                      "id": "268",
                      "parent": "1",
                      "points": [],
                      "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
                      "value": null
                    }
                  },
                  "parentID": "256"
                }
              ],
              "id": "256",
              "parent": "1",
              "value": "After Create Order",
              "xywh": [
                3824,
                2560,
                200,
                80
              ]
            }
          }
        },
        {
          "resourceType": "compose:record",
          "eventType": "afterUpdate",
          "constraints": [
            {
              "name": "namespace.handle",
              "op": "=",
              "values": [
                "crm"
              ]
            },
            {
              "name": "module.handle",
              "op": "=",
              "values": [
                "User"
              ]
            }
          ],
          "enabled": true,
          "stepID": "249",
          "meta": {
            "description": "",
            "visual": {
              "edges": [
                {
                  "childID": "249",
                  "meta": {
                    "description": "",
                    "label": "",
                    "visual": {
                      "id": "269",
                      "parent": "1",
                      "points": [],
                      "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
                      "value": null
                    }
                  },
                  "parentID": "257"
                }
              ],
              "id": "257",
              "parent": "1",
              "value": "After Update User",
              "xywh": [
                3824,
                2960,
                200,
                80
              ]
            }
          }
        },
        {
          "resourceType": "compose:record",
          "eventType": "afterUpdate",
          "constraints": [
            {
              "name": "namespace.handle",
              "op": "=",
              "values": [
                "crm"
              ]
            },
            {
              "name": "module.handle",
              "op": "=",
              "values": [
                "User"
              ]
            }
          ],
          "enabled": true,
          "stepID": "273",
          "meta": {
            "description": "",
            "visual": {
              "edges": [
                {
                  "childID": "273",
                  "meta": {
                    "description": "",
                    "label": "",
                    "visual": {
                      "id": "292",
                      "parent": "1",
                      "points": [],
                      "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
                      "value": null
                    }
                  },
                  "parentID": "280"
                }
              ],
              "id": "280",
              "parent": "1",
              "value": "After Update User",
              "xywh": [
                3824,
                3568,
                200,
                80
              ]
            }
          }
        },
        {
          "resourceType": "compose:record",
          "eventType": "afterCreate",
          "constraints": [
            {
              "name": "namespace.handle",
              "op": "=",
              "values": [
                "crm"
              ]
            },
            {
              "name": "module.handle",
              "op": "=",
              "values": [
                "Order"
              ]
            }
          ],
          "enabled": true,
          "stepID": "272",
          "meta": {
            "description": "",
            "visual": {
              "edges": [
                {
                  "childID": "272",
                  "meta": {
                    "description": "",
                    "label": "",
                    "visual": {
                      "id": "291",
                      "parent": "1",
                      "points": [],
                      "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
                      "value": null
                    }
                  },
                  "parentID": "279"
                }
              ],
              "id": "279",
              "parent": "1",
              "value": "After Create Order",
              "xywh": [
                3824,
                3168,
                200,
                80
              ]
            }
          }
        },
        {
          "resourceType": "compose:record",
          "eventType": "afterCreate",
          "constraints": [
            {
              "name": "namespace.handle",
              "op": "=",
              "values": [
                "crm"
              ]
            },
            {
              "name": "module.handle",
              "op": "=",
              "values": [
                "Order"
              ]
            }
          ],
          "enabled": true,
          "stepID": "295",
          "meta": {
            "description": "",
            "visual": {
              "edges": [
                {
                  "childID": "295",
                  "meta": {
                    "description": "",
                    "label": "",
                    "visual": {
                      "id": "315",
                      "parent": "1",
                      "points": [],
                      "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
                      "value": null
                    }
                  },
                  "parentID": "303"
                }
              ],
              "id": "303",
              "parent": "1",
              "value": "After Create Order",
              "xywh": [
                3816,
                3776,
                200,
                80
              ]
            }
          }
        },
        {
          "resourceType": "compose:record",
          "eventType": "afterUpdate",
          "constraints": [
            {
              "name": "namespace.handle",
              "op": "=",
              "values": [
                "crm"
              ]
            },
            {
              "name": "module.handle",
              "op": "=",
              "values": [
                "User"
              ]
            }
          ],
          "enabled": true,
          "stepID": "296",
          "meta": {
            "description": "",
            "visual": {
              "edges": [
                {
                  "childID": "296",
                  "meta": {
                    "description": "",
                    "label": "",
                    "visual": {
                      "id": "314",
                      "parent": "1",
                      "points": [],
                      "style": "exitX=1;exitY=0.5;exitDx=0;exitDy=0;entryX=0;entryY=0.5;entryDx=0;entryDy=0;",
                      "value": null
                    }
                  },
                  "parentID": "302"
                }
              ],
              "id": "302",
              "parent": "1",
              "value": "After Update User",
              "xywh": [
                3816,
                4176,
                200,
                80
              ]
            }
          }
        }
      ]
    }
  ]
}

For future reference, could you please use https://gist.github.com/, https://pastebin.com/, or similar for sharing larger configs such as workflow exports.

I can’t find the step you’ve mentioned in your initial question (step 48); could you tell me what steps now fail? Is your CRM configuration different from what Corteza provided out of the box (in case I’d like to run the workflow on my own)?

At a first glance over the workflow, I see a few duplocated triggers, such as After Create Order and After Update User. I would suggest you don’t have multiple triggers for the same event if you can get away without having them – this could also be what causes the stale data error when updating the order record.

I can take a deeper look a bit later, in the meantime send over which steps error out.

1 Like