I have a request which follows the old workflow. But the Workflow is still in the system and active. It stuck in an execution in the below status tab it says Unsupported Validation but the validation for the execution is the generic Numeric text field validation. Here are the screen shots. Do you have any idea how can I move thr request to the further steps?
Just go to the execution step in the workflow and then check whether the used validation is enabled or not. And also check what values are in the validation, is it returing the all possible values as shown in the outgoing arrows from that step.
Hi Mohit, The sql in the execution return a number, 2 and the transition arrows are !=0 or 0 so I think the transitions does not have a problem. Also, the validation is enabled. the validation is "Numeric Text field" which has all the from -999999 to 999999 so I think it does not have any problem with the return values.
The execution returns the number of the reference request attached to this request which is 2 in this case.
I checked the transaction log, it did not throw any error on the that log. I ca not do anything with the request so I can not trace the log. It does not give me any button or any reaction. It is completely stuck .
Admin is already defined in the securtiy tab. I even change the type of the execution to the manual but it does not give the action buttons. Because something went wrong with this execution. I even try to use move function but it did not work.
This error is in the Prod environment I can not restart the server as I wish. I have to wait till after work hours . Since this is production I can not replicte the issue.
I use this command to move ksc_move_request_workflow REQUEST_ID="[REQD.P.REQUEST_NO]" FROM_WORKFLOW_STEP_SEQ="[REQD.P.CURRENT_STEP]" EVENT_NAME="FORCE_TRANSITION" TO_WORKFLOW_STEP_SEQ="[REQD.P.TO_STEP]" RESULT_VISIBLE_VALUE="Succeeded"
then run the kcrt_request_util.move_request_workflow procedure, it will print out a group_id, run the following query with this group_id, it will tell you why it doesn't move the step.
SELECT * FROM knta_interface_errors WHERE group_id = :group_id AND message_type_id IN (10) AND NOT EXISTS (SELECT 'INTERFACE HAS 5 AND 7' FROM kwfl_transactions_int WHERE process_phase = 5 AND process_status = 7);
For proceeding this stuck request further, you can go for the above suggested solutions. However for permanent fix of this problem, you can implement as suggested below:
What you can do is: just return two values (Say 'Yes' and 'No') from the execution step and use a validation (say 'Yes/No dropdown list). In the execution step, use a function which calculates the number of refrence requests. If the refrences calculates to Zero (0) then return 'No' else return 'Yes'.