SA-24521

Summary

There is an error message 'DNodeException: Cannot execute modification statement' in a Pega 7.2 multi-node environment.

The error occurs as part of processing a headless SOAP request. The requesting client is affected.

Error Messages

com.pega.dsm.dnode.api.DNodeException: Cannot execute modification statement
at com.pega.dsm.dnode.impl.cassandra.CassandraDao.executeStatement(CassandraDao.java:172)
at com.pega.dsm.dnode.impl.cassandra.CassandraDataRepository.insert(CassandraDataRepository.java:244)
at com.pega.dsm.dnode.impl.dataset.cassandra.CassandraSaveOperation$2.emit(CassandraSaveOperation.java:104)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl$SafeDataSubscriber.subscribe(DataObservableImpl.java:320)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl.subscribe(DataObservableImpl.java:52)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl.await(DataObservableImpl.java:98)
at com.pega.dsm.dnode.impl.stream.DataObservableImpl.await(DataObservableImpl.java:87)
at com.pega.dsm.dnode.impl.dataflow.strategy.DelayedLearning.saveResultsForDelayedLearning(DelayedLearning.java:53)
at com.pega.dsm.dnode.impl.dataflow.strategy.StrategyStageProcessor.onNext(StrategyStageProcessor.java:158)
... 98 more

HazelCase Logs - 

2016-05-03 11:58:40,668 [c-operation.thread-1] [                    ] [                    ] (zelcast.cluster.ClusterService) INFO    - [YourServerIPAddressOne]:5702 [141268a7c70f4f3c888d24752499eb74] [3.4.1] Master Address[YourServerIPAddressTwo]:5702 left the cluster. Assigning new master Member [YourServerIPAddressOne]:5702 this
2016-05-03 11:58:40,678 [c-operation.thread-1] [                    ] [                    ] (zelcast.cluster.ClusterService) INFO    - [YourServerIPAddressOne]:5702 [141268a7c70f4f3c888d24752499eb74] [3.4.1] Removing Member [YourServerIPAddressTwo]:5702
2016-05-03 11:58:40,681 [9eb74.IO.thread-in-0] [                    ] [                    ] (       nio.tcp.TcpIpConnection) INFO    - [YourServerIPAddressOne]:5702 [141268a7c70f4f3c888d24752499eb74] [3.4.1] Connection [Address[YourServerIPAddressTwo]:5702] lost. Reason: java.io.EOFException[Remote socket closed!]
2016-05-03 11:58:40,681 [9eb74.IO.thread-in-0] [                    ] [                    ] (           nio.tcp.ReadHandler) WARN    - [YourServerIPAddressOne]:5702 [141268a7c70f4f3c888d24752499eb74] [3.4.1] hz._hzInstance_2_141268a7c70f4f3c888d24752499eb74.IO.thread-in-0 Closing socket to endpoint Address[YourServerIPAddressTwo]:5702, Cause:java.io.EOFException: Remote socket closed!
2016-05-03 11:58:40,687 [c-operation.thread-1] [                    ] [                    ] (zelcast.cluster.ClusterService) INFO    - [YourServerIPAddressOne]:5702 [141268a7c70f4f3c888d24752499eb74] [3.4.1] 

Steps to Reproduce

Not known

Root Cause

The nodes are decommissioned before being taken out of service.

Resolution

Perform the following local change:

Change the D-Node topology to specify the minimum number of nodes needed. Typically, this number is 1 more than the number of replicates.

For more information, see the following PDN resources:
Pega 7.2 Help topic
https://pdn.pega.com/sites/default/files/help_v72/procomhelpmain.htm#basics/v6portal/landingpages/decisioning/dnodecluster.htm
Decision Strategy Manager 7.2 D-Node Operations Guide
https://pdn.pega.com/documents/decision-strategy-manager-d-node-operations-guide-72