Currently even i am using it and have not gained much of the experience on it...

I have also been having a hard time with it and I have read over the post but am still not getting it to work...any other info on it.

Thanks for your help :lol:

John

Hi Marc,

Thank you, I'll use the Loop_RTC2.0 job.

Well, the Job F_REQUEST_CREATION_DATE_METRICS runs successfully here. Try to execute it with detailed trace in Data Manager client.

Regards,
Paulo

Now I'm using the Loop_RTC2.0 job to load RTC data into Insight, I just had to made the following adjustments:

- Change the DMCATUSR, DMCATPASSWD, DMCATDRIVER and DMCATDB variables values in the Loop_RTC2.0 job stream to match my Data Manager catalog database connection information.

- In the RTC2.0 job stream I added a variable named RESOURCE_GROUP_ID with the value 'RTC' and as our RTC uses an Oracle database I also had to define in the User variable in RTC2.0 the name of the database user that corresponds to the Schema where the RTC tables are located.

Paulo

I haven't been able to find any documentation that states which variables are needed for each of the ETL jobs - has anyone else? I made similar updates for my RTC job, but now in Insight 1.0.1 I'm having trouble getting my RQM job to run, and I'm wondering if it's due to some missing variables or other similar setup.

Hi Paulo,
I tried to set following the previous steps, but when I try to run RTC2.0 it does not work.

I tried to configure using Loop_RTC2.0, and the error still persists in RTC2.0.
Following is the log of the implementation of Loop_RTC2.0 for analysis.

*** LOG *******************************************
Data Manager v8.4.27.78 -- Copyright (C) 2008 Cognos ULC, an IBM Company. All ri
ghts reserved.
COGNOS INTERNAL USE ONLY
jobstream -- start run on bmibmx08 (24-Jan-2011 16:31:15)
DS_LOB_MAXMEM_SIZE = '65536'
DS_LOB_BUF_SIZE = '8000'
DS_DBMS_TRIM = 'SPACE'
DS_UDA_FETCH_ROWS = '50'
DS_UDA_BULKWRITE_ROWS = '50'
DS_RUN_TIMESTAMP = 2011-01-24 16:31:16
DS_JOBSTREAM_NAME = 'Loop_RTC2.0'
DS_JOBSTREAM_FNAME = 'Loop_RTC2_0'
DS_AUDIT_ID = 1767
DS_JOB_AUDIT_ID = 1767
DS_RUN_ID = 4
DS_LOG_DIR = 'C:\IBM\Rational Insight\cognos\datamanager
\log'
DS_LOG_NAME = 'C:\IBM\Rational Insight\cognos\datamanage
r\log\Job_Loop_RTC2_0_0004.log'
DS_MAX_RECURSION = '100'
. TRACE_VALUES = 'PROGRESS,DETAIL,INTERNAL,SQL,EXECUTEDS
QL,USER,VARIABLE'
. AUDIT_VALUES = 'TIMING,ALERT,USER'
. DM_OS = 'WIN32'
. DMCATUSR = 'rtcrpc05'
. DMCATPASSWD = '*************'
. DMCATDRIVER = 'DB2'
. DMCATDB = 'RTCRPC05'
. SQLSERVINST = ''
. WINAUTH = FALSE
. DMCATCONSTR = 'DB2 DSN=RTCRPC05;UID=rtcrpc05;PWD=ratio
nal_rtcrpc'
. JOB_NAME = 'RTC2.0'
JobStream 'Loop_RTC2.0' 'Loop_RTC'; starting
Start Node 1 'Start'; Idle -> Succeeded
Condition Node 4 'DataManagerOS'; Pending -> Executing
Condition Node 4 'DataManagerOS'; executing (inline)
Condition Node 4 'DataManagerOS'; Executing -> Succeeded

Condition Node 4 'DataManagerOS'; succeeded (TRUE)
RESULT = TRUE
Procedure Node 3 'UnixDM'; Idle -> Suspended
Procedure Node 2 'WindowsDM'; Idle -> Executing
Procedure Node 2 'WindowsDM'; executing (inline)
Data Manager v8.4.27.78 -- Copyright (C) 2008 Cognos ULC, an IBM Company. All ri
ghts reserved.
Catalog Export -- start run on bmibmx08 (24-Jan-2011 16:31:17)
Catalog Export -- completed (24-Jan-2011 16:31:18)
Data Manager v8.4.27.78 -- Copyright (C) 2008 Cognos ULC, an IBM Company. All ri
ghts reserved.
COGNOS INTERNAL USE ONLY
jobstream -- start run on bmibmx08 (24-Jan-2011 16:31:19)
JobStream 'RTC2.0'; starting
SQL Node 32 'CleanUp'; executing (inline)
SQL Node 32 'CleanUp'; succeeded
JobStream Node 29 'RTC_ODS2'; executing (pid 5192)
pid 5192 JobStream Node 29 'RTC_ODS2'; reported the foll
owing:

(for details, see Job_RTC_ODS2_0002.log)

JobStream Node 29 'RTC_ODS2'; failed
Done - 0 00:00:10 elapsed
JobStream 'RTC2.0' Failed
jobstream -- failed (24-Jan-2011 16:31:29)
Procedure Node 2 'WindowsDM'; Executing -> Succeeded
Procedure Node 2 'WindowsDM'; succeeded
RESULT = TRUE
JobStream Node 5 'Build_Star'; Pending -> Executing
JobStream Node 5 'Build_Star'; initializing
JobStream Node 5 'Build_Star'; executing (pid 5664)
JobStream Node 5 'Build_Star'; component 'Build_Star', R
unId 7, AuditId 1768
JobStream Node 5 'Build_Star'; Executing -> Succeeded
JobStream Node 5 'Build_Star'; succeeded
RESULT = TRUE
DM_COMPONENT_AUDIT_ID = 1768
Done - 0 00:13:05 elapsed
jobstream -- completed (24-Jan-2011 16:44:20)

*** EXIT LOG **********************************************

Now I'm using the Loop_RTC2.0 job to load RTC data into Insight, I just had to made the following adjustments:

- Change the DMCATUSR, DMCATPASSWD, DMCATDRIVER and DMCATDB variables values in the Loop_RTC2.0 job stream to match my Data Manager catalog database connection information.

- In the RTC2.0 job stream I added a variable named RESOURCE_GROUP_ID with the value 'RTC' and as our RTC uses an Oracle database I also had to define in the User variable in RTC2.0 the name of the database user that corresponds to the Schema where the RTC tables are located.

Paulo