It's all about the answers!

Ask a question

Problems running RQMALL on Datamanager 1.1


Chad Smith (21164) | asked Mar 14 '12, 5:02 p.m.
I have data manager running on a win 2003 machine. I can successfully run certain ETL's but I cannot run the RQMALL etl I get the following error. I have verified the XML data config and I can open the URL in IE. Any Ideas on how to resolve this issue


Data Manager v10.1.6235.143 -- (C) Copyright IBM Corp. 1999, 2011
jobstream -- start run on win2k3-agent.rtp.raleigh.ibm.com (14-Mar-2012 16:30:36
)
Accessing catalog
Exporting required components
Catalog banner -> COGNOS INTERNAL USE ONLY

DM-DBM-0400 UDA driver reported the following on connection Rational Data Wareho
use:

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

SQL0440N No authorized routine named "SELECT_
ETL_DATE" of type "FUNCTION" having compatible arguments was found. SQLSTATE=42
884



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

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

jobstream -- failed (14-Mar-2012 16:31:19)

Press Enter to continue

One answer



permanent link
Peter Haumer (2.2k12019) | answered Mar 15 '12, 4:41 p.m.
JAZZ DEVELOPER
Hello.
Is this for RQM 2.x? In Insight 1.1 there is no RQMALL job in the ootb
catalog. For 2.0.1.1 you would run Jobs > RQMJobs >
RQM_ODS2.0.1.1_DeltaLoad. For RQM 3.0.1.x you would run the respective
job listing the 3.x version number that is equal or smaller than your
current release version of RQM.

Best regards,
Peter Haumer.

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.