Transform map failing at "offboard" workflow attachment.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-02-2023 10:46 AM
We have an onboard / offboard process that comes from Workday. We've had this system for about five years - we ingest a file from Workday once a day, and it runs through a transform map. Once the map processes, a business rule fires for onboards and offboards, using a script include to start the "offboard" process.
As of upgrading to Utah, we've started to encounter an issue where, if a user in the file is being offboarded, the transform errors out with the following error: Import set: ISET0474187 transform stopped due to error: Transaction cancelled: Transaction cancelled. It seems to happen when the catalog item is filled out, the workflow fails to start, or at least fails to attach to the catalog item.
We've attempted to use node logs to find the issue, and it seems to exist in the startWorkflow function. The problem is that in our test environment, the process works normally. We discovered that the test environment was on a different patch, but we applied that patch this weekend, and no change.
06:39:13.712 Debug worker.4 worker.4 txid=2b3849fde106 DEBUG: completed Account Operations Task(46d86313db81b5d425ccba03e296194b): event=execute
06:39:13.714 Info worker.4 worker.4 txid=2b3849fde106 Background message, type:info, message: Workflow 'SP - Offboard - Automated AD' with context fae84d35db61b59425ccba03e29619da terminated 2023-09-28 13:39:13 UTC with : Transaction cancelled: Transaction cancelled
06:39:13.714 Error worker.4 worker.4 txid=2b3849fde106 SEVERE *** ERROR *** Workflow 'SP - Offboard - Automated AD' with context fae84d35db61b59425ccba03e29619da terminated 2023-09-28 13:39:13 UTC with : Transaction cancelled: Transaction cancelled
06:39:13.716 Info worker.4 worker.4 txid=2b3849fde106 Slow business rule 'Start Workflow' on sc_req_item: RITM0850572, time was: 0:00:33.643
06:39:13.718 Info worker.4 worker.4 txid=2b3849fde106 Slow business rule 'Cascade Request Approval to Request Item' on sc_request: REQ0654467, time was: 0:00:33.660
06:39:13.719 Error worker.4 worker.4 txid=2b3849fde106 SEVERE *** ERROR *** *** Script: Error in system logs: Transaction cancelled: Transaction cancelled
06:39:13.719 Info worker.4 worker.4 txid=2b3849fde106 Slow business rule 'Offboard Process' on u_workday_users: Silvia Tijerina, time was: 0:00:35.152
06:39:13.749 Error worker.4 worker.4 txid=2b3849fde106 SEVERE *** ERROR *** Import set: ISET0473756 transform stopped due to error: Transaction cancelled: Transaction cancelled
Further, we're regularly seeing this:
worker.7 txid=fca3e603ec7f DEBUG: Root cause: org.mozilla.javascript.WrappedException: Wrapped org.mozilla.javascript.JavaScriptException: com.glide.sys.TransactionCancelledException: Transaction cancelled: Transaction cancelled (sys_script.700cb3c9ac14657b005f7aaef70e1fc8.script; line 5)
Which points to the block:
startWorkflow(current.cat_item.workflow.toString());
function startWorkflow(id) {
var w = new Workflow();
var context = w.startFlow(id, current, current.operation(), getVars());
if (context != null)
current.context = context.sys_id;
}
where the w.startFlow is the line 5 item. But it matches our test environment.
HI has not been able to help, as the business rule / script include are custom, so we're scratching our heads. Hoping someone might have some advice here.