S/4 HANA conversion with SUM SP 19 (DMO-Database Migration Option), Its POC.
Document referred during conversion. Maintenance Planner User’s Guide http://wiki.scn.sap.com/wiki/download/attachments/187337812/Maintenance_Planner_User_Guide.pdf Important Blogs. https://blogs.sap.com/2016/11/02/sap-s4hana-system-conversion-at-a-glance/ (Master Blog) https://blogs.sap.com/2016/12/11/system-conversion-to-s4hana-1610-part-1-media-download-using-maintenance-planner/ https://blogs.sap.com/2017/01/20/system-conversion-to-s4hana-1610-part-2-pre-checks/ (S4HANA readiness check, IMP ) https://blogs.sap.com/2016/12/11/system-conversion-to-s4hana-1610-part-3-custom-code-migration-worklist/ (ABAP Custom Code) https://archive.sap.com/documents/docs/DOC-70449 (Custom Code Management) https://blogs.sap.com/2015/11/24/system-conversion-to-sap-s4hana-sum-is-the-tool/ https://blogs.sap.com/2016/10/31/simplification-list-sap-s4hana-1610/ https://blogs.sap.com/2012/10/12/near-zero-downtime-maintenance-for-sap-business-suite-systems/ (Space requirement During upgrade for SUM) S/4HANA 1610 Conversion link. (Bible) https://uacp.hana.ondemand.com/http.svc/rc/PRODUCTION/pdfe68bfa55e988410ee10000000a441470/1610%20000/enUS/CONV_OP1610.pdf Simplification list 1610.(Functional). https://uacp.hana.ondemand.com/http.svc/rc/PRODUCTION/pdfa4322f56824ae221e10000000a4450e5/1610%20000/enUS/SIMPL_OP1610.pdf Software Provisioning Manager 1.0 (SWPM) and Software Update Manager 1.0 (SUM) and SPAM/SAINT https://help.sap.com/sltoolset Data Cleansing (Functional & Basis). 2388483 - How-To: Data Management for Technical Tables (Application log table, Event table which can be archived/Housekeep) SAP Note 2343165 – SAP HANA SPS 12 Database Revision 122 https://launchpad.support.sap.com/#/notes/2343165 SAP HANA Server Installation and Update Guide http://help.sap.com/hana/SAP_HANA_Server_Installation_Guide_en.pdf DB2 Upgrade to 10.5 from 9.7. https://www.sap.com/documents/2015/07/90ac3182-5b7c-0010-82c7-eda71af511fa.html SAP Notes. 2377567 - DB2_Additional_Info_SUM19 2329005 - Minimal DB system platform requirements for NW AS ABAP 7.51 INNOVATION PKG 2292690 - SAP HANA DB: Recommended OS settings for RHEL 7 2131662 - Transparent_Huge_Page_Setting_for_SAPHANA_RHEL 784391 - SAP support terms and 3rd-party Linux kernel drivers 2298750 - SAP HANA Platform SPS 12 Release Note 2009879 - SAP HANA Guidelines for Red Hat Enterprise Linux (RHEL) Operating System 2356208 - SAP FIORI FOR SAP S/4HANA 1610: Release Information Note 1872170 - Business Suite on HANA and S/4HANA sizing report 1953429 - SAP HANA and SAP NetWeaver AS ABAP on one Server
Environment. ECC Source system. (EHB) Minimum DB version: DB2 10.5 FP06, we upgraded DB & took around 3 hrs to Upgrade. EHB: EHP5 ECC6.0 on DB2 10.5 FP10. ASCS instance number 01 PAS instance number 00. Standard configuration. ASCS, PAS & DB2 are on same HOST i.e. HANAPOC. DB Size: 570GB. S4HANA1610 Target System(EHB). S4HANA1610 on HANA1.0 SPS12 on HOST HANAPOC. HANA DB SID: E1B (HANA1.0 SPS12) with instance number 04 created. HNABOC Box Hardware details: TDIC with RHEL7.2 later all action related to HANA check is carried out.
PAM https://apps.support.sap.com/sap(bD1lbiZjPTAwMQ==)/support/pam/pam.html?smpsrv=https%3a%2f%2fwebsmp104.sapag.de#ts=4&pvnr=73555000100900000627&pt=g%7Cr
Kernel Info. HANAPOC:ehbadm 51> disp+work -------------------disp+work information -------------------kernel release kernel make variant compiled on compiled for compilation mode compile time update level patch number source id --------------------supported environment --------------------database (SAP, table SVERS)
operating system Linux 2.6 Linux 3 Linux HANAPOC:ehbadm 52>
721 721_REL Linux GNU SLES-9 x86_64 cc4.1.2 use-pr160421 for linuxx86_64 64 BIT UNICODE Jun 1 2016 13:50:02 0 700 0.700
700 710 701 702 703 711 720 730 731 732
Installed product version. Product
Release
SP-Stack
vendor
SAP_NW_UI_EXTENSIONS_100_702
100_702
07 (01/2014)
sap.com
SAP ERP
24 (10/2013)
sap.com
SAP NETWEAVER
2005 SAP EHP2 FOR NETWEAVER 7.0
14 (08/2013)
sap.com
EHP5 FOR SAP ERP 6.0
EHP5 FOR ERP 6.0
11 (10/2013)
sap.com
PURCHASECONTAPPR
1
SPS04
sap.com
DFA PURCHASEORDAPPR
1
SPS04
sap.com
DFA GENERICINBX
1
SPS04
sap.com
Sizing report.
SAP
Product SAP_NW_UI_EXTENSIONS_100_702 SAP ERP SAP NETWEAVER EHP5 FOR SAP ERP 6.0 PURCHASECONTAPPR DFA PURCHASEORDAPPR DFA GENERICINBX
/SDF/HDB_SIZING
https://launchpad.support.sap.com/#/notes/1872170
hanasizing_After_upgrade10.5.TXT
Prerequisite. Add-on component i.e. fiori & Client 066 has been removed as per below notes & S4H1610 conversion guide. 2011192 - Uninstalling ABAP add-ons 1749142 - To remove client 066
Custom code Migration worklist(Basis + ABAP task): 1) ECC i.
Update where-used index in ECC system. IMPORTANT NOTE: Its takes more than 30 Hrs. so start in advance. ii. Parallelly apply few related note in ECC system which is to be converted. iii. Download repository info from ECC system. 2) NW7.51 i. Installed separate NW7.51 IP (Innovation Package) system which will be used for code inspector check. ii. Go to Service Marketplace https://support.sap.com/swdc Software Downloads -> INSTALLATIONS AND UPGRADES – C -> CCMSIDB and download latest version of simplification database file CCMSIDB00P_580001018.ZIP iii. Import above simplification database file in NW7.51 system 000 Client. iv. Also, import Downloaded repository info from ECC system to NW7.51 IP. v. Run analysis report in NW7.51 IP, ABAP team will have collection of all Custom code list which need to be remediate as per S4HANA during preparation or Follow-on phase.
IMPORTANT: CCLM tool of Solman can be effectively used for Custom code migration worklist & custom code remediation.
HANA installation & creation. Have installed HANA1.0 SP12 & created database E1B with instance number 04. Refer: 1953429 - SAP HANA and SAP NetWeaver AS ABAP on one Server
Cleansing of application/log/trace table 2388483 - How-To: Data Management for Technical Tables CHECKS. Check for cluster (Report SDBI_CLUSTER_CHECK) & pool table (report SDBI_POOL_CHECK), Temse inconsistency, Failed Update, delete old profile & import active profile AZ10. Invalid Temp Table in SE14, ICNV list must be empty, DBACOCKPIT for missing tables & index. User type DIALOG for DDIC/000 & Validity set to infinity.
DB2 source database. We adjusted size & count of Primary, secondary logs & also make sure enough space to hold Primary logs (It occupy space in advance) however secondary logs occupy space when needed.
Generate Migration & License Key. 1. While generating Migration Key, ECC Source SID & S4H1610 Target SID will remain same however for Target system DB will be HANA in memory computing. 2. HANA1.0 SP12 license need to be generated as per memory usage. Stackfile generation. Stackfile will not generate until precheck goes green related to Add-on, there are few add-ons which are obsolete and need to be uninstall. Make sure latest SLD, LMDB & Data on Market place are in SYNC to get correct Stack file. Below Report should go Green or else SUM will shout during conversion.
1) 2182725 - S4TC Delivery SAP S/4HANA System Conversion Checks As per above note run report R_S4_PRE_TRANSITION_CHECKS in 000 of ECC source system & make sure to get all GREEN. 2) Report RSUPG_TADIR_COMPONENT_CHECK internally called by SUM during preprocessing phase to carry out component consistency check. Will proactively add it to our preparation phase and get it OK before realize phase.
DVM Data Volume reduction (Solman Functionality). We can achieve a shorter conversion duration due to reduced load size. It lists out tables which can be housekeep or archive. Function team task. Logistic team will carry out CVI to BP (Customer vender integration to Business partner) task which consume good amount of time. FICO will run report RASFIN_MIGR_PRECHECK & to get it GREEN its takes time.
Below are List of applied notes before carrying out conversion.
1614527 1623677 1627982 1652712 1884418 1917231 1939592 1949236 1996494 2011106 2048079 2082687 2090343 2091424 2182725 2185390 2185960 2186749 2187732 2188735 2190954 2192984 2194272 2194618 2194923 2196203 2197944 2198034 2198401 2198728 2198974 2202282 2205202 2206932 2209784 2211312 2216176 2216435 2216528 2216559 2216958 2219268 2224436 2227824 2240666 2243139 2252859 2270689 2283695 2291102 2294371 2303003 2303155 2305174 2310871 2325526 2326345 2326521 2327468 2328727 2330170 2330577 2330662 2331943 2335793 2336018 2338956 2339361 2339534 2339956 2345087 2349033 2350763 2354282 2356537 2358407 2365323 2374135 2389565 2392233 2403186 2422132
Short dump RAISE_EXCEPTION after note 1608831 BP_CVI: Check report for checking CVI Customizing Error 8A-327 while partial challan item qty reconciliation OKEON: Error B1 422 "Logical system & does not exist" Program termination TIME_OUT during execution of EU_INIT Runtime improvement for where-used list; job EU_INIT, table SFIN: Pre-Check Report for migrating to New Asset Accouting Start of job EU_INIT following upgrade or SP import; WBCROSS REPOSITORY_ENVIRONMENT_ALL - enhancement implementations not Extractor for executing static checks UPL: Shared Memory Flush before data collection missing Where-used list of variables and constants does not find any Environment determination REPOSITORY_ENVIRONMENT_ALL finds t Runtime error IMPORT_SET_FAILED or DBIF_RSQL_TABLE_UNKNOWN w S4TC Delivery of the SAP S/4HANA System Conversion Checks Custom Code Analyzer S4TC SAP_APPL Master Check for S/4 System Conversion Checks Infosystem: Several fixes to the environment analysis S4TC EA-GLTRADE Master Check for S/4 System Conversion Check S4TC SAP_APPL - Checks for Pricing Environment for structures and APPENDs REPOSITORY_ENVIRONMEN S4TC SAP_APPL –Pre-Transition Checks for Automatic Document S4TC ECC-DIMP Master Check for SAP S/4HANA System Conversion S4TC SAP_APPL - Checks for MM-IM S4TC SAP_APPL –Pre-Transition Checks for Subsequent Settle S4TC ECC_DIMP - Checks for Discrete Industries & Mill Produc S4TC EA-GLTRADE - Checks for LO-GT S4TC SAP_APPL - Checks for LO-AB S4TC EA-APPL Master Check for S/4 System Conversion Checks REPOSITORY_ENVIRONMENT_ALL - environment analysis - errors i S4TC FINBASIS Master Check for S/4 System Conversion Checks S4TC IS-UT Master Check for S/4 System Conversion Checks S4TC SAP_APPL - Checks for Foreign Trade S4TC SAP_APPL : Pre-Check for Material Master Data S4TC SAP_APPL - checks for EC-CS S4TC SAP_APPL –Pre-Conversion check for Business Partner Precheck report from business partner Pre-upgrade checks for PP-MRP Pre-upgrade check for storage location migration report S4TC SAP_APPL Precheck for SAP S/4HANA System Conversion of Precheck Program for Migration to SAP S/4HANA with regards t S4TC SAP_APPL - Checks for ERP-MM S4TC SAP_APPL - Checks for SD Data Model S4/HANA Pre-check for SD-Revenue Recognition S4TC SAP_APPL # Pre-Transition Checks for FIN REPOSITORY_ENVIRONMENT_ALL - too few hits for enhancement im S4TC Enterprise Asset Management: Checks before migration RFC Extractor for performing static checks Synchronization cockpit generates business partners with wro EU_INIT bzw. SAPRSEUB wird nach erfolgreicher Ausführung aut S4TC EA-FINSERV Master Check for S/4 System Conversion Check S4TC BP data exchange between SAP S/4HANA, on-premise editio S4TC SAP_APPL # Pre-Transition Checks for Business Function S4TC EA-FINSERV S/4 System Conversion Checks for Corresponde S4TC IS-R-BD-SIT pre-check for site master/business partner Global data synchronization precheck for migration to S/4 S4TC SAP_APPL conversion pre-checks for LO-RFM-MD-ART S4TC EA_RETAIL master check class for S/4 system transformat Preparatory checks for business partners and sites S4TC Pre-Transition Checks for Home Building Solution S4TC SAP_APPL - Consistency check of commodity codes assignm SAP S/4HANA Retail : Checks for Fashion Management Functiona S4TC EA-FINSERV Check for S/4 System Conversion Checks for S S4TC IS-OIL Master Check for S/4 System Conversion Checks S4TC IS-CWM Master Check for SAP S/4HANA System Conversion BP S4HANA : Suppress Mandatory BP field groups checks via MD S4TC SAP_APPL for LOCILERP Master Check for S/4 System Conve S4 PreChecks EA-RETAIL: Checks for Retail Store Fiori app S4TC SAP_APPL # Pre-transition check for Classic RE Corrections precheck for migration BP_BAP: Missing values in required entry fields cause postin S4TC Transition Check for ECC-DIMP System Conversion to SAP S4TC Minimum target release for EA-FINSERV in S4 conversion S4 PreChecks IS-UT: Reports for the conversion for transitio S4TC SAP_APPL # Pre-Transition Checks for Retail Informatio S4TC EA-FINSERV Notes for S/4 System Conversion Checks Correction concerning ITAB_DUPLICATE_KEY when reading tables Correction: Precheck - archiving, number assignment and term S4TC SAP_APPL - Checks for CO-PC-ACT S4TC EA-PS Master Check for S/4 System Conversion Checks S4TC Ariba Cloud Integration (CI) Master Check for S/4 Syste Erweiterte Prüfungen im Pre-check zur Betriebestamm / Geschä
CO-OM-OPA-C FS-BP XX-CSC-IN-MM CO-OM-CCA-A BC-DWB-UTL-BRR BC-DWB-UTL-INR FI-AA BC-DWB-UTL-INR BC-DWB-UTL-INR BC-ABA-LA BC-ABA-LA BC-DWB-UTL-INR BC-DWB-UTL-INR BC-DWB-TOO-COV BC-UPG-TLS-TLA BC-DWB-CEX LO-AB BC-DWB-UTL-INR LO-GT SD-BF-PR BC-DWB-UTL-INR IS-R-PUR-ADA IS-A MM-IM-GF MM-PUR-VM-SET IS-ADEC-SSP LO-GT LO-AB EHS-IHS BC-DWB-UTL-INR FIN-FSCM-CR IS-U-MD-BP SD-FT LO-MD-MM EC-CS LO-MD-BP LO-MD-BP PP-MRP PP-MRP CA-FLE-MAT CA-FLE-MAT MM-PUR-PO SD-BF-MIG SD-BIL-RR FI-GL BC-DWB-UTL-INR PM BC-ABA-LA CRM-MD-BP BC-DWB-UTL-INR FIN-FSCM-TRM LO-MD-BP-SYN LO-RFM-SWT FIN-FSCM-TRM-TM IS-R-BD-SIT IS-R-BD-PCT IS-R IS-R IS-R-BD-SIT IS-ADEC-HBS SD-FT-PRO LO-FSH FIN-FSCM-TRM IS-OIL-DS IS-CWM AP-MD-BP XX-CSC-IL-UTI IS-R-FIO RE-FX IS-R-BD-SIT FS-BP IS-ADEC-MPN FIN-FSCM-TRM IS-U-MD-BP LO-RFM-RIS FIN-FSCM-TRM IS-R-BD-SIT IS-R-BD-SIT CO-PC-ACT PSM-FM BNS-ARI-TRF IS-R-BD-SIT
Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished Finished
Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented Completely implemented
CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS CSC-BASIS
Executing the SUM from the below directory: /usr/sap/EHB/SUM Command to start sum: /STARTUP confighostagent EHB
Login through browser by using below url http://hanapoc:1128/lmsl/sumabap/EHB/doc/sluigui
Credentials for the SIDADM user ehbadm Admin@123
Provide the path of the XML file: /sapcd/stack/MP_Stack_2000172890_20170310_.xml
Click next after providing the path of the XML file
Extraction Phase started: 2:00 PM- 18-03-2017
Provide the DDIC password for client 000 User type should be dialog (confirmed) Password > jan@2017
Select > Don’t compare table contents Provide the migration key which is generated on SMP Migration key: 17wfdeM50D001eqteAM13A50 note@ “scale out option is not selected as we have single node system”
IMP NOTE: System using tablespace pools, are likely to encounter "Info about inconsistencies in your system" warning in INIT_CNTRANS_PRE phase. As per SAP note “2377567 - DB6: Add. Info - Software Update Manager 1.0 SP19” point#9, Ignore the inconsistency warning & Click NEXT. For more detail on Tablespace pool refer SAP note: - “2267446- SAP standard tablespaces Pool”.
The above three notes have been reset to original, as they were not implemented in the system. As result these notes disappeared from SPAU modification list.
Verify CHECKS.TXT file from Log section for Errors or waring. Configuration Phase started: 8:00 PM 19-03-2017
Select the Advance option
Here we have selected below count. ABAP processes count (up 8, Down 10). (It dependents on Dialog WP count.) SQL Processes count (up 10, Down 12). (It dependent on Database processes value.) R3Trans Processes (Up 20, Down 30). (Depends on CPU & Memory) R3load Processes (Up 40, Down 60).
SAP note 2344014, 212233 are implemented in EHB/000
Add E1B HANA database on market place and generate license.
Here we applied for 220 GB HANA license, however on server it reserved for 239 GB as allocation limit.
Password for SYSTEM user: Admin@123
Password for DBACOCKPIT: Admin@123
Password of SAP Schema User SAPABAP1: Admin@123
Selected above Language and click next
We have already applied above 2 snotes, But SUM dint picked it. Hence we will click on NEXT and again configuration phase will start.
Middle Phase already covered above, Below is the Next screen
All Support packages are relevant
There was no TR to import
DIR_LIBRARY=/usr/sap/EHB/SYS/exe/run is pointing to source kernel directory. R3load is looking for library file which should point to HANA database. We have copied the lasted LIBORA version from HANA client directory to the below path: Cdexe location of source system.
Now Below corrective actions are taken.
Error/Warning.
Background Job R_S4_PRE_TRANSITION_CHECKS Failed For missing table T130F_C, Action taken as per SAP Note 2330063(Informative). Below notes are implemented. SAP note 2324325(Created table T130F_C) & 2323185 (Run report RMMT130F_CPY). Thus, Table T130F_C populate entries from the existing table T130F.
We
checklog.txt
CHECK.TXT has been verified and no manual action, so moving ahead.
Check Phase Start: 4:45 PM 20-03-217
Db2 specific action carried out.
To overcome “Function group frame program” “ZMOB_INV_DETAILS” “exists without TLIBG entry” : Action as per SAP note (783308 - TLIBG inconsistencies before the upgrade ) carried out.
It talks about variant to be carry forward to target system (S4H1610). so, we are saving those variants by running RASUVAR1&2 job.
Its talks about BW trace and bookmarks which can be deleted, Not application data.
The RSVBCHCK job failed and this failure can be ignored as it’s just check for failed update in the system. We can proceed with next step.
Pre-processing phase start: 8:49 PM 20-03-2017
We ran report RSUPG_TADIR_COMPONENT_CHECK in EHB/900 as per below screen with option Correct not registered component and output is created in $DIR_PUT/abap/tmp. rsupg_tadir_component_check.txt
After executing report RSUPG_TADIR_COMPONENT_CHECK correction & update are recorded in special TR EHBK900002. For more update please refer note: 2318321 - Differences in SUM for the rescue of Non-SAP objects between load and delta procedure.
Inactive customer object are activated and open TRs are released.
Activate the above customer object again and its successfully moved to next step
Use Tcode lbwg, We delete respective application entries from setup table which are temporary tables & it can be repopulated with data from actual table by running certain programs. Reference URL : https://archive.sap.com/discussions/thread/1231616
Click next.
Now shadow instance creation started.
This phase takes much time , Be patients and keep on checking EU_IMPORT2 logs, Filesystem usage i.e. DB2 log area , Memory usage.
Last login: Mon Mar 20 17:49:29 IST 2017 on pts/0 HANAPOC:db2ehb 51> cd /db2/EHB HANAPOC:db2ehb 52> du -sh * 6.8G db2dump 40M db2ehb 72K db6_update_db.jar 4.0K db6_update_db.sh 128G EHB_Arch_log 3.2M final.sql 11G log_dir 768K Offline_reorg.sql 2.4M Runstat.sql 174G sapdata1 174G sapdata2 174G sapdata3 174G sapdata4 HANAPOC:db2ehb 53>
HANAPOC:db2ehb 52> du -sh * 6.8G db2dump 41M db2ehb 72K db6_update_db.jar 4.0K db6_update_db.sh 151G EHB_Arch_log 3.2M final.sql 11G log_dir 768K Offline_reorg.sql 2.4M Runstat.sql
180G sapdata1 180G sapdata2 180G sapdata3 180G sapdata4 HANAPOC:db2ehb 53> date Wed Mar 22 01:26:16 IST 2017 HANAPOC:db2ehb 54> pwd /db2/EHB HANAPOC:db2ehb 55> Here we can see increase in size of sapdata1/2/3/4 as space are being used for shadow repository. Also archive logs are getting generated. Still no moment at target HANA DB end.
From 24% to 25% it took around 5 Hrs.. we started at 10:00 PM & now its 3:00 AM.. with 4 R4Trans.
To overcome the above error
We updated dbsl library path to location cdexe. Download latest dbdb6slib.so for 721 REL kernel from SMP & upload it to cdexe location.
Now Shadow instance started , So please look at the memory usage.
Meanwhile will share few details on Shadow instance. When we login to 000 client of shadow instance with user DDIC, passwd is same as that of DDIC user from 000 client of source system. We don’t run SGEN in shadow instance, Whichever Tcode you hit it will first compile it hence processing will be bit slow.
Rest are below list for components in shadow instance. SAP_BASIS SAP_ABA SAP_GWFND SAP_UI 751 ST-PI 740 SAP_BW 751 MDG_FND WEBCUIF MDG_APPL MDG_UX 801 S4CORE 101 SAP_HR 608 SAP_HRCAE SAP_HRCAR SAP_HRCAT SAP_HRCAU SAP_HRCBE SAP_HRCBG SAP_HRCBR SAP_HRCCA SAP_HRCCH SAP_HRCCL SAP_HRCCN SAP_HRCCO SAP_HRCCZ SAP_HRCDE SAP_HRCDK SAP_HRCEG SAP_HRCES SAP_HRCFI SAP_HRCFR SAP_HRCGB SAP_HRCGR
751 75B 751 0000 0000 0000 801 801 801 0000 0000 0000 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
SAP Basis Component Cross-Application Component SAP Gateway Foundation 7.40 User Interface Technology 7.40 SAP Solution Tools Plug-In SAP Business Warehouse MDG Foundation SAP Web UI Framework MDG Applications MDG Additional User Interface S4CORE Human Resources Subcomponent SAP_HRCAE of SAP_HR Subcomponent SAP_HRCAR of SAP_HR Subcomponent SAP_HRCAT of SAP_HR Subcomponent SAP_HRCAU of SAP_HR Subcomponent SAP_HRCBE of SAP_HR Subcomponent SAP_HRCBG of SAP_HR Subcomponent SAP_HRCBR of SAP_HR Subcomponent SAP_HRCCA of SAP_HR Subcomponent SAP_HRCCH of SAP_HR Subcomponent SAP_HRCCL of SAP_HR Subcomponent SAP_HRCCN of SAP_HR Subcomponent SAP_HRCCO of SAP_HR Subcomponent SAP_HRCCZ of SAP_HR Subcomponent SAP_HRCDE of SAP_HR Subcomponent SAP_HRCDK of SAP_HR Subcomponent SAP_HRCEG of SAP_HR Subcomponent SAP_HRCES of SAP_HR Subcomponent SAP_HRCFI of SAP_HR Subcomponent SAP_HRCFR of SAP_HR Subcomponent SAP_HRCGB of SAP_HR Subcomponent SAP_HRCGR of SAP_HR
SAP_HRCHK SAP_HRCHR SAP_HRCHU SAP_HRCID SAP_HRCIE SAP_HRCIN SAP_HRCIT SAP_HRCJP SAP_HRCKR SAP_HRCKW SAP_HRCKZ SAP_HRCMX SAP_HRCMY SAP_HRCNL SAP_HRCNO SAP_HRCNZ SAP_HRCOM SAP_HRCPH SAP_HRCPL SAP_HRCPT SAP_HRCQA SAP_HRCRO SAP_HRCRU SAP_HRCSA SAP_HRCSE SAP_HRCSG SAP_HRCSI SAP_HRCSK SAP_HRCTH SAP_HRCTR SAP_HRCTW SAP_HRCUA SAP_HRCUN SAP_HRCUS SAP_HRCVE SAP_HRCZA SAP_HRGXX SAP_HRRXX EA-DFPS EA-HR 608 EA-HRCAE EA-HRCAR EA-HRCAT EA-HRCAU EA-HRCBE EA-HRCBG EA-HRCBR EA-HRCCA EA-HRCCH EA-HRCCL EA-HRCCN EA-HRCCO EA-HRCCZ EA-HRCDE EA-HRCDK EA-HRCEG EA-HRCES EA-HRCFI EA-HRCFR EA-HRCGB EA-HRCGR EA-HRCHK
608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 801 0000 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608 608
0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000
Subcomponent SAP_HRCHK of SAP_HR Subcomponent SAP_HRCHR of SAP_HR Subcomponent SAP_HRCHU of SAP_HR Subcomponent SAP_HRCID of SAP_HR Subcomponent SAP_HRCIE of SAP_HR Subcomponent SAP_HRCIN of SAP_HR Subcomponent SAP_HRCIT of SAP_HR Subcomponent SAP_HRCJP of SAP_HR Subcomponent SAP_HRCKR of SAP_HR Subcomponent SAP_HRCKW of SAP_HR Subcomponent SAP_HRCKZ of SAP_HR Subcomponent SAP_HRCMX of SAP_HR Subcomponent SAP_HRCMY of SAP_HR Subcomponent SAP_HRCNL of SAP_HR Subcomponent SAP_HRCNO of SAP_HR Subcomponent SAP_HRCNZ of SAP_HR Subcomponent SAP_HRCOM of SAP_HR Subcomponent SAP_HRCPH of SAP_HR Subcomponent SAP_HRCPL of SAP_HR Subcomponent SAP_HRCPT of SAP_HR Subcomponent SAP_HRCQA of SAP_HR Subcomponent SAP_HRCRO of SAP_HR Subcomponent SAP_HRCRU of SAP_HR Subcomponent SAP_HRCSA of SAP_HR Subcomponent SAP_HRCSE of SAP_HR Subcomponent SAP_HRCSG of SAP_HR Subcomponent SAP_HRCSI of SAP_HR Subcomponent SAP_HRCSK of SAP_HR Subcomponent SAP_HRCTH of SAP_HR Subcomponent SAP_HRCTR of SAP_HR Subcomponent SAP_HRCTW of SAP_HR Subcomponent SAP_HRCUA of SAP_HR Subcomponent SAP_HRCUN of SAP_HR Subcomponent SAP_HRCUS of SAP_HR Subcomponent SAP_HRCVE of SAP_HR Subcomponent SAP_HRCZA of SAP_HR Subcomponent SAP_HRGXX of SAP_HR Subcomponent SAP_HRRXX of SAP_HR SAP Enterprise Extension Defense Forces & Public Security SAP Enterprise Extension HR Subcomponent EA-HRCAE of EA-HR Subcomponent EA-HRCAR of EA-HR Subcomponent EA-HRCAT of EA-HR Subcomponent EA-HRCAU of EA-HR Subcomponent EA-HRCBE of EA-HR Subcomponent EA-HRCBG of EA-HR Subcomponent EA-HRCBR of EA-HR Subcomponent EA-HRCCA of EA-HR Subcomponent EA-HRCCH of EA-HR Subcomponent EA-HRCCL of EA-HR Subcomponent EA-HRCCN of EA-HR Subcomponent EA-HRCCO of EA-HR Subcomponent EA-HRCCZ of EA-HR Subcomponent EA-HRCDE of EA-HR Subcomponent EA-HRCDK of EA-HR Sub component EA-HRCEG of EA-HR Subcomponent EA-HRCES of EA-HR Subcomponent EA-HRCFI of EA-HR Subcomponent EA-HRCFR of EA-HR Subcomponent EA-HRCGB of EA-HR Subcomponent EA-HRCGR of EA-HR Subcomponent EA-HRCHK of EA-HR
EA-HRCHR EA-HRCHU EA-HRCID EA-HRCIE EA-HRCIN EA-HRCIT EA-HRCJP EA-HRCKR EA-HRCKW EA-HRCKZ EA-HRCMX EA-HRCMY EA-HRCNL EA-HRCNO EA-HRCNZ EA-HRCOM EA-HRCPH EA-HRCPL EA-HRCPT EA-HRCQA EA-HRCRO EA-HRCRU EA-HRCSA EA-HRCSE EA-HRCSG EA-HRCSI EA-HRCSK EA-HRCTH EA-HRCTR EA-HRCTW EA-HRCUA EA-HRCUN EA-HRCUS EA-HRCVE EA-HRCZA EA-HRGXX EA-HRRXX EA-PS 801 ECC-SE 801 ERECRUIT FI-CA 801 FI-CAX 801 INSURANCE IS-H 801 IS-M 801 IS-OIL 801 IS-PRA 801 IS-PS-CA IS-UT 801 LSOFE 801 GBX01HR GBX01HR5 SRA004 600 BSNAGT 200 ST-A/PI
608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 608 0000 0000 0000 801 0000 0000 0000 801 0000 0000 0000 0000 0000 801 0000 0000 0000 600 0000 605 0000 0000 0000 01S_731
Subcomponent EA-HRCHR of EA-HR Subcomponent EA-HRCHU of EA-HR Subcomponent EA-HRCID of EA-HR Subcomponent EA-HRCIE of EA-HR Subcomponent EA-HRCIN of EA-HR Subcomponent EA-HRCIT of EA-HR Subcomponent EA-HRCJP of EA-HR Subcomponent EA-HRCKR of EA-HR Subcomponent EA-HRCKW of EA-HR Subcomponent EA-HRCKZ of EA-HR Subcomponent EA-HRCMX of EA-HR Subcomponent EA-HRCMY of EA-HR Subcomponent EA-HRCNL of EA-HR Subcomponent EA-HRCNO of EA-HR Subcomponent EA-HRCNZ of EA-HR Subcomponent EA-HRCOM of EA-HR Subcomponent EA-HRCPH of EA-HR Subcomponent EA-HRCPL of EA-HR Subcomponent EA-HRCPT of EA-HR Subcomponent EA-HRCQA of EA-HR Subcomponent EA-HRCRO of EA-HR Subcomponent EA-HRCRU of EA-HR Subcomponent EA-HRCSA of EA-HR Subcomponent EA-HRCSE of EA-HR Subcomponent EA-HRCSG of EA-HR Subcomponent EA-HRCSI of EA-HR Subcomponent EA-HRCSK of EA-HR Subcomponent EA-HRCTH of EA-HR Subcomponent EA-HRCTR of EA-HR Subcomponent EA-HRCTW of EA-HR Subcomponent EA-HRCUA of EA-HR Subcomponent EA-HRCUN of EA-HR Subcomponent EA-HRCUS of EA-HR Subcomponent EA-HRCVE of EA-HR Subcomponent EA-HRCZA of EA-HR Subcomponent EA-HRGXX of EA-HR Subcomponent EA-HRRXX of EA-HR SAP Enterprise Extension Public Services ECC-SE E-Recruiting FI-CA FI-CA Extended SAP Insurance SAP Healthcare SAP MEDIA IS-OIL SAP IS-PRA IS-PUBLIC SECTOR CONTRACT ACCOUNTING SAP Utilities/Telecommunication SAP Learning Solution Front-End FIORI X1 HCM FIORI X1 HCM Create Travel Request OData Integration BSN AGENT 0000 Servicetools for SAP Basis 731
It too have same number of client as that of source system..
However, this profile can’t upload in RZ10, when tried it fail with table not exist error. If u want to edit incase needed do it from OS level… TR cannot be released. Shadow instance don’t have any logon group, RFC group, No operation mode.
SPDD and SPAU activity for Adjust modification has been done by ABAPER and we can proceed now. Below the confirmation mail from ABAPER for SPDD activity.
We can see HANA memory utilization will goes up as application data(shadow repository starts copying to target HANA DB).
As per simplification list, HBS will not be available in SAP S4HANA.
As per note 2343388, https://launchpad.support.sap.com/#/notes/2343388 Custom code using any object of the piece list SI_DI_HOME_BUILDG_SL needs to be adjusted to carry forward this functionality in S4HANA. Data elements i.e. varchar, char etc. associated with DI_HBS packages were missing as DI_HSB package was not in Shadow instance, Hence ABAP team created Custom package and assigned data element to field of Table ZOXES00135. Again, we retried and proceeded. .
Navigate to more – utilities to get below list.
http://10.0.110.77:1128/lmsl/sumabap/EHB/doc/sluigui
MAIN_SHDIMP/PARMVNT_SHD took around 5 hrs.
Here SAPOSS RFC in shadow instance was not working, we corrected password of user OSS_RFC for SAPOSS RFC. Password: CPIC (Refer SAP Note 182308) When you try to apply note is shadow instance it will be prompt “SAP system has status not Modifiable” As per note 2207944, Need to check SUM breakpoint for phase CHECK4NOTES_TOOL_SHD2 is set once this breakpoint is reached, unlock shadow system using command “SAPup unlockshd” & then login to your shadow instance using user other than DDIC & apply note. Later locking of shadow instance is taken care automatically by SUM.
Now login to shadow instance 000 client & applied above notes. IMP: Note number 2414830 Took around 1 hrs to implement & in DB01 there was lock on Table(Don’t do any thing be patients). For note 2414830, 2409043 & 2405316 where prerequisite & implemented while applying 2414830.
Above phase took around 30 minute.
We copied libSQLDBCHDB.so to /sapmnt/EHB/exe.
These steps are for SPS10, we have not carried out stated action. Moving NEXT.
When?
Phase name
Description
Directory
Logfiles
Uptime
EU_CLONE_MIG_UT_SIZE S
Determination of table sizes for uptime migration
-
EUMIGRATEUTSIZES.LOG
EU_CLONE_MIG_DT_SIZE S
Determination of table sizes for downtime migration
-
EUMIGRATEDTSIZES.LOG
EU_CLONE_MIG_UT_CRE ATE
Tables are created on target database for uptime migration
migrate_ut_ create
EUMIGRATEUTCREATE.LOG +
EU_CLONE_MIG_DT_CRE ATE
Tables are created on target database for downtime migration
migrate_dt_ create
EUMIGRATEDTCREATE.LOG + MIGRATE_DT_CREATE_RUN. LOG
EU_CLONE_MIG_UT_PRP
Creates directories and control files for uptime migration (STR, TSK, CMD files for R3load)
migrate_ut
EUMIGRATEUTPRP.LOG
EU_CLONE_MIG_UT_RUN
Transport of tables into target database
migrate_ut
EUMIGRATEUTRUN.LOG +
Creates directories and control files for downtime migration (STR,
migrate_dt
EU_CLONE_MIG_DT_PRP
MIGRATE_UT_CREATE_RUN.L OG
MIGRATE_UT_RUN.LOG EUMIGRATEDTPRP.LOG
TSK, CMD files for R3load) Downtime
EU_CLONE_MIG_DT_RUN
Transport of tables into the target database
migrate_dt
EUMIGRATEDTRUN.LOG + MIGRATE_DT_RUN.LOG
EU_CLONE_MIG_DT_CREATE is taken long time.
From this phase, it started writing on persistence layer & we can also see memory utilization started growing fast.
This phase EU_CLONE_MIG_UT_RUN has taken more than 5 Hrs.
After this we checked & source system EHB was down.
Backup of EHB Db2 database, SUM directory & /usr/sap/EHB completed. Will continue..
CHECKS.LOG file checked and all OK.
System was already down for backup , However actual downtime migration started at 11:46 AM.
Below was the error identified with enqueue port conflict.
We identified port as below and killed it after understanding consequence.
REASON WHY SUDDENLY AFTER RESTART of Source system ENQUEUE STOPED at very beginning of Downtime phase. Here SUM has added few parameter & altered some of parameter in profile of source instance from /sapmnt/EHB/exe & then copied it to his own directory
MOST IMPORTANT: One interesting thing to notice, Here ASCS will not come up during downtime phase & SUM will append ms & en entry in instance profile of PAS & also make softlink where ms & en will run from 00 instance which belongs to PAS. (01 instance number belongs to ASCS). In short, all function of ASCS is with PAS.
Now SUM was executing below command to bring 00 PAS up.
However, enqueue was not coming up due to port 50019 conflict with other. EXECUTING /usr/sap/EHB/DVEBMGS00/exe/sapcontrol -format script -prot NI_HTTP -host HANAPOC -nr 00 -function GetProcessList
Error with respect to INSTANCE.OUT file which was located under SUM/abap/log directory is it checks profile file for consistence. Using command “>sapfpar check pf= EHB_DVEBMGS00_HANAPOC”. & there was error for below two shared pool parameters & we manually edited it by given recommendation as per sappfpar. ipc/shm_psize_10 = 155000000 ipc/shm_psize_40 = 496000000 Then stopped source system “stopsap r3”. Don’t start source instance, Let SUM take it up. After taking all corrective action, Click NEXT… .
This phase took good amount of time around 10 hrs.
We can see parallel exp & import thru R3load.
We can monitor parallel exp & imp task from below window. More > DMO Migration Control Center > Charts Control Center.
Yet we haven’t seen SAPABAP1 user in catalog.
Keep habit of checking Alerts.
Kernel switching took place..
Actually it does DB cleanup & some internal process.
Current Phase: MAIN_NEWBAS/PARCONV_UPG takes around 2 hrs time.
We can see savepoint job is in progress, which write data to persistent layer i.e. /hana/data. Archive log autobackup was ON & was going to below location.
Current Phase: MAIN_NEWBAS/TABIM_UPG … Be patience this al phase take good time to complete. & some time it takes your app down.
Like wise SUM proceed.. your conversion.
Fortunately, SUM start running like Husain Bolt. Now again App is up.
Again SUM is like a tortoise.
We tried repeating this phase... as it was stuck to a point and not initializing might be bcoz of lack of HANA memory… and it continued…
Total time for Downtime activity is around 19 Hrs.
CHECKS.LOG file output.
POSTPROCESSING.
License related error.. Below is logfile output for SAPLIKEY_PEM2ND.LOG
We are not using BW. Its S4HANA so no need to check note 1908075.
Remember job JOB_RASUVAR1 ran in Preprocessing & its again running as JOB_RASUVAR2 . This job is related to variant export in preprocessing & import in postprocessing. This also takes few time.. Below is the log for above job.
Have ask ABAP team.. they will continue later within 14 days..
Finally after 24 Hrs of Downtime we are done… jai Mata Di. Njoy.. . Space usage of disk after upgrade/conversion.
