After applying bulk changes on multiple roles involved in one request at the same time.

The request completes, but the roles are stuck in applied state.

If the system is restarted during the creation of change requests related to the Role changes it may leave the Role in applied state.

Bulk Role changes create workflow watches that keep monitoring the CR completion delete the role_id from t_av_roleversion when the change request is completed.  If the system gets restarted the watches may not be cleared.

 

select cr.id,cr.name,rv.* from t_av_roleversions rv join t_av_change_requests cr on rv.cr_id=cr.id where rv.state='A' and cr.current_state='CO' order by cr.id;