Question2Replies227Views×Close popoverDevarajulu Prathapaneni (Deva_Prathapaneni) Cognizant Tech Lead Cognizant SE View ProfileSend Message Deva_Prathapaneni Member since 2014 30 posts Cognizant Posted: April 14, 2019Last activity: April 25, 2019Posted: 14 Apr 2019 10:19 EDTLast activity: 25 Apr 2019 14:32 EDT 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.0030But 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 Enterprise Application Development Dev/Designer Studio ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! 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: 1 year agoPosted: 14 Apr 2019 17:40 EDT×Close popoverKevin Zheng (KevinZheng_GCS) PEGA Director, Software Solutions Engineering Pegasystems Inc. US View ProfileSend MessageKevinZheng_GCS PEGA replied to Deva_PrathapaneniIf 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. Accepted Solution Posted: 1 year agoPosted: 25 Apr 2019 14:32 EDT×Close popoverDevarajulu Prathapaneni (Deva_Prathapaneni) Cognizant Tech Lead Cognizant SE View ProfileSend MessageDeva_Prathapaneni Cognizant replied to Deva_PrathapaneniWe have Materialized view is executing on commit that causes the slowness of workobject commit.