RTC ETL failing with no errors
I'm running the Loop_RTC2.0.0.2 ETL on a few test RTC databases. For one database it completes successfully, but if I try to use a different database source (by updating the 'Rational Team Concert' connection) it fails with little information to help understand the problem.
The failure references Job_RTC_ODS2_0_0_2_0041.log.
Since this references Build_RTC_Contributor_0041.log, I also checked this.
Neither of these have valuable information that will help me debug or understand why my ETL is failing. I would appreciate any thoughts or help others can give on how to understand what's wrong. I was able to test the database connection via DB2 and also via the data manager connection, so I can't see anything that's obviously wrong.
The failure references Job_RTC_ODS2_0_0_2_0041.log.
Run context:
JobStream 'RTC2.0.0.2'
JobStream 'RTC_ODS2.0.0.2'
JobStream 'RTC_ODS2.0.0.2' - run id 41, audit id 1113
JobStream 'RTC_ODS2.0.0.2' 'RTC_ODS'; starting
Build Node 2 'RTC_Contributor'; executing (pid 1192)
pid 1192 Build Node 2 'RTC_Contributor'; reported the fo
llowing:
(for details, see Build_RTC_Contributor_0041.log)
Build Node 2 'RTC_Contributor'; failed
Done - 0 00:00:02 elapsed
JobStream 'RTC_ODS2.0.0.2' Failed
jobstream -- failed (16-Dec-2010 16:01:32)
Since this references Build_RTC_Contributor_0041.log, I also checked this.
Run context:
JobStream 'RTC2.0.0.2'
JobStream 'RTC_ODS2.0.0.2'
Build 'RTC_Contributor'
Build 'RTC_Contributor' - run id 41, audit id 1114
Fact Build 'RTC_Contributor'
Validating Build Specification
Build 'RTC_Contributor' Failed
databuild -- failed (16-Dec-2010 16:01:32)
Neither of these have valuable information that will help me debug or understand why my ETL is failing. I would appreciate any thoughts or help others can give on how to understand what's wrong. I was able to test the database connection via DB2 and also via the data manager connection, so I can't see anything that's obviously wrong.
4 answers
Thanks Lawrence. That did help somewhat. I was able to better narrow down where in the process the error came from, but the logs were still not that beneficial in debugging.
For example, this came from Build_RTC_Build_0018.log:
It helped me understand that something was wrong in RTC_Build, but didn't really help with what. I'm trying to get the DeltaLoad working for RTC, and obviously what I've added isn't working!
Thanks for the information though, it does help understand where to look.
For example, this came from Build_RTC_Build_0018.log:
Run context:
JobStream 'RTC2.0.0.2'
JobStream 'RTC_ODS2.0.0.2'
Build 'RTC_Build'
Build 'RTC_Build' - run id 18, audit id 1604
SQL() function call
select 1 from sysibm.sysdummy1
SQL() function call
select 1 from sysibm.sysdummy1
SQL() function call
select 1 from sysibm.sysdummy1
SQL() function call
select 1 from sysibm.sysdummy1
SQL() function call
select 1 from sysibm.sysdummy1
Build 'RTC_Build' Failed
databuild -- failed (05-Jan-2011 11:37:57)
It helped me understand that something was wrong in RTC_Build, but didn't really help with what. I'm trying to get the DeltaLoad working for RTC, and obviously what I've added isn't working!
Thanks for the information though, it does help understand where to look.
Hi, have you solved your problem? how?
I am getting similar issue and wanted to know how you fixed yours. Thanks
Hi, sadly I did not solve this problem. I have written a PMR for this, but so far there is no resolution.
My only solution was to write a separate job that scans the Insight logs that are generated from the ETL to look for the string 'databuild -- failed' and send an email message to my administrators warning that there is an error that should be investigated.