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

[pawan_amarnani]

Hello,

Checked the notes, nothing found relevant or don't know whether they are helpful or not.

I am getting error while triggering select query for table D345T on column "BLOCK".

Can any one please enlighten me about the table D345T? what is this table for?

Can I delete table D345T data? what would be the effect on system?

Regards,

[former_member182657]

Hi,

Could you check with SAP KBA's   1828574 - Data Services loading Oracle table results in error: ORA-01555 Snapshot Too Old

  1221694 - Oracle error messages during consolidation (ORA-01555 and ORA-30036)

Hope this will help you.

Regards,

[yakcinar]

Hello Pavan,

Check below notes.

185822 - ora-1555 - cause and action

3807 - Error messages regarding rollback and undo segments

Regards,

Yuksel AKCINAR