Problems running RQMALL on Datamanager 1.1
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
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
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.