Question

2
Replies
158
Views
LogeshGandhi Member since 2014 2 posts
Infosys
Posted: 3 years ago
Last activity: 3 years 7 months ago
Closed

Rules Upgrade Failed - 6.2SP2 to 7.1.2 | ORA-00942: table or view does not exist | looking for pr_data table in Rules Schema

We are performing an upgrade from 6.2SP2 to 7.1.2.

During Rules Upgrade build got failed in _upgradeRuleBase step. Please find the error below :

[java] 2017-03-03 05:39:05,327 [ main] [ ] [ ] (l.access.MigrateSQLChangeProxy) INFO - Migrating instances of Rule-Application-Requirement from V7_DEVA_RULES.pr4_rule to V7__DEVA_RULES.pr4_rule_requirement
[java] 2017-03-03 05:39:05,533 [ main] [ ] [ ] (l.access.MigrateSQLChangeProxy) INFO - Migrated 93 instances of Rule-Application-Requirement
[java] 2017-03-03 05:39:05,538 [ main] [ ] [ ] (l.access.ConnectionManagerImpl) ERROR - Not returning connection 0 for database "pegarules" to the pool as it previously encountered the following error
[java] User ID: (unknown)
[java] Last SQL: select count(*) as "count" from V7_DEVA_RULES.pr_data where pxObjClass = 'Data-Project-Task'
[java] java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

[java]

Same kind of issue illustrated in the below link. However this could not help us to resolve the issue.

"setupDatabase.properties file setting bypass.pega.schema is not set to true"

https://pdn.pega.com/support-articles/ora-00942-rulesprdata-pxobjclass-…

Please let us know if there are any solution this issue.

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn