PegaRULES initialization failed error during upgrade script execution on DB2
During upgrade from Pega v6.2 SP2 to 7.3.1, below error was encountered during the upgrade.sh script execution on Rulebase. Any thoughts on this?
[java] 2018-04-17 13:19:27,203 [ ftwldsaiu1] [ STANDARD] [ ] [ ] ( internal.mgmt.PREnvironment) ERROR - com.pega.pegarules.pub.PRRuntimeException: Unable to define the cluster name
[java] 2018-04-17 13:19:27,204 [ ftwldsaiu1] [ STANDARD] [ ] [ ] ( etier.impl.EngineStartup) ERROR - PegaRULES initialization failed. Server: ftwldsaiu1
[java] com.pega.pegarules.pub.context.InitializationFailedError: PRNodeImpl init failed
[java] at com.pega.pegarules.session.internal.mgmt.PREnvironment.getThreadAndInitialize(PREnvironment.java:398) ~[prprivate.jar:?]
[java] at com.pega.pegarules.session.internal.PRSessionProviderImpl.getThreadAndInitialize(PRSessionProviderImpl.java:2084) ~[prprivate.jar:?]
[java] at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineStartup.initEngine(EngineStartup.java:671) ~[prprivate.jar:?]
[java] at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl._initEngine_privact(EngineImpl.java:172) ~[prprivate.jar:?]
[java] at com.pega.pegarules.session.internal.engineinterface.etier.impl.EngineImpl.doStartup(EngineImpl.java:145) ~[prprivate.jar:?]
[java] at com.pega.pegarules.session.internal.mgmt.EngineImpl.startEngineImpl(EngineImpl.java:249) ~[prprivate.jar:?]
[java] at com.pega.pegarules.session.internal.mgmt.EngineImpl.startEngine(EngineImpl.java:125) ~[prprivate.jar:?]
[java] at com.pega.pegarules.session.internal.mgmt.EngineImpl.startEngine(EngineImpl.java:111) ~[prprivate.jar:?]
[java] at com.pega.pegarules.exec.internal.util.RuleScannerUtility.establishEnvironment(RuleScannerUtility.java:159) ~[prprivate.jar:?]
[java] at com.pega.pegarules.exec.internal.util.pmd.PreUpgradeRuleAnalyzer.main(PreUpgradeRuleAnalyzer.java:795) ~[prprivate.jar:?]
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:1.7.0_121]
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[?:1.7.0_121]
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:1.7.0_121]
[java] at java.lang.reflect.Method.invoke(Method.java:606) ~[?:1.7.0_121]
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370) ~[prbootstrap-7.3.1-218.jar:7.3.1-218]
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411) ~[prbootstrap-7.3.1-218.jar:7.3.1-218]
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224) ~[prbootstrap-api-7.3.1-218.jar:7.3.1-218]
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273) ~[prbootstrap-api-7.3.1-218.jar:7.3.1-218]
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85) ~[prbootstrap-api-7.3.1-218.jar:7.3.1-218]
[java] Caused by: com.pega.pegarules.pub.PRRuntimeException: Unable to define the cluster name
[java] at com.pega.pegarules.session.internal.mgmt.PRNodeImpl.checkClusterConsistency(PRNodeImpl.java:2824) ~[prprivate.jar:?]
[java] at com.pega.pegarules.session.internal.mgmt.PREnvironment.getThreadAndInitialize(PREnvironment.java:384) ~[prprivate.jar:?]
[java] ... 18 more
[java] Caused by: com.pega.pegarules.pub.database.BadTableMappingException: Database-BadTableMapping-TooManyPropertiesSystem-Status-NodesCATRDBA.pr_sys_statusnodesPegaRULESPYSTARTEDDATETIME , PYACTIVEUSERCOUNT , PZASMCACHECONFIGID , PYSTOPPEDDATETIME , PYINDEXDIRECTORY , PYBATCHINDEXBUILT , PYCLUSTERADDRESS , PYCLEANSHUTDOWN , PYNODENAME , PYCODESETSLIST , PXCREATEDATETIME , PYSYSNODEID , PXCLUSTERID , PZINSKEY , PYINDEXERSTATE , PYLASTPULSEDATETIME , PYLASTINDEXBUILDDATETIME , PYINDEXERADDRESS , PYRUNSTATE , PYSYSTEMNAME , PZSOURCEREVISION , PYSHUTDOWNNOW , PXINSNAME
[java] at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInDataStoreSaveStatementWithoutStream(PageDatabaseMapperImpl.java:1578) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.PageDatabaseMapperImpl.fillInSaveStatementWithoutStream(PageDatabaseMapperImpl.java:1408) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.store.ManagedTransaction.getStatementWithPrepValues(ManagedTransaction.java:1007) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.store.ManagedTransaction.addBatchRdbms(ManagedTransaction.java:909) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.store.ManagedTransaction.performUpdate(ManagedTransaction.java:787) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:890) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.Saver.saveInstance(Saver.java:832) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.UpdateProcessor.performOps(UpdateProcessor.java:1535) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:271) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.UpdateProcessor.action(UpdateProcessor.java:83) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.store.DataStoreManager.doInTransaction(DataStoreManager.java:254) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.UpdateProcessor.processUpdates(UpdateProcessor.java:201) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.Saver.save(Saver.java:711) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.Saver.save(Saver.java:1835) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:2833) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:2824) ~[prprivate.jar:?]
[java] at com.pega.pegarules.data.internal.access.DatabaseImpl.save(DatabaseImpl.java:2815) ~[prprivate.jar:?]
[java] at com.pega.pegarules.cluster.external.SystemNodesDAO.saveNodePage(SystemNodesDAO.java:659) ~[prenginext.jar:?]
[java] at com.pega.pegarules.cluster.external.SystemNodesDAO.createPermanentNode(SystemNodesDAO.java:644) ~[prenginext.jar:?]
[java] at com.pega.pegarules.session.internal.mgmt.PRNodeImpl.checkClusterConsistency(PRNodeImpl.java:2805) ~[prprivate.jar:?]
[java] at com.pega.pegarules.session.internal.mgmt.PREnvironment.getThreadAndInitialize(PREnvironment.java:384) ~[prprivate.jar:?]
[java] ... 18 more
[java] 2018-04-17 13:19:27,206 [ ftwldsaiu1] [ STANDARD] [ ] [ ] ( etier.impl.EngineStartup) INFO - PegaRULES initialization failed. Server: ftwldsaiu1
[java] Apr 17, 2018 1:19:27 PM com.pega.pegarules.internal.bootstrap.PRBootstrap
[java] SEVERE: Problem during method invocation (main)
[java] PegaRULES failed to start; not running test.com.pega.pegarules.pub.PRRuntimeError: Unable to initialize PegaRULES
[java] at com.pega.pegarules.exec.internal.util.RuleScannerUtility.establishEnvironment(RuleScannerUtility.java:169)
[java]
[java] at com.pega.pegarules.exec.internal.util.pmd.PreUpgradeRuleAnalyzer.main(PreUpgradeRuleAnalyzer.java:795)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[java] 2018-04-17 13:19:27,341 [ ftwldsaiu1] [ STANDARD] [ ] [ ] ( internal.mgmt.EngineImpl) ERROR - Enterprise tier failed to initialize properly, PegaRULES not available
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:606)
[java] 2018-04-17 13:19:27,341 [ ftwldsaiu1] [ STANDARD] [ ] [ ] ( internal.mgmt.EngineImpl) INFO - Embedded Environment initialization failed.
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java]
[java] Apr 17, 2018 1:19:27 PM com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega
[java] SEVERE: Problem during method invocation (main)
[java] com.pega.pegarules.pub.PRRuntimeError: Unable to initialize PegaRULES
[java] at com.pega.pegarules.exec.internal.util.RuleScannerUtility.establishEnvironment(RuleScannerUtility.java:169)
[java] at com.pega.pegarules.exec.internal.util.pmd.PreUpgradeRuleAnalyzer.main(PreUpgradeRuleAnalyzer.java:795)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:606)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java]
[java] Exception in thread "ftwldsaiu1" java.lang.RuntimeException: Problem during method invocation (main)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:279)
[java] at com.pega.pegarules.pub.PegaRULES.main(PegaRULES.java:85)
[java] Caused by: com.pega.pegarules.pub.PRRuntimeError: Unable to initialize PegaRULES
[java] at com.pega.pegarules.exec.internal.util.RuleScannerUtility.establishEnvironment(RuleScannerUtility.java:169)
[java] at com.pega.pegarules.exec.internal.util.pmd.PreUpgradeRuleAnalyzer.main(PreUpgradeRuleAnalyzer.java:795)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[java] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
[java] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[java] at java.lang.reflect.Method.invoke(Method.java:606)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethod(PRBootstrap.java:370)
[java] at com.pega.pegarules.internal.bootstrap.PRBootstrap.invokeMethodPropagatingThrowable(PRBootstrap.java:411)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethodPropagatingThrowable(AppServerBridgeToPega.java:224)
[java] at com.pega.pegarules.boot.internal.extbridge.AppServerBridgeToPega.invokeMethod(AppServerBridgeToPega.java:273)
[java] ... 1 more
Posted: 2 years ago
What does the table structure look like in this environment?
That is, the table structure is different between these two version.
Below I've mapped out the properties from the exception indicating which version they appear in (assuming the 6.2SP2 version is still in 7.3.1)
PYSTARTEDDATETIME ,6.2SP2
PYACTIVEUSERCOUNT ,7.3.1
PZASMCACHECONFIGID ,6.2SP2
PYSTOPPEDDATETIME ,6.2SP2
PYINDEXDIRECTORY ,7.3.1
PYBATCHINDEXBUILT ,6.2SP2
PYCLUSTERADDRESS ,7.3.1
PYCLEANSHUTDOWN ,6.2SP2
PYNODENAME ,6.2SP2
PYCODESETSLIST ,6.2SP2
PXCREATEDATETIME ,6.2SP2
PYSYSNODEID ,6.2SP2
PXCLUSTERID ,7.3.1
PZINSKEY ,6.2SP2
PYINDEXERSTATE ,7.3.1
PYLASTPULSEDATETIME ,6.2SP2
PYLASTINDEXBUILDDATETIME ,6.2SP2
PYINDEXERADDRESS ,7.3.1
PYRUNSTATE ,7.3.1
PYSYSTEMNAME ,6.2SP2
PZSOURCEREVISION ,7.3.1
PYSHUTDOWNNOW ,6.2SP2
PXINSNAME 6.2SP2
So do these ones marked in 7.3.1 appear in your PR_SYS_STATUSNODES?
If not, how are you attempting to apply the upgrade schema change? (Automatically through the upgrade.sh script? Or generated in advance with generateddl.sh --action upgrade ?)