SA-16969

Summary

Running the upgrade to Pega 7.1.8 is failing during the "Checking Configuration Files" task
 

Error Messages

Failed to find current installed version of PRPC

BUILD FAILED
/718media/scripts/setupDatabase.xml:317: The following error occurred while executing this line:
/718media/scripts/setupDatabase.xml:1279: Failed to find current installed version of PRPC

Steps to Reproduce

Run upgrade.sh script

Root Cause

A defect or configuration issue in the operating environment.  The database user running the upgrade did not have the correct permissions as outlined in the upgrade guide.  To determine the root cause additional debug needs to be turned on. 
In the 7.1.8 media’s scripts/config directory there is a file called deploylogging.properties.
Changing the .level property from INFO to CONFIG and running the upgrade script again allows us to see the SQLException.
 
[pega:getupgradefromversion] 2015-11-18 12:25:18,302 (            DatabaseContentsChecker)  CONFIG - Encountered exception looking for latest Rule-RuleSet-Version in PEGA.pr4_rule_ruleset [pega:getupgradefromversion]
[pega:getupgradefromversion] java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Resolution

Make the following change to the operating environment: Granted the privileges outlined in the upgrade guide to the deployment user and then the upgrade completed successfuly.