We are building new provisioning commands to an oracle database and for some reason it defaults to Canceled every time without notice. What causes Work Items to be canceled?
Data
${jobUserData_username}
${jobUserData_FIRST_NAME}
${jobUserData_last_name}
${jobUserData_middle_initial}
${jobUserData_email_address}
${jobUserData_SUPERVISOR_IAM_ID}
${jobUserData_IAM_ID}
${jobUserData_Start_Date}
Query
SELECT u.first_name
, u.last_name
, u.middle_initial
, SUBSTR(u.first_name,1,1)||u.middle_initial||u.last_name AS username
, u.email_address
, s.user_id AS SUPERVISOR_IAM_ID
, u.user_id AS IAM_ID
, u.cost_center
, sysdate as Start_Date
from avuser.pv_users u, avuser.pv_users s
where s.id = u.supervisor_id
and u.id = (select distinct(affected_user_id)
from avuser.pv_change_request_activity
where change_request_id= '${access_request_requestID}'
and value_type = 'User')
Can you try delete the Provisioning Command node, save the workflow,
then open workflow and create back the Provisioning Command node. Save workflow and test again.
If the Provisioning Command still get cancelled, then replace Provisioning Command with different node object like "Email" or "Create Admin Error" and try again.