Technical Articles
Upgrade SAP BW/4HANA 2.0 – the time is now …
Last Changed: 29th of November 2021
Upgrade SAP BW/4HANA 2.0 – the time is now …
Note 3087277 – End of 2021 is the end of Mainstream Maintenance of BW/4HANA 1.0
Since SAP BW/4HANA 2.0 initially was available, it was only possible to start an Upgrade to Version 2.0 without any Add-On’s like BPS or BCS which are available now.
The current Version brings additional Features to the Market
– SAP BW/4HANA – Technical Overview
To implement SAP BW/4HANA 2.0 either as on-premise or IaaS see
– SAP BW/4HANA 2.0 – CAL for it …
Please also Note, that SAP BW/4 differs from an SAP ABAP 1809 Foundation or higher as follows:
Evolution of the SAP BW/4HANA Stack
SAP Help: SAP BW/4HANA Master Guide – What’s new in SAP BW/4 HANA 2.0
Now let’s see the Upgrade process in the Maintenance Planner (MP)
Preparations for the usage of the Maintenance Planner
- Update the SLD with tx. RZ70 from your BW/4 Backend System
- Synchronize the LMDB from SLD in the SAP Solution Manager
- Upload the Data to the Maintenance Planner
This is described in detail in the Blog – S/4HANA 1709 FPS03 – back on the Mothership again … Or as an Alternative, create the system.xml and upload this directly to the MP
If the “Installed Software Component Versions” differ from the “Installed Product Versions”, please make sure that a proper and corrected source system template is used for the maintenance process.
Steps in the Maintenance Planner
MP – Select the target release and released support package(s) …
MP – Check the Plan Changes for your System
MP – Add the Non-ABAP components …
Optionally you can deselect the Language Packages you don’t need here to save time/space for the download of the load based export. Download the stack.xml and the software content and you are ready the run the SUM tool
MP – final check of the selected files
MP – download the stack.xml and push to Download Basket
MP – the MP process is finished
Steps in the Software Update Manager (SUM)
Disclaimer
Please Note the following screenshots are already based on SUM 2.0 SP06. So you might see differences in higher versions. You will just see the most important screens. Additional Details can also be seen in the Blog – Upgrade to S/4HANA 1809 SPSx – the final frontier
Always get the latest Version from – Software Logistics Toolset
Note 2832250 – Central Note – Software Update Manager 2.0 SP08 [lmt_020]
Note 2882379 – Central Note – Software Update Manager 2.0 SP09 [lmt_021]
Note 2935104 – Central Note – Software Update Manager 2.0 SP10 [lmt_022]
As you can imagine, a current Version of SAP HANA 2.0 is mandatory. I chose the latest Version from SP04 – SAP HANA 2.0 SPS 04 Database Revision 042. Meanwhile the latest Version (20.11)
Note 2993533 – SAP HANA 2 SPS05 Revision 054.00
Note 3021026 – SAP HANA 2 SPS05 Revision 055.00
Note 3043459 – SAP HANA 2 SPS05 Revision 056.00
Note 2954097 – Checks after phase MAIN_SHDCRE/CREATEDBCON_SHDONTARGET were negative!
Since the Blog – Upgrade was never been easier… was created, the SUM tools for DMO and Upgrade were improved a lot, including the SUM Utilities …
Update 20th November 2020: SAP UI_754 Add-On is now included in the Maintenance Planer Request. SAP UI_754 is the highest Version you can apply on SAP BW/4 2.0
Blog – New dialog sequence with SUM 2.0 SP 06
optional: nZDO option with SAP BW/4 HANA Upgrade
Possible Problems/Issues:
- Shadow Instance Port is occupied
- Several sapstartsrv commands are running simultaneously
- Mixup of the profile parameters used for ENSA 1.0 and ENSA 2.0
- cleanup of SAP-IPC-Objects (cleanup <nr> remove and restart)
- Problems with the SAP HANA Client 2.0 SP05 connectivity
- Issues accessing the SAP HANA secure store
Note 2630416 – Support for Standalone Enqueue Server 2
Note 2681666 – Shadow Instance start hangs while using SUM – Phase START_SHDI_PREPUT
Note 2754662 – SUM upgrade/Installation of S/4HANA fails due to Enqueue problem
Note 2967389 – SAP HANA Client 2.6.54
Note 3033226 – SAP HANA Client 2.7.26
Note 3027730 – SAP HANA Client 2.8.16
Note 2876608 – Error (91009) Timeout Waiting for the Secure Store Access Lock
Note 2940886 – SJOBREPO: Generate job should not be triggered in shadow system
Note 2954097 – Checks after phase MAIN_SHDCRE/CREATEDBCON_SHDONTARGET were negative!
Even that the Process List of the Enqueue Server (03) shows “YELLOW”, the Shadow Instance (04) can connect like the primary instance (03).
server:b4hadm> DIR_PUT/exe/sapcontrol -nr 02 -function GetProcessList
17.09.2020 23:48:48
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
msg_server, MessageServer, YELLOW, Running but not responding, 2020 09 17 22:21:40, 1:27:08, 140954
enserver, EnqueueServer, YELLOW, Running but not responding, 2020 09 17 22:21:40, 1:27:08, 140955
server:b4hadm> DIR_PUT/exe/sapcontrol -nr 03 -function GetSystemInstanceList
17.09.2020 23:49:12
GetSystemInstanceList
OK
hostname, instanceNr, httpPort, httpsPort, startPriority, features, dispstatus
lt5088, 3, 50313, 50314, 3, ABAP|GATEWAY|ICMAN|IGS, GREEN
lt5088, 2, 50213, 50214, 1, MESSAGESERVER|ENQUE, YELLOW
server:b4hadm> DIR_PUT/exe/sapcontrol -nr 04 -function GetProcessList
17.09.2020 23:49:20
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
enq_server, Enqueue Server 2, GREEN, Running, 2020 09 17 23:13:11, 0:36:09, 157134
msg_server, MessageServer, GREEN, Running, 2020 09 17 23:13:11, 0:36:09, 157135
disp+work, Dispatcher, GREEN, Running, 2020 09 17 23:13:11, 0:36:09, 157136
gwrd, Gateway, GREEN, Running, 2020 09 17 23:13:12, 0:36:08, 157140
icman, ICM, GREEN, Running, 2020 09 17 23:13:12, 0:36:08, 157141
server:b4hadm>
Even you didn’t checked the system before either with the ASU toolbox or the usage of the task list, you can always do the configuration dynamically … (in this case tx. SE14 – clean)
Note 2452819 – Release strategy for the ABAP add-on BPC4HANA
Note 1330000 – SAP BW/4HANA, Business Consolidation Add-On ( “BCS/4HANA” )
Note 2805174 – Release strategy and Maintenance Inform for the ABAP add-on BCS4HANA 200
Note 2393067 – Release strategy for the ABAP add-on BW4CONT / BW4CONTB
Note 2705605 – Release strategy and Maintenance Information for the ABAP add-on SAP DSIM 1.0 FOR BW/4HANA
depending on the installed Add-On’s there might be inconsistencies with the result of the MP and the created stack.xml with the SAP Backend. In this case, you only can go back to the MP and create a new stack.xml based on the updated system.
Update from 20th of November 2020: SAP UI_754 SP05 as Target Level, as coming from 7.53 SP07 (update is shown a bit “unsuitable” … ;-))
Note 2597660 – Lack of performance in phase RUN_RUTDDLSCREATE
SUM-Phase: MAIN_SHDCRE/EU_IMORT_ALL
SUM-Phase: MAIN_SHDCRE/SHADOW_IMPORT_UPG1
The Shadow Instance
check the Blog – Upgrade to S/4HANA 1809 SPS0x for the solution …
enhance the shadow instance profile with these parameters.
check /usr/sap/SUM/abap/system/B4H/SYS/profile
add the profile parameters in advance
abap/buffersize = 1400000
abap/heap_area_total = 108197104800
abap/shared_objects_size_MB = 1024
em/initial_size_MB = 65536
em/global_area_MB = 49152
em/proc_max_size_MB = 128000000
em/proc_use_stdheap = TRUE
ipc/shm_psize_10 = 198000000
ipc/shm_psize_40 = 1978000000
rsdb/esm/buffersize_kb = 524288
rsdb/obj/buffersize = 524288
rsdb/otr/buffersize_kb = 16384
rsdb/tbi_buffer_area_MB = 2048
rdisp/PG_MAXFS = 128000
rdisp/PG_SHM = 128000
ztta/roll_extension = 40000000000
Note 2793766 – CDS View cannot be created/activated – Repair tool
Introducing tx. SDDLAR
cd /usr/sap/B4H/SYS/exe/uc/linuxx86_64/
server:/usr/sap/B4H/SYS/exe/uc/linuxx86_64 # dir sapuxuserchk
-rwsr-xr-x 1 root sapsys 1327618 Sep 17 19:42 sapuxuserchk
server:/usr/sap/B4H/SYS/exe/uc/linuxx86_64 # rm sapuxuserchk
server:/usr/sap/B4H/SYS/exe/uc/linuxx86_64 #
Note 2793766 – CDS View cannot be created/activated – Repair tool
Introducing tx. SDDLAR
Note 2607883 – Checking Column view and calculation scenario/ calculation model errors in BW Queries
Phase MAIN_NEWBAS/TABIM_UPG
Phase MAIN_NEWBAS/HANA_DEPLOY_UPG
Phase MAIN_NEWBAS/XPRAS_AIMMRG
Is this the end?
the software components and the product versions are in sync …
SAP BW/4HANA 2.0 – Installed Software Component Versions
after a short check running SPAU, it seems I have earned some objects in the /SPN/ namespace which were not in the system before …
Update from 10th of April: Installed Product Versions
Finally: The timing and runtime
Overall I have spent a half day running the MP process and downloading the necessary software. after this I started the Upgrade. Later this day I have continued the SUM procedure and finished the day after. So the netto runtime was 7h, which actually is a good mark. (1st brutto runtime 2d)
Update 18th of September: addition run with the nZDO option
the Upgrade run with the nZDO option was running slightly longer, nevertheless more support packages and an additional Add-On was selected. So an overall runtime of 8h looks pretty good.
SAP BW/4 HANA – Upgrade with the nZDO option
SAP BW/4HANA on premise is back …
Hot of the press: BW-PCA is available for SAP BW/4HANA!
Note 2743291 – PCA for BW/4HANA
Note 2570363 – Availability of BW PCA for BW/4HANA
Note 1707321 – BW System Copy: Post Copy Automation (BW-PCA)
Note 1614266 – System Copy: Post-Copy Automation (PCA) / SAP Landscape Management (LaMa)
Note 2821852 – HANA SDA & SDI connections in context of BW and BW/4HANA system copies
Roland Kramer, SAP Platform Architect for Analytics SAP SE
@RolandKramer
“I have no special talent, I am only passionately curious.”
Hi Roland.
Thanks a lot for a almost "next -> next -> finish" blog. 😀
We're on the way to make an upgrade of our BW4HANA but lacks of courage...Why?
Impacts on connections of our datasources and calculation views made at S/4HANA, at least to name a few worries.
Our S/4HANA system:
Our BW4HANA:
The S4HANA system will stay were they are.
What you think about it?
Can we do the upgrade BW in a "technically speaking" way?
Thanks a lot for your valuable considarations.
Espártaco
An old timer BW consultant...
Hello Espartaco
as you are already using BW/4 and the new extraction method, there should be no obstacle to Upgrade to Version 2.0 at all. Everything from the "technical upgrade" experience is mentioned in the Blog
Best Regards Roland
Hi Ronald,
Nice blog, I have somewhat different query, We are in process of readiness check for bw4hana 2.0, we are on bw 7.4 (oracle) currently. I have read many of yours and others blog but couldn't find answer to this question. If you can assist on this thread?
Basically wants to know , from where to get program TMW_BW_RC_DOWNLOAD_ANALYS_DATA and tcode RSB4HCINV in my system, I don't see any note mentioning the same. need to get the add-in? if yes, if you can point to the note.
https://answers.sap.com/questions/12964916/bw4hana-readiness-query.html?childToView=12969436&answerPublished=true#answer-12969436
Hello Jain
Did you had a look to the Blog - https://blogs.sap.com/2016/12/15/on-the-road-to-bw4hana-first-stage-accomplished/
it is quite a while since I have investigated here. Nevertheless it should be possible since BW/4 2.0 SP02 and the Availability of the BCS/4 and BPC Add-On's to convert from your Source Release.
The mentioned Sources should come from the Conversion Notes available?
Best Regards Roland
Hi Roland,
thanks for your great blogs, they are super helpful.
Currently I try to figure out if SAP_ABA 7.5E will be available for BW4/Hana 2.0? I saw the difference between S/4 and BW4 is existing in your lastest blog still, but would be curious if it comes soon, or with BW4/3?
Best regards Peter
Hello Peter
It is, what it is and no changes in the Horizont ...
Best Regards Roland
Hello Roland,
I've got a quick one: In your overview of the BW/4HANA stack in the BW/4HANA 2.0 stack BPC is referenced to BPC 2.0. The PAM documents list the BPC 11.0 for BW/4HANA 1.0 and BPC 11.1 for BW/4HANA 2.0.
Due to some experiences regarding some very specific details within the licencing contracts, I am rather cautious and allow myself the following question.
Is BPC 2.0 the same as BPC 11.1 and is this a foreshadowing that BPC 11.1 will be named BPC 2.0 in the future?
Best regards,
Corvin
Hello Corvin Schindler,
obviously it is the same. by the time of creation it was unclear if the continue the Versioning or create a new Version Digit for SAP BW/4 2.0. Finally the PAM counts ... and I changed the graphic accordantly.
Best Regards Roland
Hello Roland Kramer ,
thank you very much for the clarification.
Best regards,
Corvin
Hi Roland, thanks for this blog!
is there an Update-Guide if I am already on BW/4 2.0 and just want to update to a higher SP? In SAP Help Portal there is just a Masterguide with very few information about a simple update, but not a separate Update/Upgrade Guide for BW/4, whereas for S/4 there is an Update/Upgrade Guide in the SAP Help-portal.
So I assume the only relevant document for the Update is the SUM-Guide?
regards, Günther
Hi Günther, please, check my YT channel. It could help you...
Hi, just to be sure, SUM will also update HANA DB or do I have to do this separately? Thank you! Best regards, Daniel
Hello Daniel Geers
SUM only takes care of the ABAP Part, the HANA part is handled by their own upgrade tool.
Best Regards Roland
Hello Roland
Thanks for your blog, is very nice but I have a doubt . . I am doing a BW/4 Hana Upgrade, from 1.0 to 2.0 but I am in downtime phase, I didn´t pass for SPAU and SPDD adjustments, is it correct? You don´t need to adjust the system to accept the new changes?
Thanks a lot
Hello Oscar
You definitely have passed SPAU/SPDD also in the BW/4 Upgrade, but it is not that crucial as with ERP/S4 as potential new Fields automatically adjusted on the fly.
Furthermore, for the applied Correction you will be asked at the end of the Upgrade for the SPAU reset.
Best Regards Roland
Hi Roland
Thanks for your answer. As you said, I have passed SPAU/SPDD phase but my doubt was because I didnt received th following message in SUM tool
I am not sure if in BW/4 Hana Upgrade this phase is not working like ERP/S4 hana Upgrade.
Please let me understand you . . Do I need to adjust everything at the end of the SUM Phases or all the adjustments are done automatically?
Thanks for your support.
Hello Oscar
all the adjustments are done automatically during the SUM runtime. you will call tx. SPAU when the technical SUM procedure will tell you that in the post processing
For Details you can check also with the Document - SAP First Guidance – Using the new DMO to migrate to BW on HANA as the main steps are the same for DMO and SUM
Best Regards Roland
Thanks for your time and support, Roland.
Regards
Hi Roland,
Very nice blog !
I am planning to upgrade BW/4HANA from 2.0 to 2021, and have two questions.
Would you please check when you are avaiable?
2. I see the step to stop process chain and lock end user in task list SAP_BW4_BEFORE_UPGRADE, does this mean it enter downtime at this point, rather than during SUM downtime as S/4HANA?
Best regards,
Ning
Hello Ning Li,
1.) Yes
2.) No, this is to make sure the no PC is running before sum locks the Workbench
see also the Blog - SAP BW/4 HANA 2021 – 3rd Generation in Sync with SAP S/4
Best Regards Roland
Hi Roland,
Thank you for your prompt response.
I have checked the blog several times. I am not sure I fully understand it well because I am new to BW.
I thought BW business depends on PC. Therefore, BW enter business downtime once PC is stopped and user are locked.
Best regards,
Ning