Support Article
Cannot find datasources after deploying prweb
SA-6249
Summary
After installing Pega 7.1.7 and starting it up the first time, there is an exception in the log saying ORA-0094: table or view does not exist. The environment is a Linux system with Tomcat7 and an Oracle DB, split schema configuration.
Error Messages
Feb 06, 2015 2:54:41 PM 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:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
Steps to Reproduce
Install Pega as directed in document PRPC71_Install_TCORA.pdf
Root Cause
The root cause is because the database user given for jdbc/PegaRULES data source is rules user instead of data user.
From the PRPC documentation:
"The Datasource defined in the Context.xml has to be configured using the DATA schema userID and Password when using split schema."
Resolution
The explanation for this behavior is as follows:
Use a database user that has access to the data schema for jdbc/PegaRULES data source.
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.