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 Upgrade from 6.3 to 7.2 is not working, missing table



Upgraded to Pega 7.2 split schema.  

​Trying to start the system and it is failing because the column PYCLUSTERADDRESS is not available in the data schema table pr_sys_statusnodes.

The table is also missing some additional columns that should have been added as part of the upgrade.

Error Messages

Caused by SQL Problems.
Problem #1, SQLState 42703, Error code -206: "PYCLUSTERADDRESS" is not valid in the context where it is used.. SQLCODE=-206, SQLSTATE=42703, DRIVER=4.19.56
Problem #2, SQLState 56098, Error code -727: An error occurred during implicit system action type "2". Information returned for the error includes SQLCODE "-206", SQLSTATE "42703" and message tokens "PYCLUSTERADDRESS".. SQLCODE=-727, SQLSTATE=56098, DRIVER=4.19.56
at com.pega.pegarules.cluster.internal.PRClusterImpl.getPRSysStatusNodesInformation(
... 68 more

Steps to Reproduce

Use command line upgrade scripts to perform the upgrade from PRPC 6.3 to Pega 7.2.

Root Cause

Refer to the product documentation:

In the sections that refer to upgrading the rules and data schemas from the command line the property names in the guide incorrectly list the properties to identify the rules and data schema names in the file as pega.rules.schema and instead of and  
For the rules schema upgrade the correct property names, as specified in the file were used.  

​For the data schema upgrade the property was specified correctly but the property was not.  

​As a result the data schema was not updated correctly.


Perform the following local-change: 

Rerun the upgrade of the data schema specifying both the and properties in the file.



Published January 20, 2017 - Updated October 8, 2020

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