error while accessign tcode SM50/SM66

[pawan_amarnani]

Hello,

My session gets terminated while executing tcode SM50/SM66.

I recently installed ECC6-EHP7 on linux suse with DB Oracle.

While checking the system logs, it's showing below error ==>

Database error 1555 with SEL access to table D345T

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

ORA-22924: snapshot too old

I checked the table contents, showing the above error, and displayed only 205 rows, while there are total 211 rows.

Please help me.

Thanks,

Pavan

[manumohandas82]

Hi Pawan ,

There should be dumps in transaction ST22 , If there are post the same

Thanks ,

Manu

[pawan_amarnani]

hello,

The problem is with table d345t with column name BLOCK(data type CLOB).

Select query gives error while selecting this field only. After fetching 217 rows, it throws error :

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

ORA-22924: snapshot too old

Please help me on resolving this issue.

Regards

[former_member182657]

Hi Pawan,

I understand that you're facing an issue ORA-01555 for table D345t,for the resolution i've already shared SAP Note 185822 - ora-1555 - cause and action

and sure by following the note your issue will get resolved.Additionally check for table space sizes at your end (specially for UNDO table space ),if required you could extend table space.

Hope this will resolve your issue.

Good luck !!

[former_member182657]

Addition to above also refer SAP Note  113857 - ORA-1555 during table conversions

Regards,

[former_member182657]

Hi Pawan,

Could you please refer SAP Note  185822 - ora-1555 - cause and action

Regards,