Question

2
Replies
845
Views
Roberto Flores (rcfloresh.rw)
Rulesware

Rulesware
SV
rcfloresh.rw Member since 2017 1 post
Rulesware
Posted: April 20, 2018
Last activity: April 20, 2018
Posted: 20 Apr 2018 2:13 EDT
Last activity: 20 Apr 2018 12:40 EDT
Closed
Solved

ERROR During installation (Pega 7.3.1 - Posgresql - Tomcat) PLJAVA

During the installation I recive the next message


Encountered database error attempting to load UDF library onto PostgreSQL, clean schema before running again.


Exception in thread "main" org.postgresql.util.PSQLException: ERROR: cannot use PL/Java before successfully completing its setup


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".


I check again and again the setup in the postgresql.conf and are the next.


pljava.classpath='C:\\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_171\\jre\\bin\\server\\jvm.dll'



pljava.jar location

During the installation I recive the next message

Encountered database error attempting to load UDF library onto PostgreSQL, clean schema before running again.

Exception in thread "main" org.postgresql.util.PSQLException: ERROR: cannot use PL/Java before successfully completing its setup

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".

I check again and again the setup in the postgresql.conf and are the next.

pljava.classpath='C:\\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_171\\jre\\bin\\server\\jvm.dll'

pljava.jar location

jvm.dll location

And all the environment variables has been defined

When I run the install.sql was executed with out problems... and when I run the PRPC_Setup and check the connection to the database is connected with out problems.. even the main pega installer create some tables, funtions and views.. after to 50 seconds.. the installation is stoped with the error that I show in the begin..

Data Integration Java and Activities 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.