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
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"
Thanks for your prompt response. Please find the below SetupDatabase.Properties details. As you said PR_DATA table is not migrated to rules schema in the migration process, However during the rules upgrade is expecting the PR_DATA table.
We have exported fresh data schema & running the rule migration / rules upgrade. Now we didn't encountered the above error. Will let you know if any issue arise during the upgrade.
# connection properties that need to be set. (schema name will be automatically added)
#Uncomment this property and add a list of ; delimited connections properties
#For example jdbc.custom.connection.properties=user=usr;password=pwd
#Rules schema name : Used for all databases.
#The user name is used for default schema name rules.schema.name=V7_DEVA_RULES
# Data schema name : Used for systems running on a Split Schema
# The value of rules.schema.name is the default value for data.schema.name data.schema.name=
#User Temp Directory. Will use default if not set to valid directory user.temp.dir=/home/aaa/Pega721Build/Temp