Skip to Content

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
50 Comments
You must be Logged on to comment or reply to a post.
  • 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.

    • 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

      • 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

    • 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

  • Housekeeping activities always important at prod environment.

    Thank to know useful information and Notes.

    Thanks for sharing with us.

    Thanks

    Raman

    • 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

      • 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

        • 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

          • 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

          • 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

  • 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!

    • 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

      • 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 πŸ˜‰

    • 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

  • 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

  • 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

  • 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