cancel
Showing results for 
Search instead for 
Did you mean: 

RSBERRORLOG table grows very rapidly

Former Member
0 Kudos

Dear All,

We have installed BI 7(SAP BW path 19) with MS SQL server 2005. The table RSBERRORLOG table grows very rapidly. I have found that logs are creating each and every record in DTP process(not only for error in the record).

Please help to solve this issue.

Regards,

JP.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Dear Jp

Can u try this note it can be help u

Note 1417620

Regards

Sriram

Former Member
0 Kudos

Hi,

We reclaimed all the space running this report RSBM_ERRORLOG_DELETE. If you are running on oracle please run a online reorg on rsberrorlog.

1144400-RSBM_ERRORLOG_DELETE no frequent commits.

1095924-Correction: Deletion/analyis report for error handlign logs.

If you are on SAP_BW 701 above notes are not applicable ... you can go ahead and run report (RSBM_ERRORLOG_DELETE).

Let me know if you need more information.

Cheers...

Madhu.

Former Member
0 Kudos

Hi,

We reclaimed all the space running this report RSBM_ERRORLOG_DELETE. If you are running on oracle please run a online reorg on rsberrorlog.

1144400-RSBM_ERRORLOG_DELETE no frequent commits.

1095924-Correction: Deletion/analyis report for error handlign logs.

If you are on SAP_BW 701 above notes are not applicable ... you can go ahead and run report (RSBM_ERRORLOG_DELETE).

Let me know if you need more information.

Cheers...

Madhu.

Former Member
0 Kudos

Check these notes

Note 1083660 - Report for error stack analysis

As per above note,

Summary

Symptom

It requires a lot of time and effort to analyze which data transfer processes (DTPs) are the main cause of the contents of the table RSBERRORLOG and the error stack.

The report RSB_ANALYZE_ERRORLOG does not exist.

Other terms

RSB_ANALYZE_ERRORLOG

Reason and Prerequisites

This problem is caused by a program error.

Note 888017 - Correction: Persistence of EH data during simulation

Let us know if u have any issues.

Regards,

Ravi

Former Member
0 Kudos

Hi,

Please check this note and you shall be able to solve the issue

Note 706478 - Preventing Basis tables from increasing considerably.This note says to reffer to the Note 1095924 - Correction: Deletion/analyis report for error handling logs

I hope this may solve your Issue.

Thanks

Rishi Abrol