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

 Prathyusha Nidamanuru (PrathyushaNidamanuru)
Cognizant
Tech Lead
Cognizant
IN
PrathyushaNidamanuru Member since 2018 4 posts
Cognizant
Posted: Mar 18, 2019
Last activity: Mar 18, 2019
Posted: 18 Mar 2019 7:51 EDT
Last activity: 18 Mar 2019 15:57 EDT
Closed
Solved

Pega 7.2 installation load UDF library issue

Hi,

I'm running pega platform set up for 7.2 version. Installation wizard stopped running with this error

Show More

Hi,

I'm running pega platform set up for 7.2 version. Installation wizard stopped running with this error

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.DatabaseLibraryLoader.isJarLoadedPostgres(DatabaseLibraryLoader.java:1150)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.installJarOnPostgres(DatabaseLibraryLoader.java:267)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.runMainProgramWithoutExiting(DatabaseLibraryLoader.java:226)
[java] at com.pega.pegarules.install.DatabaseLibraryLoader.main(DatabaseLibraryLoader.java:144)
[java] 2019-03-18 16:24:20,792 ( DatabaseLibraryLoader) INFO -
[java] *****************************************************************************************************
[java]
[java] Encountered database error attempting to load UDF library onto PostgreSQL, clean schema before running again.
Can any one help me on this. Thanks in advance

Show Less
To see attachments, please log in.
Low-Code App Development
Installation and Deployment

Posted: 6 years ago
Posted: 18 Mar 2019 8:37 EDT
Kevin Zheng (KevinZheng_GCS)
PEGA
Director, Technical Support
Pegasystems Inc.
US

You either need to setup UDF or simply by pass it by setting

bypass.udf.generation=true

In the scripts/setupDatabase.properties file (rerun the installation)

UDF is really just for dev purposes not affecting key features.

To see attachments, please log in.
Posted: 6 years ago
Posted: 18 Mar 2019 8:54 EDT
Prathyusha Nidamanuru (PrathyushaNidamanuru)
Cognizant
Tech Lead
Cognizant
IN

Hi Kevin,

Thanks for the reply. I've added that setting in setupDatabase.properties file, cleared all the schema data and re-ran. Now I got the below issue

Show More

Hi Kevin,

Thanks for the reply. I've added that setting in setupDatabase.properties file, cleared all the schema data and re-ran. Now I got the below issue

Exception in thread "main" com.pega.pegarules.install.SQLLoader$SQLLoaderException:
     [java] ********************************************************************************
     [java]
     [java] Encountered a SQL Exception, clean schema before running again.
     [java]
     [java] ********************************************************************************
     [java]     at com.pega.pegarules.install.SQLLoader.fail(SQLLoader.java:359)
     [java]     at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:316)

 In PostgreSQL logs, I found the below description

2019-03-18 17:54:10 IST ERROR:  relation "pegarules.pr4_base" does not exist at character 22
2019-03-18 17:54:10 IST STATEMENT:  SELECT COUNT(*) FROM pegarules.PR4_BASE
2019-03-18 17:54:15 IST ERROR:  relation "pegarules.pr4_base" does not exist at character 22
2019-03-18 17:54:15 IST STATEMENT:  SELECT COUNT(*) FROM pegarules.PR4_BASE
2019-03-18 17:55:31 IST ERROR:  relation "pegarules.pr_engineclasses" does not exist at character 106
2019-03-18 17:55:31 IST STATEMENT:  select pzjar, pzpackage, pzclass, pzlastmodified, pzsha1, pzmoduleversion, pzstate, pzbinarycontent from pegarules.pr_engineclasses where pzpackage = $1 and pzclass = $2 and pzjar = $3 and pzcodeset = $4 and pzcodesetversion = $5 and pzpatchdate = $6
2019-03-18 17:55:31 IST LOG:  could not receive data from client: An existing connection was forcibly closed by the remote host.

In Pega platform scripts\logs, found the below
 
2019-03-18 17:34:30,826 (                          SQLLoader)    INFO - Starting logging to : 'logs/SQLinstaller.log'
2019-03-18 17:34:30,826 (                          SQLLoader)    INFO - Attempting to load profile "install.postgres": 
2019-03-18 17:34:30,826 (                          SQLLoader)    INFO - Type: postgres
2019-03-18 17:34:30,826 (                          SQLLoader)    INFO - Class: org.postgresql.Driver
2019-03-18 17:34:30,826 (                          SQLLoader)    INFO - URL: jdbc:postgresql://localhost:5432/postgres
2019-03-18 17:34:30,826 (                          SQLLoader)    INFO - User: postgres
2019-03-18 17:34:30,826 (                          SQLLoader)    INFO - JDBC Properties: 
2019-03-18 17:34:31,073 (                          SQLLoader)    INFO - Starting on C:\Users\prathyusha.nidamanur\Desktop\SD_upgrade\Pega Platform 7.2\schema\generated\postgres\install\statements
2019-03-18 17:34:31,088 (                          SQLLoader)    INFO - File: postgres00010.sql
2019-03-18 17:34:31,088 (                          SQLLoader)    INFO - CREATE TABLE PEGADATA.PR_LOG_REPORTSTATS
2019-03-18 17:34:31,157 (                          SQLLoader) WARNING - Failed to execute SQL in file postgres00010.sql
org.postgresql.util.PSQLException: ERROR: relation "pr_log_reportstats" already exists
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:615)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:451)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:443)
at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:266)
2019-03-18 17:34:31,157 (                          SQLLoader) WARNING - Statement: create table pegadata.pr_log_reportstats
(
    pxcommitdatetime TIMESTAMP NULL,
    pxsavedatetime TIMESTAMP NULL,
    pxcreatedatetime TIMESTAMP NULL,
    pxcreatesystemid VARCHAR(32) NULL,
    pxinsname VARCHAR(512) NULL,
    pxobjclass VARCHAR(96) NULL,
    pxsessionid VARCHAR(128) NULL,
    pyclassname VARCHAR(96) NULL,
    pxerrorcount DECIMAL(18) NULL,
    pxtotalelapsedtime DECIMAL(18) NULL,
    pxmodeofexecution VARCHAR(32) NULL,
    pxreportexecutioncount DECIMAL(18) NULL,
    pxreportinskey VARCHAR(255) NULL,
    pxreportoperator VARCHAR(128) NULL,
    pystreamname VARCHAR(64) NULL,
    pxrowsretrieved DECIMAL(18) NULL,
    pzinskey VARCHAR(512) NOT NULL
)

Show Less
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