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

4
Replies
507
Views
 Prathyusha Nidamanuru (PrathyushaNidamanuru) Cognizant Tech Lead
Cognizant
IN
PrathyushaNidamanuru Member since 2018 4 posts
Cognizant
Posted: March 18, 2019
Last activity: March 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

Report

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
Low-Code App Development Installation and Deployment
Posted: 4 years ago
Posted: 18 Mar 2019 8:37 EDT
Kevin Zheng (KevinZheng_GCS) PEGA Director, Technical Support
Pegasystems Inc.
US
Report

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.
Posted: 4 years ago
Posted: 18 Mar 2019 8:54 EDT
Prathyusha Nidamanuru (PrathyushaNidamanuru) Cognizant Tech Lead
Cognizant
IN
Report

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

Accepted Solution

Posted: 4 years ago
Posted: 18 Mar 2019 9:33 EDT
KrishnaChaitanya Gaddipati (KrishnaCG) ATOS
ATOS
GB
Report

I don't think schema data is cleared completed before re-run, below statements from log pointing me to that conclusion 

relation "pr_log_reportstats" already exists
Posted: 4 years ago
Posted: 18 Mar 2019 10:46 EDT
Prathyusha Nidamanuru (PrathyushaNidamanuru) Cognizant Tech Lead
Cognizant
IN
Report

Thanks Krishna..It resolved my issue. I found some uncleared scripts under scripts\generated and cleared them.

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