Skip to Content
0
Former Member
Jun 16, 2009 at 05:01 AM

Universal Data Connect

66 Views

Dear All,

Line: -


Recently we have configured UD connect on j2ee assess to external database and we are facing the problem while connecting the UD Connect Source Object - Through RSA1, Please find the error logs:

1. Date : 06/16/2009

Time : 10:21:45:553

Message : MsgException: Cannot open the connection: Cannot connect to JDBC data source: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open user default database. Login failed.

Severity : Error

Category : /Applications/BI/UDI

Location : com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean

Application : sap.com/com.sap.ip.bi.sdk.datasource.ds

Thread : SAPEngine_Application_Thread[impl:3]_8

Datasource : 16477450:/usr/sap/DBI/DVEBMGS01/j2ee/cluster/server0/BI_SDK_Trace.log

Message ID : 0018FE28508A00640000001D0000660900046C6FEE82AC3C

Source Name : com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean

Argument Objs :

Arguments :

Dsr Component : DBI

Dsr Transaction : 4A36C4E340686599E1000000AC10087D

Dsr User : SAPSYS

Indent : 0

Level : 0

Message Code :

Message Type : 0

Relatives : /Applications/BI/UDI

Resource Bundlename :

Session : 0

Source : com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean

ThreadObject : SAPEngine_Application_Thread[impl:3]_8

Transaction :

User : J2EE_GUEST

2 - Error:

Date : 06/16/2009

Time : 10:21:45:547

Message : com.sap.ip.bi.sdk.exception.BIResourceException: Cannot open the connection

[EXCEPTION]

com.sap.ip.bi.sdk.exception.BIResourceException: Cannot open the connection

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

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

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

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

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnection(JdbcConnectionFactory.java:107)

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnection(JdbcConnectionFactory.java:82)

at com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean.connect(BI_SDK_Bean.java:1868)

at com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean.processDatasourcesRemoteGet(BI_SDK_Bean.java:1738)

at com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean.processFunction(BI_SDK_Bean.java:587)

at com.sap.ip.bi.sdk.datasource.beans.IBI_SDK_LocalLocalObjectImpl0_0.processFunction(IBI_SDK_LocalLocalObjectImpl0_0.java:102)

at com.sap.engine.services.rfcengine.RFCDefaultRequestHandler.call(RFCDefaultRequestHandler.java:203)

at com.sap.engine.services.rfcengine.RFCDefaultRequestHandler.handleRequest(RFCDefaultRequestHandler.java:169)

at com.sap.engine.services.rfcengine.RFCJCOServer.handleRequest(RFCJCOServer.java:156)

at com.sap.mw.jco.JCO$Server.dispatchRequest(JCO.java:7785)

at com.sap.mw.jco.MiddlewareJRfc$Server.dispatchRequest(MiddlewareJRfc.java:2405)

at com.sap.mw.jco.MiddlewareJRfc$Server.listen(MiddlewareJRfc.java:1728)

at com.sap.mw.jco.JCO$Server.listen(JCO.java:8145)

at com.sap.mw.jco.JCO$Server.work(JCO.java:8265)

at com.sap.mw.jco.JCO$Server.loop(JCO.java:8212)

at com.sap.mw.jco.JCO$Server.run(JCO.java:8128)

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

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

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.connectDB(Connection.java:394)

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

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

... 23 more

Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open user default database. Login failed.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

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

... 25 more

Severity : Error

Category : /Applications/BI/UDI

Location : com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean

Application : sap.com/com.sap.ip.bi.sdk.datasource.ds

Thread : SAPEngine_Application_Thread[impl:3]_8

Datasource : 16477450:/usr/sap/DBI/DVEBMGS01/j2ee/cluster/server0/BI_SDK_Trace.log

Message ID : 0018FE28508A0064000000070000660900046C6FEE829C55

Source Name : com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean

Argument Objs : com.sap.ip.bi.sdk.exception.BIResourceException: Cannot open the connection

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

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

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

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

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnection(JdbcConnectionFactory.java:107)

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnection(JdbcConnectionFactory.java:82)

at com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean.connect(BI_SDK_Bean.java:1868)

at com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean.processDatasourcesRemoteGet(BI_SDK_Bean.java:1738)

at com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean.processFunction(BI_SDK_Bean.java:587)

at com.sap.ip.bi.sdk.datasource.beans.IBI_SDK_LocalLocalObjectImpl0_0.processFunction(IBI_SDK_LocalLocalObjectImpl0_0.java:102)

at com.sap.engine.services.rfcengine.RFCDefaultRequestHandler.call(RFCDefaultRequestHandler.java:203)

at com.sap.engine.services.rfcengine.RFCDefaultRequestHandler.handleRequest(RFCDefaultRequestHandler.java:169)

at com.sap.engine.services.rfcengine.RFCJCOServer.handleRequest(RFCJCOServer.java:156)

at com.sap.mw.jco.JCO$Server.dispatchRequest(JCO.java:7785)

at com.sap.mw.jco.MiddlewareJRfc$Server.dispatchRequest(MiddlewareJRfc.java:2405)

at com.sap.mw.jco.MiddlewareJRfc$Server.listen(MiddlewareJRfc.java:1728)

at com.sap.mw.jco.JCO$Server.listen(JCO.java:8145)

at com.sap.mw.jco.JCO$Server.work(JCO.java:8265)

at com.sap.mw.jco.JCO$Server.loop(JCO.java:8212)

at com.sap.mw.jco.JCO$Server.run(JCO.java:8128)

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

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

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.connectDB(Connection.java:394)

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

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

... 23 more

Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open user default database. Login failed.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

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

... 25 more

,

Arguments : com.sap.ip.bi.sdk.exception.BIResourceException: Cannot open the connection

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

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

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

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

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnection(JdbcConnectionFactory.java:107)

at com.sap.ip.bi.sdk.dac.connector.jdbc.JdbcConnectionFactory.getConnection(JdbcConnectionFactory.java:82)

at com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean.connect(BI_SDK_Bean.java:1868)

at com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean.processDatasourcesRemoteGet(BI_SDK_Bean.java:1738)

at com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean.processFunction(BI_SDK_Bean.java:587)

at com.sap.ip.bi.sdk.datasource.beans.IBI_SDK_LocalLocalObjectImpl0_0.processFunction(IBI_SDK_LocalLocalObjectImpl0_0.java:102)

at com.sap.engine.services.rfcengine.RFCDefaultRequestHandler.call(RFCDefaultRequestHandler.java:203)

at com.sap.engine.services.rfcengine.RFCDefaultRequestHandler.handleRequest(RFCDefaultRequestHandler.java:169)

at com.sap.engine.services.rfcengine.RFCJCOServer.handleRequest(RFCJCOServer.java:156)

at com.sap.mw.jco.JCO$Server.dispatchRequest(JCO.java:7785)

at com.sap.mw.jco.MiddlewareJRfc$Server.dispatchRequest(MiddlewareJRfc.java:2405)

at com.sap.mw.jco.MiddlewareJRfc$Server.listen(MiddlewareJRfc.java:1728)

at com.sap.mw.jco.JCO$Server.listen(JCO.java:8145)

at com.sap.mw.jco.JCO$Server.work(JCO.java:8265)

at com.sap.mw.jco.JCO$Server.loop(JCO.java:8212)

at com.sap.mw.jco.JCO$Server.run(JCO.java:8128)

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

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

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.connectDB(Connection.java:394)

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

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

... 23 more

Caused by: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Cannot open user default database. Login failed.

at com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)

at com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processErrorToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSLoginRequest.processReplyToken(Unknown Source)

at com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)

at com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)

at com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)

at com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)

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

... 25 more

,

Dsr Component : DBI

Dsr Transaction : 4A36C4E340686599E1000000AC10087D

Dsr User : SAPSYS

Indent : 0

Level : 0

Message Code :

Message Type : 1

Relatives : /Applications/BI/UDI

Resource Bundlename :

Session : 0

Source : com.sap.ip.bi.sdk.datasource.beans.BI_SDK_Bean

ThreadObject : SAPEngine_Application_Thread[impl:3]_8

Transaction :

User : J2EE_GUEST

Thanks & Regards,

Adarsh Kumar.

Edited by: Adarsh Kumar on Jun 16, 2009 7:02 AM