Question

3
Replies
2203
Views
Close popover
Prem Mishra (mishp4)
PEGA
Sr. System Architect
Pegasystems Inc.
AU
mishp4 Member since 2015 5 posts
PEGA
Posted: November 12, 2015
Last activity: November 29, 2015
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.

System Administration Installation and Deployment
Moderation Team has archived post,
Close popover 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.