Running the ETL Job RQMALL- Failure on DB2
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.
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
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