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

 Prem Mishra (mishp4) PEGA Sr. System Architect
Pegasystems Inc.
AU
mishp4 Member since 2015 5 posts
PEGA
Posted: Nov 12, 2015
Last activity: Nov 29, 2015
Posted: 12 Nov 2015 7:17 EST
Last activity: 29 Nov 2015 18:41 EST
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)

Show More

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.


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

Accepted Solution

Posted: 8 years ago
Posted: 12 Nov 2015 7:53 EST
John Pritchard-Williams (JOHNPW_GCS) Client Support Team Lead
Pegasystems Inc.
GB

Hi Premjit,

I installed Pega 719 Personal Edition on my 64bit Windows system with no issue:

my-os.png

my-startup.png

my-login.png

Can you check that you are installing with this with a Windows User which is has Local Administrative rights  - I believe you have to be a Local Admin for the installation to work.... (although I don't that the specific symptoms you get are related to this or not - I haven't tried with Local Admin Rights).


Cheers

John

To see attachments, please log in.
Posted: 8 years ago
Posted: 12 Nov 2015 15:27 EST
Prem Mishra (mishp4) PEGA Sr. System Architect
Pegasystems Inc.
AU

Hi John,

           Thank you for your inputs. I have logged in as an Admin.Btw which Postgres and Java version do you have in your setup ?  In my installation,I had only the Pega software.It mentions that its packaged with PostGres and tomcat as well which I did  not find when I downloaded 2 months back.So I had to download them.

Thank You,

Prem

To see attachments, please log in.
Posted: 8 years ago
Posted: 29 Nov 2015 18:41 EST
Prem Mishra (mishp4) PEGA Sr. System Architect
Pegasystems Inc.
AU

Downloaded the Personal edition and it installed fine.The issue mentioned was for the actual platform which did not come packaged with any App server or DB.Closing the ticket.

Thank You,

Prem

To see attachments, please log in.

Related content:

Question Solved

ERROR: function data.sppr_purge_table(character varying, character varying, integer) does not exist

Question

SQLState: 42P01 Message: ERROR: relation "sqlj.classpath_entry" does not exist

Question

SEVERE: Connection error: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and po

Question Solved

org.postgresql.util.PSQLException: This connection has been closed when installing pega719

Question Solved

org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the

Question

SEVERE: Connection error: org.postgresql.util.PSQLException: Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

Support Doc

org.postgresql.util.PSQLException error when pr_index_operators table size expands significantly

Question

installing pega 8.6 + error: pagarules schema does not exist in the database

Question Solved

ERROR: column "total_time" does not exist

Question Solved

get error Unable to load class: org.postgresql.Driver when installing Pega 8.64

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