Question

Infosys
IN
Last activity: 6 Apr 2018 19:26 EDT
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"
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-data-project-task
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.