8 Replies Latest reply on Jul 10, 2019 1:05 AM by Ravi Reddi

    Smart Reporting Error

    Meyananth Kuppusamy Chellamuthu
      Share This:

      Hi Team,

       

      we are getting the below error while accessing the Smart Reporting.

       

       

      ERROR (DBAction:<init>) - Error occurred when connecting to the database: java.lang.NullPointerException

      java.lang.NullPointerException

      at com.hof.pool.DBConnectionManager.A(DBConnectionManager.java:421)

      at com.hof.pool.DBConnectionManager.getConnection(DBConnectionManager.java:292)

      at com.hof.util.DBAction.<init>(DBAction.java:352)

      at com.hof.util.DBAction.<init>(DBAction.java:465)

      at com.hof.util.DBAction.<init>(DBAction.java:407)

      at com.hof.servlet.SystemTaskManager$_A.A(SystemTaskManager.java:674)

      at com.hof.servlet.SystemTaskManager$_A.run(SystemTaskManager.java:424)

      at java.util.TimerThread.mainLoop(Unknown Source)

      at java.util.TimerThread.run(Unknown Source)

      BMC:SR:2019-07-05 00:47:00:ERROR (SystemTaskManager:A) - com.hof.util.ActionErrorsException: DBAction constructor exception

      BMC:SR:2019-07-05 00:47:00:ERROR (SystemTaskManager:run) - Error loading schedules: com.hof.util.ActionErrorsException: DBAction constructor exception

       

      Kindly help!

       

      Thanks & Regards,

      Meyananth

        • 1. Re: Smart Reporting Error
          PAWAN KAUSHIK

          Hi, as per the error logs the db connection is not setup. Check out the Smart Reporting DB if the credentials  are correct or not,

          1 of 1 people found this helpful
          • 3. Re: Smart Reporting Error
            Meyananth Kuppusamy Chellamuthu

            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 Reddi

              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

                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 Reddi

                  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

                    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 Reddi

                      Hi Meyananth,

                       

                      Glad that the issue has been resolved now, as well thanks for sharing the details!

                       

                      Cheers,

                      Ravi Reddi