ReportServer Forum

heiovsky

Member

Registered: 2017-06-20

Error during version upgrade - database RS3.0-16 -> RS3.0-24 -Postgres

Column type error UPDATE RS_SCHED_ACTION_MAIL_REPORT SET compressed = 0 where compressed is NULL

Column should be boolean or integer?

12-Oct-2022 12:12:53.557 INFO [main] net.datenwerke.rs.EnvironmentValidator.schemaupdate Performing database update RS3.0-16 -> RS3.0-24
12-Oct-2022 12:12:53.558 INFO [main] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-17-PostgreSQL_UPDATE.sql
12-Oct-2022 12:12:54.058 INFO [main] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-18-PostgreSQL_UPDATE.sql
12-Oct-2022 12:12:57.784 INFO [main] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-19-PostgreSQL_UPDATE.sql
12-Oct-2022 12:13:00.521 INFO [main] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-20-PostgreSQL_UPDATE.sql
12-Oct-2022 12:13:01.620 INFO [main] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-21-PostgreSQL_UPDATE.sql
12-Oct-2022 12:13:04.274 INFO [main] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-22-PostgreSQL_UPDATE.sql
12-Oct-2022 12:13:05.642 INFO [main] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-23-PostgreSQL_UPDATE.sql
12-Oct-2022 12:13:06.761 INFO [main] net.datenwerke.rs.EnvironmentValidator.doVersionUpdate Running script RS3.0-24-PostgreSQL_UPDATE.sql
12-Oct-2022 12:13:07.118 SEVERE [main] net.datenwerke.rs.EnvironmentValidator.processStatements Error executing update statement: BŁĄD: kolumna "compressed" jest typu boolean ale wyrażenie jest typu integer
  Wskazówka: Będziesz musiał przepisać lub rzutować wyrażenie.
  Pozycja: 53 (n=9, statement=UPDATE RS_SCHED_ACTION_MAIL_REPORT SET compressed = 0 where compressed is NULL)
12-Oct-2022 12:13:07.118 WARNING [main] net.datenwerke.rs.EnvironmentValidator.startup Error processing the schema update
    org.postgresql.util.PSQLException: BŁĄD: kolumna "compressed" jest typu boolean ale wyrażenie jest typu integer
  Wskazówka: Będziesz musiał przepisać lub rzutować wyrażenie.
  Pozycja: 53

Tobias F

Administrator

Registered: 2020-02-07

Re: Error during version upgrade - database RS3.0-16 -> RS3.0-24 -Postgres

Hi heiovsky,

this column should be boolean and NOT NULL. You can look it up in the ddl directory: reportserver-RSx.x.x-yyyy-schema-PostgreSQL_CREATE.sql

Regards.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Error during version upgrade - database RS3.0-16 -> RS3.0-24 -Postgres

Hi heiovsky,

as Tobias F pointed out, this field is in fact a boolean. We will check the upgrade script regarding the "= 0", and if it is a bug we will release a fixed version.

Regards,
Eduardo

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Error during version upgrade - database RS3.0-16 -> RS3.0-24 -Postgres

Hi heiovsky,

we found the bug and fixed it in ticket RS-6212. Pls revert your db to your previous backup (before the upgrade) and try with the next patch release. I will update here when the patch release is ready.

Regards,
Eduardo

heiovsky

Member

Registered: 2017-06-20

Re: Error during version upgrade - database RS3.0-16 -> RS3.0-24 -Postgres

Hi,
I fixed it by editing sql update file.

But i have other problem, schema validation now takes 1 hour long, should it be that long?

12-Oct-2022 13:58:04.545 INFO [main] net.datenwerke.rs.EnvironmentValidator.startup Validating database schema...

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Error during version upgrade - database RS3.0-16 -> RS3.0-24 -Postgres

Hi heiovsky,

this should not have changed between upgrades. Did you check this?  https://forum.reportserver.net/viewtopic.php?id=2708

Regards,
Eduardo

heiovsky

Member

Registered: 2017-06-20

Re: Error during version upgrade - database RS3.0-16 -> RS3.0-24 -Postgres

Problem fixed after using database from backup and then upgrading to new version.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Error during version upgrade - database RS3.0-16 -> RS3.0-24 -Postgres

Hi heiovsky,

pls note we released 4.3.0-6079 today with the fixed Postgres bug during the upgrade process: https://forum.reportserver.net/viewtopi … 9914#p9914

Regards,
Eduardo