Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 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
Posted: 8 May 2019 2:45 EDT
Last activity: 23 May 2019 2:17 EDT
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:

Show More

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.


Show Less
To see attachments, please log in.
Installation and Deployment

Posted: 5 years ago
Posted: 8 May 2019 5:47 EDT
somasekhar kummari (somasekhark5785)
Cognizant Technology Solutions India PVT Ltd

Cognizant Technology Solutions India PVT Ltd
IN

HI Gundk 

I just created pegarules and pegadata schema only, i didn't create sqlj schema in postgresql db

could you please provide the step how to create sqlj schema what are the steps need to follow it 

To see attachments, please log in.
Posted: 5 years ago
Posted: 8 May 2019 5:56 EDT
Kranthi Kumar Gunda (gundk)
PEGA
Principal Engineer, Technical Support
Pegasystems Inc.
IN

Hi,

Please fallow below steps

Copy the content of install.sql file from path…pega8.1\ResourceKit\PLJava\9.5\Windows(or)Linux  (depends on your environment) location.

Paste the copied content into the pgAdmin Create Script tab then select all queries and click on Execute/Refresh - gets success message

Observe that sqlj schema will be created in your database

To see attachments, please log in.

Accepted Solution

Posted: 5 years ago
Posted: 8 May 2019 7:06 EDT
somasekhar kummari (somasekhark5785)
Cognizant Technology Solutions India PVT Ltd

Cognizant Technology Solutions India PVT Ltd
IN

Hi Gundk,

 

I have created sqlj schema now it's working fine.

thanks a lot.  

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice