Question

9
Replies
515
Views
saravanank1808 Member since 2015 21 posts
Citigroup technology inc
Posted: 2 years ago
Last activity: 1 year 8 months ago
Closed

Unable to bring up pega application post data refresh

We have split schema rules_a and worker(data) for our application and in pega 7.2.2, we dropped all the objects from both rules and data schema and imported the dump from the working env, we verified, post import all the object count between source and target matched.

From WAS console, we tested the connectivity of the datasource, it works fine, checked the namespace binding, all good.

But when we tried to start the application server, in the start up log we see below error in which it couldnt find the table.

As per other article in pega community, we checked the prengineclasses table and we see records exists and highest code set version is 07-10-27. Not sure why pega unable to find the table and giving an message table dint exist, although the datasource connectivity from WAS console works fine.

prconfig.xml has below entries

<env name="database/databases/PegaRULES/dataSource" value="java:comp/env/jdbc/PegaRULES"/>
<env name="database/databases/PegaDATA/dataSource" value="java:comp/env/jdbc/PegaRULES"/>

Error

[6/16/18 7:46:00:533 EDT] 0000006f PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap Engine classes schema: RSM_RULES_B_D7
[6/16/18 7:46:00:534 EDT] 0000006f PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap Assembled classes schema: RSM_RULES_B_D7
[6/16/18 7:46:00:534 EDT] 0000006f PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap prbootstrap.properties merged with prbootstrap entries in Data-Admin-System-Settings
[6/16/18 7:46:00:548 EDT] 0000006f PRBootstrap Z com.pega.pegarules.internal.bootstrap.PRBootstrap PRBootstrap.calculateEngineCodeVersionFromDB() - unable to calculate codeset version from database: ORA-00942: table or view does not exist

[6/16/18 7:46:00:549 EDT] 0000006f PRMiniLoader Z com.pega.pegarules.internal.bootstrap.PRMiniLoader Will load phase 2 bootstrap from Pega-EngineCode:
[6/16/18 7:46:00:551 EDT] 0000006f PRMiniLoader Z com.pega.pegarules.internal.bootstrap.PRMiniLoader PRMiniLoader - unable to load classes from the database: ORA-00942: table or view does not exist

Low-Code App Development Installation and Deployment Data Integration
Moderation Team has archived post
Share this page LinkedIn