Technical Blog Post
ITM Agent Insights: TDW data source connection troubleshoot Error
This blog is to help troubleshoot error/failure while creating the TDW data source connection. You may encounter such issues while stepping through the procedure to establishing successfully TDW data source connection detailed under my accompanying blog ITM Agent Insights: Establishing successfully TDW data source connection steps.
Note: On warehouse machine make sure it is connected to warehouse and It has to be cataloged to local TCR machine otherwise it will not connect to TDW on other server
Getting error while testing the connection at step number 12 from Blog : ITM Agent Insights: Establishing successfully TDW data source connection steps.
QE-DEF-0285 The logon failed.
QE-DEF-0321 The userID or password is either missing or invalid.
RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
UDA-SQL-0031 Unable to access the "testDataSourceConnection" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
UDA-SQL-0129 Invalid login information was detected by the underlying database.
[IBM][CLI Driver] SQL1013N The database alias name or database name " " could not be found. SQLSTATE=42705
BME-EX-0144 Trace back:
BmtPlayTransaction.cpp(788): QFException: CCL_RETHROW: BmtPlayTransaction::DoAction
BmtActionsHelper.cpp(488): QFException: CCL_RETHROW: BmtActionsHelper::DoAction
QFSSession.cpp(1153): QFException: CCL_RETHROW: QFSSession::ProcessDoRequest()
QFSSession.cpp(1151): QFException: CCL_CAUGHT: QFSSession::ProcessDoRequest()
QFSSession.cpp(2045): QFException: CCL_RETHROW: QFSSession::SessionProcessTestConnection()
Source/QE_RsApi.cpp(2089): QFException: CCL_RETHROW: QE
Source/QEI_ConnectionFault.cpp(814): QFException: CCL_THROW: QE
Script Stack Trace
Action No=1 Action Name=TestDataSourceConnection
Resolve this issue:
There will be two issue here.
1. On warehouse machine make sure it is connected to warehouse and It has to be cataloged to local TCR machine otherwise it will not connect to TDW on other server
It has to be catalogs to local TCR machine otherwise it will not connect to TDW on other server.
su - db2inst1 – linux
db2cmd – Windows (following Procedure are on window machine)
db2 catalog tcpip node WHSE remote hostname.ibm.com server 50000
db2 catalog tcpip node WHSE remote 0.0.0.0 server 50000
where zero is IP address of database warehouse machine.
db2 catalog database WAREHOUS as WAREHOUS at node WHSE
db2stop and db2start
If fail then do this:
db2 connect to warehous user USERNAME using PASSWORD
Then do the test connection again.
2. DB2 database name is missing. See following the image.
The error "SQL1013N The database alias name or database name " " could not be found. SQLSTATE=42705" explain the issue here.
In Specify the IBM DB2 connection string as seen in above image.
- Edit the parameters to build a DB2 connection string.
- DB2 database name: WAREHOUS or whatever the name you have for your warehous.
- Then use same user and password that you have for above database and click test connection.
Additional ITM Agent Insights series of IBM Tivoli Monitoring Agent blogs are indexed under ITM
Subscribe and follow us for all the latest information directly on your social feeds: