You are not logged in.
Hi,
I'm new to ReportServer and I am just trying to start up a community edition of ReportServer as a Proof-Of-Concept to myself. I have Apache Tomcat 9.0.48 running on my local machine and a Microsoft SQL database running on a remote machine. I am using Java Runtime Environment 8. I struggled a bit with getting a driver for MSSQL in the right folder, and getting the driver to recognize the SQL URL, but now according to the startup script, everything should be connected properly. However, when I visit http://localhost:8080/reportserver, I still get Apache's "404" status with the description "The origin server did not find a current representation for the target resource or is not willing to disclose that one exists." Here is the startup log:
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version name: Apache Tomcat/9.0.48
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Jun 10 2021 09:22:01 UTC
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version number: 9.0.48.0
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 10
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: x86
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Program Files (x86)\Java\jre1.8.0_291
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_291-b10
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\conf\logging.properties
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0
28-Jun-2021 10:36:15.015 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\temp
28-Jun-2021 10:36:15.030 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 (x86)\Java\jre1.8.0_291\bin;C:\WINDOWS\Sun\Java\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files\Git\cmd;C:\ProgramData\chocolatey\bin;C:\Program Files\nodejs\;C:\Program Files\dotnet\;C:\Users\[my username]\AppData\Local\Programs\Python\Python39\Scripts\;C:\Users\[my username]\AppData\Local\Programs\Python\Python39\;C:\Users\[my username]\AppData\Local\Microsoft\WindowsApps;C:\Users\[my username]\AppData\Local\Programs\Microsoft VS Code\bin;C:\Users\[my username]\AppData\Roaming\npm;C:\Users\[my username]\.dotnet\tools;.]
28-Jun-2021 10:36:15.330 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8080"]
28-Jun-2021 10:36:15.361 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [518] milliseconds
28-Jun-2021 10:36:15.393 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]
28-Jun-2021 10:36:15.393 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.48]
28-Jun-2021 10:36:15.408 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\docs]
28-Jun-2021 10:36:16.401 WARNING [main] org.apache.catalina.util.SessionIdGeneratorBase.createSecureRandom Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [773] milliseconds.
28-Jun-2021 10:36:16.432 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\docs] has finished in [1,024] ms
28-Jun-2021 10:36:16.432 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\examples]
28-Jun-2021 10:36:16.869 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\examples] has finished in [437] ms
28-Jun-2021 10:36:16.869 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\host-manager]
28-Jun-2021 10:36:16.900 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\host-manager] has finished in [31] ms
28-Jun-2021 10:36:16.900 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\manager]
28-Jun-2021 10:36:16.947 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\manager] has finished in [47] ms
28-Jun-2021 10:36:16.947 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\ROOT]
28-Jun-2021 10:36:16.978 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\ROOT] has finished in [31] ms
28-Jun-2021 10:36:16.978 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\RS3.7.0-6044-2021-06-09-10-02-15-reportserver-ce]
28-Jun-2021 10:36:43.224 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.
10:36:46.266 INFO n.datenwerke.rs.EnvironmentValidator -
_____ _ _____
| __ \ | | / ____|
| |__) |___ _ __ ___ _ __| |_| (___ ___ _ ____ _____ _ __
| _ // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__|
| | \ \ __/ |_) | (_) | | | |_ ____) | __/ | \ V / __/ |
|_| \_\___| .__/ \___/|_| \__|_____/ \___|_| \_/ \___|_|
| |
|_|
Version: RS3.7.0-6044 2021-06-09-10-02-15
Code Version: 2021-06-08-15-41-23
Java Version: Oracle Corporation Java HotSpot(TM) Client VM 25.291-b10 (1.8)
VM Args: -Djava.util.logging.config.file=C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\conf\logging.properties -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djdk.tls.ephemeralDHKeySize=2048 -Djava.protocol.handler.pkgs=org.apache.catalina.webresources -Dignore.endorsed.dirs= -Dcatalina.base=C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0 -Dcatalina.home=C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0 -Djava.io.tmpdir=C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\temp
rs.configdir: Not Configured
### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.SQLServer2008Dialect (OK)
hibernate.connection.driver_class: com.microsoft.sqlserver.jdbc.SQLServerDriver (OK)
hibernate.connection.url: jdbc:sqlserver://[my server URL];databaseName=reportserver (OK)
hibernate.connection.username: sa
hibernate.connection.password: ********
hibernate.default_schema:
Connection Test: OK
Schema Version: RS3.0-20
10:36:46.532 INFO n.datenwerke.rs.EnvironmentValidator - Validating database schema...
10:37:49.294 INFO n.datenwerke.rs.EnvironmentValidator - Schema validation completed
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.AdminResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.AdminResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.BasicRepositoryResource2
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.DataSourceResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.ExporterResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.ExporterResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.FilterRepositoryResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.FilterRepositoryResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.InfoResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.InfoResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.License
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.License
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.OlapDiscoverResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.Query2Resource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.Query2Resource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.SessionResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.SessionResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.SaikuI18nResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - try to bind: net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource
10:37:51.035 INFO n.d.r.s.server.rest.SaikuRestModule - done binding: net.datenwerke.rs.saiku.server.rest.resources.StatisticsResource
10:37:57.060 WARN n.d.r.c.s.c.ConfigServiceImpl - Configfile scheduler/scheduler.cf could not be loaded. Default values are in effect.
10:37:57.060 WARN n.d.r.c.s.c.ConfigServiceImpl - Configfile exportfilemd/pdfexport.cf could not be loaded. Default values are in effect.
10:37:57.060 WARN n.d.r.c.s.c.ConfigServiceImpl - Configfile exportfilemd/pdfexport.cf could not be loaded. Default values are in effect.
10:37:57.435 INFO n.d.r.s.s.saiku.ThinQueryServiceImpl - loaded thinqueryservice
10:37:57.855 INFO n.d.r.c.s.i.RemoteMessageServiceImpl - Loading messages...
10:38:06.424 INFO n.d.r.c.s.i.RemoteMessageServiceImpl - Available locales: de, hi, lo, pt, lt, hr, lv, hu, zh-CN, hy, uk, id, mk, mn, af, uz, ms, el, mt, en, is, it, my, es, et, eu, vi, ja, ne, ro, nl, no, be, fi, ru, bg, keys, bn, fr, jw, bs, ka, si, sk, sl, ga, gd, ca, sq, sr, kk, km, sv, ko, zh-TW, ta, cs, th, lb, tl, pl, da, tr
10:38:14.662 INFO n.d.r.c.s.j.h.ReportServerExtenderHooker - Start loading ReportServer extensions.
10:38:14.677 INFO n.d.r.c.s.EnvironmentAfterStartupInformation -
Application Server: Apache Tomcat/9.0.48
### PAM Configuration ###
Static PAM configuration: net.datenwerke.rs.authenticator.service.pam.UserPasswordPAMAuthoritative
Finalized PAM configuration: class net.datenwerke.rs.authenticator.service.pam.UserPasswordPAMAuthoritative
28-Jun-2021 10:38:15.693 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\RS3.7.0-6044-2021-06-09-10-02-15-reportserver-ce] has finished in [118,715] ms
28-Jun-2021 10:38:15.693 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8080"]
28-Jun-2021 10:38:15.740 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [120559] milliseconds
10:38:16.865 INFO n.d.r.s.s.search.SearchServiceImpl - Rebuilding search index...
10:38:18.610 INFO n.d.g.s.lateinit.LateInitStartup - Startup completed
I honestly think the only noteworthy thing about my attempted installation is that my SQL server is remote. Otherwise, I can't understand why this is not working. Any help is appreciated!
Last edited by knelson (2021-06-28 16:18:21)
Offline
Hi knelson,
your database connection seems to work. But as a hint, the JDBC Driver for the Reportserver database on your MS SQL Server belongs in the Tomcat-lib-directory: ..\Tomcat\lib
Newest driver: https://docs.microsoft.com/en-us/sql/co … rver-ver15
Please rename your directory
C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\RS3.7.0-6044-2021-06-09-10-02-15-reportserver-ce
-->
C:\Program Files (x86)\Apache Software Foundation\Tomcat 9.0\webapps\reportserver
and
http://localhost:8080/reportserver
should work.
Regards,
Tobias
Offline
Renaming it reportserver worked - thank you so much.
Offline