RSBCS_REORG job throw dump ora-: "ORA-01555: snapshot too old: rollback segment

[Former Member]

Dear Experts,

While running RSBCS_REORG job , we are getting below ABAP DUMP:

"ORA-01555: snapshot too old: rollback segment   number 3 with name "_SYSSMU3$" too small"

please suggest....

[Former Member]

Hi Sumit,

May be what you are selecting is very huge. Try changing the variant and running it for smaller data selection.May be smalled time intervals. Your undo is not large enough to hold that much of undo data.

Regards.

Ruchit.

[Former Member]

Variant using for job is:

1000    Documents with Send Request    P		X
1000    Documents Without Send Request    P		X
1000    Specify Creation Date    P		X
1000    Specify Age (in Days)    P
1000    Age in Days    S

1000    Date created    S    I    LE    19.05.2012    00.00.0000

1000    Date created    S    I    BT    12.05.2012    12.06.2012

1000    Created by    S    I    CP    *   

1000    Document title    S

1000    Document class    S    I    EQ    RAW   

1000    Document class    S    I    EQ    OTF   

1000    Object year    S
1000    Object number    S

1000    AddrType    S    I    CP    *   

1000    StatusCode    S
1000    Expired Send Requests Only    P
1000    Max. Number of Hits    P		0
1000    Pack. Size    P		500
1000    Detailed Output    P		X
1000    Test Mode    P

[Former Member]

Hi Sumit,

What do you mean by

1000    Specify Creation Date    P		X
1000    Specify Age (in Days)    P
1000    Age in Days    S

1000    Date created    S    I    LE    19.05.2012    00.00.0000

1000    Date created    S    I    BT    12.05.2012    12.06.2012

I mean what is P and S ... Also date created is less thanequal to 19th May..That must be a lot of data. Please reduce it. Try running it for a week or so of data and see if dump occurs.

Regards.

Ruchit.