Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Hi Snowy, Unfortunately yes. Do you have any ideas how to deal with that? And what about dats/tims field. the Database has fields declared as date and time but only date is included. Is it possible to receive this field as char and convert it to date within BI? thanks in advance for any advice. bye crunny
| | | ---------------Original Message--------------- From: Crunchips77 Sent: Thursday, November 18, 2010 4:25 AM Subject: Issue connecting MS SQL via UD Connect in SAP BW 7 Hello everyone, Hope so is still taking care of this thread because I have a similar issue and I need some input and advices. We are on BI 7 patch 701. Approach is to extract a view from a ms sql db. We have already created a new users belonging to the group of the db owner "dbo" of the ms sql db. The java engine is configured from our SAP Basis to connect to the MS SQL DB. Here the key facts: Running a smooth connection test from SAP BI based on the RFC settings done in SM59 and in the java engine is successful. But creating a DS and entering the UDC Source object (= name of view) the error appears saying: UDCADAPTERROR::RSSDK|200|Cannot open the connection Going 2 steps back. I tried to run the URL to check if the connection is fine, but even this was not working: URL: [url=http://[xxxxx]:54000/TestJDBC_Web/TestJDBCPage .jsp]http://[xxxxx]:54000/TestJDBC_Web/TestJDBCPag e.jsp[/url] "Could not connect to database. Connection is inactive or does not support JBDC. " Attached at the end: the complete message. My general questions are, - is the connection test in BI only checking the connection between BI and the Jave engine? - And which system is not supporting JDBC, BI or MS SQL? - And of course which is much more helpful what to do here? Thanks in advance for your hints which are really appreciated. bye crunny. 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) ... 25 more | | __.____._ Copyright © 2011 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251 | | Most Popular White Papers In the Spotlight _.____.__ |