You are not logged in.
Hi Team,
My Installation of linux version RS3.0.3-6002-2017-12-09-12-26-19-reportserver-ce failed with below error.
Connection Test: OK
Schema Version: RS3.0-9
23:05:21.293 INFO n.datenwerke.rs.EnvironmentValidator - Validating database schema...
23:05:24.601 ERROR n.datenwerke.rs.EnvironmentValidator - Schema-validation: missing table [RS_ACE]
23:05:24.602 ERROR n.d.rs.ReportServerServiceConfig - ReportServer encountered an error while validating its environment. Startup interrupted.
Jun 29, 2018 11:05:24 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 6007 ms
Jun 29, 2018 11:05:24 PM org.apache.catalina.core.StandardServer await
SEVERE: StandardServer.await: create[localhost:30006]:
I am running new installation with Oracle DB.
i have properly executed CREATE DDL present in ddl/ directory.
Thanks
Mukesh
Last edited by mugoyal (2018-07-01 08:53:37)
Offline
Hi eduardo,
can you please suggest?
Thanks in advance
Mukesh
Offline
Hi Mukesh,
if you take a look at the oracle create-DB script, the first line is:
create table RS_ACE (
ENTITY_ID number(19,0) not null,
accesstype number(10,0) not null,
n number(10,0) not null,
ENTITY_VERSION number(10,0),
acl_id number(19,0) not null,
folk_id number(19,0),
primary key (ENTITY_ID)
);
so the table is present in your installation if you executed this script.
Please make sure that your persistence.properties file point to the same database where you executed your DDL script.
Take a look at this tutorials: https://reportserver.net/en/tutorials/i … -practice/ (linux) and https://reportserver.net/en/tutorials/i … n-windows/ (windows).
You can also install the bitnami version for testing. This is the most easy to install.
Regards,
Eduardo
Offline
Hi Eduardo,
Thanks for the response.
I verified the table are in correct database. And also ReportServer is also able to connect to it , as per logs shown in catalina.out below.
But the issue still persist.
INFO: validateJarFile(/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/webapps/RS/WEB-INF/lib/servlet-api-2.4.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
15:12:56.405 INFO n.datenwerke.rs.EnvironmentValidator -
_____ _ _____
| __ \ | | / ____|
| |__) |___ _ __ ___ _ __| |_| (___ ___ _ ____ _____ _ __
| _ // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__|
| | \ \ __/ |_) | (_) | | | |_ ____) | __/ | \ V / __/ |
|_| \_\___| .__/ \___/|_| \__|_____/ \___|_| \_/ \___|_|
| |
|_|
Version: RS3.0.3-6002 2017-12-09-12-26-19
Code Version: 2017-12-08-10-49-15
Java Version: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.31-b07 (1.8)
VM Args: -Djava.util.logging.config.file=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/conf/logging.properties -Djava.awt.headless=true -Xmx4g -XX:+UseConcMarkSweepGC -Dfile.encoding=UTF8 -Drs.configdir=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/webapps/RS/WEB-INF/classes/ -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/endorsed -Dcatalina.base=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat -Dcatalina.home=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat -Djava.io.tmpdir=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/temp
rs.configdir: Not Configured
### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.OracleDialect (OK)
hibernate.connection.driver_class: oracle.jdbc.driver.OracleDriver (OK)
hibernate.connection.url: jdbc:oracle:thin:@ilcecmm013:1521:CMMABP1 (OK)
hibernate.connection.username: CMMDB45
hibernate.connection.password: *******
hibernate.default_schema: CMMABP1
Connection Test: OK
Schema Version: RS3.0-9
15:12:56.420 INFO n.datenwerke.rs.EnvironmentValidator - Validating database schema...
15:12:59.745 ERROR n.datenwerke.rs.EnvironmentValidator - Schema-validation: missing table [RS_ACE]
15:12:59.746 ERROR n.d.rs.ReportServerServiceConfig - ReportServer encountered an error while validating its environment. Startup interrupted.
Jul 01, 2018 3:12:59 PM org.apache.catalina.startup.Catalina start
INFO: Server startup in 6441 ms
Offline
Hi Mukesh,
make sure the table exists in the schema "CMMABP1" and is reachable via this url: jdbc:oracle:thin:@ilcecmm013:1521:CMMABP1 and this user "CMMDB45" is able to see it (permissions).
Use an external program for connecting and make sure all credentials/schema/permissions are correct.
Regards,
Eduardo
Offline
Hi Eduardo,
Looks i found out the issue.
My DB do not support Instance based connection to the database.
Can you please suggest some way to connect in Service Mode?
any additional properties to set service mode for persistence.properties ?
Thanks
Mukesh
Offline
Hi Mukesh,
try with this url:
jdbc:oracle:thin:@IP:1521/SID
where SID = your Oracle System Identifier
Regards,
Eduardo
Offline
Hi Eduardo,
No it did not work.
We need configuration as such it will resolve PORT & IP from tnsnames.ora file of system.
Currently all the apps running on my server are making service mode connection And IP/PORT are resolved through TNS settings.
Thanks & Regards
Mukesh
Offline
Hi Mukesh,
try to pass the Java VM argument -Doracle.net.tns_admin=%ORACLE_HOME%\network\admin pointing to the directory that contains your tnsnames.ora file
check this
https://stackoverflow.com/questions/141 … snames-ora
and this: http://przemyslawkruglej.com/archive/20 … a-in-java/
for more information.
Please let me know if it works.
Regards,
Eduardo
Offline
Hi Eduardo,
After adding VM argument as suggested and passing URL hibernate.connection.url with only Service_name , The Collection Test itself failed, PFB code.
### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.OracleDialect (OK)
hibernate.connection.driver_class: oracle.jdbc.driver.OracleDriver (OK)
[B]hibernate.connection.url: jdbc:oracle:thin:@CMMABP1 (OK)[B]
hibernate.connection.username: CMMDB45
hibernate.connection.password: *******
hibernate.default_schema: CMMABP1
Connection Test: Failed (Unknown host specified )
05:06:00.086 ERROR n.d.rs.ReportServerServiceConfig - ReportServer encountered an error while validating its environment. Startup interrupted.
Jul 02, 2018 5:06:00 AM org.apache.catalina.startup.Catalina start
And when i use URL with IP/PORT passed, Connection Test done but issue still persist.
### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.OracleDialect (OK)
hibernate.connection.driver_class: oracle.jdbc.driver.OracleDriver (OK)
hibernate.connection.url: jdbc:oracle:thin:@ilcecmm013:1521/CMMABP1 (OK)
hibernate.connection.username: CMMDB45
hibernate.connection.password: *******
hibernate.default_schema: CMMABP1
Connection Test: OK
Schema Version: RS3.0-9
05:07:06.135 INFO n.datenwerke.rs.EnvironmentValidator - Validating database schema...
05:07:16.004 ERROR n.datenwerke.rs.EnvironmentValidator - Schema-validation: missing table [RS_ACE]
05:07:16.005 ERROR n.d.rs.ReportServerServiceConfig - ReportServer encountered an error while validating its environment. Startup interrupted.
The VM args are as below :
VM Args: -Djava.util.logging.config.file=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/conf/logging.properties -Djava.awt.headless=true -Xmx4g -XX:+UseConcMarkSweepGC -Dfile.encoding=UTF8 -Drs.configdir=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/webapps/ReportServer/WEB-INF/classes/ -Doracle.net.tns_admin=/oravl01/oracle/ -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.endorsed.dirs=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/endorsed -Dcatalina.base=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat -Dcatalina.home=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat -Djava.io.tmpdir=/users/gen/cmmwrk45/Amc-ilcecmm020/tomcat/temp
May be issue with how URL is extracted from persistence.properties file.
Thanks & Regards
Mukesh
Last edited by mugoyal (2018-07-02 02:38:02)
Offline
Hi Mukesh,
the URL is passed directly to the driver:
String url = jpaProperties.getProperty("hibernate.connection.url");
DriverManager.getConnection(url, username, password)
Some questions:
1. /oravl01/oracle/tnsnames.ora exists, correct ? Is this path correct?
2. Is this file: /oravl01/oracle/tnsnames.ora working from another context ? I think yes because of this: "Currently all the apps running on my server are making service mode connection And IP/PORT are resolved through TNS settings." . But I want to make sure that this same file is working from another apps.
3. Do you see the
[B]
output or it is just a formatting error in the forum:
[B]hibernate.connection.url: jdbc:oracle:thin:@CMMABP1 (OK)[B]
4. Which Oracle version exactly are you using ?
Regards,
Eduardo
Offline
Hi Eduardo,
PFB, comments for each question:
for #1 -> Yes the path is correct and accessible (Read Only).
for #2 -> Yes the same file is working fine for other apps.
for #3 -> It's a formatting error, wanted to have nested URL tags.
for #4 -> Oracle version using is 12.1.0.2
I have also installed windows version on my system.
But when i am trying to add "Relational Database" in Data sources tab, it giving me "The Connection Test failed" with below error.
Error
500 Internal Server Error The call failed on the server; see server log for details Statuscode: 500 EncodedResponse: The call failed on the server; see server log for details
Seems this is the same issue i am facing in Linux version installation.
Thanks & Regards
Mukesh
Last edited by mugoyal (2018-07-02 08:23:12)
Offline
Hi Mukesh,
you installed on windows (which db are you using here? ) and then you add a relational database (the oracle one?). What url do you use for adding it when you get this error?
And please post the complete error log (tomcat logs)
Regards,
Eduardo
Offline
Hi Mukesh,
another question:
can you connect from the same machine of your reportserver installation with another JDBC client to your oracle db using this url: jdbc:oracle:thin:@ilcecmm013:1521/CMMABP1
Please mention the jdbc client your use for this test and post the tables you are able to see.
Regards,
Eduardo
Offline
Hi Eduardo,
For windows, i did it through Bitnami auto installer package.
And for ReportServer related data it has used MariaDB.
And while adding Oracle datasource i got that eeror.
This Error is resolved though , after updating the xdb6.jar to xdb.jar. have took reference from (stackoverflow forum (ckick here))
And for Unix , i have tried same as above but it didn't worked.
Thanks & Regards
Mukesh
Last edited by mugoyal (2018-07-02 12:01:16)
Offline
Hi Mukesh,
ok, you seem to have resolved another unrelated problem with the xdb6.jar upgrade (java.lang.NoClassDefFoundError).
So now you can connect from your windows bitnami installation to your Oracle ? What jdbc url do you use for that ?
Regards,
Eduardo
Offline
Hi Eduardo,
Yes i can connect from Windows installation to Oracle. I used below URL to connect
jdbc:oracle:thin:@10.234.176.70:1521/CMMABP1
now i will go for bitnami installation for Linux as well.
It would be helpful if you can share link to tutorial's or demo for configuring basic reports.
Thanks a lot again Eduardo for the Quick responses.
-Regards
Mukesh
Offline
Hi Mukesh,
ok, so adding a datasource from windows to your oracle with jdbc:oracle:thin:@10.234.176.70:1521/CMMABP1 works.
Could you please change your persistence.properties (in bitnami here: C:\Bitnami\reportserverenterprise-3.0.3-1\apps\reportserver\reportserver-conf\persistence.properties )
and change it to point to your Oracle with this url: jdbc:oracle:thin:@10.234.176.70:1521/CMMABP1 ( Comment out the rest )
# Oracle
hibernate.dialect=net.datenwerke.rs.utils.hibernate.Oracle10gDialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@10.234.176.70:1521/CMMABP1
hibernate.default_schema=CMMABP1
If you could connect from your windows machine to oracle creating a datasource, you should be also able to directly connect to Oracle using your persistence.properties.
Yes, of course, here is a link to the documentation:
https://reportserver.net/en/guides/admin/main/
Start with dynamic lists:
https://reportserver.net/en/guides/admi … amic-List/
Here all the documentation:
https://reportserver.net/en/documentation/
Regards,
Eduardo
Offline
Hi Eduardo,
No it is giving error as below, i updated the mentioned persistence.properties file.
Error
405 Method Not Allowed <!DOCTYPE html><html><head><title>Apache Tomcat/8.0.51 - Error report</title><style type="text/css">H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}.line {height: 1px; background-color: #525D76; border: none;}</style> </head><body>
HTTP Status 405 - HTTP method POST is not supported by this URL
<div class="line"></div><p>type Status report</p><p>message <u>HTTP method POST is not supported by this URL</u></p><p>description <u>The specified HTTP method is not allowed for the requested resource.</u></p><hr class="line">
Apache Tomcat/8.0.51
</body></html> Statuscode: 405 EncodedResponse: <!DOCTYPE html><html><head><title>Apache Tomcat/8.0.51 - Error report</title><style type="text/css">H1 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:22px;} H2 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:16px;} H3 {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;font-size:14px;} BODY {font-family:Tahoma,Arial,sans-serif;color:black;background-color:white;} B {font-family:Tahoma,Arial,sans-serif;color:white;background-color:#525D76;} P {font-family:Tahoma,Arial,sans-serif;background:white;color:black;font-size:12px;}A {color : black;}A.name {color : black;}.line {height: 1px; background-color: #525D76; border: none;}</style> </head><body>
HTTP Status 405 - HTTP method POST is not supported by this URL
<div class="line"></div><p>type Status report</p><p>message <u>HTTP method POST is not supported by this URL</u></p><p>description <u>The specified HTTP method is not allowed for the requested resource.</u></p><hr class="line">
Apache Tomcat/8.0.51
</body></html>
Thanks & Regards
Mukesh
Last edited by mugoyal (2018-07-03 04:42:36)
Offline
Hi Mukesh,
so to summarize:
you have a bitnami windows installation. If you add a datasource of type oracle with this url: "jdbc:oracle:thin:@10.234.176.70:1521/CMMABP1", everything works. If you click on "test connection" everything works. You can create a dynamic list that uses this oracle datasource.
If you change the persistence.properties file to point to your oracle installation using the same url: "jdbc:oracle:thin:@10.234.176.70:1521/CMMABP1" , and then you restart your bitnami installation, especially tomcat, you get this error (HTTP Status 405).
Is this correct? Please check all steps for making sure.
In this scenario: can you please check the tomcat logs and post them here? Also your persistence.properties file (you can delete your password).
Regards,
Eduardo
Offline
Hi Eduardo,
I ran again with Oracle details in persistence.properties.
# Credentials
hibernate.connection.username=CMMDB45
# Oracle
hibernate.dialect=net.datenwerke.rs.utils.hibernate.OracleDialect
hibernate.connection.driver_class=oracle.jdbc.driver.OracleDriver
hibernate.connection.url=jdbc:oracle:thin:@10.234.176.70:1521/CMMABP1
hibernate.default_schema=CMMABP1
below is the logs from resportserver.<DATE>.log
_____ _ _____
| __ \ | | / ____|
| |__) |___ _ __ ___ _ __| |_| (___ ___ _ ____ _____ _ __
| _ // _ \ '_ \ / _ \| '__| __|\___ \ / _ \ '__\ \ / / _ \ '__|
| | \ \ __/ |_) | (_) | | | |_ ____) | __/ | \ V / __/ |
|_| \_\___| .__/ \___/|_| \__|_____/ \___|_| \_/ \___|_|
| |
|_|
Version: RS3.0.3-6002 2017-12-09-12-26-19
Code Version: 2017-12-08-10-49-15
Java Version: Oracle Corporation Java HotSpot(TM) 64-Bit Server VM 25.161-b12 (1.8)
VM Args: -Dcatalina.home=C:\Bitnami\REPORT~1.3-2\APACHE~1 -Dcatalina.base=C:\Bitnami\REPORT~1.3-2\APACHE~1 -Dignore.endorsed.dirs=C:\Bitnami\REPORT~1.3-2\APACHE~1\endorsed -Djava.io.tmpdir=C:\Bitnami\REPORT~1.3-2\APACHE~1\temp -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=C:\Bitnami\REPORT~1.3-2\APACHE~1\conf\logging.properties -Drs.configdir=C:\Bitnami\reportserver-3.0.3-2/apps/reportserver/reportserver-conf -Dfile.encoding=UTF8 exit abort -Xms512m -Xmx1536m -Xmx1024M
rs.configdir: C:\Bitnami\reportserver-3.0.3-2\apps\reportserver\reportserver-conf (OK)
### DB Config ###
hibernate.dialect: net.datenwerke.rs.utils.hibernate.OracleDialect (OK)
hibernate.connection.driver_class: oracle.jdbc.driver.OracleDriver (OK)
hibernate.connection.url: jdbc:oracle:thin:@10.234.176.70:1521/CMMABP1 (OK)
hibernate.connection.username: CMMDB45
hibernate.connection.password: *******
hibernate.default_schema: CMMABP1
Connection Test: OK
Schema Version: RS3.0-9
04-Jul-2018 16:56:52.221 INFO [localhost-startStop-1] net.datenwerke.rs.EnvironmentValidator.startup Validating database schema...
04-Jul-2018 16:57:30.056 SEVERE [localhost-startStop-1] net.datenwerke.rs.EnvironmentValidator.hibernateValidateSchema Schema-validation: missing table [RS_ACE]
04-Jul-2018 16:57:30.057 SEVERE [localhost-startStop-1] net.datenwerke.rs.ReportServerServiceConfig.getInjector ReportServer encountered an error while validating its environment. Startup interrupted.
below is the logs from reportservertomcat-stder.<DATE>.log
04-Jul-2018 16:55:57.940 INFO [Thread-9] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["ajp-apr-8012"]
04-Jul-2018 16:55:57.995 INFO [Thread-9] org.apache.catalina.core.StandardService.stopInternal Stopping service Catalina
04-Jul-2018 16:55:58.011 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [reportserver] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
04-Jul-2018 16:55:58.012 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [org.apache.commons.vfs.cache.SoftRefFilesCache$SoftRefReleaseThread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.lang.ref.ReferenceQueue.remove(Unknown Source)
org.apache.commons.vfs.cache.SoftRefFilesCache$SoftRefReleaseThread.run(SoftRefFilesCache.java:76)
04-Jul-2018 16:55:58.013 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->2sonlu9wrzjxp71jg9pqb|368d6060]-AdminTaskTimer] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.util.TimerThread.mainLoop(Unknown Source)
java.util.TimerThread.run(Unknown Source)
04-Jul-2018 16:55:58.014 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->2sonlu9wrzjxp71jg9pqb|368d6060]-HelperThread-#0] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
04-Jul-2018 16:55:58.014 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->2sonlu9wrzjxp71jg9pqb|368d6060]-HelperThread-#1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
04-Jul-2018 16:55:58.015 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->2sonlu9wrzjxp71jg9pqb|368d6060]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
04-Jul-2018 16:55:58.016 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [com.google.inject.internal.util.$Finalizer] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.lang.ref.ReferenceQueue.remove(Unknown Source)
java.lang.ref.ReferenceQueue.remove(Unknown Source)
com.google.inject.internal.util.$Finalizer.run(Finalizer.java:114)
04-Jul-2018 16:55:58.024 INFO [Thread-9] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["ajp-apr-8012"]
Picked up _JAVA_OPTIONS: -Xmx1024M
2018-07-04 16:56:01 Commons Daemon procrun stderr initialized
04-Jul-2018 16:56:02.120 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.0.51
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Apr 9 2018 21:20:15 UTC
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.0.51.0
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 10
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Bitnami\REPORT~1.3-2\java
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_161-b12
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Bitnami\reportserver-3.0.3-2\apache-tomcat
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Bitnami\reportserver-3.0.3-2\apache-tomcat
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Bitnami\REPORT~1.3-2\APACHE~1
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Bitnami\REPORT~1.3-2\APACHE~1
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=C:\Bitnami\REPORT~1.3-2\APACHE~1\endorsed
04-Jul-2018 16:56:02.126 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Bitnami\REPORT~1.3-2\APACHE~1\temp
04-Jul-2018 16:56:02.130 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
04-Jul-2018 16:56:02.130 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Bitnami\REPORT~1.3-2\APACHE~1\conf\logging.properties
04-Jul-2018 16:56:02.130 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Drs.configdir=C:\Bitnami\reportserver-3.0.3-2/apps/reportserver/reportserver-conf
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF8
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: abort
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms512m
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1536m
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024M
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library 1.2.16 using APR version 1.6.3.
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
04-Jul-2018 16:56:02.993 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized (OpenSSL 1.0.2m 2 Nov 2017)
04-Jul-2018 16:56:03.204 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-apr-8012"]
04-Jul-2018 16:56:03.218 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1630 ms
04-Jul-2018 16:56:03.269 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
04-Jul-2018 16:56:03.270 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.0.51
04-Jul-2018 16:56:03.288 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory C:\Bitnami\reportserver-3.0.3-2\apache-tomcat\webapps\reportserver
04-Jul-2018 16:56:03.293 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory C:\Bitnami\reportserver-3.0.3-2\apache-tomcat\webapps\ROOT
04-Jul-2018 16:56:04.295 INFO [localhost-startStop-2] 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.
04-Jul-2018 16:56:04.644 WARNING [localhost-startStop-2] org.apache.catalina.util.SessionIdGeneratorBase.createSecureRandom Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [301] milliseconds.
04-Jul-2018 16:56:04.685 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory C:\Bitnami\reportserver-3.0.3-2\apache-tomcat\webapps\ROOT has finished in 1,392 ms
04-Jul-2018 16:56:43.504 INFO [localhost-startStop-1] 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.
04-Jul-2018 16:57:31.173 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory C:\Bitnami\reportserver-3.0.3-2\apache-tomcat\webapps\reportserver has finished in 87,885 ms
04-Jul-2018 16:57:31.177 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-apr-8012"]
04-Jul-2018 16:57:31.221 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 87998 ms
below is the logs from localhost_access_log.<DATE>.txt
::1 - - [04/Jul/2018:16:57:58 +0530] "POST /reportserver/reportserver/base_datasource HTTP/1.1" 405 1110
::1 - - [04/Jul/2018:16:57:58 +0530] "POST /reportserver/reportserver/homepage HTTP/1.1" 405 1110
::1 - - [04/Jul/2018:16:57:58 +0530] "GET /reportserver/reportserver/fileServerAccess?path=/resources/public/hostpage-extra.js&noredirect&_=1530703676766 HTTP/1.1" 200 2044
catalina.<DATE>.log
04-Jul-2018 16:55:57.940 INFO [Thread-9] org.apache.coyote.AbstractProtocol.pause Pausing ProtocolHandler ["ajp-apr-8012"]
04-Jul-2018 16:55:57.995 INFO [Thread-9] org.apache.catalina.core.StandardService.stopInternal Stopping service Catalina
04-Jul-2018 16:55:58.011 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesJdbc The web application [reportserver] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
04-Jul-2018 16:55:58.012 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [org.apache.commons.vfs.cache.SoftRefFilesCache$SoftRefReleaseThread] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.lang.ref.ReferenceQueue.remove(Unknown Source)
org.apache.commons.vfs.cache.SoftRefFilesCache$SoftRefReleaseThread.run(SoftRefFilesCache.java:76)
04-Jul-2018 16:55:58.013 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->2sonlu9wrzjxp71jg9pqb|368d6060]-AdminTaskTimer] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.util.TimerThread.mainLoop(Unknown Source)
java.util.TimerThread.run(Unknown Source)
04-Jul-2018 16:55:58.014 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->2sonlu9wrzjxp71jg9pqb|368d6060]-HelperThread-#0] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
04-Jul-2018 16:55:58.014 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->2sonlu9wrzjxp71jg9pqb|368d6060]-HelperThread-#1] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
04-Jul-2018 16:55:58.015 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [C3P0PooledConnectionPoolManager[identityToken->2sonlu9wrzjxp71jg9pqb|368d6060]-HelperThread-#2] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:683)
04-Jul-2018 16:55:58.016 WARNING [localhost-startStop-4] org.apache.catalina.loader.WebappClassLoaderBase.clearReferencesThreads The web application [reportserver] appears to have started a thread named [com.google.inject.internal.util.$Finalizer] but has failed to stop it. This is very likely to create a memory leak. Stack trace of thread:
java.lang.Object.wait(Native Method)
java.lang.ref.ReferenceQueue.remove(Unknown Source)
java.lang.ref.ReferenceQueue.remove(Unknown Source)
com.google.inject.internal.util.$Finalizer.run(Finalizer.java:114)
04-Jul-2018 16:55:58.024 INFO [Thread-9] org.apache.coyote.AbstractProtocol.stop Stopping ProtocolHandler ["ajp-apr-8012"]
04-Jul-2018 16:56:02.120 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server version: Apache Tomcat/8.0.51
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server built: Apr 9 2018 21:20:15 UTC
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Server number: 8.0.51.0
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name: Windows 10
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version: 10.0
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture: amd64
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home: C:\Bitnami\REPORT~1.3-2\java
04-Jul-2018 16:56:02.124 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version: 1.8.0_161-b12
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor: Oracle Corporation
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE: C:\Bitnami\reportserver-3.0.3-2\apache-tomcat
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME: C:\Bitnami\reportserver-3.0.3-2\apache-tomcat
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.home=C:\Bitnami\REPORT~1.3-2\APACHE~1
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dcatalina.base=C:\Bitnami\REPORT~1.3-2\APACHE~1
04-Jul-2018 16:56:02.125 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dignore.endorsed.dirs=C:\Bitnami\REPORT~1.3-2\APACHE~1\endorsed
04-Jul-2018 16:56:02.126 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.io.tmpdir=C:\Bitnami\REPORT~1.3-2\APACHE~1\temp
04-Jul-2018 16:56:02.130 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager
04-Jul-2018 16:56:02.130 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=C:\Bitnami\REPORT~1.3-2\APACHE~1\conf\logging.properties
04-Jul-2018 16:56:02.130 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Drs.configdir=C:\Bitnami\reportserver-3.0.3-2/apps/reportserver/reportserver-conf
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dfile.encoding=UTF8
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: exit
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: abort
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xms512m
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1536m
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Xmx1024M
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent Loaded APR based Apache Tomcat Native library 1.2.16 using APR version 1.6.3.
04-Jul-2018 16:56:02.131 INFO [main] org.apache.catalina.core.AprLifecycleListener.lifecycleEvent APR capabilities: IPv6 [true], sendfile [true], accept filters [false], random [true].
04-Jul-2018 16:56:02.993 INFO [main] org.apache.catalina.core.AprLifecycleListener.initializeSSL OpenSSL successfully initialized (OpenSSL 1.0.2m 2 Nov 2017)
04-Jul-2018 16:56:03.204 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["ajp-apr-8012"]
04-Jul-2018 16:56:03.218 INFO [main] org.apache.catalina.startup.Catalina.load Initialization processed in 1630 ms
04-Jul-2018 16:56:03.269 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service Catalina
04-Jul-2018 16:56:03.270 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet Engine: Apache Tomcat/8.0.51
04-Jul-2018 16:56:03.288 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory C:\Bitnami\reportserver-3.0.3-2\apache-tomcat\webapps\reportserver
04-Jul-2018 16:56:03.293 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory C:\Bitnami\reportserver-3.0.3-2\apache-tomcat\webapps\ROOT
04-Jul-2018 16:56:04.295 INFO [localhost-startStop-2] 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.
04-Jul-2018 16:56:04.644 WARNING [localhost-startStop-2] org.apache.catalina.util.SessionIdGeneratorBase.createSecureRandom Creation of SecureRandom instance for session ID generation using [SHA1PRNG] took [301] milliseconds.
04-Jul-2018 16:56:04.685 INFO [localhost-startStop-2] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory C:\Bitnami\reportserver-3.0.3-2\apache-tomcat\webapps\ROOT has finished in 1,392 ms
04-Jul-2018 16:56:43.504 INFO [localhost-startStop-1] 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.
04-Jul-2018 16:57:31.173 INFO [localhost-startStop-1] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory C:\Bitnami\reportserver-3.0.3-2\apache-tomcat\webapps\reportserver has finished in 87,885 ms
04-Jul-2018 16:57:31.177 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["ajp-apr-8012"]
04-Jul-2018 16:57:31.221 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in 87998 ms
I am also facing 1 issue with HTTP external ports as i am not familiar with tomcat. (it is the case when i am running with MySQL defaul Db for reportserver and oracle DB as datasource.)
The issue is when i connect with reportserver website with localhost (http://localhost/reportserver/) it works file.
But when i launch app from different server than host server using 8080 port, i am not able to launch it.
want to know which port is open for reportserver app and where to configure it in tomcat. Or i need to Open port in my windows firewall.
Thanks & Regards
Eduardo
Offline
Hi Mukesh,
you did not answer my question:
you have a bitnami windows installation. If you add a datasource of type oracle with this url: "jdbc:oracle:thin:@10.234.176.70:1521/CMMABP1", everything works. If you click on "test connection" everything works. You can create a dynamic list that uses this oracle datasource.
If you change the persistence.properties file to point to your oracle installation using the same url: "jdbc:oracle:thin:@10.234.176.70:1521/CMMABP1" , and then you restart your bitnami installation, especially tomcat, you get this error (HTTP Status 405).
Is this correct? Please check all steps for making sure.
In this scenario: can you please check the tomcat logs and post them here? Also your persistence.properties file (you can delete your password).
Are these logs you posted from your windows machine, the same machine where your oracle datasource is working?
Please also post a screenshot of the datasource configuration that is working with oracle.
Regards,
Eduardo
Offline
Hi Eduardo,
Yes for "Is this correct? Please check all steps for making sure".
And yes i have shared logs from my windows machine from my Oracle as a datasource working fine.
How do attached the SS to this forum. I dont see any uploader.
Thanks & Regards
Mukesh
Offline
Hi Mukesh,
thanks for clarifying.
You can post images to an online image service like https://imgbb.com/ and then post the link to the image here.
Regards,
Eduardo
Offline
Hi Eduardo,
PFB SS.
can you please also help on my other question.
Thanks & Regards
Mukesh
Offline