cancel
Showing results for 
Search instead for 
Did you mean: 

/BI0/ASM_UPLLD00 grows constantly

SAPSupport
Employee
Employee
0 Kudos

table /BI0/ASM_UPLLD00 is constantly growing and I could not find any documentation how to clean it up. I used How to reduce the size of tables SACONT01 and SASA... - SAP Community  to reduce size of /BI0/ASM_UPLDD00 significantly, but it does not help with the other... 

Please advise


------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

Accepted Solutions (1)

Accepted Solutions (1)

SAPSupport
Employee
Employee
0 Kudos

Please first make sure Usage Logging housekeeping is activated by referencing following Guided Answer link:
https://gad5158842f.us2.hana.ondemand.com/dtp/viewer/#/tree/3142/actions/48298:48299:48301/?version=...

When housekeeping activated, daily background job E2E BI HOUSEKEEPING will cleanup table /BI0/ASM_UPLDD00 automatically.

In case table /BI0/ASM_UPLDD00 size still grows despite that housekeeping had already been activated,
and job E2E BI HOUSEKEEPING finishes everyday, please refer to below Guided Answer link to delete data manually:
https://gad5158842f.us2.hana.ondemand.com/dtp/viewer/#/tree/3142/actions/48298:48299/?version=curren...

Last, if there are other solution manager tables beside /BI0/ASM_UPLDD00 also growing constantly, please refer
to following KBA for more solutions:
2549260 - Certain tables in Solution Manager system grow fast

Answers (0)