Question
Swedbank AB
SE
Last activity: 25 Apr 2019 14:32 EDT
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
Swedbank AB
SE
We have Materialized view is executing on commit that causes the slowness of workobject commit.
Pegasystems Inc.
US
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.