Question

3
Replies
1684
Views
 Anandh Palanisamy (Anandh Palanisamy)
Ford Motor Company

Ford Motor Company
US
Anandh Palanisamy Member since 2013 62 posts
Ford Motor Company
Posted: May 13, 2018
Last activity: May 14, 2018
Posted: 13 May 2018 22:09 EDT
Last activity: 14 May 2018 10:16 EDT
Closed

Clearing SLA table entries in Pega 7.3.1

Hi,

Can you please let me know, can we clear SLA entries in the SLA table. We did the upgrade from 6.2 to 7.3.

Is that good advice or best pratice to clear those entries from SLA table?

Regards,

Anandh

Reporting
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 3 years ago
Posted: 14 May 2018 2:46 EDT
Vikash Ranjan Karn (Vikash Karn)
PEGA
Senior Technical Solutions Engineer
Pegasystems Inc.
IN

Hi Anandh,


By SLA table do you mean PR_SYS_QUEUE_SLA? 


Whenever the process reach an assignment which has an SLA defined on it, a record is created in pr_sys_queue_sla table which contains information of the assignment, sla goal,deadline etc.


Please check the link below link which might help you:


https://pdn.pega.com/community/pega-product-support/question/prsysqueuesla-table


 


Regards,


Vikash


 
Posted: 3 years ago
Posted: 14 May 2018 9:47 EDT
Anandh Palanisamy (Anandh Palanisamy)
Ford Motor Company

Ford Motor Company
US

Yes Vikash,  PR_SYS_QUEUE_SLA table.


We know, its holding a information about assignment, is that way to clearing those entries or what else we need to consider while deleting those records?


Regards,


Anandh
Posted: 3 years ago
Posted: 14 May 2018 10:16 EDT
Carissa Wenhardt (CarissaW_GCS)
PEGA
Principal Software Solutions Engineer
Pegasystems Inc.
US

The items in a Scheduled status are those that have not yet reached the point when they are to be processed. If you remove those, then the SLA will not be processed on your work objects.


You should review the items in a Broken-Process status to see if they need to be requeued. If they are no longer needed then you can remove those items.