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')
You can try enabling the Wait for result checkbox (screenshot below).
See the following article for additional information - 000034403 - Provisioning node CommandStatusCode and CommandStatusMessage in RSA Identity Governance & Lifecycle
Also I would check the logs for errors (aveksaServer.log and Workpoint.log)