Approval Queue issue in monitoring tab

[Former Member]

Hi All,

SAP IDM 7.2 SP8, DB2 Database

I have an issue that monitoring tab shows many old entries in "Approval Queue" which does not exist anymore in Tabs ToDo/Approval Management and

IDM tables mxi_approver, mxi_approval and mxi_approval_pending_action .

Below is the screenshot.

I have verified during testing that after approval/decline/timeout of pending approval requests, new entries get removed from the approval queue in monitoring tab and also from ToDo and above mentioned IDM tables.

I have below questions

1. From where these entries could come up if not in ToDo and above mentioned IDM tables ?

2. Where I can see these entries in IDM tables/views ?

3. How to cleanup them ?

Thank you very much in advance.

Regards,

Pradeep

Message was edited by: Pradeep Singh Rawat

[ChrisPS · Accepted solution]

Hello Pradeep,
                       just to update the status here that this behaviour is under investigation by SAP through incident. Some technical background for documentation purposes - the approval queue is based on view mxvw_approval. This view does not take into account the mxi_approv* tables views rather the tasks and entry tables/views. We will update once root cause/solution is identified.

Regards,

Chris

SAP AGS

[Former Member · Accepted solution]

Hi Chris,

Thank you.

I see that incident has been sent to SAP Dev team.

Once I get the solution from SAP, I would updated it here and close the thread.

Thank you.

Kind Regards,

Pradeep