Jun 02, 2008 at 11:43 AM

Creating BI JDBC System ...

84 Views

Hello all,

I created BI JDBC System for Visual Composer on our test and productive EP. I progressed in according with this guide:

On test system it works fine but on the productive one the connection ends with error:

#1.5 #001CC4568C0200780000012400000DD000044EAA8C584DCF#1212394312872#com.sap.engine.services.servlets_jsp.client.RequestInfoServer#sap.com/com.sap.ip.bi.sdk.dac.connector.checkj#com.sap.engine.services.servlets_jsp.client.RequestInfoServer#Guest#0##n/a##8ef82280307b11ddbb81001cc4568c02#SAPEngine_Application_Threadimpl:3_15##0#0#Error##Plain###application TestJDBC_Web Processing HTTP request to servlet Control 2 finished with error. The error is: java.lang.NoClassDefFoundError: oracle/dms/instrument/ExecutionContextForJDBC

at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:341)

at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)

at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)

at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:854)

at java.sql.DriverManager.getConnection(DriverManager.java:512)

at java.sql.DriverManager.getConnection(DriverManager.java:140)

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

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:188)

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:102)

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

#

The error is: java.lang.NoClassDefFoundError: oracle/dms/instrument/ExecutionContextForJDBC

Exception id: 001CC4568C0200780000012400000DD000044EAA8C584DCF#

I checked the configuration and it seems to be same on both portals.

Do you have any idea where could be problem?

Thank you in advance for every advice!

With regards

Zbynek