Skip to main content

Support Article

ORA-00942 unable to calculate codeset version starting 7.1.7

SA-6300

Summary



New installation of Pega 7.1.7 split schema failing to start.

Error Messages



Feb 11, 2015 12:35:00 PM com.pega.pegarules.internal.bootstrap.PRBootstrap 
19830421: PRBootstrap.calculateEngineCodeVersionFromDB() - unable to calculate codeset version from database: ORA-00942: table or view does not exist 


Steps to Reproduce



Try to start Pega 7.1.7 split schema system. 


Root Cause



The root cause of this problem is defect/misconfiguration in the PRPC operating environment.  The defaultSchema configuration properties are not set correctly.

Resolution



This issue is resolved by making the following change to the PRPC operating environment: 

In Tomcat context.xml file add the following entries, replacing the RulesSchema and DataSchema values with the appropriate schema names.

<Environment name="prconfig/database/databases/PegaRULES/defaultSchema" value="RulesSchema" type="java.lang.String"/>
<Environment name="prconfig/database/databases/PegaDATA/defaultSchema" value="DataSchema" type="java.lang.String"/>
Suggest Edit

Published January 31, 2016 - Updated October 8, 2020

Did you find this content helpful?

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

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