E2E BI HOUSEKEEPING Job failing due to timeout

[Former Member]

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

[christoph_ostrop]

https://me.sap.com/notes/2053261

https://me.sap.com/notes/3144142

[paulcrauwels]

Hello Yogesh,

I experience exactly the same issue. Can you share the solution if you resolved this?

Thank you,

Paul.