Question

List of System Nodes Outdated in Designer Studio and AES

We frequently replace our Pega JBoss Application server nodes. This causes a new node to be created in the System Nodes list. However, the old nodes still show up with the node id's that were previously existing. Is there a way to cleanup these stale instances of Nodes.

Go to Designer Studio--->System--->General--->Systems,Nodes,Requestors

There is a Nodes list at the bottom

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Correct Answer
February 16, 2016 - 2:22pm

There is a OOTB activity 'RemoveOldNodes' that you can run to remove the old nodes from the list.

Comments

Keep up to date on this post and subscribe to comments

November 3, 2015 - 12:59pm

Hi Abhishek,

You can tally these Node IDs in table pr_sys_statusnodes .

You can review Data in this table and take appropriate decision for maitainability.

November 3, 2015 - 1:05pm
Response to ARVINDMALAV

Thanks for the response Arvind. I am able to see them in the table mentioned, but they also have records for old nodes which do not even exist. The list in Designer Studio and this table tallies, but how do I cleanup old nodes? Is it safe to just drop those records from this table? Or is this table just a list but the actual information comes from somewhere else?

November 3, 2015 - 1:44pm
Response to AbubakerS

I assume, this is development environment, so you can play around safely.

you can take backup of data of this table, delete the content of table and restart the server.

Re-starting of server makes current node entry in this table.

kindly post the results after performing this test.

November 4, 2015 - 12:43pm
Response to ARVINDMALAV

I deleted some rows from the pr_sys_statusnodes table but they were still showing up in the Designer Studio

November 4, 2015 - 1:35pm
Response to AbubakerS

Did you restart server?

November 4, 2015 - 1:37pm
Response to ARVINDMALAV

Yes I did

Pega
November 4, 2015 - 3:11am

The reason to keep the node information in AES is to be able to know which node generate the alerts or exceptions. Deleting the node details will not give you that detail. That said, based on your use case, you can delete the specific nodes which are no longer in use. Pega platform has no OOTB mechanism because we don't know if the node has been shut down and will be restarted or the node will no longer ever come back up.

November 4, 2015 - 12:45pm
Response to nistr

Yes it makes sense that Pega may not know if the node has been shut down and will be restarted or the node will no longer ever come back up. But I am sure the nodes list that shows up should be coming from either in some file on Filesystem or some Table, so I was looking to find out what that location is so that I can bulk manage it.

November 4, 2015 - 3:29pm
Response to AbubakerS

Hi Abubaker, use Pega tracer and see where records are read from.

December 9, 2015 - 2:05am

How does creating a new domain name (keeping the old one as is) affects the System Nodes. In our case new System Nodes got created and when the app server is bounced, one of the existing NodeIDs is picked up randomly. Why is it picking a different NodeID every time we bounce the app server? This keeps the search functionality breaking (unless we add multiple Host Node IDs under 'Search Index Host Node Setting). Just for a single node environment, I see 4 System Node instances (big mess) and I see proportionate number of Agent Schedule instances for all agents with an X factor of 4. I see two records in pr_sys_statusnodes table. Appreciate if someone could share ideas on deleting these System Nodes, What gets affected if we get rid off the old domain name and does it have affect on WebSphere profiles etc?

January 29, 2016 - 10:37am
Response to GovardhanGangavaram

We are having a similar issue. Did you get any answer on this?

February 16, 2016 - 2:22pm
Response to PatrickC8660

There is a OOTB activity 'RemoveOldNodes' that you can run to remove the old nodes from the list.

October 3, 2016 - 11:20am

Recently needed to truncate pr_sys_statusnodes on 7.2.1 to resolve an issue with JBoss startup ("This node not found in the database - Either the record was never saved or was deleted. Unable to join the cluster "). This resolved the issue. However, after logging in and viewing the "Systems, Nodes, Requestors" landing page, we see the old node is still referenced. This article references using RemoveOldNodes activity to clean up this data. But, this activity appears to delete records from pr_sys_statusnodes - which had been truncated. Furthermore, tracing this landing page, the data is coming from Data-Admin-Nodes which maps to pegadata.pr_data_admin. Is there another activity to clear this table?