Question

3
Replies
2592
Views
Chandra Das (ChandraD5557)
Tech Mahindra

Tech Mahindra
CA
ChandraD5557 Member since 2016 1 post
Tech Mahindra
Posted: December 23, 2016
Last activity: January 17, 2017
Posted: 23 Dec 2016 14:15 EST
Last activity: 17 Jan 2017 8:52 EST
Closed

PEGA 722 Installation: Issue while loading UDF

Require your help to resolve the issue.


Below resources used for this installation


1) App server - tomcat


2) Database server - Postgres 9.3; Also tried with Postgres Plus Advance 9.5


3) JAVA version - 8


4) postgresql.conf file has also been attached 


Got below error while loading UDF file:


Apply UDFs:


Apply UDFs Inner:

Require your help to resolve the issue.

Below resources used for this installation

1) App server - tomcat

2) Database server - Postgres 9.3; Also tried with Postgres Plus Advance 9.5

3) JAVA version - 8

4) postgresql.conf file has also been attached 

Got below error while loading UDF file:

Apply UDFs:

Apply UDFs Inner:

Load UDF:
Execute SQL In Transaction:false
    [mkdir] Created dir: C:\Users\dasc\AppData\Local\Temp\1\PegaInstallTemp-23-December-2016-12.07.59\udf_temp
     [copy] Copying 3 files to C:\Users\dasc\AppData\Local\Temp\1\PegaInstallTemp-23-December-2016-12.07.59\udf_temp
     [echo] arg values : --config=C:\Users\dasc\AppData\Local\Temp\1\/PegaInstallTemp-23-December-2016-12.07.59/prbootstrap.properties --profile=install.postgres --dataOnly=false --run-in-transaction=false --jar-path=C:\Users\dasc\Documents\Softwares\PEGA722\scripts/../archives/udf/prreadstream.jar C:\Users\dasc\AppData\Local\Temp\1\/PegaInstallTemp-23-December-2016-12.07.59/udf_temp
     [java] 2016-12-23 12:11:17,224 (                         UDFManager)    INFO - AutoCommit set to true. Executing with out transaction
     [java] 2016-12-23 12:11:17,239 (               PostgresUDFJarLoader)    INFO - Loading UDF jar on Postgres DB
     [java] 2016-12-23 12:11:17,239 (                  ConnectionWrapper)    INFO - Attempting to load profile "install.postgres": 
     [java] 2016-12-23 12:11:17,239 (                  ConnectionWrapper)    INFO -     Type: postgres
     [java] 2016-12-23 12:11:17,239 (                  ConnectionWrapper)    INFO -     Class: org.postgresql.Driver
     [java] 2016-12-23 12:11:17,239 (                  ConnectionWrapper)    INFO -     URL: jdbc:postgresql://localhost:5444/prpc
     [java] 2016-12-23 12:11:17,239 (                  ConnectionWrapper)    INFO -     User: pegauser
     [java] 2016-12-23 12:11:17,239 (                  ConnectionWrapper)    INFO -     JDBC Properties: 
     [java] 2016-12-23 12:11:17,551 (                  ConnectionWrapper)    INFO - Autocommit set to true
     [java] 2016-12-23 12:11:17,567 (               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] 2016-12-23 12:11:17,567 (               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:2455)
     [java]     at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
     [java]     at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
     [java]     at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
     [java]     at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
     [java]     at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
     [java]     at org.postgresql.jdbc.PgCallableStatement.executeWithFlags(PgCallableStatement.java:78)
     [java]     at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
     [java]     at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.isJarLoadedPostgres(PostgresUDFJarLoader.java:161)
     [java]     at com.pega.pegarules.install.udf.loaders.PostgresUDFJarLoader.installJarOnPostgres(PostgresUDFJarLoader.java:122)
     [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

 

 

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.