Question

9
Replies
551
Views
saravanan kvkandasamy (saravanank1808)
Citigroup technology inc

Citigroup technology inc
US
saravanank1808 Member since 2015 22 posts
Citigroup technology inc
Posted: June 16, 2018
Last activity: February 17, 2019
Posted: 16 Jun 2018 19:02 EDT
Last activity: 17 Feb 2019 14:53 EST
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

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

System Administration Installation and Deployment Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.