Question
Infosys
IN
Last activity: 22 May 2020 13:23 EDT
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***