Question

3
Replies
1926
Views
naras4 Member since 2017 1 post
PEGA
Posted: December 1, 2017
Last activity: March 15, 2018
Closed

ERROR: cannot use PL/Java before successfully completing its setup

I am installing PRPC 7.3.1 with postgreSQL 9.6. I have SQLJ schema properly created. But the platform setup fails with following error.

pljava.classpath='C:\\Program Files\\PostgreSQL\\9.6\\lib\\pljava.jar'
pljava.vmoptions = '-Xms32M -Xmx64M -XX:ParallelGCThreads=2'
work_mem = 5MB
pljava.libjvm_location = 'C:\\Program Files\\Java\\jdk1.8.0_151\\jre\\bin\\server\\jvm.dll'

oad UDF:
Execute SQL In Transaction:false
[mkdir] Created dir: C:\Users\naras4\AppData\Local\Temp\PegaInstallTemp-01-December-2017-14.07.10\udf_temp
[copy] Copying 6 files to C:\Users\naras4\AppData\Local\Temp\PegaInstallTemp-01-December-2017-14.07.10\udf_temp
[echo] arg values : --config=C:\Users\naras4\AppData\Local\Temp\/PegaInstallTemp-01-December-2017-14.07.10/prbootstrap.properties --profile=install.postgres --dataOnly=false --run-in-transaction=false --jar-path=C:\Users\naras4\Downloads\115631_Pega7.31 (1)\scripts/../archives/udf/prreadstream.jar C:\Users\naras4\AppData\Local\Temp\/PegaInstallTemp-01-December-2017-14.07.10/udf_temp
[java] 2017-12-01 14:07:49,060 ( UDFManager) INFO - AutoCommit set to true. Executing with out transaction
[java] 2017-12-01 14:07:49,074 ( PostgresUDFJarLoader) INFO - Loading UDF jar on Postgres DB
[java] 2017-12-01 14:07:49,076 ( ConnectionWrapper) INFO - Attempting to load profile "install.postgres":
[java] 2017-12-01 14:07:49,076 ( ConnectionWrapper) INFO - Type: postgres
[java] 2017-12-01 14:07:49,077 ( ConnectionWrapper) INFO - Class: org.postgresql.Driver
[java] 2017-12-01 14:07:49,083 ( ConnectionWrapper) INFO - URL: jdbc:postgresql://localhost:5432/pegaDB
[java] 2017-12-01 14:07:49,084 ( ConnectionWrapper) INFO - User: adminUser
[java] 2017-12-01 14:07:49,085 ( ConnectionWrapper) INFO - JDBC Properties:
[java] 2017-12-01 14:07:49,278 ( ConnectionWrapper) INFO - Autocommit set to true
[java] 2017-12-01 14:07:49,288 ( PostgresUDFJarLoader) INFO - Jar is not already loaded in schema rulesschema
[java] 2017-12-01 14:07:49,300 ( 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] 2017-12-01 14:07:49,300 ( 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:2476)
[java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2189)
[java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:300)
[java] at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:428)
[java] at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:354)
[java] at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:169)
[java] at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:78)
[java] at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:117)
[java] at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.loadJarIntoPostgres(PostgresUDFJarLoader.java:269)
[java] at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.installJarOnPostgres(PostgresUDFJarLoader.java:125)
[java] at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.load(PostgresUDFJarLoader.java:89)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.loadUDFJar(UDFManager.java:348)
[java] at com.pega.pegarules.install.UDFManager$ExecuteUDFWithOutTransaction.executeInner(UDFManager.java:293)
[java] at com.pega.pegarules.install.UDFManager$AbstractUDFExecutor.execute(UDFManager.java:357)
[java] at com.pega.pegarules.install.UDFManager.process(UDFManager.java:178)
[java] at com.pega.pegarules.install.UDFManager.main(UDFManager.java:129)
BUILD FAILED
C:\Users\naras4\Downloads\115631_Pega7.31 (1)\pegaGuiInstallerTemp\build.xml:133: The following error occurred while executing this line:
C:\Users\naras4\Downloads\115631_Pega7.31 (1)\pegaGuiInstallerTemp\build.xml:99: The following error occurred while executing this line:
C:\Users\naras4\Downloads\115631_Pega7.31 (1)\scripts\setupDatabase.xml:472: The following error occurred while executing this line:
C:\Users\naras4\Downloads\115631_Pega7.31 (1)\scripts\setupDatabase.xml:1865: The following error occurred while executing this line:
C:\Users\naras4\Downloads\115631_Pega7.31 (1)\scripts\setupUDF.xml:132: Java returned: 1
Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn