Question

2
Replies
170
Views
Logesh Gandhi Subramanian (LogeshGandhi)
Infosys

Infosys
IN
LogeshGandhi Member since 2014 2 posts
Infosys
Posted: March 3, 2017
Last activity: April 6, 2018
Posted: 3 Mar 2017 7:39 EST
Last activity: 6 Apr 2018 19:26 EDT
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"

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.

System Administration Upgrades
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.