Skip to Content
0
Former Member
Apr 09, 2014 at 02:29 PM

E2E BI HOUSEKEEPING Job failing due to timeout

188 Views

Hi Folks,

Reviewing our Solman system I found that some tables are getting really large, I found SMD_HASH_TABLE is over 71GB compressed. I found the note 1958979 - Solution Manager - Tablespace increase which in turn directs you to the attached document of the note 1480588 - ST: E2E Diagnostics - BI Housekeeping - Information.

Per the document, I executed TAANA transaction and ran analysis on the table and got the following data,

Per the next steps, I added the following entry in the table E2E_BI_DELETE.




the next run of the job, I got an ABAP dump with timeout.

Looks like while selecting the data for deletion, it timed out.

Has someone faced this issue and can suggest ways I can run this outside of this job one time to clean up this table. I believe the subsequent runs will be ok as long as the housekeeping job is run regularly.

regards

Yogesh

Attachments

SAP error.jpg (26.9 kB)
SAP error.jpg (26.9 kB)