Question

3
Replies
2012
Views
Suresh Narayanan (naras4)
PEGA
Sr. Technical Architect
Pegasystems Inc.
US
naras4 Member since 2017 1 post
PEGA
Posted: December 1, 2017
Last activity: March 15, 2018
Posted: 1 Dec 2017 17:30 EST
Last activity: 15 Mar 2018 2:39 EDT
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'




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

System Administration Installation and Deployment
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.