Question

3
Replies
2509
Views
ChandraD5557 Member since 2016 1 post
Tech Mahindra
Posted: December 23, 2016
Last activity: January 17, 2017
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:

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

 

 

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