ITM Agent Insights: TDW data source connection troubleshoot Error

Body

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: 
    testDataSourceConnection

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 Agent Insights: Introduction.

Subscribe and follow us for all the latest information directly on your social feeds: