Question
2
Replies
227
Views
Cognizant
Posted: April 14, 2019
Last activity: April 25, 2019
Closed
Solved
Case create commit takes more than 10 secs.
Hi All,
We are creating CPM interaction case and we are receiving PEGA0002 alert in CommitWithErrorHandling activity. When we analayse the DB queries executed in it is as follows in secs.
1. Work table insert query- 0.0140
2. Pca_indexinteraction merge query - 0.0110
3. Pc_assign_worklist merge query - 0.0130
4. History insert query-0.0030
But end of this query execution i can find PEGA0002 with 14 secs. Not able to find any other queries or commits.
How to find where is this time taken.
Thanks,
Deva
Accepted Solution
Posted: 1 year ago
We have Materialized view is executing on commit that causes the slowness of workobject commit.
If you turn on the debug log of the activity, you should see which step taking how much time:
Rule_Obj_Activity.commitWithErrorHandling.Work_.Action
Is it 'commit' step? If yes, it may be due to deferred save, which takes more time than individual query.