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

 RuoYue Dai (YueDai2358)
WTS Advisory
Senior Manager
WTS Advisory
DE
YueDai2358 Member since 2015 3 posts
WTS Advisory
Posted: Sep 25, 2017
Last activity: Oct 11, 2017
Posted: 25 Sep 2017 12:12 EDT
Last activity: 11 Oct 2017 8:26 EDT
Closed
Solved

Error when update 7.3 from 7.1.9

Hello,

I'm updating 7.1.9 to 7.3 and following the UpdateGuide.

Now I'm keep getting the following error without further solution. Please Support.

Show More

Hello,

I'm updating 7.1.9 to 7.3 and following the UpdateGuide.

Now I'm keep getting the following error without further solution. Please Support.

[java] org.postgresql.util.PSQLException: FEHLER: Spalte „pztenantid“ enthält NULL-Werte
[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:406)
[java] at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:398)
[java] at com.pega.pegarules.install.SQLLoaderInternal.readAndExecuteSQLStatements(SQLLoaderInternal.java:151)
[java] at com.pega.pegarules.install.SQLLoaderInternal.load(SQLLoaderInternal.java:110)
[java] at com.pega.pegarules.install.SQLLoader.loadInner(SQLLoader.java:98)
[java] at com.pega.pegarules.install.SQLLoader.load(SQLLoader.java:77)
[java] at com.pega.pegarules.install.SQLLoader.main(SQLLoader.java:65)
[java] 2017-09-25 18:07:20,045 ( SQLLoaderInternal) WARNING - Statement: ALTER TABLE rulesschema.pr_changelog ADD "pztenantid" VARCHAR(255) NOT NULL
[java] 2017-09-25 18:07:20,045 ( SQLLoaderInternal) WARNING -


Show Less
To see attachments, please log in.
Updates

Accepted Solution

Posted: 7 years ago
Posted: 27 Sep 2017 6:25 EDT
Mohammad Asif Hasan (Mohammad_Asif_Hasan)
EPAM Systems, Inc.
Mohammad Asif Hasan
EPAM Systems, Inc.
ES

Similar stack was reported with Postgres database, please fix the PL/Java configuration and re-run the upgrade set up file.

Hope it helps.

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