failed RQMALL job
I m running it on 2003 server 32 bit with DB2.
I m receiving this Error when i try to run the RQMALL job
jobstream -- start run on vmdevrqm02 (07-May-2010 15:24:28)
DM-DBM-0724 The CM Data Source 'RIDW (ETL)'; is unable to find the signon 'RIDW (ETL)' in the content store.
DM-LIB-0300 Error initializing variable 'ETL_DATEID' to:
GetETLDateID( $ETL_STARTTIME ).
DM-BLD-0004 JobStream 'RQMAll' is not a valid specification.
jobstream -- failed (07-May-2010 15:24:35)
I have signons in the connection, any ideas?
I m receiving this Error when i try to run the RQMALL job
jobstream -- start run on vmdevrqm02 (07-May-2010 15:24:28)
DM-DBM-0724 The CM Data Source 'RIDW (ETL)'; is unable to find the signon 'RIDW (ETL)' in the content store.
DM-LIB-0300 Error initializing variable 'ETL_DATEID' to:
GetETLDateID( $ETL_STARTTIME ).
DM-BLD-0004 JobStream 'RQMAll' is not a valid specification.
jobstream -- failed (07-May-2010 15:24:35)
I have signons in the connection, any ideas?
6 answers
Do you have Rational Insight or Rational Common Reporting (RCR - comes with RQM) installed?
This error typically means that a signon with the name RIDW (ETL) cannot be found for the data source connection RIDW (ETL). You can check your data source connection by selecting
Launch->IBM Cognos Administration -> Configuration -> Data Source Connections
Select RIDW (ETL) -> More... _> View signons
The name of the signon should be RIDW (ETL). You can set the specific user name and password properties by clicking on More... After you set the signon test the connection to ensure that it's working.
Lawrence
This error typically means that a signon with the name RIDW (ETL) cannot be found for the data source connection RIDW (ETL). You can check your data source connection by selecting
Launch->IBM Cognos Administration -> Configuration -> Data Source Connections
Select RIDW (ETL) -> More... _> View signons
The name of the signon should be RIDW (ETL). You can set the specific user name and password properties by clicking on More... After you set the signon test the connection to ensure that it's working.
Lawrence
Hi!
I have this problem too, with signon
so i remove them and add again, but now i have second problem with this job:
Data Manager v8.4.29.13 -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
COGNOS INTERNAL USE ONLY
jobstream -- start run on KFLONT (18-Jun-2010 15:33:45)
JobStream 'RQMAll'; starting
JobStream Node 2 'RQM_ODS2.0'; executing (pid 4572)
pid 4572 JobStream Node 2 'RQM_ODS2.0'; reported the following:
(for details, see Job_RQM_ODS2_0_0001_000011dc129213416574050000.log)
JobStream Node 2 'RQM_ODS2.0'; failed
Done - 0 00:02:39 elapsed
JobStream 'RQMAll' Failed
jobstream -- failed (18-Jun-2010 15:36:24)
I have this problem too, with signon
so i remove them and add again, but now i have second problem with this job:
Data Manager v8.4.29.13 -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
COGNOS INTERNAL USE ONLY
jobstream -- start run on KFLONT (18-Jun-2010 15:33:45)
JobStream 'RQMAll'; starting
JobStream Node 2 'RQM_ODS2.0'; executing (pid 4572)
pid 4572 JobStream Node 2 'RQM_ODS2.0'; reported the following:
(for details, see Job_RQM_ODS2_0_0001_000011dc129213416574050000.log)
JobStream Node 2 'RQM_ODS2.0'; failed
Done - 0 00:02:39 elapsed
JobStream 'RQMAll' Failed
jobstream -- failed (18-Jun-2010 15:36:24)
I am having a similar issue. I have RCR with SQL Server 2005 installed. I can test the connection successfully with RIDW (ETL) so theoretically I should run the 'RQMALL' data movement task and I should be able to load the RIDW.
However, when I run 'RQMALL', I get an error that says: "DME Process Failed". I check the log and it just says: "jobstream -- failed". So there is nothing useful there.
Anyone have any clues on what else I could check? I've been stumped on this for a while. I know this is the Insight forum, but cant find anything similar to this in the RQM forum.
However, when I run 'RQMALL', I get an error that says: "DME Process Failed". I check the log and it just says: "jobstream -- failed". So there is nothing useful there.
Anyone have any clues on what else I could check? I've been stumped on this for a while. I know this is the Insight forum, but cant find anything similar to this in the RQM forum.
The signon problem is likely either due to a signon with the wrong name (it needs to be 'RIDW (ETL)') or that the user does not have the appropriate permissions to write to the data warehouse. Remember, the ETL user is inserting, updating, and deleting data from the warehouse.
If your problem is with the ODBC/JDBC driver (a quick failure not due to the signon issue) you can enable more logs for the ODBC/JDBC driver.
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m0/topic/com.ibm.rational.raer.troubleshooting.doc/topics/ts_enablinglogodbc.html
Note that you will need to restart your application server before the new log preferences will be enabled.
Lawrence
If your problem is with the ODBC/JDBC driver (a quick failure not due to the signon issue) you can enable more logs for the ODBC/JDBC driver.
http://publib.boulder.ibm.com/infocenter/rentrpt/v1r0m0/topic/com.ibm.rational.raer.troubleshooting.doc/topics/ts_enablinglogodbc.html
Note that you will need to restart your application server before the new log preferences will be enabled.
Lawrence