AnsweredAssumed Answered

Datamart rollup job failing

Question asked by DCuthbert on Jan 7, 2010
Latest reply on Jan 19, 2010 by another_martink
Hi all,  I'm currently having problems (in Clarity 7.5.3 FP3) with the Datamart Rollup job failing, has anyone encountered something similar? This is the error i'm getting:  This scheduled job failed. Datamart Rollup - Time Facts and Time Summary
Job: Datamart Rollup - Time Facts and Time Summary
Run ID: 6703147
Scheduler ID: bg@wlsprdappw001
Failed - Message: java.sql.SQLException: ORA-20000: Error in CMN_JOB_DATAMART_ROLLUP_SP - ORA-20000: Error in NBI_EXTRACT_TF_TS_SP - Rolling up NBI_RESOURCE_TIME_SUMMARY: ORA-20000: Error in NBI_RESOURCE_TIME_SUMMARY - Building string of weeks that need to be rolled up again: ORA-20000: Error in NBI_GET_ROLLUP_TIME_INFO_SP - Building string of weeks that need to be rolled up again: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "CLARITY.CMN_JOB_DATAMART_ROLLUP_SP", line 11
ORA-06512: at line 1  Thanks  Dave

Outcomes