Items Stuck In Workflow
🤔 Problem
Transfers posted, but are still showing up in workflow with null, busy or missing status.
Example ticket WESS-4018
🌱 Solution
To solve this issue, the steps below must be taken.
The query below must be modified to look for the specific transfers
- CODE
select * from workflow_events where entity_number IN ('11175','11942','12107') and entity_type like '%transfer%' order by entity_number, id desc
If each Transfer has a record in workflow_events with a status of ‘Posting’, then we know everything updated and all that was left was unlocking lines, clearing workflow, and updating the status.
The sql below needs to be run when transfers fail at this stage
- CODE
-- Set to posted. --UPDATE upstream_owner_transfers SET status = 'Posted', date_posted = '2020-08-06' select * from upstream_owner_transfers WHERE number = '11720' -- Clear lock reasons from LOIs. --UPDATE loi SET loi.upstream_lock_reason_id = NULL select * FROM upstream_lines_of_interest loi JOIN upstream_lock_reasons lr ON loi.upstream_lock_reason_id = lr.id WHERE locking_object_id IN (SELECT id FROM upstream_owner_transfers WHERE number = '11720') AND locking_object_type like '%transfer%' -- Clear lock reasons. --DELETE upstream_lock_reasons Select * From upstream_lock_reasons WHERE locking_object_id IN (SELECT id FROM upstream_owner_transfers WHERE number = '11720') AND locking_object_type like '%transfer%' -- Clear workflow activity for transfers --Delete RUOTE_WF_DOCUMENTS select * from RUOTE_WF_DOCUMENTS rwfd join workflow_events we on rwfd.WFID = we.wfid where we.entity_type like '%transfer%' --and we.entity_number IN ('11720')