Question
Tech Mahindra
CA
Last activity: 17 Jan 2017 8:52 EST
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
Pegasystems Inc.
IN
I hope you are referring ResourceKitREADME.txt. If you do not
install PL/Java before you attempt to install the Pega 7 Platform, the installation fails.
Instead using Pega provided PlJava, can you download the zip from below location and try?
https://www.postgresql.org/ftp/projects/pgFoundry/pljava/pljava/1.4.3/
CIBC
CA
Yes I referred "ResourceKitREADME.txt" while installing pljava. Still throwing error while loading UDF. OS version I am using here is Windows2010.
PEG
GB
I've not previously done this installation on PostgreSQL. So this may turn out to be of no help whatsoever.
But I was running into the same error/stack
I've not previously done this installation on PostgreSQL. So this may turn out to be of no help whatsoever.
But I was running into the same error/stack
[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:2182)
[java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
[java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:615)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:465)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:350)
[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)
This appears to be attempting to run the following sql statement: -
select jarname from sqlj.jar_repository
And if I tried running this statement directly in psql (as the same user that I'd used during the install) then I was receiving a similar error.
So it appears that it's looking for schema named sqlj which didn't exist in my system.
To address this, as well as following the steps from ResourceKitREADME.txt, I'd also import the "install.sql" file.
So in PSQL I'd just running the following: -
postgres=# \i 'D:\\download2\\pega\\PRPC\\PEGA_7_2_1\\115143_Pega721\\ResourceKit\\PLJava\\9.4\\Windows\\install.sql'
This should hopefully show that it created a number of objects.
Similarly, when I now view the schemas in my database in pgAdmin I can now see the sqlj schema
Might be worth a try