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"/>
Published January 31, 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.