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