Question
PEGA0042: alert meaning
So, i'm a bit confused about this alert.
I'm running a report that generates two alerts: PEGA0005 (after 2 secs) and PEGA0042 (after 2 mins!!)
What i noticed is that the time spent running the query on DB, traced with PEGA0005, is consistente with the time it takes running the same query in a SQL client (2 secs).
It's unclear to me what are the operations carried out by pega, after fetching the records, that takes such a huge time generating the PEGA0042 alert.
I'm a bit at loss here because i have no idea how can i optimize this report since the SQL time spent on DB (2 secs) is well within acceptable range for our users.
Any idea on what generates PEGA0042 alert?
Hello Robert,
Please check article : https://pdn.pega.com/pega0042-alert-packaging-database-query-has-exceeded-operation-time-threshold/pega0042-alert
which explains both Pega0042 and Pega0005 alerts.
However in the alert logs it will display the actual threshold value the query has taken to execute.
As suggested can make changes to below entry in prconfig.xml accordingly
<env name="alerts/database/operationTimeThreshold" value="500" />
Regards,
Shanthini Charles