Hello,
There are a few requests with pending status. We need to know how can we change manually the request status from pending to complete?
By the way we know that pending status will be completed when DB collection run again. But in our environment DB collections run once a week because of some performance issues. That is why we would like to do manually before DB collections running.
I hope there are some people who will help us in this matter.
Thanks
Hello Adem,
It not really recommended to update database directly, but you can use below SQL's.
update avuser.t_av_change_requests set current_state='CO' where id=<OID>;
UPDATE avuser.t_av_change_request_details
SET state = 'CO'
WHERE change_requests_id = <OID>
AND state IN ('WD', 'PZ', 'PV');
OID is nothing but id column of t_av_change_requests. Please be careful while doing this operation, if you forgot to mention where clause then it will end-up marking all the requests as complete.
Thanks
Hemant.
Hello Mandle,
Thanks for your quick response.
I totally agree with you. The thing is that we don't want to update database directly. Some tables can be affected accordingly.
Can we do this using RSA Via UI instead of updating database?
Thanks
Steps to complete CR from UI:
Note : Overall CR status will not be 100%.
Hope this helps.
Hello Pargain,
Thanks for your help and response.
The thing is that I am not able to see "Change state" when I click "wait for verification" node.
is it related UI version?
Thanks
Complete all the approvals till manual fulfillment node. Then edit wait for verification node in the activity workflow.
Yes, What Latika is explaining is one of the way of handling it using UI. Please let us know if you would need more help regarding this issue.
Hello Mandle and Pargain,
Thanks for your support.
We did that you mentioned. We can see on completed part.
But State part is still "pending verification". It will be great if state part is completed. How can we do it?
Many thanks for your support
Pending verification state will move to completed only after running collections. At least overall CR is in complete state which was your requirement I guess.
Complete all the approvals till manual fulfillment node. Then edit wait for verification node in the activity workflow.