You are not logged in.
Pages: 1
At the moment I have version RS3. 3.0-6030.
When I trying to update to ReportServer version 3.4.0-6033, I get an error when upgrading the schema script RS3. 0-18-PostgreSQL_UPDATE.sql
ERROR: column "show_execute_button" is of type boolean but expression is of type integer.
Please,tell me how to solve this problem?
Last edited by dubeshko.alexei (2021-03-10 11:53:21)
Offline
I have the same problem.
Is there an easy solution?
I don't want to modify the database manually without background.
Cheers,
Christoph
Offline
Hi Dubeshko and Christoph,
thanks for letting us know, we are working on a fix for this (RS-4768). I will write later here with the fix.
Pls. restore your database backup completely.
Regards,
Eduardo
Offline
Hi Dubeshko and Christoph,
we released 3.4.0-6034 today, which should solve the problem. After restoring your database backup to the old version, you can try the upgrade again.
Regards,
Eduardo
Offline
Hi, Eduardo.
Now I have the following error:
ERROR: syntax error at or near "$"
Position: 119 (n=5, statement=rs_for: SELECT id AS REP_SCHED_EXECUTE_REPORT_JOB WHERE report_id = ${REP_ID})
Position: 119 (n=5, statement=rs_for: SELECT id AS REP_ID, NAME_FIELD AS REP_NAME, description AS REP_DESCRIPTION FROM RS_REPORT)
Offline
Hi Dubeshko,
we are currently looking into this.
Regards,
Eduardo
Offline
Hi Dubeshko and Christoph,
we released 3.4.0-6035 today, which should solve the problem. After restoring your database backup to the old version, you can try the upgrade again.
Regards,
Eduardo
Offline
Hi Eduardo.
The update was successful. Thanks for solving this problem. However, I noticed one more thing. Unable to import report link into teamspace.
When I click on the "import reports" button in teamspace and go to the "catalog" link, I don't see any of my reports. The search button is also missing.
Offline
Hi Dubeshko,
since 3.4.0, the catalog loads reports on-demand, i.e. not all reports are loaded in the beginning, as you may have thousands of reports, this does not work well (performance). You can now use the search field for looking for a specific report (analogous as with the search).
See here: https://reportserver.net/releasenotes/RS3.4.0.html
RS-4504 Improvement Allow report server-side search in report catalog dialog for avoiding to load complete catalog on dialog init
Regards,
Eduardo
Offline
Hi Dubeshko,
can you pls post which postgres version are you using currently? We are checking postgres driver versions, that's why I ask.
Regards,
Eduardo
Offline
Hi Eduardo,
At the moment I have psql(PostgreSQL) 9.2.24
Offline
Hi Dubeshko,
thanks for the info!
Regards,
Eduardo
Offline
Not at all. Thanks for solving the problem
Offline
Pages: 1