RSBERRORLOG cleanup

[former_member199694]

hi,

RSBERRORLOG table has 250 millions of entries, when checked in oracle level. Is it possible to find count based on months?However, could not see any date field in the table. Also, RSBM_ERRORLOG_DELETE do not see records to delete except for few months. This is APO system with SCM 5 - SPS 16. SAP-BW is level 21. I do see couple of fixes, may not match this issue.

Thanks,

Raj S

[former_member21257 · Accepted solution]

Hi Raj,

After you run report RSB_ANALYZE_ERRORLOG, you will learn which DTP creates the most erroneous records in table RSBERRORLOG. So you should resolve the DTP error accordingly to avoid table RSBERRORLOG increasing.

You should run RSB_ANALYZE_ERRORLOG monthly (always in background mode) & thus you can keep an eye on it more regularly.

To improve the performance for RSBM_ERRORLOG_DELETE, please check and apply SAP Note 1453036.

If you want to delete the entire content of RSBERRORLOG, you can always use SE14 -> drop table. However, this will remove all datasets detected by the DTP errorhandler. If you can afford to lose this information, then use SE14 to delete the table.

Rgds,

Colum

[Former Member]

Hello,

you can use report RSB_ANALYZE_ERRORLOG for analyzing the error log. I'm not sure though ig this meets your requirements.

If you want to see the timestamp on db level you have to join table rsberrorlog with table rsbkrequest (RSBERRORLOG-REQUEST with RSBKREQUEST-REQUID). rsbkrequest contains the timestamps for the requests. The join might be expensive and you have to extract the month from the timestamp.

Best regards,

Ralf