Wednesday, March 30, 2011

Sap Database And Jdbc Exception Details

Exception Details:
 
com.sap.ip.bi.sdk.exception.BIConnectionFailedException: Cannot open the connection
at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactor y.getConnectionEx(JdbcConnectionFactory.java:238)
at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCM odel.getConnection(JDBCModel.java:796)
at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCM odel.getTables(JDBCModel.java:132)
at com.sap.ip.bi.sdk.trialarea.connector.servlet.controller. Control2.doPost(Control2.java:25)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:760)
at javax.servlet.http.HttpServlet.service(HttpServlet .java:853)
at com.sap.engine.services.servlets_jsp.server.HttpHa ndlerImpl.runServlet(HttpHandlerImpl.java:401)
at com.sap.engine.services.servlets_jsp.server.HttpHa ndlerImpl.handleRequest(HttpHandlerImpl.java:266)
at com.sap.engine.services.httpserver.server.RequestA nalizer.startServlet(RequestAnalizer.java:386)
at com.sap.engine.services.httpserver.server.RequestA nalizer.startServlet(RequestAnalizer.java:364)
at com.sap.engine.services.httpserver.server.RequestA nalizer.invokeWebContainer(RequestAnalizer.java:1039)
at com.sap.engine.services.httpserver.server.RequestA nalizer.handle(RequestAnalizer.java:265)
at com.sap.engine.services.httpserver.server.Client.h andle(Client.java:95)
at com.sap.engine.services.httpserver.server.Processo r.request(Processor.java:175)
at com.sap.engine.core.service630.context.cluster.ses sion.ApplicationSessionMessageListener.process(Applica tionSessionMessageListener.java:33)
at com.sap.engine.core.cluster.impl6.session.MessageR unner.run(MessageRunner.java:41)
at com.sap.engine.core.thread.impl3.ActionObject.run( ActionObject.java:37)
at java.security.AccessController.doPrivileged(Access Controller.java:219)
at com.sap.engine.core.thread.impl3.SingleThread.exec ute(SingleThread.java:104)
at com.sap.engine.core.thread.impl3.SingleThread.run( SingleThread.java:176)
Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot open the connection
at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectio n.(JdbcManagedConnection.java:123)
at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectio nFactory.createManagedConnection(JdbcManagedConnectionFact ory.java:112)
at com.sap.engine.services.connector.jca.ConnectionHa shSet.match(ConnectionHashSet.java:338)
at com.sap.engine.services.connector.jca.ConnectionMa nagerImpl.allocateConnection(ConnectionManagerImpl.java:262 )
at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactor y.getConnectionEx(JdbcConnectionFactory.java:233)
... 19 more
Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Cannot connect to JDBC data source
at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.conn ectDB(Connection.java:336)
at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.conn ect(Connection.java:99)
at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectio n.(JdbcManagedConnection.java:118)
... 23 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
at com.microsoft.sqlserver.jdbc.SQLServerConnection.t erminate(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(Unkno wn Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.P relogin(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.l oginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.c onnect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.conne ct(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager .java:559)
at java.sql.DriverManager.getConnection(DriverManager .java:158)
at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.conn ectDB(Connection.java:320) 


Read more about sap servers





1 comment:

  1. With the extensive use of the internet worldwide, we use different browsers to visit various web pages. Amidst this browsing, you might have come across the message that says “This Site Can’t Be Reached” or “The Connection Was Reset”. When Google Chrome or any other browser is redirected to some website, it could be due to several reasons. This “Connection Reset Error” creates trouble, causing interruption to work, thereby breaking our workflow. Sometimes by simply refreshing the page or restarting Chrome helps to overcome this err connection reset error. But in certain cases, issues are not resolved and need to be worked out in-depth. Adopting some of these methods can be your saviour and allow you to work uninterruptedly.

    ReplyDelete

your comment will be visible after administrator approval