Question

4
Replies
1341
Views
somasekhark5785 Member since 2018 3 posts
Cognizant Technology Solutions India PVT Ltd
Posted: 1 year ago
Last activity: 1 year 5 months ago
Closed
Solved

PEGA 8.1 Installation with PostgreSQL 9.6 DB

Hi Team,

We are trying to install our sandbox PEGA 8.1 instance with PostgreSQL 9.6 V Database.

Issue:

Apply UDFs:
Apply UDFs Inner:
Load UDF:
Execute SQL In Transaction:false
[mkdir] Created dir: C:\Users\433098\AppData\Local\Temp\2\PegaInstallTemp-07-May-2019-20.17.21\udf_temp
[copy] Copying 6 files to C:\Users\433098\AppData\Local\Temp\2\PegaInstallTemp-07-May-2019-20.17.21\udf_temp
[echo] arg values : --config=C:\Users\433098\AppData\Local\Temp\2\/PegaInstallTemp-07-May-2019-20.17.21/prbootstrap.properties --profile=install.postgres --dataOnly=false --rulesOnly=${db.onlyRules} --run-in-transaction=false --jar-path=E:\PEGA Software\116167_PEGA_8.1\scripts/../archives/udf/prreadstream.jar C:\Users\433098\AppData\Local\Temp\2\/PegaInstallTemp-07-May-2019-20.17.21/udf_temp
[java] 2019-05-07 20:18:41,957 ( UDFManager) INFO - AutoCommit set to true. Executing with out transaction
[java] 2019-05-07 20:18:42,023 ( PostgresUDFJarLoader) INFO - Loading UDF jar on Postgres DB
[java] 2019-05-07 20:18:42,027 ( ConnectionWrapper) INFO - Attempting to load profile "install.postgres":
[java] 2019-05-07 20:18:42,028 ( ConnectionWrapper) INFO - Type: postgres
[java] 2019-05-07 20:18:42,029 ( ConnectionWrapper) INFO - Class: org.postgresql.Driver
[java] 2019-05-07 20:18:42,031 ( ConnectionWrapper) INFO - URL: jdbc:postgresql://localhost:5432/postgres
[java] 2019-05-07 20:18:42,035 ( ConnectionWrapper) INFO - User: postgres
[java] 2019-05-07 20:18:42,036 ( ConnectionWrapper) INFO - JDBC Properties:
[java] 2019-05-07 20:18:42,274 ( ConnectionWrapper) INFO - Autocommit set to true
[java] 2019-05-07 20:18:42,302 ( PostgresUDFJarLoader) WARNING - Encountered a database problem when attempting to load jar onto PostgreSQL: ERROR: relation "sqlj.jar_repository" does not exist
[java] Position: 21
[java] 2019-05-07 20:18:42,303 ( 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: relation "sqlj.jar_repository" does not exist
[java] Position: 21
[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.isJarLoadedPostgres(PostgresUDFJarLoader.java:155)
[java] at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.installJarOnPostgres(PostgresUDFJarLoader.java:116)
[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)

We did below mention steps for to resolve above issue

We did set environment variable JAVA_HOME and JRE_HOME use JDK 1.8.0_202.

You should keep pljava.jar and pljava.dll from ResourceKit\PLJava folder to the installed PostgreSQL\9.6\lib\ folder. Then do the changes in PostgreSQL\9.6\data\postgresql.conf like follows: (location can be changed based on your installation)

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_181\\jre\\bin\\server\\jvm.dll'

Execute vcredist-2013_x64.exe, which available on\ResourceKit\PLJava\9.6\Windows\

Restart the Postgress from the windows service.

Now create the DB, create your schema from PostgressSQL console.

after that started PEGA installation steps followed with PEGA 8.1 installation guide.

Could you please help us as soon as possible.

Low-Code App Development Installation and Deployment
Moderation Team has archived post
Share this page LinkedIn