Support Article
PegaRULES initialization failed during update
SA-21097
Summary
When updating from Pega 7.1.5 to 7.1.9 the PegaRULES engine fails to initialize, and causes the update process to abort.
Error Messages
2016-03-07 10:07:53,951 [ <ID>] [ ] [ ] ( etier.impl.EngineStartup) ERROR - PegaRULES initialization failed. Server: vslmlopsd1
com.pega.pegarules.pub.context.InitializationFailedError: PRNodeImpl init failed
at com.pega.pegarules.session.internal.mgmt.PREnvironment.getThreadAndInitialize(PREnvironment.java:396)
at com.pega.pegarules.session.internal.PRSessionProviderImpl.getThreadAndInitialize(PRSessionProviderImpl.java:1998)
Caused by: com.pega.pegarules.pub.PRRuntimeError: Problem initializing Connection Manager
at com.pega.pegarules.data.internal.access.DatabaseImpl.<init>(DatabaseImpl.java:1753)
at com.pega.pegarules.data.internal.access.DatabaseImpl.newDatabaseImpl(DatabaseImpl.java:1666)
at com.pega.pegarules.data.internal.access.DatabaseImpl.newDatabaseImpl(DatabaseImpl.java:1661)
at com.pega.pegarules.data.internal.PRDataProviderImpl.ctorDatabaseImpl(PRDataProviderImpl.java:790)
... 18 more
Caused by: com.pega.pegarules.pub.database.DatabaseException: Database-General Unable to check for obsolete database triggers 904 42000 ORA-00904: : invalid identifier
From: (unknown)
Caused by SQL Problems.
Problem #1, SQLState 42000, Error code 904: java.sql.SQLSyntaxErrorException: ORA-00904: : invalid identifier
at com.pega.pegarules.data.internal.access.DatabaseImpl.confirmDependentTriggersRemoved(DatabaseImpl.java:15164)
at com.pega.pegarules.data.internal.access.DatabaseImpl.<init>(DatabaseImpl.java:1735)
... 37 more
Steps to Reproduce
Run the update.sh script to start an update.
Root Cause
A third-party product issue: The Oracle database user did not have required privileges for the update process.
Resolution
Please see pages 9, 10 and 11 of the installation guide regarding the necessary privileges for the database user during upgrade/update processing:
https://pdn.pega.com/documents/pega-719-platform-installation-guide-oracle-apache-tomcat
Published March 18, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.