Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

System is un-responsive after upgrade to 8.1.

SA-75371

Summary



Decisioning Services landing page displays batch nodes in the Unreachable state and the system is un-responsive. The application runs correctly on the Unreachable nodes.
On clicking the Configure-Decisioning-Infrastructure-Services, the page loads after 15 minutes. The Add Node button or the Stop/Decomissiond node actions take 15 minutes to load.


Error Messages



Outbound Node`s state is unreachable.

--------------------------

[.PegaWorkManager : 4] [STANDARD] [ ] [CHIL:01.01.01] (ortDefinitionListSpecification) ERROR   - There is a bad class referenced in the user SQL: Class Data-BatchOutPR3102 does not exist
com.pega.pegarules.pub.database.BadClassDefinitionException: Class Data-BatchOutPR3102 does not exist
    at com.pega.pegarules.data.internal.access.rdb.SQLParser.setClass(SQLParser.java:360) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.rdb.SQLParser.directive(SQLParser.java:765) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.rdb.SQLParser.sql(SQLParser.java:614) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.rdb.SQLParser.parse(SQLParser.java:291) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.RDBListSpecificationImpl.parseAndSetValues(RDBListSpecificationImpl.java:115) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.ReportDefinitionListSpecification.<init>(ReportDefinitionListSpecification.java:425) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.ReportDefinitionListSpecification.<init>(ReportDefinitionListSpecification.java:375) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.ReportDefinitionListSpecification.<init>(ReportDefinitionListSpecification.java:356) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.RDBListSpecificationImpl.<init>(RDBListSpecificationImpl.java:83) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.RDBListSpecificationImpl.<init>(RDBListSpecificationImpl.java:74) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.DatabaseImpl.createRDBListSpec(DatabaseImpl.java:5878) ~[prprivate.jar:?]
    at com.pega.decision.dsm.batch.RDBBatchReader.<init>(RDBBatchReader.java:67) ~[prpublic.jar:?]

[.PegaWorkManager : 5] [STANDARD] [ ] [FIN:01.01.01] (MKT_Data_Outbound_Queue.Action) ERROR   - WriteToFile: Outbound File Batch processing failed. 

com.pega.pegarules.pub.PRRuntimeException: Cannot create rdb list specification for sql batch execution. SQL=SELECT STAG.PXCREATEDATETIME AS "pxCreateDateTime", STAG.PROGRAMRUN AS "ProgramRun", STAG.USERID AS "UserID", STAG.RANKID AS "RankID", STAG.DESTINATIONTYPE AS "DestinationType", STAG.TEMPLATENAME AS "TemplateName", STAG.TREATMENTNAME AS "TreatmentName",  STAG.COLUMNSPAYLOAD AS "ColumnsPayload", STAG.VALUESPAYLOAD AS "ValuesPayload", OFFER.PXIDENTIFIER AS "pxIdentifier", STAG.OFFERCLASSNAME as "OfferClassName" FROM {CLASS: PegaMKT-Data-Outbound-Staging} STAG LEFT OUTER JOIN {CLASS: Data-BatchOutPR4748} OFFER ON STAG.USERID = OFFER. AND STAG.RANKID = OFFER.PXRANK AND STAG.PROGRAMRUN = OFFER.PYWORKID WHERE STAG.DESTINATIONTYPE = 'FILE' AND STAG.STATUS = 'NEW' AND STAG.TEMPLATENAME = 'IbTechHealthCheck' AND STAG.OFFERCLASSNAME = 'Data-BatchOutPR4748'
    at com.pega.decision.dsm.batch.RDBBatchReader.<init>(RDBBatchReader.java:69) ~[prpublic.jar:?]
    at com.pegarules.generated.createSQLBasedIterator_080101_373222742713466010.createSQLBasedIterator08_01_01(createSQLBasedIterator_080101_373222742713466010.java:130) ~[?:?]
    at com.pegarules.generated.createSQLBasedIterator_080101_373222742713466010.invoke(createSQLBasedIterator_080101_373222742713466010.java:106) ~[?:?]
    at com.pega.pegarules.generation.internal.library.LibraryRuntime.resolveAndinvokeFunctionViaReflection(LibraryRuntime.java:222) ~[prprivate.jar:?]
    at com.pega.pegarules.generation.internal.library.LibraryRuntime.invokeLibraryRuntime(LibraryRuntime.java:119) ~[prprivate.jar:?]
    at com.pega.pegarules.session.internal.mgmt.Executable.invokeLibraryRuntime(Executable.java:9234) ~[prprivate.jar:?]
    at com.pega.pegarules.priv.generator.LibrarySupport.resolveAndInvokeFunctionViaReflectionWithException(LibrarySupport.java:275) ~[prpublic.jar:?]
    at java.lang.invoke.DirectHandle.invokeExact_thunkArchetype_L(DirectHandle.java:300) ~[?:2.9]
    at java.lang.invoke.BruteArgumentMoverHandle.invokeExact_thunkArchetype_X(BruteArgumentMoverHandle.java:398) ~[?:2.9]
    at java.lang.invoke.CollectHandle.invokeExact_thunkArchetype_X(CollectHandle.java:122) ~[?:2.9]
    at java.lang.invoke.FilterReturnHandle.invokeExact_thunkArchetype_X(FilterReturnHandle.java:59) ~[?:2.9]
    at java.lang.invoke.AsTypeHandle.invokeExact_thunkArchetype_X(AsTypeHandle.java:49) ~[?:2.9]
    at
Caused by: com.pega.pegarules.pub.database.BadClassDefinitionException: Class Data-BatchOutPR4748 does not exist
    at com.pega.pegarules.data.internal.access.rdb.SQLParser.setClass(SQLParser.java:360) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.rdb.SQLParser.directive(SQLParser.java:765) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.rdb.SQLParser.sql(SQLParser.java:614) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.rdb.SQLParser.parse(SQLParser.java:291) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.RDBListSpecificationImpl.parseAndSetValues(RDBListSpecificationImpl.java:115) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.ReportDefinitionListSpecification.<init>(ReportDefinitionListSpecification.java:425) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.ReportDefinitionListSpecification.<init>(ReportDefinitionListSpecification.java:375) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.ReportDefinitionListSpecification.<init>(ReportDefinitionListSpecification.java:356) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.RDBListSpecificationImpl.<init>(RDBListSpecificationImpl.java:83) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.RDBListSpecificationImpl.<init>(RDBListSpecificationImpl.java:74) ~[prprivate.jar:?]
    at com.pega.pegarules.data.internal.access.DatabaseImpl.createRDBListSpec(DatabaseImpl.java:5878) ~[prprivate.jar:?]
    at com.pega.decision.dsm.batch.RDBBatchReader.<init>(RDBBatchReader.java:67) ~[prpublic.jar:?]
    ... 52 more

[BackgroundProcessing] [ STANDARD] [ ] [ ] (rvice.operation.StartOperation) INFO    - Successfully started service [DataFlow.BackgroundProcessing]
[vice: DataFlow.Batch] [STANDARD] [ ] [ ] (prpc.service.ServiceManager) INFO    - Will start service DataFlow.Batch as it is configured to start in dsm/services
[ploymentLocalTask:28] [STANDARD] [ ] [ ] (rvice.DataFlowDiagnosticLogger) INFO    - TopologyChangedMessage{nodeId=pgmprdout04_pegaoutbound403, serviceInstance=BackgroundProcessing, nodeEvent=JOINED, senderNodeId=pgmprdout04_pegaoutbound403, timestamp=1551860423560, currentCluster=[MemberInfo{address=127.0.0.1, uuid=a0c1a6c5-4b17-4535-be8a-04559000264e, prpcId=pgmprdout01_pegaoutbound101, state=NORMAL}, MemberInfo{uuid=8b620142-1d9b-4cab-a772-9a54c94c4926, prpcId=pgmprdout01_pegaoutbound103, state=UNREACHABLE, errorMessage=Unable to reach the node due to an exception}, MemberInfo{uuid=822ee62c-e74b-4e24-b499-f414342cca24, prpcId=pgmprdout01_pegaoutbound104,



Steps to Reproduce



Restart the application and open the Decisioning Services landing page.


Root Cause



Diagnostic data was included in Pega 8 platform release. That is, when multiple nodes were started simultaneously, multiple nodes were stopped from starting correctly.


Resolution



Apply HFix-51612.

Published April 2, 2019 - Updated December 2, 2021

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

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

Pega Community 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
Contact us