Skip to Content
Author's profile photo Martin Grob

Create #SAP #BW Housekeeping task list

Applies to SAP BW 7.31

This document describes how you install the housekeeping task list for BW systems.

If you are on SAP NW BW 7.31 SPS8 you can go straight to Tx STC01 step.

A lot of so called “housekeeping” task are done manually now or in processchains like repair indexes and cleanup statistical data. SAP has delivered a task list that can handle things like that.

The Housekeeping task list can assist you with the following tasks:
  • Repairs indices on InfoCube fact table(s) at the Data Dictionary level
  • Re-assign requests written into the incorrect PSA partition
  • Ensure request consistencies throughout the PSA landscape
  • Ensure partitioned tables are correctly indexed for the PSA
  • Verify DataSource segments assignment to PSA
  • Checks BW metadata with regard to the DDIC
  • Deletes the entries that are no longer required in table RSIXW
  • Reorganize and delete bookmark IDs and view IDs
  • This program deletes RSTT traces
  • This program deletes BW statistical data
  • Delete Aggregate data via deactivation
  • Clear all OLAP Cache parameters
 

How do you implement the list?

First things first: Read Note 1829728.
“This note contains the necessary coding required for the SAP_BW_HOUSEKEEPING task list
creation. This task list can be used to facilitate some of the BW system’s
routine housekeeping activities and should be run on a regular basis.”
You need your SAP Basis help for this implementation!
1) First follow the document attached in the note called PCAI_Guide.pdf. This is a basis task.
 
2) Once done with this you need to install Report ZNOTE_1829728_PRE.TXT. Create the program ZNOTE_1829728_PRE
and copy/paste the code from the note or from my attachment. (If you have an OSS account you might want to get it from the note to have the most recent one)
3) In the attributes Pop-up please enter description and ‘Executable program’ as type.
 
4) Execute now the PRE steps.
ZNOTE_1829728_PRE.png
Choose your transport layer and do an update.
Use the same transport request as for the rest of the manual activities and the corrections of this note. You don’t need to transport the programs you have just created, but the objects, which were generated by the report.
    
Now create the post report ZNOTE_1829728_POST_70X or ZNOTE_1829728_POST_73X depending on your
release. Proceed the same way as above.
Execute it in testrun. If you get an error the note – or one of the prerequisites have not been done. 
ZNOTE_1829728_PRE_B.png
From the Note:
“The program will automatically create several objects like Package, Function Group, Error messages, Task lists and will prompt you for a transport request. Please use the same transport request as for the rest of the manual activities and the corrections of the note. “
Make sure all changes are collected on the same transport.
Once installed go into Tx STC01
Task Manager for Technical Configuration_2013-09-13_15-37-53.png
 
The task list is called SAP_BW_HOUSEKEEPING
   
Select the steps you want to execute. Most of them only run in background mode due to their long run time. You can schedule the housekeeping items on periodic basis.  Most of the task can also be run in a check mode only.
ZZ.png
Each step is explained when you click on the document icon at the end. A couple steps are Repair related while others are for Cleanup purposes.
All in all a great tool to fix some of the db related issues that keep happening in a BW environment. The same applies for all cleanup steps that BW needs!
EDIT: You can also refer to the new SAP Guidance on Housekeeping that came out SAP First Guidance – BW Housekeeping and BW-PCA or to SAP NetWeaver BW Application Lifecycle Manageme… | SCN

Assigned tags

      51 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Thanks for sharing such nice document for BW Housekeeping, Also I am expecting documentation relevant BASIS Housekeeping for BW.

      Regards,

      Sushant 

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Hi

      Thanks for your comment I will think about creating one for basis tasks.

      Author's profile photo Andreas Schuth
      Andreas Schuth

      Very nice stuff there Martin.

      I wonder if it would be possible to include things like "Delete DTP Error Log",... etc.

      You have any experience with that?

      Thanks.

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Hi Andreas

      As this housekeeping list is made by SAP we need to wait until they add it πŸ™‚

      But so far this has been a nice add on and I saw SAP NW 7.31 SPS8 has it already included.

      Martin

      Author's profile photo Former Member
      Former Member

      Hi,

      You can expect DTP error log deletion, Process Chain Log deletion as well as Application log deletion among the upcoming improvements for the Housekeeping task list. Stay tuned!

      /Pasquale

      Author's profile photo Former Member
      Former Member

      Mentioned note is not accessible.

      Regards

      Michal

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Hi Michal

      Looks like OSS is slow but the note is accessible. I just downloaded it and tried to attach it but somehow it doesn't let me attach another file.

      Martin

      Author's profile photo CH Raman
      CH Raman

      Housekeeping activities always important at prod environment.

      Thank to know useful information and Notes.

      Thanks for sharing with us.

      Thanks

      Raman

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      thanks Raman I think this new invention from SAP is helping us a lot in those maintainance tasks

      Martin

      Author's profile photo CH Raman
      CH Raman

      Yes, it seems.

      Author's profile photo Roland Kramer
      Roland Kramer

      Hi,

      See the Document - http://scn.sap.com/docs/DOC-46433 as well

      unfortunally it took a while to publish this on SCN

      Best Regards Roland

      PM BW/In-Memory

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Hi Roland

      When I read the note I was wondering why SAP didn't make a bigger deal about it πŸ™‚

      I think this has great potential.

      thanks

      Martin

      Author's profile photo Roland Kramer
      Roland Kramer

      This is one oft the Best Helpers we ever did. the Developer is currently in Walldorf. He started this as a "Hobby", can you imagine?

      He implemented the most of my Housekeeping Recommendations I suggest prior to an Upgrade or a Migration. More Additions will follow ...

      See also - http://scn.sap.com/docs/DOC-7856#section16

      Furthermore we mentioned all this as well in the e2e Guide - Migration BW on HANA - http://help.sap.com/nw731bwhana#section2

      That´s all you have to read ... πŸ˜‰

      Best Regards Roland

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Quite an impressive "hobby" one can have πŸ™‚   I totally agree this is a great addition for housekeeping bw! Even just the first step on it's own, recreating index saves us from maintaining a process chain to rebuild those on the weekends.

      I'm suprised the reaction isn't any bigger but I guess not everyone has figured out yet what a handy tasklist this is. Excited to see it grow.

      Martin

      Author's profile photo Roland Kramer
      Roland Kramer

      stay tuned. We have several TechEd Presentations which give more Insight to the BW Houskeeping Tasklist.

      Best Regards Roland

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Hi Roland. Unfortunately I had to pass to attend this years teched in AMS as my daughter was born that week πŸ™‚ Is there any of the housekeeping content form teched online available?

      thanks Martin

      Author's profile photo Roland Kramer
      Roland Kramer

      Hi Martin,

      As you are one/the Frontrunner with BW Housekeeping, you know everything.

      we enhanched it also for 7.40 and we will continue implementing more tasks as well

      Updates will be published by the SAP Note and in the SAP First Guidance Document mentioned in your Post.

      Best Regards Roland

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Hi Roland

      Thanks for the update. I follow now your document so I guess I see the updates comming in πŸ™‚

      Martin

      Author's profile photo Raf Boudewijns
      Raf Boudewijns

      Hey Martin,

      just went through this as I'm at a (BW) client today. They have BW7.31 SP6 so all the prerequisites have already been met except for the ZNOTE_1829728_PRE report. When I tried executing it, I got an error stating that the note (1829728) could not be read:

      SAP Note 0001829728 cannot be read; Ensure correct download of note first.

      So I assume we actually have to download it via SNOTE (which I didn't see mentioned anywhere btw). Right now I'm stuck because it seems system admin here has "fooled around" with the OSS connection (which currently no longer works 😑 ). I guess it won't be fixed today anymore, so I'll have to wait to "play" with this for another 2 weeks (when I'll be back here).

      Thanks for sharing!

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Hi Raf

      Did you had a chance to look at the pdf attached to note 1829728? (PCAI_Guide.pdf)
      A simple download of the note via snote will not be enough if basis hasn't installed the post copy automation abap the note download will not be applicable. The pdf will tell you at what point you need to download it via snote. Sorry you need to wait two weeks πŸ™‚

      Martin

      Author's profile photo Raf Boudewijns
      Raf Boudewijns

      I downloaded that document, but since it's title states "PCAI Guide with note 1589145" I ignored it (as all prerequisites for that note have been met in our release by default).

      Anyways, we would eventually need SNOTE to work for that as well πŸ˜‰

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Such a nice information Martin
      πŸ™‚

      ~SM

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      thanks glad you like it.. personally I think this housekeeping task list is pretty awesome work done by SAP but I get the feeling people haven't yet realized what it all can do for you..
      Maritn

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice document martin .......... πŸ™‚

      ~ SM

      Author's profile photo Srinu S
      Srinu S

      Helpful document shared. thanks for sharing. πŸ™‚

      Author's profile photo Rajkumar Bhumij
      Rajkumar Bhumij

      Hi Martin,

      You really relieved my pain.... 😘
      Thanks for the wonderful document.

      Cheers!!!

      Rajkumar

      Author's profile photo Former Member
      Former Member

      Nice blog martin thanks for sharing...

      Author's profile photo Former Member
      Former Member

      Hi Martin

      i went through this on our internal test system but got a question here..

      an error message was given after executing ZNOTE_1829728_POST_73X (we are on SAP_BW SAPKW73107)

      "SAP Note 0001829728 not implemented."

      Yes, quite similar situation as Raf described in his comment.

      However, it prevented me from downloading 1829728 as it is not released.. then i turned to PCAI_Guide.pdf... what i did is just download note 1589145 but it cannot be implemented due to release problem

      i hence checked the original note 1829827 again.. it implies that i am on 731 sp7 so that i do not need to implement 1589145

      so.. i am little bit confused here.. what should i do next in order to get note 1829827 implemented?

      Thanks a bunch!!

      GX

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      HI

      So you are on 7.31 sp7? Have you tried tx STC01 the bw housekeeping tasklist should already be delivered then.

      Martin

      Author's profile photo Former Member
      Former Member

      Hi Martin

      yes it has STC01 already.. but there is no task list naming SAP_BW_HOUSEKEEPING.. dont know whats wrong

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Have you created /executed the post program steps?

      Author's profile photo Former Member
      Former Member

      Yes. i executed ZNOTE_1829728_POST_73X in update mode but it throws an error message 'SAP Note 0001829728 not implemented', which cant be download via SNOTE.. what shall i do to have SAP_BW_HOUSEKEEPING task list?

      Thanks a bunch

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Sorry took me a while to get back to you but Roland already gave you the answer. Since it says can't download the note you seem to miss the installation part noted in the pdf mentioned above.

      Martin

      Author's profile photo Roland Kramer
      Roland Kramer

      Hi,

      The following Note - 1829728 - BW Housekeeping Task List must be present in the 7.0x and 7.3x at any time. So download the Note ans make it available in the System.

      When you can see the Icon which indicates that is possible to apply, please do so.

      Read alsoc arefully the manual activites of the Note.

      In addition check the updated SAP First Guidance - BW Housekeeping and BW-PCA

      the latest Version can be found here, until the Version in SCN is updated

      https://share.sap.com/a:ofpi67/MyAttachments/72a8c829-3a2b-427f-94fc-d748e9e6585e/

      Best Regards Roland

      Author's profile photo Former Member
      Former Member

      Hi Roland and Martin

      thanks a bunch!

      we now have sap_bw_housekeeping in task list

      thank you both

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Good to know glad you where able to get it to work!

      Author's profile photo Former Member
      Former Member

      Hello Martin

      Another question about sap_bw_housekeeping, maybe you already know the answer.

      'where is the log generated by the tasks themselves stored?'

      Thanks a lot

      Gene

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      The job logs you can see in sm37 they start with STCTM_*

      Author's profile photo Former Member
      Former Member

      Is there any other logs generated by task run besides job logs in sm37? coz i am just curious little about whether i need to run other log clean job for this task list

      Thanks a bunch

      Gene

      Author's profile photo Former Member
      Former Member

      Hi,

      We are also receiving the same error - 'SAP Note 0001829728 not implemented'.

      Here are the steps we followed:

      1. Started to implement the note and basis asked us to do Pre manual steps.

      2. Performed Pre-manual steps by executing the pre program.

      3. Asked basis to continue. They continued and asked us to perform post manual steps.

      4. When tried to execute post manual pgm, received the error.

      How did you solve this error?

      Reg

      Deb

      Author's profile photo Gaurav Aggarwal
      Gaurav Aggarwal

      very useful document!!!

      Thanks for sharing.

      Author's profile photo Former Member
      Former Member

      Hi Martin

      is it possible to set dynamic variant for task 'Deletes the entries that are no longer required in table RSIXW'? coz i want to schedule it as a periodical job but the standard variant only allows to enter a certain date which means i have to schedule the job every week or every month manually.. so is it possible to set dynamic variant?

      Thanks a lot.

      Gene

      Author's profile photo Martin Grob
      Martin Grob
      Blog Post Author

      Hi Gene

      I don't know an option to dynamically derive the range for that job.

      Author's profile photo Former Member
      Former Member

      Very informative doc Martin...

      Thanks for Sharing πŸ™‚

      Author's profile photo Roland Kramer
      Roland Kramer

      Hallo Martin,

      Möchtest Du am 30.01.2014 am DSAG Arbeitskreis "Upgrade BW 7.x" über die BW Housekeeping Taskliste berichten? Das wäre wirklich Super.

      Viele Grüsse Roland

      Author's profile photo Phani KV
      Phani KV

      Nice document Martin.

      Thanks,

      Phani.

      Author's profile photo Former Member
      Former Member

      Good one.

      Author's profile photo Former Member
      Former Member

      Thanks for the informative document..

      Regards,

      Shaan..

      Author's profile photo Surendra P
      Surendra P

      Thanks for providing good information.

      Regars

      Surendra

      Author's profile photo Former Member
      Former Member

      Hi,

      is there any dangerous issue, which i take care on task β€œSAP_BW_HOUSEKEEPING”running? we have BI NW 7.4 SP 12 on Hana.
      thanks
      Sascha
      Author's profile photo Harsha Jalakam
      Harsha Jalakam

      Hi,

      Its a good approach that all of the house keeping activities are grouped together in the task manager - STC01. However, for BW/4HANA system, there isn't such activities grouped in task manager, as I could see that the note 1829728 is also not applicable to BW/4HANA. Is there any way where these can be made available in these systems as well?

       

      Regards,
      Harsha