Data load error

[Former Member]

hi friends,

While loading the full load from 1st level DSO to 2nd level Dso i got below error.

ORA-01555: snapshot too old: rollback segment number 46 with name "_SYSSMU46$" too small

pleae advice me what is the action to be taken

Thanks and Regards

pedamarla

[Former Member · Accepted solution]

Hi,

ORA dumps are usually related to database issues.

Please contact your Basis team regarding it.

Further, you can check the following links also:

Hope this helps...

[Former Member]

Hi,

It might be issue with DB. Can you please mention your entire error, so that we can analyse and will put solutions.

Reg

Pra

[Former Member]

only thse two messages are diplaying in the log for failed load

@5C@ ORA-01555: snapshot too old: rollback segment number 46 with name "_SYSSMU46$" too small @35@

@5C@ Error while extracting from source EPUD0001 (type DataStore) @35@

Thanks and Regards

pedamarla

[Former Member]

Hi,

Chk the long text in the error or the detailed description in the process ing tab of each failed data packet....

In addition to that chk these note:

Note 60233 - Oracle rollback segments, more information.

--

rgds,

[Former Member]

Hi,

I guess this is memory issue. As you are saying full load make sure that less number of parallel jobs run during this load. This may be due to the lack of sufficient memory..check up with ur basis team.

Regards

vamsi