Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Unable to initialize PRPC utilizing non schema owner

SA-43045

Summary



PRPC initialization fails on startup with table not found.

This is for an existing PRPC 6.2 SP1 installation where schema owner user works for PegaRULES database.

Audit requirements specify that the schema owner Id must be locked.

Role has been created and runtime permissions set within role and granted to non-schema owner database id.

Using non-schema ids in PRPC 6.2 SP1 will not resolve regardless of the use of synonyms.


Error Messages


Caused by: com.pega.pegarules.pub.database.NonexistentTableException: Database-NonexistentTable pr4_base PegaRULES
From: (unknown)
at com.pega.pegarules.data.internal.access.TableInformationMapImpl.lookupTableInfo(TableInformationMapImpl.java:522)


Steps to Reproduce



1. Create separate IDs for database connections and grant appropriate runtime permissions needed.
2. Update context.xml file to utilize new id/password information.
3. Create table synonyms in new schema.
4. Start Tomcat


Root Cause



A defect or configuration issue in the operating environment. includeSynonyms=true connection property is needed on PegaRULES datasource.

Resolution



Perform the following local-change:

Update context.xml in tomcat and add the connection property. Then start tomcat with prweb application is deployed.


<Resource name="jdbc/PegaRULES" auth="Container" type="javax.sql.DataSource"
maxActive="100" maxIdle="30" maxWait="10000" connectionProperties="includeSynonyms=true"
username="your_non-schema_user" password="your_password" driverClassName="oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = your_host)(PORT = your_port))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = your_service)
)
)" />

Suggest Edit

Published November 3, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

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