Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

RTC2.0Jobs Build_star failed

Hi All,

I have configured the variables properly and trying run the build manually but its failed at "Build_Start" as below

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 4584)
JobStream Node 5 'Build_Star'; component 'Build_Star', R
unId 1, AuditId 43
pid 4584 JobStream Node 5 'Build_Star'; reported the fol
lowing:

(for details, see Job_Build_Star_0001.log)

JobStream Node 5 'Build_Star'; Executing -> Failed
JobStream Node 5 'Build_Star'; failed
RESULT = FALSE
DM_COMPONENT_AUDIT_ID = 43
Done - 0 00:02:50 elapsed
JobStream 'Loop_RTC2.0' Failed
jobstream -- failed (13-Apr-2010 10:26:43)

Press Enter to continue

*********************


Please see the logs in Job_Build_Star_0001.log

Data Manager v8.4.27.78 -- Copyright (C) 2008 Cognos ULC, an IBM Company. All rights reserved.
COGNOS INTERNAL USE ONLY
jobstream -- start run on ETLDEVMACHINE (13-Apr-2010 10:26:40)

Run context:
JobStream 'Loop_RTC2.0'
JobStream 'Build_Star'

JobStream 'Build_Star' - run id 1, audit id 43
SQL() function call

select 1 from sysibm.sysdummy1

LOOKUP() function call

VALUES( RIDW.SELECT_ETL_DATE (1, CAST('2010-04-13 10:26:42' AS TIMESTAMP),2))

JobStream 'Build_Star' Failed
jobstream -- failed (13-Apr-2010 10:26:43)

*******************************
Can any one help me whats wrong with my configuration and build?

Thanks,
Om.

0 votes



2 answers

Permanent link
I have noticed one thing here. My DB2 9.5 fixpack 4 is in AIX box and its had problem while creating the RIDW database. I have tested running the RTC build with my Test box ( DB2 9.5 fixpack 4 in Linux ) then build was success.

Can we have database in AIX to support Insight 1.0.0.2 version?

Thanks for the help in advance.

Thanks,
Om.

0 votes


Permanent link
Hi All,

I have fixed this problem by doing ML 4 upgrade at AIX os level and recreated the RIDW database with dw script. I am able to run the build success now. :D

May be some other person may face this problem so it is useful to them and save his life too.

Thanks,
Om.

0 votes

Your answer

Register or log in 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.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Apr 13 '10, 10:40 a.m.

Question was seen: 7,082 times

Last updated: Apr 13 '10, 10:40 a.m.

Confirmation Cancel Confirm