#1 2024-10-20 02:31:45

hstan
Member
Registered: 2024-10-17

Report server encounter error

Hi,
I got this error.  I could have missed something in config.  I checked on log files, no severe errors.

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

Version: RS4.7.2-6108 2024-09-18-12-15-33
Code Version: 2024-09-02-10-04-32
Java Version: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 23.0.1+11-39 (23)
VM Args: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 9.0 -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 9.0 -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 9.0\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 9.0\conf\logging.properties --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED exit abort -Xms128m -Xmx256m
Max memory: 256 MB
Groovy Version: 4.0.21
JVM Locale: en_US
JVM user language: en
JVM user country: US
JVM user timezone: Asia/Singapore
JVM file encoding: UTF-8
JVM server time: 2024-10-20T10:13:40.7191668+08:00[Asia/Singapore]
Operation system: Windows 10 10.0 (amd64)
rs.configdir: Not Configured

### DB Config ###
hibernate.dialect:  (Class Not Found)
hibernate.connection.driver_class:  (Class Not Found)
hibernate.connection.url:
hibernate.connection.username:
hibernate.default_schema:

Connection Test: Failed (Cannot invoke "java.lang.Class.newInstance()" because "dialectClass" is null)


I have run
reportserver-RS4.7.2-6108-schema-MySQL5_CREATE

I put this into reportserver.properties

# MariaDB
hibernate.dialect = net.datenwerke.rs.utils.hibernate.MariaDbDialect
hibernate.connection.driver_class = org.mariadb.jdbc.Driver
hibernate.connection.url = jdbc:mariadb://localhost:3306/reportserver
hibernate.connection.username = root
hibernate.connection.password = password

Offline

#2 2024-10-21 03:09:33

hstan
Member
Registered: 2024-10-17

Re: Report server encounter error

I removed the MariaDB in the reportserver.properties and put it into persistence.properties file.  Now I got this error where reportserver failed to start.

21-Oct-2024 10:29:06.672 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name:   Apache Tomcat/9.0.96
21-Oct-2024 10:29:06.732 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built:          Oct 3 2024 19:44:30 UTC
21-Oct-2024 10:29:06.733 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.96.0
21-Oct-2024 10:29:06.734 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Windows 10
21-Oct-2024 10:29:06.736 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            10.0
21-Oct-2024 10:29:06.737 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64
21-Oct-2024 10:29:06.737 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             C:\Program Files\Java\jdk-23
21-Oct-2024 10:29:06.738 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           23.0.1+11-39
21-Oct-2024 10:29:06.738 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Oracle Corporation
21-Oct-2024 10:29:06.739 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         C:\Program Files\Apache Software Foundation\Tomcat 9.0
21-Oct-2024 10:29:06.739 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         C:\Program Files\Apache Software Foundation\Tomcat 9.0
21-Oct-2024 10:29:06.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Program Files\Apache Software Foundation\Tomcat 9.0
21-Oct-2024 10:29:06.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Program Files\Apache Software Foundation\Tomcat 9.0
21-Oct-2024 10:29:06.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Program Files\Apache Software Foundation\Tomcat 9.0\temp
21-Oct-2024 10:29:06.769 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
21-Oct-2024 10:29:06.769 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Program Files\Apache Software Foundation\Tomcat 9.0\conf\logging.properties
21-Oct-2024 10:29:06.769 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED
21-Oct-2024 10:29:06.769 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED
21-Oct-2024 10:29:06.769 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
21-Oct-2024 10:29:06.769 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit
21-Oct-2024 10:29:06.770 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: abort
21-Oct-2024 10:29:06.770 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms128m
21-Oct-2024 10:29:06.770 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx256m
21-Oct-2024 10:29:06.790 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent The Apache Tomcat Native library which allows using OpenSSL was not found on the java.library.path: [C:\Program Files\Apache Software Foundation\Tomcat 9.0\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files\Java\jdk-23\bin;C:\Program Files\Common Files\Oracle\Java\javapath;C:\Python311\Scripts\;C:\Python311\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Lenovo\Touch Fingerprint Software\;C:\Program Files (x86)\Lenovo\Access Connections\;C:\Program Files (x86)\Common Files\Lenovo;C:\ProgramData\Lenovo\ReadyApps;C:\WINDOWS\System32\OpenSSH\;C:\php;C:\Program Files\PuTTY\;C:\Program Files\dotnet\;C:\ProgramData\ComposerSetup\bin;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\GAM\;C:\ProgramData\chocolatey\bin;C:\Program Files\Docker\Docker\resources\bin;C:\Program Files\nodejs\;C:\Program Files\liquibase;C:\Program Files\liquibase\internal\lib;C:\WINDOWS\ServiceProfiles\LocalService\AppData\Local\Microsoft\WindowsApps;.]
21-Oct-2024 10:29:07.747 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
21-Oct-2024 10:29:07.814 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [1796] milliseconds
21-Oct-2024 10:29:07.922 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
21-Oct-2024 10:29:07.922 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.96]
21-Oct-2024 10:29:07.937 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\docs]
21-Oct-2024 10:29:08.579 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\docs] has finished in [639] ms
21-Oct-2024 10:29:08.580 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\examples]
21-Oct-2024 10:29:09.771 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\examples] has finished in [1,191] ms
21-Oct-2024 10:29:09.772 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\host-manager]
21-Oct-2024 10:29:09.884 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\host-manager] has finished in [111] ms
21-Oct-2024 10:29:09.884 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\manager]
21-Oct-2024 10:29:10.069 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\manager] has finished in [185] ms
21-Oct-2024 10:29:10.069 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files\Apache Software Foundation\Tomcat 9.0\webapps\reportserver]
21-Oct-2024 10:29:56.419 INFO [main] org.apache.jasper.servlet.TldScanner.scanJars At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
21-Oct-2024 10:30:24.465 WARNING [main] com.google.inject.servlet.InternalServletModule$BackwardsCompatibleServletContextProvider.get You are attempting to use a deprecated API (specifically, attempting to @Inject ServletContext inside an eagerly created singleton. While we allow this for backwards compatibility, be warned that this MAY have unexpected behavior if you have more than one injector (with ServletModule) running in the same JVM. Please consult the Guice documentation at https://github.com/google/guice/wiki/Servlets for more information.
21-Oct-2024 10:30:27.846 WARNING [main] com.google.inject.servlet.InternalServletModule$BackwardsCompatibleServletContextProvider.get You are attempting to use a deprecated API (specifically, attempting to @Inject ServletContext inside an eagerly created singleton. While we allow this for backwards compatibility, be warned that this MAY have unexpected behavior if you have more than one injector (with ServletModule) running in the same JVM. Please consult the Guice documentation at https://github.com/google/guice/wiki/Servlets for more information.
21-Oct-2024 10:30:27.848 WARNING [main] com.google.inject.servlet.InternalServletModule$BackwardsCompatibleServletContextProvider.get You are attempting to use a deprecated API (specifically, attempting to @Inject ServletContext inside an eagerly created singleton. While we allow this for backwards compatibility, be warned that this MAY have unexpected behavior if you have more than one injector (with ServletModule) running in the same JVM. Please consult the Guice documentation at https://github.com/google/guice/wiki/Servlets for more information.
21-Oct-2024 10:30:27.849 WARNING [main] com.google.inject.servlet.InternalServletModule$BackwardsCompatibleServletContextProvider.get You are attempting to use a deprecated API (specifically, attempting to @Inject ServletContext inside an eagerly created singleton. While we allow this for backwards compatibility, be warned that this MAY have unexpected behavior if you have more than one injector (with ServletModule) running in the same JVM. Please consult the Guice documentation at https://github.com/google/guice/wiki/Servlets for more information.
21-Oct-2024 10:30:27.849 WARNING [main] com.google.inject.servlet.InternalServletModule$BackwardsCompatibleServletContextProvider.get You are attempting to use a deprecated API (specifically, attempting to @Inject ServletContext inside an eagerly created singleton. While we allow this for backwards compatibility, be warned that this MAY have unexpected behavior if you have more than one injector (with ServletModule) running in the same JVM. Please consult the Guice documentation at https://github.com/google/guice/wiki/Servlets for more information.
21-Oct-2024 10:30:27.854 WARNING [main] com.google.inject.servlet.InternalServletModule$BackwardsCompatibleServletContextProvider.get You are attempting to use a deprecated API (specifically, attempting to @Inject ServletContext inside an eagerly created singleton. While we allow this for backwards compatibility, be warned that this MAY have unexpected behavior if you have more than one injector (with ServletModule) running in the same JVM. Please consult the Guice documentation at https://github.com/google/guice/wiki/Servlets for more information.
21-Oct-2024 10:30:29.213 WARNING [main] com.google.inject.servlet.InternalServletModule$BackwardsCompatibleServletContextProvider.get You are attempting to use a deprecated API (specifically, attempting to @Inject ServletContext inside an eagerly created singleton. While we allow this for backwards compatibility, be warned that this MAY have unexpected behavior if you have more than one injector (with ServletModule) running in the same JVM. Please consult the Guice documentation at https://github.com/google/guice/wiki/Servlets for more information.
21-Oct-2024 10:30:29.401 INFO [main] org.apache.lucene.store.MemorySegmentIndexInputProvider.<init> Using MemorySegmentIndexInput with Java 21 or later; to disable start with -Dorg.apache.lucene.store.MMapDirectory.enableMemorySegments=false
21-Oct-2024 10:30:50.155 WARNING [main] com.google.inject.servlet.InternalServletModule$BackwardsCompatibleServletContextProvider.get You are attempting to use a deprecated API (specifically, attempting to @Inject ServletContext inside an eagerly created singleton. While we allow this for backwards compatibility, be warned that this MAY have unexpected behavior if you have more than one injector (with ServletModule) running in the same JVM. Please consult the Guice documentation at https://github.com/google/guice/wiki/Servlets for more information.
21-Oct-2024 10:30:50.182 SEVERE [main] org.apache.catalina.core.StandardContext.startInternal One or more listeners failed to start. Full details will be found in the appropriate container log file
21-Oct-2024 10:30:50.185 SEVERE [main] org.apache.catalina.core.StandardContext.startInternal Context [/reportserver] startup failed due to previous errors

Offline

#3 2024-10-21 08:18:21

Felix
Moderator
Registered: 2022-08-01

Re: Report server encounter error

Hi hstan,

have you configured your persistence.properties? Please have a look into our configuration guide around Page 8 (Adapt the persistence.properties config file)

kind regards

Felix


Softwareentwickler bei Infofabrik

Offline

#4 2024-10-22 02:38:28

hstan
Member
Registered: 2024-10-17

Re: Report server encounter error

Hi Felix,

Yes I did.  Here is my persistence.properties config file.  The error I posted on 21/Oct/2024 are the error messages after persistence.properties is configured.

# Credentials
hibernate.connection.username=root
hibernate.connection.password=xxxxxx


# MariaDb
hibernate.dialect=net.datenwerke.rs.utils.hibernate.MariaDbDialect
hibernate.connection.driver_class=org.mariadb.jdbc.Driver
hibernate.connection.url=jdbc:mariadb://localhost:3306/reportserver

Offline

Board footer

Powered by FluxBB