SA-17524

Summary

After adding monitored nodes, errors appear in Autonomic Event Services (AES) node server logs.

Error Messages

Caused by: java.lang.NoClassDefFoundError: com/pega/aes/utils/sql/SQLParser
at java.lang.Class.getDeclaredFields0(Native Method)
at java.lang.Class.privateGetDeclaredFields(Class.java:2499)
at java.lang.Class.privateGetPublicFields(Class.java:2530)
at java.lang.Class.getFields(Class.java:1420)
at com.pega.pegarules.generation.internal.vtable.VirtualTableDependencyTracker.extractExternalDependenciesFrom(VirtualTableDependencyTracker.java:209)
at com.pega.pegarules.generation.internal.vtable.VirtualTableDependencyTracker.checkStateToken(VirtualTableDependencyTracker.java:186)
at com.pega.pegarules.generation.internal.vtable.asm.VirtualTableAssemblyHandler.load(VirtualTableAssemblyHandler.java:343)
at com.pega.pegarules.generation.internal.vtable.asm.VirtualTableAssemblyHandler.loadForAspect(VirtualTableAssemblyHandler.java:155)
at com.pega.pegarules.generation.internal.vtable.containers.ClassNameRuleContainer.upgrade(ClassNameRuleContainer.java:56)
at com.pega.pegarules.generation.internal.vtable.ruleres.VirtualTableCandidate.upgradeContainerFor(VirtualTableCandidate.java:286)
at com.pega.pegarules.generation.internal.vtable.ruleres.VirtualTableCandidate.getExecutableContainerFor(VirtualTableCandidate.java:220)
at com.pega.pegarules.generation.internal.vtable.ruleres.VirtualTableResolver.resolveToContainer(VirtualTableResolver.java:425)
at com.pega.pegarules.generation.internal.vtable.ruleres.VirtualTableResolver.resolveRule(VirtualTableResolver.java:155)
at com.pega.pegarules.generation.internal.vtable.VirtualTableImpl.resolveRule(VirtualTableImpl.java:295)
at com.pega.pegarules.generation.internal.PRGenProviderImpl.get(PRGenProviderImpl.java:474)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3488)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10563)
at com.pegarules.generated.activity.ra_action_processproblemcorrelation_9e90166c7108aad4ec967927436609e8.step8_circum0(ra_action_processproblemcorrelation_9e90166c7108aad4ec967927436609e8.java:1856)
at com.pegarules.generated.activity.ra_action_processproblemcorrelation_9e90166c7108aad4ec967927436609e8.perform(ra_action_processproblemcorrelation_9e90166c7108aad4ec967927436609e8.java:224)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3505)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10563)
at com.pegarules.generated.activity.ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.step29_circum0(ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.java:2870)
at com.pegarules.generated.activity.ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.perform(ra_action_parsealertline_7043315bc4df33f3bf0cd7cd2ba5821e.java:624)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3505)
at com.pega.pegarules.session.internal.mgmt.Executable.invokeActivity(Executable.java:10563)
at com.pegarules.generated.activity.ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.step4_circum0(ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.java:313)
at com.pegarules.generated.activity.ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.perform(ra_action_parsealertlinesoap_7a26e04c4a9359d23c155291fc34db0b.java:103)
at com.pega.pegarules.session.internal.mgmt.Executable.doActivity(Executable.java:3505)
at com.pega.pegarules.session.internal.mgmt.base.ThreadRunner.runActivitiesAlt(ThreadRunner.java:646)
... 104 more
Caused by: java.lang.ClassNotFoundException: com.pega.aes.utils.sql.SQLParser

Steps to Reproduce

1. Install Pega 7.1.9 version
2. Install AES 7.1.7.
3. Configure nodes to monitor the PRPC.
4. AES logs contains these errors

Root Cause

A software use or operation error. Lookup 'com.pega.aes.utils.sql.SQLParser' Class from the SMA>Advanced>Web Tier Runtime Environment Version 1.0. If it returns 'class not found' then possibly,the PegaAES jar was imported with database/AutoDBSchemaChanges DSS set to false.

Thus, the complete AES media did not get imported into the database.

Resolution

Set database or AutoDBSchemaChanges DSS to true, then import AES media jar again.
(or)
Download the schema DDL for AES > Apply it to the DB > Import the AES media jar again.