0001734333_BW Upgrade Pre and Post Upgrade

SAP Note      1734333 - BW Pre and Post Upgrade and Migration TasksVersion   21     Validity: 01/19/2015 - active   Language   English (Master)Header DataReleased On 01/19/2015 13:20:42Release Status Released for CustomerComponent BW-WHM-TC Technical ConfigurationPriority Correction with medium priorityCategory Installation informationSymptomThis note automates several of the BW tasks required for system upgrades and migration.Other Termsupgrade, task listReason and PrerequisitesThis note contains the necessary coding required for the task list creation. These task lists can beused to facilitate a BW system Upgrade, Migration.This note requires that all pre-requisites for the BW-related system copy automation are metaccording to note 1707321. It serves as a supplement to note 1707321 and should you choose toinstall note 1707321, it will also install this note 1734333. If you choose to skip the installationof the task manager content notes, then you will not be able to use the following two tasks: \"StopRDA Daemons and Process Chains\" and \"Restart RDA Daemons and Process Chains\". However, if you are onSAP BW 7.30, you can use report \"RS_SYSTEM_SHUTDOWN\" instead of the tasks and run the report at thetime point in which the tasks would normally execute. Otherwise, if you are SAP BW 7.0X, you willneed to perform these actions manually.IMPORTANT: If a system is on the following support packs then CAREFULLY read note 1589145 andperform ALL necessary tasks (ie: using the Post Copy Automoation Installer).ATTENTION:, if you are on a support pack above the ones mentioned, you do not need to implement note1589145.SAP Netweaver BW 7.00: SP16 - SP26SAP Netweaver BW 7.01: SP00 - SP09SAP Netweaver BW 7.02: SP00 - SP08SAP Netweaver BW 7.11: SP00 - SP07SAP Netweaver BW 7.30: SP01 - SP03SAP Netweaver BW 7.31: SP01SAP Netweaver BW 7.40: SP01SolutionIt is important to note, that the utilization of the task lists is only meaningful, if you plan ondoing an Upgrade without Migration to SAP HANA or a Migration to SAP HANA without an Upgrade. Ifhowever you are planning to perform an upgrade along with a DB migration to SAP HANA, do not usethis task list. Instead, the tool of choice should be the Database Migration Option in SoftwareUpdate Manager, which is now generally available and already includes these tasks. More detailsavailable here and in note 1813548Upon successful implementation of this note's manual activities and pre-requisites, four task listswill be created: SAP_BW_BEFORE UPGRADE, SAP_BW_AFTER UPGRADE, SAP_BW_BEFORE MIGRATION, SAP_BW_AFTERMIGRATION. Each task listed in a task list is further described by the documentation available inthe task list manager (Tx. STC01). Please be aware that these tasks lists are intended to alleviatesome of the manual tasks requried by users. They do not fully replace the execution of ALL tasksrequired during the different phases of an Upgrade or Migration. As such they should be used inconjuction with avaible upgrade guides.Specifically, the pre update tasklist, SAP_BW_BEFORE UPGRADE should be executed at the sametimepoint (activity in the upgrade) as when the ASU toolbox prompts the user to action from withinSoftware Update Manager (see note 1000009 for more details). In fact, the complete execution ofthe SAP_BW_BEFORE UPGRADE task list is split into two; initial execution and manual confirmation.When the task list is initially triggred, all tasks listed prior to the 'Confirm all end users arecurrently locked' task are executed. The remaining tasks require that no further end-user action

take place on the system and must therefore be completed when the'user lock' phase of the upgrade isreached. As such, the administrator must return the the SAP_BW_BEFORE UPGRADE task list run andmanually confirm the 'Confirm all end users are currently locked' task so that the remaining taskslisted in the SAP_BW_BEFORE UPGRADE task list can run to completion. The post update tasklist, SAP_BW_AFTER UPGRADE  should be executed at the same timepoint (activityin the upgrade) as when the ASU toolbox prompts the user to action from within Software UpdateManager following the uprade. See note 1000009 for more details.The pre migration task, SAP_BW_BEFORE MIGRATION, should be executed at the begining of yourmigration timetable; that is, prior to the export.The post migration tasklist, SAP_BW_AFTER MIGRATION, should be executed at the same time point asone would execute the report RS_BW_POST_MIGRATION and can be used to replace the use of this reportall together.All task lists should be executed as Background jobs via the task list manager (Tx. STC01) whenpossible. l SAP NetWeaver BW 7.00 Import Support Package 32 for SAP NetWeaver BW 7.00 (SAPKW70032) into your BW system. The Support Package will be available as soon as note 1862745 with the short text \"SAPBWNews NW BW 7.0 ABAP SP32\", which describes this Support Package in more detail, is released for customers. l SAP NetWeaver BW 7.01 (SAP NW BW7.0 EHP 1) Import Support Package 15 for SAP NetWeaver BW 7.01 (SAPKW70115) into your BW system. The Support Package will be available as soon as SAP Note 1868060 with the short text \"SAPBINews NW7.01 BW ABAP SP15\", which describes this Support Package in more detail, is released for customers. l SAP NetWeaver BW 7.02 (SAP NW BW7.0 EHP 2) Import Support Package 15 for SAP NetWeaver BW 7.02 (SAPKW70215) into your BW system. The Support Package will be available as soon as SAP Note 1875427 with the short text \"Preliminary Version SAPBWNews NW BW 7.02 ABAP SP15\", which describes this Support Package in more detail, is released for customers. l SAP NetWeaver BW 7.11 Import Support Package 13 for SAP NetWeaver BW 7.11 (SAPKW71113) into your BW system. The Support Package will be available as soon as SAP Note 1871772 with the short text \"Preliminary Version SAPBINews NW7.11 BW ABAP SP13\", which describes this Support Package in more detail, is released for customers. l SAP NetWeaver BW 7.30 Import Support Package 11 for SAP NetWeaver BW 7.30 (SAPKW73011) into your BW system. The Support Package will be available as soon as SAP Note 1878293 with the short text \"SAPBWNews NW7.30 BW ABAP SP11\", which describes this Support Package in more detail, is released for customers. l SAP NetWeaver BW 7.31 (SAP NW BW7.0 EnhP 3) Import Support Package 11 for SAP NetWeaver BW 7.31 (SAPKW73111) into your BW system. The Support Package will be available as soon as SAP Note 1914639 with the short text \"Preliminary Version SAPBWNews NW BW 7.31/7.03 ABAP SP11\", which describes this Support Package in more detail, is released for customers. l SAP NetWeaver BW 7.40 Import Support Package 6 for SAP NetWeaver BW 7.40 (SAPKW74006) into your BW system. The Support Package will be available as soon as SAP Note 1920525 with the short text \"Preliminary Version SAPBWNews NW BW 7.4 ABAP SP06\", which describes this Support Package in more detail, is released for customers.In urgent cases you can use the correction instructions.Before you use the correction instructions, make sure that you check SAP Note 875986 fortransaction SNOTE.This SAP Note might already be available before the Support Package is released. In this case,however, the short text still contains the term \"preliminary version\".------------------------------------------------------------------------|Manual Post-Implement.                                                |------------------------------------------------------------------------|VALID FOR                                                             ||Software Component   SAP_BW                        Business Inform...|| Release 700          SAPKW70017 - SAPKW70031                         || Release 711          SAPKW71101 - SAPKW71112                         || Release 701          SAPKW70101 - SAPKW70114                         || Release 702          SAPKW70201 - SAPKW70214                         |------------------------------------------------------------------------

1. Download the attached file ZNOTE_1734333_POST_70X.txt. Please create in transaction se38 (ABAP Editor) a report 'ZNOTE_1734333_POST_70X.txt'. In the attributes Pop-up please enter some description and 'Executable program' as type. Save the program as local temporary object. Choose in Menue 'Utilities' -> 'More Utilities' -> 'Upload/Dwnload' -> 'Upload'. In the next pop-up select the file downloaded from the note. Save and activate the report. Execute the report. 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. You do not need to transport the report you have created, but the objects, which were generated by the report. 2. Read the text of the note itself carefully! It contains important advice on the automatic implementation of the note.------------------------------------------------------------------------|Manual Post-Implement.                                                |------------------------------------------------------------------------|VALID FOR                                                             ||Software Component   SAP_BW                        Business Inform...|| Release 731          SAPKW73101 - SAPKW73110                         || Release 730          SAPKW73001 - SAPKW73010                         |------------------------------------------------------------------------ 1. Download the attached file ZNOTE_1734333_POST_73X.txt. Please create in transaction se38 (ABAP Editor) a report 'ZNOTE_1734333_POST'. In the attributes Pop-up please enter some description and 'Executable program' as type. Save the program as local temporary object. Choose in Menue 'Utilities' -> 'More Utilities' -> 'Upload/Dwnload' -> 'Upload'. In the next pop-up select the file downloaded from the note. Save and activate the report. Execute the report. 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. You do not need to transport the report you have created, but the objects, which were generated by the report. 2. Read the text of the note itself carefully! It contains important advice on the automatic implementation of the note.------------------------------------------------------------------------|Manual Post-Implement.                                                |------------------------------------------------------------------------|VALID FOR                                                             ||Software Component   SAP_BW                        Business Inform...|| Release 740          SAPKW74001 - SAPKW74005                         |------------------------------------------------------------------------ 1. Download the attached file ZNOTE_1734333_POST_74X.txt. Please create in transaction se38 (ABAP Editor) a report 'ZNOTE_1734333_POST'. In the attributes Pop-up please enter some description and 'Executable program' as type. Save the program as local temporary object. Choose in Menue 'Utilities' -> 'More Utilities' -> 'Upload/Dwnload' -> 'Upload'. In the next pop-up select the file downloaded from the note. Save and activate the report. Execute the report. 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. You do not need to transport the report you have created, but the objects, which were generated by the report. 2. Read the text of the note itself carefully! It contains important advice on the automatic implementation of the note.ValiditySoftware Component From Rel. To Rel. And SubsequentSAP_BW 700 702   711 711   730 730   731 731   740 740  SAP_BW_VIRTUAL_COMP 701 701  Correction InstructionsCorrection InstructionsSoftware Component Valid from Valid to NumberSAP_BW 700 711 1306759SAP_BW 730 740 1306758Causes - Side Effects

Notes / Patches corrected with this noteNote Reason From Version To Version Note Solution Version Support PackageThe table does not contain any entriesThe following SAP Notes correct this Note / PatchNote Reason From Version To Version Note Solution Version Support Package1734333 0 0 2047410 1  Support Packages & PatchesSupport PackagesSoftware Component Release Support PackageSAP_BW_VIRTUAL_COMP 701 SAPK-70142INVCBWTECH 701 SAPK-70140INVCBWTECHSAP_BW 700 SAPKW70032 700 SAPKW70032 701 SAPKW70114 701 SAPKW70115 702 SAPKW70214 702 SAPKW70215 711 SAPKW71113 711 SAPKW71112 730 SAPKW73011 730 SAPKW73010 731 SAPKW73111 731 SAPKW73108ReferencesThis document refers to:SAP Notes1786506   Safe & fast Reset of OLAP Cache content1714734   Functions RSPC_SHUTDOWN and RSPC_STARTUP do not exist1695112   Activities in BW after migrating to the SAP HANA database1539128   WHM statistics are not deleted from the table RSDDSTATWHM1388287   RSRD_BOOKMARK_REORGANISATION: Specified time not used1142427   Trace cannot be deleted regularlyThis document is referenced by:SAP Notes (6)1695112   Activities in BW after migrating to the SAP HANA database1142427   Trace cannot be deleted regularly1714734   Functions RSPC_SHUTDOWN and RSPC_STARTUP do not exist1388287   RSRD_BOOKMARK_REORGANISATION: Specified time not used1786506   Safe & fast Reset of OLAP Cache content1539128   WHM statistics are not deleted from the table RSDDSTATWHMAttachmentsFile Name File Size (KB) Mime TypeZNOTE_1734333_POST_73X.txt 56 text/plainZNOTE_1734333_POST_70X.TXT 57 text/plainZNOTE_1734333_POST_74X.txt 119 text/plain