Contributed by Celeste Dufresne
Symptoms
When you run the update script to update Pega Platform™ from version 8.6.3 to release 23.1.0, the update process runs for a few minutes and then stalls with no progress. An hour elapses and still there is no progress with the update. You see no new information in the log after the first few minutes of the update stalling. You see no immediate error message indicating build failure.
You might also experience this problem during installations of Pega Platform ’23 and later releases.
You are installing or updating to Pega Platform ’23 with Oracle database version 18.x or 19.x.
This problem is detected from the command line scripts and from Helm installations or updates.
Errors
The following are examples from reported cases of the last log entries seen before the installation or update stalls:
[exec] 2023-12-06 20:47:08.631 [ForkJoinPool-1-worker-3] INFO com.pega.codeloader.AbstractFastCodeLoader - Loading prmaster-schema.jar ...
[exec] 2023-10-11 13:33:11.387 [ForkJoinPool-1-worker-2] INFO com.pega.codeloader.engine.FastJarLoaderTool - Loading prneethi-3.0.2.jar so that it is extracted at startup
[exec] 2023-11-03 15:54:16.343 [ForkJoinPool-1-worker-2] INFO com.pega.codeloader.AbstractFastCodeLoader - Loading prmaster-schema.jar ...
Explanation
Environment issue: Third-party product change
Client infrastructure: Old version of JDBC driver
The version of the JDBC driver being used blocks multiple threads when inserting JAR files into the Oracle database.
The installation or update stalls when trying to load the JAR files identified in the log entries into the pr_engineclasses database table.
A newer version of the Oracle JDBC driver that is compatible with and certified for the Java version and the Oracle 18.x or 19.x database that you are running is available. See the Solution.
Environments
The problem was reported in Pega Platform release 23.1.0 on-premises and client-managed cloud environments.
Solution
Testing with JDBC 20.5 and later versions has been successful.
Use a version of the ojdbc8.jar file or ojdbc11.jar file that is later than 20.5 to get the fixes for the problem.
However, you could use the latest available version of the JBDC driver that is compatible with and certified for the Java version and the Oracle that you are using in your Pega deployment.
Currently version 23.3.0.23.09 is available for Java 8, 11, and 17:
For Java 8, use ojdbc8.jar file version 23.3.0.23.
For Java 11 or 17, use ojdbc11.jar file version 23.3.0.23.
For more information, see Oracle JDBC FAQ, the question, What is the recommended 19.x JDBC driver to be used with JDK11?
To download the latest version of the JDBC driver that you need for your Pega deployment, go to Oracle Database JDBC driver and Companion Jars Downloads.
The Pega Platform Support Guide will be updated for Pega Platform release 23.1.2.
Watch the Pega Support Center Pega Platform Resolved Issues. When the Resolved Issues for Pega Platform release 23.1.2 are published, search for ISSUE-831855 Infinity 23 update script execution is stuck on Oracle 19.