Support Article
System is un-responsive after upgrade to 8.1.
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
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.