Question

4
Replies
1415
Views
Close popover
somasekhar kummari (somasekhark5785)
Cognizant Technology Solutions India PVT Ltd

Cognizant Technology Solutions India PVT Ltd
IN
somasekhark5785 Member since 2018 3 posts
Cognizant Technology Solutions India PVT Ltd
Posted: May 8, 2019
Last activity: May 23, 2019
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.

System Administration Installation and Deployment
Moderation Team has archived post