You are not logged in.
hi
we are getting some issues
we have upgraded to RS4.3.0-6078 from RS3.0.2-5855
we have the application sitting on an AWS elastic Beanstalk instance and the Database sitting on an RDS instance running postgresSQL Database
when we try to access the web page we get the following
----------------------------------
ReportServer encountered an error while validating its environment. Please check the server log files for additional information.
_____ _ _____
| __ \ | | / ____|
| |__) |___ _ __ ___ _ __| |_| (___ ___ _ ____ _____ _ __
| _ // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__|
| | \ \ __/ |_) | (_) | | | |_ ____) | __/ | \ V / __/ |
|_| \_\___| .__/ \___/|_| \__|_____/ \___|_| \_/ \___|_|
| |
|_|
Version: RS4.3.0-6078 2022-09-08-21-33-32
Code Version: 2022-09-06-22-15-35
Java Version: Amazon.com Inc. OpenJDK 64-Bit Server VM 11.0.16.1+9-LTS (11)
VM Args: -DJDBC_CONNECTION_STRING= -Xmx3096m -Djava.awt.headless=true -XX:+UseConcMarkSweepGC -Dfile.encoding=UTF8 -Drs.configdir=/opt/reportserver -Xms512m -Dcatalina.base=/usr/share/tomcat -Dcatalina.home=/usr/share/tomcat -Djava.endorsed.dirs= -Djava.io.tmpdir=/var/cache/tomcat/temp -Djava.util.logging.config.file=/usr/share/tomcat/conf/logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
Max memory: 3,079 MB
rs.configdir: /opt/reportserver (OK)
### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.PostgreSQLDialect (OK)
hibernate.connection.driver_class: org.postgresql.Driver (OK)
hibernate.connection.url: jdbc:postgresql://glappdrepdb-0001.c2jhshatyxji.eu-west-2.rds.amazonaws.com/glarepdb (OK)
hibernate.connection.username: glarepdbsvc
hibernate.connection.password: **********
hibernate.default_schema:
Connection Test: OK
Schema Version: RS3.0-23
### Internal datasource metadata ###
Database name: PostgreSQL
Database version: 12.6
Driver name: PostgreSQL JDBC Driver
Driver version: 42.5.0
JDBC major version: 4
JDBC minor version: 2
JDBC URL: jdbc:postgresql://glappdrepdb-0001.c2jhshatyxji.eu-west-2.rds.amazonaws.com/glarepdb
JDBC username: glarepdbsvc
there is no error message to go on in the Tomcat logs and we can see there are no active connections to the RDS database
Offline
Hi Hamlynboi,
if you revert your database to the previous state RS3.0.2-5855, make sure you can start it and it is really version RS3.0.2-5855, then you follow this upgrade guide:
https://reportserver.net/en/tutorials/upgrade-30/
and you start reportserver without stopping it, even if it takes a long time, you should see in the logs something similar as:
16:27:30.458 INFO n.datenwerke.rs.EnvironmentValidator - Performing database update RS3.0-11 -> RS3.0-24
16:27:34.220 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-12-MySQL5_UPDATE.sql
16:27:34.230 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-13-MySQL5_UPDATE.sql
16:27:34.240 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-14-MySQL5_UPDATE.sql
16:27:34.250 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-15-MySQL5_UPDATE.sql
16:27:34.260 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-16-MySQL5_UPDATE.sql
16:27:34.270 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-17-MySQL5_UPDATE.sql
16:27:34.280 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-18-MySQL5_UPDATE.sql
16:27:34.290 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-19-MySQL5_UPDATE.sql
16:27:34.300 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-20-MySQL5_UPDATE.sql
16:27:34.310 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-21-MySQL5_UPDATE.sql
16:27:34.320 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-22-MySQL5_UPDATE.sql
16:27:34.330 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-23-MySQL5_UPDATE.sql
16:27:34.340 INFO n.datenwerke.rs.EnvironmentValidator - Running script RS3.0-24-MySQL5_UPDATE.sql
16:29:35.175 INFO n.datenwerke.rs.EnvironmentValidator - Validating database schema...Pls make sure you see these logs to make sure that the upgrade works correctly.
Regards,
Eduardo
Offline
hi
we see the upgrade scripts run but we get this error
Nov 24 21:42:22 ip-10-62-3-105 server: 21:42:22.215 ERROR n.datenwerke.rs.EnvironmentValidator - Error executing update statement: ERROR: column "compressed" is of type boolean but expression is of type integer
Nov 24 21:42:22 ip-10-62-3-105 server: Hint: You will need to rewrite or cast the expression.
Nov 24 21:42:22 ip-10-62-3-105 server: Position: 53 (n=9, statement=UPDATE RS_SCHED_ACTION_MAIL_REPORT SET compressed = 0 where compressed is NULL)
Nov 24 21:42:22 ip-10-62-3-105 server: 21:42:22.226 WARN n.datenwerke.rs.EnvironmentValidator - Error processing the schema update
Nov 24 21:42:22 ip-10-62-3-105 server: org.postgresql.util.PSQLException: ERROR: column "compressed" is of type boolean but expression is of type integer
Nov 24 21:42:22 ip-10-62-3-105 server: Hint: You will need to rewrite or cast the expression.
Nov 24 21:42:22 ip-10-62-3-105 server: Position: 53
maybe we are trying to upgrade to a version we can't. e.g. we have to upgrade to an earlier version first.
Offline
Hi Hamlynboi,
pls always use the latest patch. This is resolved here:
https://reportserver.net/releasenotes/R … ckets-6079
RS-6212 Bug Upgrade script is not working for "compressed" fields in Postgres
Regards,
Eduardo
Offline