It's all about the answers!

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

×1,235

question asked: Jun 24 '10, 10:26 a.m.
question was seen: 5,362 times
last updated: Jun 24 '10, 10:26 a.m.

Related questions

RTC2.0Jobs Build_star failed using Oracle

0
Bruno Braga (480●1●36●21) | asked 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?

One answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Xiang Dong Hu (76●2) | answered Jul 13 '10, 10:16 p.m.
JAZZ DEVELOPER
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.

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.