Question

4
Replies
3489
Views
RobertoB5433 Member since 2014 5 posts
Reply
Posted: 3 years ago
Last activity: 3 years 3 months ago
Closed

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?

System Administration
Close popover
Moderation Team has archived post
Posted: 3 years ago

Hello Robert,


Please check article : https://pdn.pega.com/pega0042-alert-packaging-database-query-has-exceed…


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

Posted: 3 years ago

Hi, thank you both for your feedback!


Sadly in those articles it's not clearly explained what are the reasons behind a PEGA0042 alert. I really can't figure out what "packaging of the query" means. DB time time and fetching of the results seems to occour before PEGA0005 alert which is consistent to the observation that the same query executed in a SQL client takes the same time (2 secs).


Given those evidences working on query optimization doesn't seems to get any appreciable result in the overall execution time. 


So i'm still left wondering what's happening between PEGA0005 alert and PEGA0042 one.


I'm aware that i can configure threshold time for the alerts but the main problem here is not having an alert traced in the logs but the fact that the user has to wait 2 mins to view the report

Posted: 3 years ago

Hi Roberto


Just out of interest, how are you measuring the query time directly?


That is, normally when I run a query directly in, say SQLDeveloper, I can see results faster than the real time needed to complete the query. I believe this is because it just performing the first fetch/display of those results.


Whereas if you want to measure the actual time it took to complete the query then you're probably need to wrap this into a block of SQL (I'd tend to wrap this into a cursor in PL/SQL on Oracle), so I can get an idea of the definitive start/end time.


Is this something that you've done already?


Thanks


Laurence
Share this page LinkedIn
Copied!