INSIGHT:RTC_WorkitemStateHistory3 ETL Job Freezing Problem
Hi,
I started OOTBE2E job for first data collection but it frozen on the RTC_WorkitemStateHistory3 fact build.
I try to run sql query in this build, and it also frozen.
I have found the following message in data manager log;
Data Manager v10.1.6235.143 -- (C) Copyright IBM Corp. 1999, 2011
COGNOS INTERNAL USE ONLY
databuild -- start run on OPCRINSIGHT.kfs.local (09-Oct-2012 01:10:05)
Run context:
JobStream 'OOTBE2E'
JobStream 'CLM3.0.1.3_All'
JobStream 'RTC_ODS3.0.1.2_DeltaLoad'
JobStream 'RTC_ODS3.0.1.2'
JobStream 'RTC_Workitem3.0.1.2'
JobStream 'RTC_WorkitemHistory3.0.1.2'
Build 'RTC_WorkitemStateHistory3'
[PROGRESS - 01:10:06] Fact Build 'RTC_WorkitemStateHistory3'
[PROGRESS - 01:10:06] Parsing Reference Definition
[PROGRESS - 01:10:06] Validating Build Specification
[PROGRESS - 01:10:07] Checking Fact Data existence
I started OOTBE2E job for first data collection but it frozen on the RTC_WorkitemStateHistory3 fact build.
I try to run sql query in this build, and it also frozen.
I have found the following message in data manager log;
Data Manager v10.1.6235.143 -- (C) Copyright IBM Corp. 1999, 2011
COGNOS INTERNAL USE ONLY
databuild -- start run on OPCRINSIGHT.kfs.local (09-Oct-2012 01:10:05)
Run context:
JobStream 'OOTBE2E'
JobStream 'CLM3.0.1.3_All'
JobStream 'RTC_ODS3.0.1.2_DeltaLoad'
JobStream 'RTC_ODS3.0.1.2'
JobStream 'RTC_Workitem3.0.1.2'
JobStream 'RTC_WorkitemHistory3.0.1.2'
Build 'RTC_WorkitemStateHistory3'
[PROGRESS - 01:10:06] Fact Build 'RTC_WorkitemStateHistory3'
[PROGRESS - 01:10:06] Parsing Reference Definition
[PROGRESS - 01:10:06] Validating Build Specification
[PROGRESS - 01:10:07] Checking Fact Data existence