Question

6
Replies
115
Views
HarishR7728 Member since 2017 1 post
Infosys
Posted: November 25, 2019
Last activity: May 22, 2020

SLA processing (Overall SLA) is happening even after cases are Resolved

SLA processing is happening even after cases are Resolved. This is creating ‘Error: Agent Exception’ in WB table and also SLA table

Workbasket Query :

Select * from pega_data.pc_assign_workbasket where PYASSIGNMENTSTATUS like 'Error: Agent Exception' and PXREFOBJECTINSNAME in(Select pyid from pega_data.WorkTable where pystatuswork like 'Resolved-%' and pyid like'I-%')

SLA Table Query:

Select * from PEGA_DATA.pr_sys_queue_sla where PXINSNAME in (Select pxREFQUEUEKEY from pega_data.pc_assign_workbasket where PYASSIGNMENTSTATUS like 'Error: Agent Exception'and PXREFOBJECTINSNAME in(Select pyid from pega_data.WORKTABLE where pystatuswork like 'Resolved-%' and pyid like'I-%'))

Please let me know the root cause and solution for this issue.

***Edited by Moderator: Lochan to update platform capability tags***

Pega Platform Case Management
Share this page LinkedIn