It's all about the answers!

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

×10,961

question asked: Nov 01 '10, 11:20 a.m.
question was seen: 4,914 times
last updated: Nov 01 '10, 11:20 a.m.

Related questions

Running the ETL Job RQMALL- Failure on DB2

0
Terry Taylor (16●3●2) | asked Nov 01 '10, 11:20 a.m.
My environment is: Microsoft Server 2008 R2 with DB2 as the database. I am running Rational Quality Manager and Rational Common Reporting.

I am trying to run the ETL Job RQMALL and I am getting the following error message in the log file:

Data Manager v8.4.27.78 -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
COGNOS INTERNAL USE ONLY
jobstream -- start run on (this section has my server info) (31-Oct-2010 21:18:13)

DM-DBM-0402 UDA driver reported the following:

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

UDA-SQL-0107 A general exception has occurred during the operation "attach".

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

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

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

jobstream -- failed (31-Oct-2010 21:18:14)

Any help is appreciated.

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Terry Taylor (16●3●2) | answered Nov 08 '10, 3:18 p.m.
My environment is: Microsoft Server 2008 R2 with DB2 as the database. I am running Rational Quality Manager and Rational Common Reporting.

I am trying to run the ETL Job RQMALL and I am getting the following error message in the log file:

Data Manager v8.4.27.78 -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
COGNOS INTERNAL USE ONLY
jobstream -- start run on (this section has my server info) (31-Oct-2010 21:18:13)

DM-DBM-0402 UDA driver reported the following:

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

UDA-SQL-0107 A general exception has occurred during the operation "attach".

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

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

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

jobstream -- failed (31-Oct-2010 21:18:14)

Any help is appreciated.



FINALLY!!! After a weeks worth of research I found out what was causing my problem. I had a special character in the password that I was using to connect to the database in my RIDW (ETL) account. In my case the special character was the "@" I replaced it with "_" and now I can run RQMALL.

The link below is where I found the reference to the password special character:

http://www.developer.com/lang/other/article.php/3818216/Connecting-to-IBM-DB2-Database-Source-from-Cognos-8.htm

I hope no one else ever has to deal with this issue.
Terry

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.