Question
CYBG
GB
Last activity: 14 Sep 2017 5:59 EDT
prbootstrap.properties finds wrong version of code?
We're attempting to update PRPC from 7.2.1 to 7.2.2. When we run the update.bat script, we get the following error:
[java] SEVERE:
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] SEVERE: ============================= Failed to bootstrap PegaRULES =============================
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] SEVERE:
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] SEVERE: Could not load the java class 'com/pega/pegarules/internal/bootstrap/phase2/PRBootstrapImpl.class' from the database table 'PRWFNPE1.pr_engineclasses'
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] SEVERE: This is usually due to an empty 'PRWFNPE1.pr_engineclasses' table, or possibly it does not contain the configured codeset version.
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] SEVERE: In this run the prbootstrap.properties specified 'pega-enginecode:07-10-27', checking database...
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
...
We're attempting to update PRPC from 7.2.1 to 7.2.2. When we run the update.bat script, we get the following error:
[java] SEVERE:
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] SEVERE: ============================= Failed to bootstrap PegaRULES =============================
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] SEVERE:
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] SEVERE: Could not load the java class 'com/pega/pegarules/internal/bootstrap/phase2/PRBootstrapImpl.class' from the database table 'PRWFNPE1.pr_engineclasses'
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] SEVERE: This is usually due to an empty 'PRWFNPE1.pr_engineclasses' table, or possibly it does not contain the configured codeset version.
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
[java] SEVERE: In this run the prbootstrap.properties specified 'pega-enginecode:07-10-27', checking database...
[java] Aug 17, 2017 1:27:47 PM com.pega.pegarules.internal.bootstrap.PRMiniLoader
...
[java] ============ PegaRULES Bootstrap Configuration ============
[java] Date: Thu Aug 17 13:27:47 BST 2017
[java] Java Version: Oracle Corporation 1.8.0_60
[java] Configuration: file:/C:/Users/S514812/AppData/Local/Temp/PegaInstallTemp-15-August-2017-14.00.26/prbootstrap.properties
[java] Pega-EngineCode: 07-10-27
[java] JDBC Driver: oracle.jdbc.OracleDriver
[java] JDBC URL: jdbc:oracle:thin:@vrhogdu100.eu.nag.net:1643/PWFU.eu.nag.net
[java] JDBC User: PWFU_SYS
[java] Database: Oracle Oracle Database 11g Enterprise Edition Release Proprietary information hidden.0 - 64bit Production
[java] With the Partitioning, OLAP, Data Mining and Real Application Testing options
[java] Driver: Oracle JDBC driver Proprietary information hidden.0
[java]
[java] (!) Unable to use given database configuration
[java] (!) Unable to locate classes on filesystem
[java] =============== End Bootstrap Configuration ===============
The pzCodesetVersion for the prbootstrap.properties record in the pr_engineclasses table is 07-10-25, which I assume is correct for the version of 7.2.1 that we have installed. So why does the 7.2.2 update expect it to be 07-10-27 and throw a fit because it's not (assuming that what the above means)?
We've attempted five PRPC updates in the past few years, and only one was successful. In all other cases we had to export the code in a product file, wipe and install the new version and then import the application. Has this been the experience of any other PRPC users? Is there really an easy way to update PRPC or is the complete wipe-and-reinstall the only way to be sure?
JPMorgan Chase & Company
US
Hi,
Please execute below query in database, it will return the class entry
SELECT * FROM PRWFNPE1.pr_engineclasses where pzclass = 'PRBootstrapImpl.class'
If class entry available please check database connection details in prbootstrap. properties file.
CYBG
GB
Hi Sudhakar,
The result of the query is 07-10-25 (see original post). However, I cannot find the prbootstrap.properties file anywhere. I've seen this mentioned in several posts but I can't find any reference in any PRPC documentation as to it's location. Do you know where it can be found?
Many thanks,
Mike.
Pegasystems Inc.
US
Please post the full log so we can understand what step is trying to start as 07-10-27. The codeset for 7.2.2 is 07-10-27. Since your database still has only 07-10-25 then the code in the database has not been updated yet. This would mean that it should be using the code from the media to start the engine at this point or that something else went wrong earlier.
Your experience with an upgrade is not normal so we need to understand what is wrong in your environment that is causing this behavior.
Pegasystems Inc.
US
Sorry I was sidetracked.
In the log I can see that you have not specified a user.temp.dir. Please set this to a valid, existing directory that can be used for the update.
user.temp.dir=
Please try setting this and then retry the update. At this point in the update it should be looking for the code in the media and I think is only trying to find it in the database because it cannot find it in the media.
The other thing that I don't like is that your path has a blank in the middle of the folder name. This can cause issues with scripts. Can you remove the space between PRPC and installation in the directory name.
c:\temp\PRPC installation\115289_P722UPD\scripts
CYBG
GB
Thank you Celeste. I was also sidetracked - for much longer, as you can see!
We are expecting a more up-to-date media file from Pega any day now. Once that arrives I will retry with the changes you suggest and see how I get on.
Many thanks again for your help,
Mike.