Requested Item is "Cancelled" before the REQ was Approved.
Any supported release
Bad query in one of the RunScript activity which updates the 'sc_req_item' record.
ResolutionThe REQ workflow had a RunScript activity in the workflow after an Approval activity.
This activity has been connected to the "Rejected" condition of the Approval activity.
From here, once the Approval is "Rejected" on the REQ, the RunScript queries 'sc_req_item' table and update the state to "Cancelled".
But the script has below piece of code:
var rec = new GlideRecord('sc_req_item');
rec.addQuery('request.getDisplayValue()', current.number);from the above code is not valid.
So, based on the other query, it grabs all the Active requested item records and update the State to '9' (cancelled).
Replacing the invalid query with
rec.addQuery('request.number', current.number);resolves the issue.