ReportServer encountered an error while validating its environment.

iincitr · 2022-10-29 18:52:07

Hi
I just used bitmani report server 4.3.0.6079

But I could not manage to run on windows 10 pro env.

localhost:82/reportserver/

*******************************************
ReportServer encountered an error while validating its environment. Please check the server log files for additional information.

_____ _ _____
| __ \ | | / ____|
| |__) |___ _ __ ___ _ __| |_| (___ ___ _ ____ _____ _ __
| _ // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__|
| | \ \ __/ |_) | (_) | | | |_ ____) | __/ | \ V / __/ |
|_| \_\___| .__/ \___/|_| \__|_____/ \___|_| \_/ \___|_|
| |
|_|

Version: RS4.3.0-6079 2022-10-19-13-16-45
Code Version: 2022-09-08-21-33-32
Java Version: BellSoft OpenJDK 64-Bit Server VM 11.0.16.1+1-LTS (11)
VM Args: -Dcatalina.home=C:\Bitnami\REPORT~2\APACHE~1 -Dcatalina.base=C:\Bitnami\REPORT~2\APACHE~1 -Dignore.endorsed.dirs=C:\Bitnami\REPORT~2\APACHE~1\endorsed -Djava.io.tmpdir=C:\Bitnami\REPORT~2\APACHE~1\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Bitnami\REPORT~2\APACHE~1\conf\logging.properties -Drs.configdir=C:\Bitnami\reportserver3/apps/reportserver/reportserver-conf -Dfile.encoding=UTF8 --add-opens=java.base/java.net=ALL-UNNAMED --add-opens=java.base/jdk.internal.ref=ALL-UNNAMED --add-opens=java.base/jdk.internal.reflect=ALL-UNNAMED --add-opens=java.base/java.lang.invoke=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED -Djavax.net.ssl.trustStoreType=JKS --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED exit abort -Xms512m -Xmx1536m
Max memory: 1.536 MB
rs.configdir: C:\Bitnami\reportserver3\apps\reportserver\reportserver-conf (OK)

### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.MariaDbDialect (OK)
hibernate.connection.driver_class: org.mariadb.jdbc.Driver (OK)
hibernate.connection.url: jdbc:mariadb://127.0.0.1:3307/bitnami_reportserver (OK)
hibernate.connection.username: bn_reportserver
hibernate.connection.password: **********
hibernate.default_schema:

Connection Test: OK
Schema Version: RS3.0-24

### Internal datasource metadata ###
Database name: MariaDB
Database version: 10.4.25-MariaDB
Driver name: MariaDB Connector/J
Driver version: 3.0.8
JDBC major version: 4
JDBC minor version: 2
JDBC URL: jdbc:mariadb://127.0.0.1:3307/bitnami_reportserver?user=bn_reportserver&password=***
JDBC username: bn_reportserver

Schema-validation: missing column [ent?ty_?d] in table [RS_ACE]

****************************************************************

eduardo · 2022-10-31 07:58:22

Hi iincitr,

"C:\Bitnami\reportserver3" -> is this a standard installation or did you change something else? The standard installation installs in reportserver, not reporterver3, so what did you change?
Strange, "i"'s seem not to be recognized: "ent?ty_?d".

Regards,
Eduardo

iincitr · 2022-10-31 10:44:17

"C:\Bitnami\reportserver3" there is also reportserver
I reinstall Bitnami again for a different folder may resolve the error.

Strange, "i"'s seem not to be recognized: "ent?ty_?d". Yes I also change "ENTITY_ID" as "entity_id" on the database field name but no solution.

In Turkish languages capital "i" is not "I" . is "İ" may this info helps.

Regards

eduardo · 2022-11-03 11:26:49

Hi iincitr,

after consultation with the Bitnami team, this may be related to your DB collation. Can you pls post the collation for the following as explained here:
https://database.guide/show-the-collation-in-mariadb/

- Server Collation
- Connection-Level Collation
- Database-Level Collation
- Table-Level Collation for the table RS_ACE
- Column level Collation for the column RS_ACE.entity_id

Pls post the exact commands you used so we can compare your results with a non-turkish installation where this works.

Regards,
Eduardo

iincitr · 2022-11-03 15:56:05

SHOW VARIABLES LIKE 'collation%';
/* Affected rows: 0 Found rows: 3 Warnings: 0 Duration for 1 query: 0.000 sec. */

collation_connection utf8mb4_general_ci
collation_database utf8_general_ci
collation_server utf8mb4_unicode_ci

************************************
SELECT
table_schema,
table_name,
table_collation
FROM information_schema.tables
WHERE table_schema = 'rs_ace';

collation_connection utf8mb4_general_ci
collation_database utf8_general_ci
collation_server utf8mb4_unicode_ci

***************************************

SHOW FULL COLUMNS FROM rs_ace;

there are not any string/varchar fields
all fields bigint or int

Felix · 2022-11-16 14:37:17

I quick installed Reportserver-4.3.0.6079 on win11 using our enterprise-edition installer... running without error. The bitnami-installer for the community edition follows tomorrow.

As for the Collations:

SHOW VARIABLES LIKE 'collation%';

collation_connection utf8mb4_general_ci
collation_database utf8_bin
collation_server utf8mb4_unicode_ci

###################################

SELECT
table_schema,
table_name,
table_collation
FROM information_schema.tables
WHERE table_schema = 'rs_ace';

completely empty

###################################

SHOW FULL COLUMNS FROM rs_ace;

Field              |Type           |Collation     |Null     |Key     |Default     |Extra              |Privileges                          |Comment
ENTITY_ID          |bigint(20)     |\N            |NO       |PRI     |\N          |auto_increment     |select,insert,update,references     |
accesstype         |int(11)        |\N            |NO       |        |\N          |                   |select,insert,update,references     |
n                  |int(11)        |\N            |NO       |        |\N          |                   |select,insert,update,references     |
ENTITY_VERSION     |int(11)        |\N            |YES      |        |\N          |                   |select,insert,update,references     |
acl_id             |bigint(20)     |\N            |NO       |MUL     |\N          |                   |select,insert,update,references     |
folk_id            |bigint(20)     |\N            |YES      |MUL     |\N          |                   |select,insert,update,references     |

iincitr · 2022-11-16 15:00:51

Thank you, I will try it in a week

Felix · 2022-11-17 11:07:26

Same results on the (current == 4.3.0.6080) bitnami installer: no problems while installing and running out of the box

Even switching the current codepage (command chcp) from 850 to 857 (turkish) had no negative effect

unfortunately i will be completely lost if i try to change my windows-language to turkish

eduardo · 2022-11-17 11:19:44

Hi iincitr,

according to Felix' tests, the database collation is
collation_database utf8_bin

which is the correct collation (according to the Bitnami team)

Your database collation is:
collation_database utf8_general_ci

maybe this is the root of the problem. We will check with the Bitnami team why this is not set correctly in some cases.
Anyway, can you please try to set it manually and look if it works?

https://mariadb.com/kb/en/alter-database/
ALTER DATABASE bitnami_reportserver COLLATE='utf8_bin';

Regards,
Eduardo

iincitr · 2022-11-17 11:27:56

Ok I will try it ASAP

iincitr · 2022-11-17 19:39:06

No solution
I will try to reinstall windows 10 and then inform you.

ReportServer Forum

#1 2022-10-29 18:52:07

ReportServer encountered an error while validating its environment.

#2 2022-10-31 07:58:22

Re: ReportServer encountered an error while validating its environment.

#3 2022-10-31 10:44:17

Re: ReportServer encountered an error while validating its environment.

#4 2022-11-03 11:26:49

Re: ReportServer encountered an error while validating its environment.

#5 2022-11-03 15:56:05

Re: ReportServer encountered an error while validating its environment.

#6 2022-11-16 14:37:17

Re: ReportServer encountered an error while validating its environment.

#7 2022-11-16 15:00:51

Re: ReportServer encountered an error while validating its environment.

#8 2022-11-17 11:07:26

Re: ReportServer encountered an error while validating its environment.

#9 2022-11-17 11:19:44

Re: ReportServer encountered an error while validating its environment.

#10 2022-11-17 11:27:56

Re: ReportServer encountered an error while validating its environment.

#11 2022-11-17 19:39:06

Re: ReportServer encountered an error while validating its environment.

Board footer