Post DMO Migration effort on BW on HANA – Sequence of steps including owners of tasks

We recently upgraded and migrated our BW 7..02 to BW 7.40 on HANA platform using DMO successfully. Major emphasize consider from technical front is to get BW system ready for business usage immediately after all SAP Basis and BW/HANA post DMO activities completed.

This is a challenging and required expertize on SAP Basis and BW front and understanding of all reporting and tools available in BW 7.40.

In each step mentioned in our step by step technical sheet consolidated and created by mutual effort of Basis and BW/HANA teams as a combined template for each post DMO effort.

Preparation Infrastructure Tasks
S.No	Task Name	Duration	Team	Remarks
1	Window 2008 upgrade	TBD	Infra team
2	Validate HANA appliance, OS patches, firmware updates etc. updated.	TBD	Infra team
3	Determine means to transport DB export from Source BW to Target HANA in different Datacenter.	TBD	Infra team

Preparation Basis Tasks
1	Kernel upgrade 720_EXT_REL patch 110 or higher including SAPPSCOL, SPAM update	TBD	BASIS
2	Upgrade Host agent SAP HOST AGENT 7.20 SP188 or higher	TBD	BASIS
3	SAP update to SP17-7 (SAP_BASIS) and SP19-7 (SAP_BW).	TBD	BASIS
4	Dual stack split	TBD	BASIS
5	Testing and validation	TBD	BASIS
6	1736976 – Make sure this note is implemented before sizing report	TBD	BASIS
7	Run ABAP Report /SDF/HANA_BW_SIZING	TBD	BASIS
8	Generate Stack file for Upgrade to BW 7.4 SP0XX	TBD	BASIS
9	Pre-migration performance tuning on OS, DB, SAP level.	TBD	BASIS
Preparation BW Tasks
1	SAP_BW_HOUSEKEEPING – before the upgrade 1829728 (STC01)	TBD	BW Team
2	SAP BW ABAP Routine Analyzer – checks BW system for critical ABAP statements in data flows and fix outstanding issues.	TBD	BW/ABAP Team
3	ZBW_HANA_MIGRATION_COCKPIT -Checklist tool	TBD	BW/BASIS
4	Other BW Steps for cleanup	TBD	BW Team
Pre-Migration Tasks
1	Download Latest SUM Toolset and SWPM Tool (for Primary Instance)	TBD	BASIS
2	Download Latest Kernl CD for NW 7.4 for (SQL)	TBD	BASIS
3	Download Latest R3loadctl,R3ta,R3szchk,R3load and SAPEXE,SAPEXEDB files	TBD	BASIS
4	SAP BASIS SP patch level (SMIGR_CREATE_DDL)	TBD	BASIS
5	SAP Note 1921023- SMIGR_CREATE_DDL	TBD	BASIS
6	SAP HANA requires unicode – Check the Unicode Status	TBD	BASIS
7	List of HANA components allowed to install ( SAP Note:1603671)	TBD	BASIS
8	SAP HANA hardware check ( SAP Notes: 1652078 & 1658845)	TBD	BASIS
9	SAP BW system to HANA – H/W Sizing ( SAP Note: 1736976 & 1637145)	TBD	BASIS
10	scale out architecture, sizing of master node ( SAP Note: 1855041)	TBD	BASIS
11	ABAP statements will be optimized for SAP HANA ( SAP Note: 1847431)	TBD	BASIS/BW Team
12	install the ABAP Development Tools (SAP Note 1718399)	TBD	BASIS/BW Team
13	Regular tasks for maintenance of BW system – BW Housekeeping Task List ( SAP Note: 1829728 ) as part of HANA_COCKPIT)	TBD	BASIS
14	SAP Business Warehouse Migration to HANA ( SAP Note: 1600929)	TBD	BASIS
15	Optimal settings of SUSE Linux SLES 11 SP3 (SAP Note: 1954788 )	TBD	BASIS
16	Conversion of standard DSO’s in to HANA optimized DSO is no more required ( SAP Note: 1849497 & 1849498)	TBD	BW Team
17	Conversion of standard Info cube in to HANA optimized DSO is no more required	TBD	BW Team
18	Prerequisites for HANA migration automatically SAP HANA – Checklist Tool ( SAP Note: 1729988)	TBD	BASIS
19	Migration/system copy to SAP HANA using latest SUM SP13 before starting migration ( SAP Note: 1775293)	TBD	BASIS
20	Perform house keeping tasks to delete unwanted data from database (ZBW_HANA_COCKPIT)	TBD	BASIS/BW Team
21	Consider Table splitting for larger tables ( SAP Note: 1783927)	TBD	BASIS
22	Request or generate a migration key	TBD	BASIS
23	Update database statistics of Source DB ( SQL)	TBD	BASIS
24	Execute: Pre migration tasklist, SAP_BW_BEFORE_UPGRADE/MIGRATION	TBD	BASIS/BW Team
	Execute Report: SAP_UPDATE_DBDIFF (SAP Note: 2017638)	TBD
	Target System:	TBD
1	Apply Latest HANA Server Software- DB Version including latest Revisions	TBD	BASIS
2	Download Latest SAP Hana Client	TBD	BASIS
3	Download Latest SAP Kernel for Target DB for ( HANA)	TBD	BASIS
4	Download Latest Kernl CD for NW 7.4 for (HANA)	TBD	BASIS
5	set the environment variable HDB_MASSIMPORT=YES on Target System during Import	TBD	BASIS
7	Order and install a new SAP license for HANA DB	TBD	BASIS
8	Correct time zone for HANA DB & SAP NetWeaver (CST instead of UTC)	TBD	BASIS
9	Check UUIID libraries on Linux based AppServers ( SAP Note: 1310037)	TBD	BASIS
10	Local host name refers to loopback address ( SAP Note: 1054467)	TBD	BASIS
Unicode conversion Preparation
		TBD	BASIS
	Run report UMG_ADD_PREP_STEP – the below tasks are now part of this report	TBD	BASIS
	Delete QCM tables Note: 9385	TBD	BASIS
	BW System conversions:/BI0/0; Note: 449891	TBD	BASIS
	Apply Note 679275 for RPU470ADJUST_T52C5	TBD	BASIS
	Report RADNTLANG 480671, 672835	TBD	BASIS
	Reset nametab buffers /$NAM	TBD	BASIS
	Consistency check for ABAP Dictionary – Run report RUTCHKNT in SE38 (172 Inconsistent Objects)/RUTMSJOB	TBD	BASIS
	Run report RSCPINST in SE38	TBD	BASIS
	Check entries Table TCPDB in SE16	TBD	BASIS
	Print old spool requests (Can also execute report UMG_POOL_TABLE) 842767	TBD	BASIS
	report UMG_R3CHECK_FILES 89384	TBD	BASIS
	Run R3check on database level	TBD	BASIS
	Update DB Statistics Before Scans	TBD	BASIS
	Application of note # 970780	TBD	BASIS
	Increase PSAPTEMP to 500 GB	TBD	BASIS
	Run report RS_TRANSLATION_EXPORT_OLD_PP as described in SAP Note 660873 (now obsolete) and 1055820	TBD	BASIS
	Reset All Scans	TBD	BASIS
	Initialise language list	TBD	BASIS
	Edit Language List	TBD	BASIS
	Maintain SPUMG Settings; (make checkpoint “active” & create secondary index on CDCLS, as given in Summary document)	TBD	BASIS
	Run report RSCP0125 to check if the code page(s) are roundtrip-compatible.	TBD	BASIS
	Update WorkList	TBD	BASIS
	Configuration of operation mode to increse the background jobs	TBD	BASIS
	SCAN1-Perform Consistency Check in SPUMG	TBD	BASIS
	Updated statistics on UMGCCTL, UMGPMIG, UMGPMDIC, UMGPMDII and UMGSTAT/Vocabulary files upload as per note 756535	TBD	BASIS
DMO Specific tasks
	Check the SAPHOSTAGENT.SAR version	TBD	BASIS
	execute command –> SUMSTART confighostagent	TBD	BASIS
	From Browser run – http://<hostname>:1128/msl/upgrade/<SID>/doc/gui	TBD	BASIS
	follow the SUM Screens with Expert mode selection	TBD	BASIS
Migration and Upgrade Tasks
	Necessary Pre Steps (Application Specific) – Source System	TBD	BASIS
1	Execute: RS_SYSTEM_SHUTDOWN / Migration Cockpit	TBD	BASIS
2	Executre: BTCTRNS 1	TBD	BASIS
3	Run SMIGR_CREATE_DDL	TBD	BASIS
4	Tablesplit Preparation selection	TBD	BASIS
5	Run the Export Preparation with SUM	TBD	BASIS
	Specify the TMP/TEMP space Bourne shell (sh)	TBD	BASIS
	TEMP=/usr/sap/tmp; export TEMP	TBD	BASIS
	TMP=/usr/sap/tmp; export TMP	TBD	BASIS
6	Table split Preparation	TBD	BASIS
7	Specify Export Dump Location	TBD	BASIS
8	Check the availability of the created files in the export directory	TBD	BASIS
9	Run the Export with SWPM – DB Instance Export	TBD	BASIS
10	Check the availability of the created files in the export directory	TBD	BASIS
7	Starting the import with SWPM	TBD	BASIS
8	Specify HANA client version for the HANA server revision	TBD	BASIS
9	Register in SLD during SWPM Installaton	TBD	BASIS
10	Refer Note 885441 – Common Migration Errors	TBD	BASIS
11	Check invalid_objects.txt after Import Completion	TBD	BASIS
Post-Migration Tasks
1	Find the potential Infoproviders that can be retired when using HANA. ( SAP Note 1908367)	TBD	BW Team
2	For comparing ABAP code execution times after a migration to SAP HANA ( SAP Note: 1942889)	TBD	BW Team
3	Order and install a new SAP license ( BW)	TBD	BASIS
4	Correct the DEFAULT.PFL and adapt the instance profile	TBD	BASIS
5	Import new license and check secure storage after migration	TBD	BASIS
6	Apply corrections after SP08 for HANA based systems ( SAP Note: 1769670)	TBD	BASIS/BW Team
7	Manual processing of some SAP notes ( SAP Note 1673420)	TBD	BASIS
8	check the consistency with transaction DB02	TBD	BASIS
9	Execute : RDSU_TABLE_CONSISTENCY report	TBD	BASIS/BW Team
10	BW-MT: Composite SAP Note for SAP NetWeaver 7.40 SP07 4/2 – executing UDO repor	TBD	BW Team
11	OData and BICS – Corrections after SP07?	TBD	BW Team
12	Workspace Designer – Corrections after SP07?	TBD	BW Team
	1953480 – Column view generation after upgrade to SAP BW 7.40 SP5 or above	TBD	BASIS
13	Run – SGEN	TBD	BASIS
14	Modifying the SAP profiles (restart SAP)	TBD	BASIS
15	Check the HDB/ABAP settings in general	TBD	BASIS
16	Check the HDB settings for SP08 and higher	TBD	BASIS
17	Check transaction SECSTORE after system copy	TBD	BASIS
18	Reset the logon groups	TBD	BASIS
19	Check settings in report RSCPINST	TBD	BASIS
20	Check myself connection after system migration ( RSA1)	TBD	BASIS
21	Check DSO activation parameters	TBD	BASIS
22	Execute: Report RS_BW_POST_MIGRATION – run in Background with Variant SAP&POSTMGRDB	TBD	BASIS/BW Team
23	Execute: The post migration tasklist, SAP_BW_AFTER MIGRATION	TBD	BASIS/BW Team
24	Convert the BW InfoCubes to in-memory optimized – Transaction RSMIGRHANADB	TBD	BW Team
25	Check the settings for TMS after the system copy	TBD	BASIS
26	Check SE06 Settings	TBD	BASIS
27	Check SE80 – Package	TBD	BW Team
28	Check further SAP NetWeaver BW basis settings ( if Any)	TBD	BASIS
29	Remodel process chain to remove the obsolete variants in process chain	TBD	BW Team
30	Install calender related hierarchy – from business content	TBD	BW Team
31	Connect to Hana Studio	TBD	BW Team
32	Role determination and assignment for Hana tool administration	TBD	Security
33	Functional Check list	TBD	BW Team
Unicode Conversion Post Steps
34	Complete Post System copy steps as per system copy guide	TBD	BASIS
35	Run report UMG_HISTORY	TBD	BASIS
36	Run report UMG_POOL_TABLE (SAP note 813445)	TBD	BASIS
37	Run report RUTTTYPACT	TBD	BASIS
38	Run report RSCPINST and Activate New NLS configuration	TBD	BASIS
39	Check Table Pools	TBD	BASIS
40	Special Handling of DBTABLOG Tables; Note # 1042842	TBD	BASIS
41	Special Handling of Tlock * Tables; Note # 795871	TBD	BASIS
42	Import the Proposal Pool for the translation workbench by running RS_TRANSLATION_IMPORT_OLD_PP for all source – target language	TBD	BASIS
43	Create file_info.txt file	TBD	BASIS
44	Run report UMG_SCAN_STATISTICS	TBD	BASIS
45	Table DMEE_TREE_NODE run report HRUU_CONVERT_IN_UNICODE if necessary(Note 895804)	TBD	BASIS
46	Adapt Parameters according to SAP Note 790099	TBD	BASIS
47	RFC Destinations; Apply SAP Note 647495, 547444 & 722193	TBD	BASIS
48	SUMG – Completion procedure using file_info.txt	TBD	BASIS
49	SAP License Application	TBD	BASIS
50	Restart SAP	TBD	BASIS
51	SGEN	TBD	BASIS

Note, these steps are generic steps for Post BW Migration using DMO., consider it as template only.

5 Comments

You must be Logged on to comment or reply to a post.

Harish Allachervu

June 17, 2016 at 9:12 am

Good job! Although you've listed 4 steps before migration, it would have been nice if you listed activities more specific to BW consultant needs to taken care, I mean to say pre&post migration from BW perspective.

Regards,

Harish

AMIT Lal

Blog Post Author

June 17, 2016 at 2:02 pm

Hi Harish,

In migration approach using SAP DMO tool, we have ZBW_HANA_MIGRATION_COCKPIT -Checklist tool available give all BW related pre and post migration steps, we have to make sure this report is up to date.

Thank you,

Amit

Prasanthi K

July 28, 2016 at 8:13 am

Hi Amit,

Thanks for listing the activities for migration! it helps a lot. I have a question, note 1847431 is mandatory activity to perform? Please let me know.

Thanks & Regards

Prasanthi

AMIT Lal

Blog Post Author

July 29, 2016 at 1:45 pm

HI Prasanthi, It required for critical ABAP statements in data flows running in BW system. Its only recommendation from SAP. Ours BW system does not have much codes.

Regards,

Amit