Analytics Software

Hello all,

I hope someone can help me on this.
I have installed eBS 11.5.10.2 (including the vision database) & BIA 7.9.3 & OIEE10.1.3.3.1.

Now I started the dac client and started the complete oracle 11.5.10.
Now it fails at the 177th job.
I think it has something to do with the tablespace or something, but don't know what (it is big enough)

It fails on: SDE_ORA_GLJournals and on TASK_GROUP_Extract_EmployeeEventFact and on SDA_ORA_Per_Assg_For_PayrollFact

When I look in the log file of the GLJournals I see the following:
WRITER_1_*_1> WRT_8161
TARGET BASED COMMIT POINT Tue Apr 08 20:19:24 2008
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 560560 Applied: 560560 Rejected: 0 Affected: 560560

WRT_8036 Target: W_ORA_GLRF_DERV_F_TMP (Instance Name: [W_ORA_GLRF_DERV_F_TMP])
WRT_8044 No data loaded for this target


WRITER_1_*_1> WRT_8161
TARGET BASED COMMIT POINT Tue Apr 08 20:19:29 2008
===================================================

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 570752 Applied: 570752 Rejected: 0 Affected: 570752

WRT_8036 Target: W_ORA_GLRF_DERV_F_TMP (Instance Name: [W_ORA_GLRF_DERV_F_TMP])
WRT_8044 No data loaded for this target


WRITER_1_*_1> Tue Apr 08 20:19:30 2008
WRITER_1_*_1> CMN_1022 Database driver error...
CMN_1022 [ ORA-02478: merge into base segment would overflow MAXEXTENTS limit
Database driver error... Function Name : Commit]
WRITER_1_*_1> Tue Apr 08 20:19:30 2008
WRITER_1_*_1> WRT_8024 ERROR doing COMMIT in Writer [
TARGET BASED COMMIT POINT Tue Apr 08 20:19:30 2008
===================================================
]. Writer terminating.
WRITER_1_*_1> WRT_8328 The rollback is issued due to failed commit
WRITER_1_*_1> WRT_8331 Rollback statistics:
WRT_8162 ===================================================
WRT_8330 Rolled back [0] inserted, [0] deleted, [0] updated rows for the target [W_ORA_GL_JOURNALS_F_TMP]

WRT_8330 Rolled back [0] inserted, [0] deleted, [0] updated rows for the target [W_ORA_GLRF_DERV_F_TMP]



WRITER_1_*_1> WRT_8333 Rolling back all the targets due to fatal session error.
WRITER_1_*_1> WRT_8325 Final rollback executed for the target [W_ORA_GL_JOURNALS_F_TMP, W_ORA_GLRF_DERV_F_TMP] at end of load
WRITER_1_*_1> WRT_8035 Load complete time: Tue Apr 08 20:19:30 2008

LOAD SUMMARY
============

WRT_8036 Target: W_ORA_GL_JOURNALS_F_TMP (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
WRT_8038 Inserted rows - Requested: 570752 Applied: 570752 Rejected: 0 Affected: 570752

WRT_8036 Target: W_ORA_GLRF_DERV_F_TMP (Instance Name: [W_ORA_GLRF_DERV_F_TMP])
WRT_8044 No data loaded for this target



WRITER_1__1> WRT_8043 ****END LOAD SESSION*****
WRITER_1_*_1> Tue Apr 08 20:19:30 2008
WRITER_1_*_1> WRT_8076 Writer run terminated. [Commit Error]
TRANSF_1_1_1> Tue Apr 08 20:19:30 2008
TRANSF_1_1_1> TM_6085 The transformation [W_ORA_GL_JOURNALS_F_TMP] encountered fatal error. Terminating session.
TRANSF_1_1_1> Tue Apr 08 20:19:30 2008
TRANSF_1_1_1> TM_6085 The transformation [EXP_GL_JOURNALS_KEY_ID] encountered fatal error. Terminating session.
TRANSF_1_1_1> Tue Apr 08 20:19:30 2008
TRANSF_1_1_1> TM_6085 The transformation [EXP_GL_JOURNALS_KEY_ID] encountered fatal error. Terminating session.
TRANSF_1_1_1> Tue Apr 08 20:19:30 2008
TRANSF_1_1_1> TM_6085 The transformation [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] encountered fatal error. Terminating session.
TRANSF_1_1_1> Tue Apr 08 20:19:30 2008
TRANSF_1_1_1> TM_6085 The transformation [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] encountered fatal error. Terminating session.
TRANSF_1_1_1> Tue Apr 08 20:19:30 2008
TRANSF_1_1_1> TM_6085 The transformation [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] encountered fatal error. Terminating session.
TRANSF_1_1_1> DBG_21511 TE: Fatal Transformation Error.
MASTER> PETL_24020

***** RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****
MASTER> PETL_24018 Thread [READER_1_1_1] created for the read stage of partition point [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] has completed: Total Run Time = [233.734375] secs, Total Idle Time = [58.968750] secs, Busy Percentage = [74.771041].
MASTER> PETL_24019 Thread [TRANSF_1_1_1] created for the transformation stage of partition point [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES] has completed: Total Run Time = [91.875000] secs, Total Idle Time = [27.062500] secs, Busy Percentage = [70.544218].
MASTER> PETL_24022 Thread [WRITER_1_*_1] created for the write stage of partition point(s) [W_ORA_GL_JOURNALS_F_TMP, W_ORA_GLRF_DERV_F_TMP] has completed: Total Run Time = [173.703125] secs, Total Idle Time = [129.343750] secs, Busy Percentage = [25.537465].
MASTER> PETL_24021 ***** END RUN INFO *****

MASTER> PETL_24005 Starting post-session tasks.
MASTER> PETL_24029 Post-session task completed successfully.
MAPPING> TM_6020 Session [SDE_ORA_GLJournals_Full] completed at [Tue Apr 08 20:19:31 2008]
MAPPING> TM_6018 Session [SDE_ORA_GLJournals_Full] run completed with [0] row transformation errors.
MAPPING> TM_6022

SESSION LOAD SUMMARY
================================================

MAPPING> TM_6252 Source Load Summary.
MAPPING> CMN_1740 Table: [SQ_GL_JE_LINES] (Instance Name: [mplt_BC_ORA_GLXactsJournalsExtract.SQ_GL_JE_LINES])
Output Rows [584928], Affected Rows [584928], Applied Rows [584928], Rejected Rows [0]
MAPPING> TM_6253 Target Load Summary.
MAPPING> CMN_1740 Table: [W_ORA_GL_JOURNALS_F_TMP] (Instance Name: [W_ORA_GL_JOURNALS_F_TMP])
Output Rows [570752], Affected Rows [570752], Applied Rows [570752], Rejected Rows [0]
MAPPING> CMN_1740 Table: [W_ORA_GLRF_DERV_F_TMP] (Instance Name: [W_ORA_GLRF_DERV_F_TMP])
Output Rows [0], Affected Rows [0], Applied Rows [0], Rejected Rows [0]
MAPPING> TM_6023
===================================================

MASTER> PETL_24002 Parallel Pipeline Engine finished.
MASTER> PETL_24013 Session run completed with failure.





Hope anyone can help me on this!