-
1. Re: Smart Reporting Error
PAWAN KAUSHIK Jul 5, 2019 7:00 AM (in response to Meyananth Kuppusamy Chellamuthu)1 of 1 people found this helpfulHi, as per the error logs the db connection is not setup. Check out the Smart Reporting DB if the credentials are correct or not,
-
2. Re: Smart Reporting Error
Jose Daniel Sosa Posadas Jul 5, 2019 5:08 PM (in response to Meyananth Kuppusamy Chellamuthu)Meyananth Kuppusamy Chellamuthu
HI,
Please chetck the conection of the database
https://communities.bmc.com/docs/DOC-68898
Regards
Daniel Sosa
-
3. Re: Smart Reporting Error
Meyananth Kuppusamy Chellamuthu Jul 7, 2019 9:50 PM (in response to Jose Daniel Sosa Posadas)Hi Pawan / Jose,
There is no issue in connecting the database with the credentials provided in Web.xml (when i try manually). Am not sure, why the smart reporting server is not able to connect with the database.
Is there any other configuration which need to be refreshed in the system?
Thanks,
Meyananth
-
4. Re: Smart Reporting Error
Ravi ReddiJul 8, 2019 2:56 AM (in response to Meyananth Kuppusamy Chellamuthu)
Hey,
You may check if the connectivity between your SmartReporting server and Database servers is responding over the PING & TELNET.
- Did you check the jdbc.log from the SmartReporting's log folder? This may have more details.
- Are you using bundled Tomcat or External? Is the tomcat being run using Service Account or Domain Account?
- Is the SmartReporting database user using SQL or Windows Authentication?
Regards,
Ravi Reddi
-
5. Re: Smart Reporting Error
Meyananth Kuppusamy Chellamuthu Jul 9, 2019 4:47 AM (in response to Ravi Reddi)Hi Ravi,
Please find the updates.
- Did you check the jdbc.log from the SmartReporting's log folder? This may have more details.
- Are you using bundled Tomcat or External? Is the tomcat being run using Service Account or Domain Account? Yes, we have Bundled Tomcat and run using Service Account.
- Is the SmartReporting database user using SQL or Windows Authentication? Using SQL Authentication
Error from JDBC.log
ARN: Failed to create initial connection at DBConnectionPool startup (attempt 1). Will try again in 15 seconds. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host #######, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
2019-07-09 03:37:03 ERROR: Failed to create initial connection at DBConnectionPool startup. Giving up.
com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host #######, port 1433 has failed. Error: "Connection timed out: no further information. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)
at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:242)
at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2369)
at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:551)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1963)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)
at com.hof.pool.JDBCConnection.openConnection(JDBCConnection.java:179)
at com.hof.pool.DBConnection.authenticateAndOpenConnection(DBConnection.java:127)
at com.hof.pool.DBConnectionPool.A(DBConnectionPool.java:1211)
at com.hof.pool.DBConnectionPool.createJDBCPool(DBConnectionPool.java:567)
at com.hof.pool.DBConnectionManager.initialiseAppPool(DBConnectionManager.java:396)
at com.hof.servlet.InitConnectionPool.init(InitConnectionPool.java:222)
at org.apache.catalina.core.StandardWrapper.initServlet(StandardWrapper.java:1183)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1099)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:989)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4913)
at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5223)
at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:724)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:700)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:734)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:596)
at org.apache.catalina.startup.HostConfig$DeployDescriptor.run(HostConfig.java:1805)
at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
at java.util.concurrent.FutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
Also, am able to Ping the DB server name without any issues.
-
6. Re: Smart Reporting Error
Ravi ReddiJul 9, 2019 8:28 AM (in response to Meyananth Kuppusamy Chellamuthu)
Hi there, Thanks for all the details provided.
One outstanding question though! Have you tested TELNET as requested? Please do!
I strongly believe this is with the port being blocked or the TCP/IP isn't enabled!
You can check the below: Perform these on the SQL Server box/machine:
- Go to Start->All Programs-> Microsoft SQL Server 2012-> Configuration Tool
- Click SQL Server Configuration Manager
- Expand SQL Server Network Configuration-> Protocol
- Enable TCP/IP Right box
- Double Click on TCP/IP and go to IP Addresses Tap and Put port 1433 under TCP port.
Ideally even if you try to create a local DSN on the SmartReporting server and try to establish a connection to the database server then it should result in same error. The point I am trying to make here is that the issue isn't application specific rather network related.
Let me know how it goes!
Regards,
Ravi Reddi
-
7. Re: Smart Reporting Error
Meyananth Kuppusamy Chellamuthu Jul 9, 2019 10:26 PM (in response to Ravi Reddi)Thanks Ravi,
Issue got fixed.
In Smart Reporting Server, Host file having the wrong IP of DB server. We updated the correct IP address and the service restart established the connection with the DB.
Thanks,
Meyananth
-
8. Re: Smart Reporting Error
Ravi ReddiJul 10, 2019 1:05 AM (in response to Meyananth Kuppusamy Chellamuthu)
Hi Meyananth,
Glad that the issue has been resolved now, as well thanks for sharing the details!
Cheers,
Ravi Reddi