#1 2021-03-10 08:26:26

dubeshko.alexei
Member
Registered: 2021-02-04

Database update RS3. 0-17 - >RS3. 0-18

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

#2 2021-03-12 07:53:34

itatwork
Member
Registered: 2019-12-11

Re: Database update RS3. 0-17 - >RS3. 0-18

I have the same problem.
Is there an easy solution?
I don't want to modify the database manually without background.

Cheers,
Christoph

Offline

#3 2021-03-12 08:02:48

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Database update RS3. 0-17 - >RS3. 0-18

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

#4 2021-03-12 11:17:21

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Database update RS3. 0-17 - >RS3. 0-18

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

#5 2021-03-12 12:50:05

dubeshko.alexei
Member
Registered: 2021-02-04

Re: Database update RS3. 0-17 - >RS3. 0-18

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

#6 2021-03-22 09:43:56

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Database update RS3. 0-17 - >RS3. 0-18

Hi Dubeshko,

we are currently looking into this.

Regards,
Eduardo

Offline

#7 2021-03-23 16:16:32

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Database update RS3. 0-17 - >RS3. 0-18

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

#8 2021-03-24 06:25:26

dubeshko.alexei
Member
Registered: 2021-02-04

Re: Database update RS3. 0-17 - >RS3. 0-18

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

#9 2021-03-24 09:30:05

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Database update RS3. 0-17 - >RS3. 0-18

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

#10 2021-03-24 14:02:30

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Database update RS3. 0-17 - >RS3. 0-18

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

#11 2021-03-24 14:13:48

dubeshko.alexei
Member
Registered: 2021-02-04

Re: Database update RS3. 0-17 - >RS3. 0-18

Hi Eduardo,
At the moment I have psql(PostgreSQL) 9.2.24

Offline

#12 2021-03-24 14:25:29

eduardo
Administrator
Registered: 2016-11-01
Website

Re: Database update RS3. 0-17 - >RS3. 0-18

Hi Dubeshko,

thanks for the info!

Regards,
Eduardo

Offline

#13 2021-03-24 14:33:51

dubeshko.alexei
Member
Registered: 2021-02-04

Re: Database update RS3. 0-17 - >RS3. 0-18

Not at all. Thanks for solving the problem

Offline

Board footer

Powered by FluxBB