Question
Capgemini
US
Last activity: 7 May 2019 3:43 EDT
PEGA 8.2 Installation Error: cannot use PL/Java before successfully completing its setup
Hello community,
I am trying to install Pega 8.2 to Postgres 9.6 on Windows 10. I have been able to create the SQLJ schema successfully after copying the pljava files to the postgres directory and updating postgresql.conf as below.
pljava.classpath='C:\\Program Files\\PostgreSQL\\9.6\\lib\\pljava.jar'
pljava.vmoptions = '-Xms32M -Xmx64M -XX:ParallelGCThreads=2'
work_mem = 5MB
pljava.libjvm_location = '%JRE_HOME%\\bin\\server\\jvm.dll'
Even though the paths above are ok, I get the error highlighted below. Any help is appreciated.
Hello community,
I am trying to install Pega 8.2 to Postgres 9.6 on Windows 10. I have been able to create the SQLJ schema successfully after copying the pljava files to the postgres directory and updating postgresql.conf as below.
pljava.classpath='C:\\Program Files\\PostgreSQL\\9.6\\lib\\pljava.jar'
pljava.vmoptions = '-Xms32M -Xmx64M -XX:ParallelGCThreads=2'
work_mem = 5MB
pljava.libjvm_location = '%JRE_HOME%\\bin\\server\\jvm.dll'
Even though the paths above are ok, I get the error highlighted below. Any help is appreciated.
Execute SQL In Transaction:false
[mkdir] Created dir: C:\Users\ronny\AppData\Local\Temp\PegaInstallTemp-02-May-2019-23.29.50\udf_temp
[copy] Copying 6 files to C:\Users\ronny\AppData\Local\Temp\PegaInstallTemp-02-May-2019-23.29.50\udf_temp
[echo] arg values : --config=C:\Users\ronny\AppData\Local\Temp\/PegaInstallTemp-02-May-2019-23.29.50/prbootstrap.properties --profile=install.postgres --dataOnly=false --rulesOnly=${db.onlyRules} --run-in-transaction=false --jar-path=C:\Users\ronny\Documents\116328_Pega82.1\scripts/../archives/udf/prreadstream.jar C:\Users\ronny\AppData\Local\Temp\/PegaInstallTemp-02-May-2019-23.29.50/udf_temp
[java] 2019-05-02 23:34:05,795 ( UDFManager) INFO - AutoCommit set to true. Executing with out transaction
[java] 2019-05-02 23:34:05,795 ( PostgresUDFJarLoader) INFO - Loading UDF jar on Postgres DB
[java] 2019-05-02 23:34:05,811 ( ConnectionWrapper) INFO - Attempting to load profile "install.postgres":
[java] 2019-05-02 23:34:05,811 ( ConnectionWrapper) INFO - Type: postgres
[java] 2019-05-02 23:34:05,811 ( ConnectionWrapper) INFO - Class: org.postgresql.Driver
[java] 2019-05-02 23:34:05,811 ( ConnectionWrapper) INFO - URL: jdbc:postgresql://localhost:5432/pegasus
[java] 2019-05-02 23:34:05,811 ( ConnectionWrapper) INFO - User: pega_admin
[java] 2019-05-02 23:34:05,811 ( ConnectionWrapper) INFO - JDBC Properties:
[java] 2019-05-02 23:34:06,029 ( ConnectionWrapper) INFO - Autocommit set to true
[java] 2019-05-02 23:34:06,045 ( PostgresUDFJarLoader) INFO - Jar is not already loaded in schema pegarules
[java] 2019-05-02 23:34:06,248 ( PostgresUDFJarLoader) WARNING - Encountered a database problem when attempting to load jar onto PostgreSQL: ERROR: cannot use PL/Java before successfully completing its setup
[java] Hint: Check the log for messages closely preceding this one, detailing what step of setup failed and what will be needed, probably setting one of the "pljava." configuration variables, to complete the setup. If there is not enough help in the log, try again with different settings for "log_min_messages" or "log_error_verbosity".
[java] 2019-05-02 23:34:06,248 ( PostgresUDFJarLoader) WARNING -
[java] *****************************************************************************************************
[java]
[java] Encountered database error attempting to load UDF library onto PostgreSQL, clean schema before running again.
[java]
[java] *****************************************************************************************************
[java] Exception in thread "main" org.postgresql.util.PSQLException: ERROR: cannot use PL/Java before successfully completing its setup
[java] Hint: Check the log for messages closely preceding this one, detailing what step of setup failed and what will be needed, probably setting one of the "pljava." configuration variables, to complete the setup. If there is not enough help in the log, try again with different settings for "log_min_messages" or "log_error_verbosity".
[java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
[java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
[java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:308)
[java] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:441)
[java] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:365)
[java] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:143)
[java] at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:77)
[java] at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:106)
[java] at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.loadJarIntoPostgres(PostgresUDFJarLoader.java:263)
[java] at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.installJarOnPostgres(PostgresUDFJarLoader.java:119)
[java] at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.load(PostgresUDFJarLoader.java:89)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.loadUDFJar(UDFManager.java:346)
[java] at com.pega.pegarules.install.UDFManager$ExecuteUDFWithOutTransaction.executeInner(UDFManager.java:291)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.execute(UDFManager.java:355)
[java] at com.pega.pegarules.install.UDFManager.process(UDFManager.java:186)
[java] at com.pega.pegarules.install.UDFManager.main(UDFManager.java:138)
***Edited by Moderator: Pallavi to update platform capability tags***
Accepted Solution
Capgemini
US
It seems like the issue is related to the version of Postgres or the pljava files provided for 9.6. I used the exact same configuration in posgresql.config in Postgres version 9.4 using the pljava files for that version and the rule base migration was completed successfully.
Pegasystems Inc.
IN
Hi ,
Please add complete path of JRE installed in system as mentioned below and then restart Postgres service and then try again.
pljava.libjvm_location = 'C:\\Program Files\\Java\\jre1.8.0_191\\bin\\server\\jvm.dll'
Replace 'C:\\Program Files\\Java\\jre1.8.0_191\\bin\\server\\jvm.dll' with system JRE location
Please Note : Posting making above changes if you are getting any exception related to pr4_base table already exist then you need to delete existing schema and recreate it , it will resolve an issue related to duplicate pr4_base table.
Thank you
Capgemini
US
Thanks for the response. I had previously tried setting the full path but after running the SQLJ script, there were warning messages and even though the schema was created, the installation failed at the same point.
SQLJ SCRIPT MESSAGE=> WARNING: Java Virtual Machine not yet loaded DETAIL: The specified Module could not be found HINT: Set pljava.libjvm_location to correct path to the jvm library
So I created the environment variable JRE_HOME to C:\Program Files\Java\jre1.8.0_212 and changed it in PostgreSQL.conf as shown above and the SQLJ script ran without errors. It seems like the installation issue is when trying to load the pljava.jar file. I tried to creating an environment variable for the Postgres_home directory (C:\Program Files\PostgreSQL\9.6) to refer it in postgresql.conf and have added all those paths to the system environment variable "path". Still after trying all this, the installation fails at the same point.
Any other idea?
Accepted Solution
Capgemini
US
It seems like the issue is related to the version of Postgres or the pljava files provided for 9.6. I used the exact same configuration in posgresql.config in Postgres version 9.4 using the pljava files for that version and the rule base migration was completed successfully.