It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×1,230

question asked: Jun 21 '11, 5:15 a.m.
question was seen: 6,723 times
last updated: Jun 21 '11, 5:15 a.m.

Related questions

ETL Rational Data Warehouse connection in etl

0
Gavin Corfield (16●4●1) | asked Jun 21 '11, 5:15 a.m.
I have insight 1.0.0.2 installed on linux I have configured the rqm data source in the xml config data manager however when I run the OOTB2ETE job it always fails with followign error:

DM-DBM-0402 UDA driver reported the following:

UDA-SQL-0031 Unable to access the "Rational Data Warehouse" database.

UDA-SQL-0129 Invalid login information was detected by the underlying database.

SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001


DM-DBM-0306 UDA driver error connecting to 'Rational Data Warehouse'.

DM-LIB-0300 Error initializing variable 'ETL_DATEID' to:
GetETLDateID( $ETL_STARTIME ).

DM-BLD-0004 JobStream 'Build_Star' is not a valid specification.

(for details, see Job_Build_Star_0010.log)

JobStream Node 8 'Build_Star'; failed but continuing
Done - 0 00:00:48 elapsed
jobstream -- completed (21-Jun-2011 17:07:57)

I have following odbc config:


Description = DB2 Driver
Driver = /opt/ibm/db2/V9.7/lib32/libdb2.so


dbalias=RIDW
UID=db2inst1
PWD=mypassword

Am I going about this the right way? Whenever I try and use isql I always connect I only have a problem in the context of the job.

2 answers

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Petroula Pantazopoulos (366●1●2) | answered Jun 21 '11, 8:54 a.m.
JAZZ DEVELOPER
I have insight 1.0.0.2 installed on linux I have configured the rqm data source in the xml config data manager however when I run the OOTB2ETE job it always fails with followign error:

DM-DBM-0402 UDA driver reported the following:

UDA-SQL-0031 Unable to access the "Rational Data Warehouse" database.

UDA-SQL-0129 Invalid login information was detected by the underlying database.

SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001


DM-DBM-0306 UDA driver error connecting to 'Rational Data Warehouse'.

DM-LIB-0300 Error initializing variable 'ETL_DATEID' to:
GetETLDateID( $ETL_STARTIME ).

DM-BLD-0004 JobStream 'Build_Star' is not a valid specification.

(for details, see Job_Build_Star_0010.log)

JobStream Node 8 'Build_Star'; failed but continuing
Done - 0 00:00:48 elapsed
jobstream -- completed (21-Jun-2011 17:07:57)

I have following odbc config:


Description = DB2 Driver
Driver = /opt/ibm/db2/V9.7/lib32/libdb2.so


dbalias=RIDW
UID=db2inst1
PWD=mypassword

Am I going about this the right way? Whenever I try and use isql I always connect I only have a problem in the context of the job.


The connection to the warehouse is not defined to be an ODBC connection, if you go to the ETL catalog under the connection list in the tree you will see it listed there as "Rational Data Warehouse" . You need to select the appropriate DBMS datasource type to configure that is either a DB2, Oracle or SQL Server connection and supply the right credentials to connect to the data source.
0
permanent link
li yaqiang (194●2●3) | answered Jun 21 '11, 8:45 p.m.
I have insight 1.0.0.2 installed on linux I have configured the rqm data source in the xml config data manager however when I run the OOTB2ETE job it always fails with followign error:

DM-DBM-0402 UDA driver reported the following:

UDA-SQL-0031 Unable to access the "Rational Data Warehouse" database.

UDA-SQL-0129 Invalid login information was detected by the underlying database.

SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001


DM-DBM-0306 UDA driver error connecting to 'Rational Data Warehouse'.

DM-LIB-0300 Error initializing variable 'ETL_DATEID' to:
GetETLDateID( $ETL_STARTIME ).

DM-BLD-0004 JobStream 'Build_Star' is not a valid specification.

(for details, see Job_Build_Star_0010.log)

JobStream Node 8 'Build_Star'; failed but continuing
Done - 0 00:00:48 elapsed
jobstream -- completed (21-Jun-2011 17:07:57)

I have following odbc config:


Description = DB2 Driver
Driver = /opt/ibm/db2/V9.7/lib32/libdb2.so


dbalias=RIDW
UID=db2inst1
PWD=mypassword

Am I going about this the right way? Whenever I try and use isql I always connect I only have a problem in the context of the job.


You can open the catalog in the Windows system's Data Manager and modify the user/password in the Rational Data Warehouse connection under the RationalInsightETL\Library\Connections

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.