Support Article
Fresh Install - table or view does not exist
SA-12449
Summary
The engine startup fails with error.
Error Messages
Jul 20, 2015 11:35:11 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
19830421: Bootstrap datatables schema: null
Jul 20, 2015 11:35:11 AM com.pega.pegarules.internal.bootstrap.PRBootstrapDataSource
SEVERE: Unable to connect to database. Will only use properties from file.
java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
Steps to Reproduce
- Install split schema Pega 7.1.7.
- Start the Tomcat instance against it.
Root Cause
A software use or operation error
Resolution
Perform the following local-change:
Change JNDI binding identifiers in context.xml to reflect correct case in defaultschema word:
Change
<Environment name="prconfig/database/databases/PegaRULES/defaultschema" value="PegaRules_Catalyst" type="java.lang.String" />
<Environment name="prconfig/database/databases/PegaDATA/defaultschema" value="PegaData_Catalyst" type="java.lang.String" />
to
<Environment name="prconfig/database/databases/PegaRULES/defaultSchema" value="PegaRules_Catalyst" type="java.lang.String" />
<Environment name="prconfig/database/databases/PegaDATA/defaultSchema" value="PegaData_Catalyst" type="java.lang.String" />
Published October 27, 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.