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

iincitr
Member
Registered: 2022-10-29

ReportServer encountered an error while validating its environment.

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]


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

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Website

Re: ReportServer encountered an error while validating its environment.

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

Offline

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

iincitr
Member
Registered: 2022-10-29

Re: ReportServer encountered an error while validating its environment.

"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

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Website

Re: ReportServer encountered an error while validating its environment.

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

Offline

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

iincitr
Member
Registered: 2022-10-29

Re: ReportServer encountered an error while validating its environment.

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

Offline

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

Felix
Moderator
Registered: 2022-08-01

Re: ReportServer encountered an error while validating its environment.

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     |

Softwareentwickler bei Infofabrik

Offline

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

iincitr
Member
Registered: 2022-10-29

Re: ReportServer encountered an error while validating its environment.

Thank you, I will try it in a week

Offline

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

Felix
Moderator
Registered: 2022-08-01

Re: ReportServer encountered an error while validating its environment.

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

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 wink


Softwareentwickler bei Infofabrik

Offline

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

eduardo
Administrator
Registered: 2016-11-01
Website

Re: ReportServer encountered an error while validating its environment.

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

Offline

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

iincitr
Member
Registered: 2022-10-29

Re: ReportServer encountered an error while validating its environment.

Ok I will try it ASAP

Offline

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

iincitr
Member
Registered: 2022-10-29

Re: ReportServer encountered an error while validating its environment.

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

Offline

Board footer

Powered by FluxBB