It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×1,230

question asked: Dec 16 '10, 5:24 p.m.
question was seen: 5,634 times
last updated: Dec 16 '10, 5:24 p.m.

Related questions

RTC ETL failing with no errors

0
Jackie Albert (1.6k●1●49●47) | asked Dec 16 '10, 5:24 p.m.
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.
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

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Lawrence Mandel (511●2●1) | answered Dec 17 '10, 4:35 p.m.
FORUM MODERATOR
Hi Jackie,

Have you seen this post that I made back in Oct. with details on getting more trace information from DM jobs?

http://jazz.net/forums/viewtopic.php?t=13212
0
permanent link
Jackie Albert (1.6k●1●49●47) | answered Jan 05 '11, 12:52 p.m.
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:
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.
0
permanent link
Victoria Zambrano (16●3●2) | answered Sep 14 '11, 3:11 p.m.
Hi, have you solved your problem? how?
I am getting similar issue and wanted to know how you fixed yours. Thanks
0
permanent link
Jackie Albert (1.6k●1●49●47) | answered Sep 14 '11, 3:19 p.m.
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.

Your answer

Register or to post 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.