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

 Hari C (HariC982)
Schwab

Schwab
US
HariC982 Member since 2017 5 posts
Schwab
Posted: Nov 18, 2018
Last activity: Jul 31, 2019
Posted: 18 Nov 2018 12:15 EST
Last activity: 31 Jul 2019 7:26 EDT
Closed
Solved

pega 8.1.1 installation missing sqlj.jar_repository for postgres

During installation of pega 8.1.1 with postgres for standalone application installation, the installation fails during the UDF step as it doesnt find a particular jar, sqlj.jar_repository.

Below is detailed error message

Show More

During installation of pega 8.1.1 with postgres for standalone application installation, the installation fails during the UDF step as it doesnt find a particular jar, sqlj.jar_repository.

Below is detailed error message

[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)

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

Posted: 5 years ago
Posted: 31 Jul 2019 7:26 EDT
Vidyaranjan AV (Vidyaranjan) Senior Online Community Moderator
Pegasystems Inc.
IN

Hi @Thomass5914 -

Thank you for posting your query in the PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write Post button here. Once created, please reply here with the URL of the new post.

You may also refer this discussion link as a reference in the new thread.

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