Question
Pega 7.3.1 Update - Failed to find current installed version
We are executing the update scripts for Pega 7.1.5 to Pega 7.3.1.We have encountered below build failed issue -
[pega:getupgradefromversion] Failed to find current installed version of PRPC.
Any suggestion Please.
Note -
1. We have split schema configuration.We are doing in-place update for both Rules and Data schema. And we have faced this issue while executing the update.sh script for Rule schema.
2. In PDN, I have found few resolutions, but none of the are applicable for our case -
2.a. https://pdn.pega.com/support-articles/upgrade-716-failed-find-current-installed-version
We are using deployment user which has access to all the tables in both "Rules" and "Data" schema.
2.b. https://pdn.pega.com/support-articles/upgrade-fails-find-current-installed-version-prpc
we are facing issue while updating "Rules" schema.
3. The deployment user has all the required privileges and roles as defined in Upgrade document.
4. We have updated the log level in deploylogging.properties from INFO to CONFIG, but that did not produce any additional information in log file.
Please see the log file.
Hi,
Can you run below query by logging in as the user which you were using for updating your Pega
SELECT DISTINCT pzcodesetversion, pzcodeset, count(pzcodesetversion) FROM <RULES_SCHEMA_NAME>.PR_ENGINECLASSES GROUP BY pzcodesetversion, pzcodeset
Also please share the permissions you have granted to the user.
Try below steps to trace the DB related issues while performing update.
1. Use the ojdbc6_g.jar version of the JDBC driver. This jar will work with jdbc tracing.
In setupDatabase.properties set pega.jdbc.driver.jar=location of ojdbc6_g.jar
2. Create a file JDBCConfig.properties file to set the level of trace that you want.
.level=SEVERE
oracle.level=FINE
oracle.jdbc.level=FINE
oracle.jdbc.handlers=java.util.logging.FileHandler
java.util.logging.FileHandler.level=FINE
java.util.logging.FileHandler.pattern=jdbcTraceUpgrade.log
java.util.logging.FileHandler.count=20
java.util.logging.FileHandler.formatter=java.util.logging.SimpleFormatter
java.util.logging.FileHandler.append=true
3. Before you run the upgrade.sh script you need to set ANT_OPTS like this. For the second parameter is the location where you put the JDBCConfig.properties.properties file. If you put the config file in the scripts directory you can just set ANT_OPTS like this. If you put it someplace else then include the path.
For Unix:
export ANT_OPTS="-Doracle.jdbc.Trace=true -Djava.util.logging.config.file=JDBCConfig.properties"
For Windows:
set ANT_OPTS="-Doracle.jdbc.Trace=true -Djava.util.logging.config.file=JDBCConfig.properties"
4. Then just run ./upgrade.sh (or update.bat) and the jdbcTraceUpgrade.log file that is generated.
The generated log file shows if there are any DB related exceptions while update.