Question
S & P Global Company Ltd
IN
Last activity: 11 Apr 2020 9:59 EDT
Pega 8.2 Installation Issue
Hi,
We are trying to install PRPC 8.2 on Oracle and deploy using tomcat 8 + OpenJDK 1.8. It's WAR deployment.
We were able to load rules into the database i.e. Split Schema by double clicking on PRPC_Setup.jar.
We edited context.xml to use JNDI data sources and tried deploying. We ended up with table not found exceptions.
Attached configurations for context.xml, prbootstrap.properties and prconfig.xml. Please note that the attached files have placeholders for some configs and it is intentional. During deployment, we replaced placeholders with correct values.
Attached deployment logs also
===================================================================================
Hi,
We are trying to install PRPC 8.2 on Oracle and deploy using tomcat 8 + OpenJDK 1.8. It's WAR deployment.
We were able to load rules into the database i.e. Split Schema by double clicking on PRPC_Setup.jar.
We edited context.xml to use JNDI data sources and tried deploying. We ended up with table not found exceptions.
Attached configurations for context.xml, prbootstrap.properties and prconfig.xml. Please note that the attached files have placeholders for some configs and it is intentional. During deployment, we replaced placeholders with correct values.
Attached deployment logs also
===================================================================================
Caused by: com.pega.pegarules.pub.PRRuntimeException: Error determining the mode of PRPC install from database. at com.pega.pegarules.data.internal.PRDataProviderImpl.isMultiTenantEnvironment(PRDataProviderImpl.java:1398) at com.pega.pegarules.exec.internal.basic.SystemSettingsImpl$SystemSettingsInner.<clinit>(SystemSettingsImpl.java:200) ... 107 more Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable .pr4_base PegaRULES From: (unknown) ===================================================================================
Any help is much appreciated.
Pegasystems Inc.
US
Hi Shiva,
During deployment, you don't have to change anything in prbootstrap or prconfig.xml file. Try to use the default files from archive files.
Context.xml should have the Pega DB connection properties with valid schema and the user who have access to both rules & data schema.
I have verified the context.xml and it looks fine. As per the deployment startup logs, Java process couldn't find pr4_base table during the initial bootstrap process. As this table must be in rules schema, can you verify if it's present in the same schema and mainly confirm if the provided user is context.xml had access to this schema & table?
If the problem persists, try using a deployment user who has access to both rules & data schema with max privileges.