Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Sudipta Dey (SudiptaD) Swedbank Software Engineer
Swedbank
SE
SudiptaD Member since 2013 7 posts
Swedbank
Posted: Apr 30, 2019
Last activity: May 9, 2019
Posted: 30 Apr 2019 3:50 EDT
Last activity: 9 May 2019 10:39 EDT
Closed

The response time when clicking on Access Groups is very long

Hi,

Access group landing page is taking too much time to load the page. In our application we have total 8298 operators presents at this moment. I hope for large scale applications this number is not that much. Did anyone of you face this kind of problem in your application before? It will be really helpful if you can help me to solve this problem.

Also i have checked all the backend implementations and everything is final over there. I would really appreciate if you can give me any suggestions.

Thanks,

Sudipta dey

***Edited by Moderator: Pallavi to update platform capability tags***

To see attachments, please log in.
Dev/Designer Studio System Administration

Posted: 5 years ago
Posted: 9 May 2019 10:39 EDT
Sudipta Dey (SudiptaD) Swedbank Software Engineer
Swedbank
SE

Hello Carissa,

Thanks for your reply. Yes there are four alerts first PEGA0005 then two PEGA0001 and after that one PEGA0037. Main root cause that i can think about is because of the query.

 Database operation took more than the threshold of 1000 ms: 149,396 ms SQL: SELECT  Count("PC0"."PYLABEL")  AS "pySummaryCount(1)"  , "PC0"."PYACCESSGROUPADDITIONAL" AS "pyAccessGroupAdditional"  FROM  PEG10_APP_DATA.pr_index_operators "PC0"  WHERE  "PC0"."PXOBJCLASS" = ?  GROUP BY "PC0"."PYACCESSGROUPADDITIONAL" ORDER BY "PC0"."PYACCESSGROUPADDITIONAL"
 
It is taking too much time to get the result set. All of these things are Pega OOTB and final. Can you please suggest something?
To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice