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

RTC2.0Jobs Build_star failed using Oracle

Questions
Tags
Users
Badges
Bruno Braga
(480●1●36●21) Jun 24 '10, 10:26 a.m.
I have configured the RTC connection and trying run the build manually but its failed at "Build_Start" as below: 


[VARIABLE   - 11:20:16] . JOB_NAME = 'RTC2.0'



[PROGRESS   - 11:20:16] JobStream 'Loop_RTC2.0' 'Loop_RTC'; starting



[INTERNAL   - 11:20:16] Start Node 1 'Start'; Idle -> Succeeded



[INTERNAL   - 11:20:16] Condition Node 4 'DataManagerOS'; Pending -> Executing



[PROGRESS   - 11:20:16] Condition Node 4 'DataManagerOS'; executing (inline)



[INTERNAL   - 11:20:16] Condition Node 4 'DataManagerOS'; Executing -> Succeeded



[PROGRESS   - 11:20:16] Condition Node 4 'DataManagerOS'; succeeded (TRUE)



[VARIABLE   - 11:20:16] RESULT = TRUE



[INTERNAL   - 11:20:16] Procedure Node 3 'UnixDM'; Idle -> Suspended



[INTERNAL   - 11:20:16] Procedure Node 2 'WindowsDM'; Idle -> Executing



[PROGRESS   - 11:20:16] Procedure Node 2 'WindowsDM'; executing (inline)



[INTERNAL   - 11:20:18] Procedure Node 2 'WindowsDM'; Executing -> Succeeded



[PROGRESS   - 11:20:18] Procedure Node 2 'WindowsDM'; succeeded



[VARIABLE   - 11:20:18] RESULT = TRUE



[INTERNAL   - 11:20:18] JobStream Node 5 'Build_Star'; Pending -> Executing



[INTERNAL   - 11:20:18] JobStream Node 5 'Build_Star'; initializing



[PROGRESS   - 11:20:18] JobStream Node 5 'Build_Star'; executing (pid 4696)



[DETAIL     - 11:20:19] JobStream Node 5 'Build_Star'; component 'Build_Star', RunId 6, AuditId 109



[PROGRESS   - 11:20:24] pid 4696 JobStream Node 5 'Build_Star'; reported the following:







(for details, see Job_Build_Star_0006.log)







[INTERNAL   - 11:20:24] JobStream Node 5 'Build_Star'; Executing -> Failed



[PROGRESS   - 11:20:24] JobStream Node 5 'Build_Star'; failed



[VARIABLE   - 11:20:24] RESULT = FALSE



[VARIABLE   - 11:20:24] DM_COMPONENT_AUDIT_ID = 109



[PROGRESS   - 11:20:25] Done - 0 00:00:10 elapsed



[PROGRESS   - 11:20:25] JobStream 'Loop_RTC2.0' Failed



jobstream -- failed (24-Jun-2010 11:20:25)




Run context:



JobStream 'Loop_RTC2.0'



	JobStream 'Build_Star'







[PROGRESS   - 11:20:19] JobStream 'Build_Star' - run id 6, audit id 109



[SQL        - 11:20:19] SQL() function call







select 1 from sysibm.sysdummy1







[SQL        - 11:20:19] SQL() function call







select 1







[SQL        - 11:20:19] SQL() function call







declare var integer; begin select 1 into var from dual; end;







[SQL        - 11:20:19] LOOKUP() function call







SELECT RIDW.SELECT_ETL_DATE (1,TO_TIMESTAMP('2010-06-24 11:20:19','YYYY-MM-DD HH24:MI:SS.FF6'),2) FROM DUAL







[SQL        - 11:20:20] LOOKUP() function call







SELECT MAX(PERIOD_START_DATE) FROM RIDW.D_DATE







[SQL        - 11:20:20] SQL() function call







select 1 from sysibm.sysdummy1







[SQL        - 11:20:20] SQL() function call







select 1







[SQL        - 11:20:20] SQL() function call







declare var integer; begin select 1 into var from dual; end;







[SQL        - 11:20:20] LOOKUP() function call







SELECT DATE_ID FROM RIDW.D_DATE WHERE PERIOD_START_DATE=TO_DATE('2012-06-24 00:00:00','yyyy-mm-dd hh24:mi:ss')







[PROGRESS   - 11:20:20] JobStream 'Build_Star'; starting



[PROGRESS   - 11:20:20] Condition Node 22 'isDB2:3'; executing (inline)



[PROGRESS   - 11:20:21] Condition Node 22 'isDB2:3'; succeeded (FALSE)



[PROGRESS   - 11:20:21] Condition Node 23 'isOracle:3'; executing (inline)



[PROGRESS   - 11:20:21] Condition Node 23 'isOracle:3'; succeeded (TRUE)



[PROGRESS   - 11:20:21] SQL Node 21 'ODS_Statistics_Oracle'; executing (inline)



[PROGRESS   - 11:20:24] SQL Node 21 'ODS_Statistics_Oracle'; reported the following:







ANALYZE TABLE "RIODS".TEMP_BASELINE COMPUTE STATISTICS FOR TABLE FOR ALL INDEXES FOR ALL INDEXED COLUMNS







[PROGRESS   - 11:20:24] SQL Node 21 'ODS_Statistics_Oracle'; reported the following:







DM-DBM-0400 UDA driver reported the following on connection Rational Data Warehouse:







UDA-SQL-0107 A general exception has occurred during the operation "execute immediate".







ORA-00942: a tabela ou view no existe















[PROGRESS   - 11:20:24] SQL Node 21 'ODS_Statistics_Oracle'; failed



[PROGRESS   - 11:20:24] Done - 0 00:00:06 elapsed



[PROGRESS   - 11:20:24] JobStream 'Build_Star' Failed



jobstream -- failed (24-Jun-2010 11:20:24)


"RIODS".TEMP_BASELINE table or view doesn't exits
How can I fix that?

0 votes

1 answer
5,541 views
0 votes

One answer

Permanent link
Xiang Dong Hu
JAZZ DEVELOPER (76●2) Jul 13 '10, 10:16 p.m.
Please make sure your data warehouse installed appropriately, and make sure you are using ETL catalog and data warehouse from same Insight version.
If you do customize the data warehouse, please do not delete anything provided by Insight out of the box.

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.

Ask a question
Guidelines
FAQ
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: Jun 24 '10, 10:26 a.m.

Question was seen: 5,541 times

Last updated: Jun 24 '10, 10:26 a.m.

Confirmation Cancel Confirm