Issues in Connecting SQL Server 2008 to BI om Sola...

Former Member · ‎02-17-2011

Hi ,

I am trying to Connect a Standalone SQL Server to a BI System on UNIX Via UD Connect . Both SQL Server and BI System are on the Same Network ( Subnet ) .

I have Deployed the JDBC Drivers in BI Via Visual Administrator

PATH :- Server --> Services --> JDBC Connector

Then , in VIsual Admin in CONNECTOR COntainer , I copied the SDK_JDBC and Created another Connector SDK_JDBC1 which Connects to SQL Server

In the Properties I have Maintained the Following Parameters :-

DriverName :- com.microsoft.jdbc.sqlserver.SQLServerDriver

URL :- jdbc:microsoft:sqlserver://<SQLServer_HOST>:1433;DatabaseName=<SID>

User :- Username which Authenticates to SQL Server and NOT WINDOWS

Password :- Password Of the User

I have not BOUNCED the JAVA Stack .

Now , when I test the Connection via URL http://<FQDN>/TestJDBC_Web/TestJDBCPage.jsp

and I Select SDK_JDBC1 , I get the Following Errors .

I am giving extract of Error of BI_SDK_Trace.log and DefaultTrace Log

Trace of BI_SDK_Trace.log :- #1.#0003BAE27F27001F0000007500006DD100049C78328E98DE#1297939965056#com.sap.ip.bi.sdk.dac.connector.relational.CommonConnection#sap.com/com.sap.ip.bi.sdk.dac.connector.checkj#com.sap.ip.bi.sdk.dac.connector.relational.CommonConnection#Guest#0##n/a##0d131de63a8411e097c90003bae27f27#SAPEngine_Application_Thread[impl:3]_29##0#0#Error#1#/Applications/BI/UDI#Plain###Class Not Found: com.microsoft.jdbc.sqlserver.SQLServerDriver#

#1.#0003BAE27F27001F0000007900006DD100049C78328FE6CC#1297939965133#com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection#sap.com/com.sap.ip.bi.sdk.dac.connector.checkj#com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection#Guest#0##n/a##0d131de63a8411e097c90003bae27f27#SAPEngine_Application_Thread[impl:3]_29##0#0#Error#1#/Applications/BI/UDI#Java###com.sap.ip.bi.sdk.exception.BIResourceException: Class DriverName is not found

[EXCEPTION]

#1#com.sap.ip.bi.sdk.exception.BIResourceException: Class DriverName is not found at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connectDB(Connection.java:314)

at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connect(Connection.java:99)

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnection.<init>(JdbcManagedConnection.java:118)

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcManagedConnectionFactory.createManagedConnection(JdbcManagedConnectionFactory.java:112)

at com.sap.engine.services.connector.jca.ConnectionHashSet.match(ConnectionHashSet.java:338)

at com.sap.engine.services.connector.jca.ConnectionManagerImpl.allocateConnection(ConnectionManagerImpl.java:262)

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnectionEx(JdbcConnectionFactory.java:233)

at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCModel.getConnection(JDBCModel.java:796)

at com.sap.ip.bi.sdk.trialarea.connector.servlet.model.JDBCModel.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.HttpHandlerImpl.runServlet(HttpHandlerImpl.java:401)

at com.sap.engine.services.servlets_jsp.server.HttpHandlerImpl.handleRequest(HttpHandlerImpl.java:266)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:386)

at com.sap.engine.services.httpserver.server.RequestAnalizer.startServlet(RequestAnalizer.java:364)

at com.sap.engine.services.httpserver.server.RequestAnalizer.invokeWebContainer(RequestAnalizer.java:1039)

at com.sap.engine.services.httpserver.server.RequestAnalizer.handle(RequestAnalizer.java:265)

at com.sap.engine.services.httpserver.server.Client.handle(Client.java:95)

at com.sap.engine.services.httpserver.server.Processor.request(Processor.java:175)

at com.sap.engine.core.service630.context.cluster.session.ApplicationSessionMessageListener.process(ApplicationSessionMessageListener.java:33)

at com.sap.engine.core.cluster.impl6.session.MessageRunner.run(MessageRunner.java:41)

at com.sap.engine.core.thread.impl3.ActionObject.run(ActionObject.java:37)

at java.security.AccessController.doPrivileged(Native Method)

at com.sap.engine.core.thread.impl3.SingleThread.execute(SingleThread.java:104)

at com.sap.engine.core.thread.impl3.SingleThread.run(SingleThread.java:176)

Caused by: java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriverFound in negative cache

-

Loader Info -

ClassLoader name: [connector:default]

Parent loader name: [Frame ClassLoader]

References:

common:service:http;service:servlet_jsp

service:ejb

common:service:iiop;service:naming;service:p4;service:ts

service:jmsconnector

library:jsse

library:servlet

common:library:IAIKSecurity;library:activation;library:mail;library:tc_secssl

library:ejb20

library:j2eeca

library:jms

library:opensql

common:library:com.sap.security.api.sda;library:com.sap.security.core.sda;library:security.class;library:signature_lib;library:webservices_lib;service:adminadapter;service:basicadmin;service:com.sap.security.core.ume.service;service:configuration;service:connector;service:dbpool;service:deploy;service:jmx;service:jmx_notification;service:keystore;service:security;service:userstore

interface:resourcecontext_api

interface:webservices

interface:cross

interface:ejbserialization

common:library:bi_mmrcore;library:bi_mmrdb

library:tc_connconnectorframework

library:com.sap.ip.bi.sdk.dac.connector.odbodll

library:sapxmltoolkit

sap.com/com.sap.ip.bi.sdk.dac.connector.xmla.x

library:com.sap.mw.jco

library:com.sap.aii.proxy.framework

library:com.sap.aii.util.misc

sap.com/caf~core

sap.com/caf_runtimeear

library:bi_mmrcwm_1.0_library

library:bi_mmrjmi

library:com.sap.ip.bi.sdk

library:MSS_DRIVER

library:SYSTEM_DRIVER

library:ORA_DRIVER

Resources:

/usr/sap/TP1/JC00/j2ee/cluster/server0/apps/sap.com/caf_bwadapter_{assembly/connector/connectors/caf}bw_adapterassembly.rar/sap.com_cafbw_adaptercaf.bw.adapter.jar

/usr/sap/TP1/JC00/j2ee/cluster/server0/apps/sap.com/com.sap.ip.bi.sdk.dac.connector.xmla/connector/connectors/bi_sdk_xmla.rar/bi_sdk_xmla.jar

/usr/sap/TP1/JC00/j2ee/cluster/server0/apps/sap.com/com.sap.ip.bi.sdk.dac.connector.sapq/connector/connectors/bi_sdk_sapq.rar/bi_sdk_sapq.jar

/usr/sap/TP1/JC00/j2ee/cluster/server0/apps/sap.com/com.sap.ip.bi.sdk.dac.connector.jdbc/connector/connectors/bi_sdk_jdbc.rar/bi_sdk_jdbc.jar

Loading model: {parent,references,local}

-

at com.sap.engine.frame.core.load.ReferencedLoader.loadClass(ReferencedLoader.java:360)

at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:302)

at java.lang.Class.forName0(Native Method)

at java.lang.Class.forName(Class.java:141)

at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connectDB(Connection.java:309)

... 25 more

Trace of Defaultlog

#1.#0003BAE27F27001F0000007800006DD100049C78328FDED9#1297939965140#System.err#sap.com/com.sap.ip.bi.sdk.dac.connector.checkj#System.err#Guest#0##n/a##0d131de63a8411e097c90003bae27f27#SAPEngine_Application_Thread[impl:3]_29##0#0#Error##Plain###Feb 17, 2011 4:22:45 PM ....connector.jdbc.JdbcManagedConnection [SAPEngine_Application_Thread[impl:3]_29] Error: com.sap.ip.bi.sdk.exception.BIResourceException: Class DriverName is not found

[EXCEPTION]

com.sap.ip.bi.sdk.exception.BIResourceException: Class DriverName is not found at com.sap.ip.bi.sdk.dac.connector.jdbc.impl.Connection.connectDB(Connection.java:314)