8.4p3
Hi Sailors,
For one of the our certification campaigns, certifiers are getting reminders even after signing off their reviews. The campaign is active. Check Expired work Items task runs daily.
Have any idea?
@gkiris1 To rule out mailbox issue, can you check the emailSent audit in advanced analytics. If the creation date is before signoff, it could be mailbox delivery delay.
Hi Sivaprakash,
I can see that emailSent records are after signoff date. Even today a new email sent and visible in audit.
@gkiris1 Could you please check access review work item is still open for the respective certification which was signed off. If its open, you can delete them—provided you have confirmed that the sign-off is complete.
select * from spt_work_item where certification='certification_id';
@gkiris1 Quite possible that approvers can’t approve their own access and that kept the cert to remain open. Please check that. You can use the query provide by @SivaprakashRNTBCI to know if there are any open work items for certification.
@gkiris1 When the workitem gets completed, it will be moved to archive. but sometimes it might get stuck/duplicated. You can delete the workitem object to stop the reminder notification. Keep the workitem archive object.
Thank you for your quick response. We have at least 4 different users with the same problem for the same certification campaign. Do you have any idea how we can find other users with the same problem?
@gkiris1 Use below query to get the open workitems for certifications which are already signed off.
select w.name from spt_certification c, spt_work_item w
where c.id=w.certification and c.signed != null;
while running the query select w.name from spt_certification c, spt_work_item w
where c.id=w.certification and c.signed != null; i am not geting any results but i can see open workitems which are signedoff by user and any reason why this issue occured. we are recently upgraded to 8.5 and it was old certification which was activated after upgrade
