We are getting db commit time alert PEGA0002 due to DF_CaptureInteraction save operation while running capture interaction activity.
Can any one please suggest how to avoid these type of alerts.
Thanks in advance.
@Mohd Qizer Uddin HI Mohd,
We are getting this commit time pega0002 alert while running commitWithErrorHandling activity. Please suggest how to avoid this alert.
@prasadn1 The PEGA0002 alert is triggered when a database operation takes more than the threshold time.
This could be due to various reasons such as network latency, database load, or inefficient queries.
To avoid this, you can optimize your database operations, ensure efficient network connectivity, and avoid running heavy operations during peak load times. If the issue persists, you may need to investigate the specific queries or operations that are causing the delay. In some cases, the delay could be due to a Materialized view executing on commit, as seen in one of the references. It’s also important to ensure that locks are properly acquired and released to avoid commit fail errors.
This is a GenAI-powered tool. All generated answers require validation against the provided references.
Case create commit takes more than 10 secs.
Could not commit when auto commit set on
How to resolve Pega0002 alert I.E. CSFSSocial:07.22
If you still need help please log a support INC via the MSP and let us know the INC id here.
If you’re happy your issue is resolved, please mark the reply with ‘Accept Solution’ .