Question7Replies210Views SREECHARAN Member since 2011 21 posts Cognizant Technologies Solutions US Posted: 8 months agoLast activity: 8 months 2 weeks ago pr_sys_statusnodes table emptyHello Team,am seeing pr_sys_statusnodes table is empty even after JVM recycle, db user id which we using has access to this table. Will anyone please let me know what are the consequences that occur and how can we update this table with entries. Pega Platform System Administration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Posted: 8 months agoKevinZheng_GCS PEGA replied to SREECHARANwhat is your database platform and pega platform version? Posted: 8 months agoSREECHARAN Cognizant Technologies Solutions US replied to KevinZheng_GCSHello Kevin, We are on Oracle12c with Pega v8.1.1 Thanks Posted: 8 months agoAnthony_Gourtay Altran replied to SREECHARANHello, Can you please check whether this table is not existing in both DATA & RULES schema. Then it could be that your synonym table is pointing to the table not used by the system leading to an empty table. Regards Anthony Posted: 8 months agoSREECHARAN Cognizant Technologies Solutions US replied to SREECHARANThanks Anthony, Kevin for reply. we recycled JVM's by truncating db cache.. now am seeing entries. But still not sure why earlier table was empty. Posted: 8 months agoHarish_GCS PEGA replied to SREECHARANHi, This table holds the node(s) information and each record represents a node(JVM) in order to form a cluster.Please note that in 8.x versions, upon clean shutdown of any node will remove its own record from this table and restarting the node will insert the record in the table again. Let me know if this clarifies! Posted: 8 months agoAnthony_Gourtay Altran replied to Harish_GCSDear Harish,Could you please clarify what is meant behind a "clean shutdown" and the difference with a normal shutdown?is this linked to prconfig/initialization/rebuildlocalcachesonnodestart/default which is either true or false?Then, if the entry is removed from the table during clean shutdown, does it mean that the nodeID changes? if not, where is it stored? Thank youRegardsAnthony Posted: 8 months agoHarish_GCS PEGA replied to SREECHARANHi, 1). An app server shutdown command going through a proper shutdown hook to end the JVM process without needing to force kill the Java process is a clean shutdown (normal), unlike the force shutdown.Eg:- Running shutdown.bat/sh for Tomcat. 2). rebuildlocalcachesonnodestart setting is not linked to this process. It influences whether to rebuild local caches on each JVM start. 3). Node entry gets removed upon clean shutdown and it doesn't mean that nodeID will get changed. NodeID is stored as an instance of "Data-Admin-Nodes" under pr_data_admin table. Let me know if this answers your queries.