Bitnami ReportServer stack upgrade

nikolajoder · 2021-12-24 07:18:52

Dear,

we are using Bitnami ReportServer stack 3.1.0. We would like to upgrade the complete stack to latest version.

Can you provide us with upgrade instructions?

Kind regards, Nikolaj.

eduardo · 2021-12-29 14:19:54

Hi nikolajoder,

we are looking into this and will let you know when we have more information.

Regards,
Eduardo

nikolajoder · 2022-01-05 12:06:16

Thank you for update.

Mario · 2022-01-07 14:44:40

nikolajoder wrote:

Thank you for update.

Dear nikolajoder,

here we got a blog entry that will solve your problem regarding the upgrade of the bitnami stack.

Please click on this blog entry.

Regards,
Mario

nikolajoder · 2022-01-10 07:02:59

Thank you for detailed instructions.

Kind regards, Nikolaj.

nikolajoder · 2022-01-10 09:57:24

Dear,

we tried the upgrade procedure, we are stuck with db export. We get the following error:

D:\Bitnami\reportserver-3.1.0.6016-0\mariadb\bin>mysqldump -ubn_reportserver -pxxxxxx
bitnami_reportserver > d:\install\report_server_dump_20220110.dmp
mysqldump: Error: 'Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf
8mb4_general_ci,COERCIBLE) for operation '='' when trying to dump tablespaces
mysqldump: Couldn't execute 'SELECT table_name FROM INFORMATION_SCHEMA.TABLES WH
ERE table_schema = DATABASE() AND table_name = 'á'': Illegal mix of collations (
utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' (
1267)

eduardo · 2022-01-10 10:20:09

Hi nikolajoder,

"AND table_name = 'á''" ? this is very strange. Can you pls check in your tables if you have some such table?

can you pls also post the result of this:
SELECT table_name FROM INFORMATION_SCHEMA.TABLES

you can create a dynamic list and look at the results. Do you have something similar as 'á' ?

Regards,
Eduardo

nikolajoder · 2022-01-10 11:04:34

eduardo · 2022-01-10 11:28:53

Hi nikolajoder,

thanks, we will compare this with our results. Can you pls sort them for easy comparison?

select table_name, table_collation FROM INFORMATION_SCHEMA.TABLES order by table_name

and post the results here again?

Regards,
Eduardo

nikolajoder · 2022-01-10 11:36:24

eduardo · 2022-01-10 12:21:40

Hi nikolajoder,

you have some tables not available in the ReportServer 3.1.0 version: rs_datasink_container(_a), rs_datasink_definition(_a), rs_datasink_folder(_a), and rs_datasink_mngr_node(_a).

This means you already performed some ReportServer upgrade, although the Bitnami stack version continues to be 3.1.0 (since the stack was not upgraded, only ReportServer).
Can you pls post 1. your exact rs-version (you can find it in the reportserver start screen, lower left) and 2. the content of the RS_SCHEMAINFO table ?

Regards,
Eduardo

nikolajoder · 2022-01-10 12:37:36

Yes, we made upgrades in the past, only for the application. Our current version:

RS3.6.0-6040
2021-05-11-12-35-17
Community Edition
English

nikolajoder · 2022-01-10 12:41:20

RS_SCHEMAINFO
MariaDB [bitnami_reportserver]> select * from RS_SCHEMAINFO;
+-----------+---------------+------------------------+
| ENTITY_ID | KEY_FIELD | value |
+-----------+---------------+------------------------+
| 1 | created | 2020-01-08 08:23:53 |
| 2 | version | RS3.1.0-6016 |
| 3 | schemaversion | RS3.0-14 |
| 4 | updated | 2020-02-03 11:04:01 |
| 5 | script | RS3.0-15-MySQL5_UPDATE |
| 6 | schemaversion | RS3.0-15 |
| 7 | updated | 2020-07-09 08:38:27 |
| 8 | script | RS3.0-16-MySQL5_UPDATE |
| 9 | schemaversion | RS3.0-16 |
| 10 | updated | 2020-07-09 08:38:27 |
| 11 | script | RS3.0-17-MySQL5_UPDATE |
| 12 | schemaversion | RS3.0-17 |
| 13 | updated | 2021-03-02 07:38:59 |
| 14 | script | RS3.0-18-MySQL5_UPDATE |
| 15 | schemaversion | RS3.0-18 |
| 16 | updated | 2021-05-13 08:35:52 |
| 17 | script | RS3.0-19-MySQL5_UPDATE |
| 18 | schemaversion | RS3.0-19 |
+-----------+---------------+------------------------+
18 rows in set (0.002 sec)

eduardo · 2022-01-10 15:56:09

Hi nikolajoder,

we tested these scenarios:
1. install bitnami 3.6.0 and create a dump -> it works
2. install bitnami 3.1.0, upgrade rs to 3.6.0 and create a dump -> it works

so we cannot reproduce the problem you got.
Did you change anything on your tables manually, or create/change something on your tables? In our test environment it works as described in the blog entry.

Regards,
Eduardo

nikolajoder · 2022-01-11 06:54:23

No, we did not change anything on the database.

It looks, the problem is, that tables in different schemas of the bitnami_reportserver database have different table_collation setting. We did not change that manually.

We will try a new installation of latest bitnami stack and check the table_collation settings there.

Kind regards, Nikolaj.

nikolajoder · 2022-01-11 08:07:49

With new installation (Bitnami stack 3.7.1) dump works.

We will load the data from export and try dump again.

eduardo · 2022-01-11 08:26:46

Hi nikolajoder,

"We will load the data from export and try dump again." ->

if you are able to export the complete database of your old installation and import it into the new bitnami installation, that's all you need, as this is what we are doing with a database dump. So if this works by any other backup/restore way, it will do the job instead of a database dump

Pls let us know how this works. Always pls refer to the blog entry for the other steps of the upgrade.

Regards,
Eduardo

nikolajoder · 2022-01-12 07:11:20

We installed new instance of RS Bitnami Stack v3.7.1. We used RS build-in Export & Import Tools. We are having issues with Saiku Reports, i reported the error in separate forum entry.

Kind regards, Nikolaj.

eduardo · 2022-01-12 09:13:12

Hi nikolajoder,

ok, pls just keep in mind that the rs export-import functionality is not guaranteed to work for different-version export/import, only for same versions. But as you had a relatively new version (RS3.6.0-6040) and you are installing RS3.7.1, if this works for you, fine

But pls make sure you can dump the data in the new version 3.7.1 so you can upgrade by the upgrade guide in the future.

Regading your issues with Saiku I will take a look at the separate entry.

Regards,
Eduardo

nikolajoder · 2022-01-12 10:20:21

We installed the latest version of Bitnami RS 3.7.1, after installation we tried the export, the error is the same:

D:\Bitnami\reportserver-3.7.1.6050-0\mariadb\bin>mysqldump -ubn_reportserver -p6e5ee8d66c bitnami_reportserver > d:\install\report_server_dump_20220110.dmp
mysqldump: Error: 'Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='' when trying to dump tablespaces
mysqldump: Couldn't execute 'SELECT table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = DATABASE() AND table_name = 'á'': Illegal mix of collations (
utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' (1267)

eduardo · 2022-01-12 10:26:58

Hi nikolajoder,

"after installation" and after import of your previously exported reports, or just after a fresh 3.7.1 installation?

Regards,
Eduardo

nikolajoder · 2022-01-12 11:20:23

After installation meaning right after new install and before any imports.

eduardo · 2022-01-12 11:29:41

Hi nikolajoder,

we will double-check after a fresh installation if we get this error too.

Regards,
Eduardo

eduardo · 2022-01-12 13:55:34

Hi nikolajoder,

in our case, with a fresh 3.7.1 installation, the dump works, so we are not able to reproduce the problem.
Nevertheless, I am asking the Bitnami team, maybe they have some idea why you may be getting this error.

Regards,
Eduardo

nikolajoder · 2022-01-13 11:44:20

Dear Eduardo,

we tried with --force option when exporting. It works fine.

Thank you.

Kind regards, Nikolaj.

ReportServer Forum

#1 2021-12-24 07:18:52

Bitnami ReportServer stack upgrade

#2 2021-12-29 14:19:54

Re: Bitnami ReportServer stack upgrade

#3 2022-01-05 12:06:16

Re: Bitnami ReportServer stack upgrade

#4 2022-01-07 14:44:40

Re: Bitnami ReportServer stack upgrade

#5 2022-01-10 07:02:59

Re: Bitnami ReportServer stack upgrade

#6 2022-01-10 09:57:24

Re: Bitnami ReportServer stack upgrade

#7 2022-01-10 10:20:09

Re: Bitnami ReportServer stack upgrade

#8 2022-01-10 11:04:34

Re: Bitnami ReportServer stack upgrade

#9 2022-01-10 11:28:53

Re: Bitnami ReportServer stack upgrade

#10 2022-01-10 11:36:24

Re: Bitnami ReportServer stack upgrade

#11 2022-01-10 12:21:40

Re: Bitnami ReportServer stack upgrade

#12 2022-01-10 12:37:36

Re: Bitnami ReportServer stack upgrade

#13 2022-01-10 12:41:20

Re: Bitnami ReportServer stack upgrade

#14 2022-01-10 15:56:09

Re: Bitnami ReportServer stack upgrade

#15 2022-01-11 06:54:23

Re: Bitnami ReportServer stack upgrade

#16 2022-01-11 08:07:49

Re: Bitnami ReportServer stack upgrade

#17 2022-01-11 08:26:46

Re: Bitnami ReportServer stack upgrade

#18 2022-01-12 07:11:20

Re: Bitnami ReportServer stack upgrade

#19 2022-01-12 09:13:12

Re: Bitnami ReportServer stack upgrade

#20 2022-01-12 10:20:21

Re: Bitnami ReportServer stack upgrade

#21 2022-01-12 10:26:58

Re: Bitnami ReportServer stack upgrade

#22 2022-01-12 11:20:23

Re: Bitnami ReportServer stack upgrade

#23 2022-01-12 11:29:41

Re: Bitnami ReportServer stack upgrade

#24 2022-01-12 13:55:34

Re: Bitnami ReportServer stack upgrade

#25 2022-01-13 11:44:20

Re: Bitnami ReportServer stack upgrade

Board footer