Question

3
Replies
2114
Views
mishp4 Member since 2015 5 posts
PEGA
Posted: 4 years ago
Last activity: 4 years 9 months ago
Closed
Solved

org.postgresql.util.PSQLException: ERROR: function sqlj.get_classpath(character varying) does not exist

I am trying to install a personal edition of Pega 7.1.9 on Tomcat and Postgres 9.3 on windows 64 bit machine.The rules and data schema works fine.When it tried to load the UDF module,it fails with below error:

+++++++++++++++++++++++++++++++++++++++++++++++

Install UDF Jar:

     [java] 2015-11-12 23:10:21,590 (              DatabaseLibraryLoader)    INFO - Loading user-defined functions into the database.

     [java] 2015-11-12 23:10:21,623 (              DatabaseLibraryLoader)    INFO - Using a Postgres database.

     [java] 2015-11-12 23:10:21,836 (              DatabaseLibraryLoader)    INFO - Jar is not already loaded.

     [java] 2015-11-12 23:10:21,842 (              DatabaseLibraryLoader) WARNING - Encountered a database problem when attempting to load jar onto PostgreSQL: ERROR: function sqlj.get_classpath(character varying) does not exist

     [java]   Hint: No function matches the given name and argument types. You might need to add explicit type casts.

     [java]   Position: 8

     [java]

     [java] org.postgresql.util.PSQLException: ERROR: function sqlj.get_classpath(character varying) does not exist

     [java]   Hint: No function matches the given name and argument types. You might need to add explicit type casts.

     [java]   Position: 8

     [java] at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2198)

     [java] at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1927)

     [java] at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)

     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:562)

     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:420)

     [java] at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:305)

     [java] at com.pega.pegarules.install.DatabaseLibraryLoader.loadJarIntoPostgres(DatabaseLibraryLoader.java:939)

     [java] at com.pega.pegarules.install.DatabaseLibraryLoader.installJarOnPostgres(DatabaseLibraryLoader.java:270)

     [java] at com.pega.pegarules.install.DatabaseLibraryLoader.runMainProgramWithoutExiting(DatabaseLibraryLoader.java:226)

     [java] at com.pega.pegarules.install.DatabaseLibraryLoader.main(DatabaseLibraryLoader.java:144)

     [java] 2015-11-12 23:10:21,844 (              DatabaseLibraryLoader)    INFO -

     [java] *****************************************************************************************************

     [java]

     [java] Encountered database error attempting to load UDF library onto PostgreSQL, clean schema before running again.

     [java]

     [java] *****************************************************************************************************

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++==

I have added the jar file in the postgres lib and specified the path  as  below  in the postgresql file.

work_mem = 5MB

pljava.classpath='C:\\Postgres\\lib\\pljava.jar'

Any hints appreciated.

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