Question

2
Replies
58
Views
Pradeep Chowdary Pydi (PradeepPydi)
Anthem
Senior PEGA DEVOPS and Cloud Administrator
Anthem
IN
PradeepPydi Member since 2017 221 posts
Anthem
Posted: December 4, 2018
Last activity: December 6, 2018
Posted: 4 Dec 2018 15:05 EST
Last activity: 6 Dec 2018 6:19 EST
Closed

AES Database performance review

Hi Andy,


Could you please review the attached AES database related AWR and PegaRules and PegaAlert logs and provide subsequent recommendations.


AES 731 and Monitored nodes version 731.


Following errors and SQL queries are observed high in number :


From PegaRules log :


1) 2018-12-04 00:01:02,646 [ PegaRULES-Batch-3] [ STANDARD] [ ] [ AES:07.30] ( internal.mgmt.Executable) ERROR Rule-Connect-SOAP.PegaAES-Data-RSSnapshot.GetRuleSetSnapshot - Exception

com.pega.pegarules.pub.services.ResourceUnavailableException: SOAP service failed

Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target


2)2018-12-04 00:30:17,662 [ttp-nio-8080-exec-62] [ STANDARD] [ ] [ AES:07.30] ( internal.util.PRParseUtils) ERROR va10n40604|10.100.106.74|SOAP|PegaAES|Events|logAlert|A2R1EOW0OWA9AFZ6S082F2EH1GSH5KFVM - XML parsing failed

com.pega.pegarules.pub.PRException: Failed to parse XML. Error: Content is not allowed in prolog.


PegaAlert Logs :


1) Database operation took more than the threshold of 500 ms: 58,857 ms SQL: DELETE FROM DEVKM_PEGADATA.pegaam_alert "PC0" WHERE ( ( "PC0"."CLUSTERNAME" = ? ) AND ( "PC0"."GENERATEDDATETIME" ? ) ) AND "PC0"."PXOBJCLASS" = ?

Last Input : PegaAES-.CallcleanupAESAgent

Show More

Hi Andy,

Could you please review the attached AES database related AWR and PegaRules and PegaAlert logs and provide subsequent recommendations.

AES 731 and Monitored nodes version 731.

Following errors and SQL queries are observed high in number :

From PegaRules log :

1) 2018-12-04 00:01:02,646 [ PegaRULES-Batch-3] [ STANDARD] [ ] [ AES:07.30] ( internal.mgmt.Executable) ERROR Rule-Connect-SOAP.PegaAES-Data-RSSnapshot.GetRuleSetSnapshot - Exception
com.pega.pegarules.pub.services.ResourceUnavailableException: SOAP service failed
Caused by: sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target

2)2018-12-04 00:30:17,662 [ttp-nio-8080-exec-62] [ STANDARD] [ ] [ AES:07.30] ( internal.util.PRParseUtils) ERROR va10n40604|10.100.106.74|SOAP|PegaAES|Events|logAlert|A2R1EOW0OWA9AFZ6S082F2EH1GSH5KFVM - XML parsing failed
com.pega.pegarules.pub.PRException: Failed to parse XML. Error: Content is not allowed in prolog.

PegaAlert Logs :

1) Database operation took more than the threshold of 500 ms: 58,857 ms SQL: DELETE FROM DEVKM_PEGADATA.pegaam_alert "PC0" WHERE ( ( "PC0"."CLUSTERNAME" = ? ) AND ( "PC0"."GENERATEDDATETIME" ? ) ) AND "PC0"."PXOBJCLASS" = ?
Last Input : PegaAES-.CallcleanupAESAgent

2)Database operation took more than the threshold of 500 ms: 8,406 ms SQL: SELECT COUNT(ASTERISK) AS "pySummaryCount(1)" , MIN("PC0"."GENERATEDDATETIME") AS "pySummaryDateTime(1)" , MAX("PC0"."GENERATEDDATETIME") AS "pySummaryDateTime(2)" FROM DEVKM_PEGADATA.pegaam_exception "PC0" WHERE ( "PC0"."PROBLEMCORRELATION" = ? ) AND "PC0"."PXOBJCLASS" = ?

Show Less
Pega Autonomic Event Services Data Integration
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.