Post-Migration Steps - BASIS

 After the successful migration using SWPM, there are general Basis activities required to set up the SAP BW system on new database. These are generic like setup of transport landscape, maintenance of operation modes, adaptation of RFC server group.

However, there are certain SAP BW on HANA specific post migration activities that need to be performed.

Generic Basis Activities-

Step 1: Reset the database log mode and create a backup

Open SAP HANA studio, and go to CONFIGURATION tab in the ADMINISTRATION perspective. Expand the GLOBAL.INI-PERSISTENCE tree. An input window opens once you double click on LOG_MODE. Set the log mode parameter of SYSTEM back to NORMAL.

Also, reset the value for ENABLE_AUTO_LOG_BACKUP to YES.

Note that the database does not generate any log files until a back up is created.

For creating backup, right click on you SAP HANA system in the system tree. Select BACKUP AND RECOVERY-BACK UP SYSTEM from the menu.

Step 2: Activities at Operation System and Database level

The SAP Basis administrator should carry out some activities at the operating system level of the new SAP BW application server. Like for example, instance and default profile, connection of job scheduler, integration of application specific directories.

Also, Basis need to clear some database tables after migration. More on this is given on "Information material on SAP BW on SAP HANA migration" in the first post of this series.

Step 3: Basis Activities in the SAP BW system

These activities can be read in detail in the migration guide and are discussed briefly here in the form of below table-

ActivityTransaction
Perform Installation CheckSM28 or SICK
Import System ProfilesRZ10
Maintain Operation typesRZ04, SM63
Check logon groupsSMLG
Set up spool ServerSPAD, SP12
Import SAP LicenseSLICENSE
Maintain Security SettingsSTRUST, SECSTORE
Adapt RFC server groupsRZ12
Adapt RFC connectionSMQR, SM58, SM59
Maintain Partner ProfilesWE20, WE21
Set up transport SystemSTMS
Check external commandsSM69
Maintain DBA Planning CalendarDB13

Step 4: Execute the Post-Migration Report

In the tcode SE38, run the report RS_BW_POST_MIGRATION. This program is used to carry out database specific adaptations after heterogenous system copy. Use the variant SAP&POSTMGRHDB for changeover to SAP HANA.

Ensure that the checkmark 'CREATE CACL VIEWS CUBES/INFOOBJECTS' is checked. Otherwise the system will not create logical indices, and queries may not be executable (SAP Note 1695112)

This report may take more than an hour to run depending on the system size and version.

SAP BW specific post processing steps will be discussed in the next post.

 

Comments

Post a Comment

Popular posts from this blog

Domains and Data Elements

  Domains A domain provided Technical attributes (type, length and possible values) for a field. The definition of domain in ABAP is same as that in Mathematics. In the world of Mathematics, a domain is defined as the set of input values that are valid for a given function. The same holds true for domains in ABAP. To understand this, let us first see what is the role of domains in ABAP data dictionary. Domains -> Data Elements -> (Structures, DB tables, program references etc.)
Read more

How to update exchange rates via process chain in BW

Image
 The exchange rate in the BW system may not be updated one. Also the business wants to see the amounts according to the exchange rates in the source. In such cases, you have to update the exchange rate in the BW system via process chain. Include the step ‘Execute ABAP Program’ in the process chain. Give the program name as ‘RSIMPCURR’. Create a variant for the program.
Read more

Sample ABAP program for Updating notepad file data to Internal table and Sending it to Application server

 *--Structure type TYPES: BEGIN OF TY_STD, RONO TYPE C LENGTH 4, NAME1 TYPE C LENGTH 20, GEN TYPE C LENGTH 6, FEES TYPE C LENGTH 10. END OF TY_STD. *--Header line and internal table DATA WKA TYPE TY_STD. DATA INT_TAB TYPE TABLE OF TY_STD. *--Application server files are known as "Datasets" *--here "fname" is the Dataset DATA FNAME TYPE C LENGTH 40 VALUE "StudentsInfo.txt". *--Convert notepad file data into internal table CALL FUNCTION 'GUI_UPLOAD' EXPORTING FILENAME = 'C:Documents and SettingsAdministratorDesktopstudents.txt' HAS FIELD_SEPARATOR = 'X' TABLES DATA_TAB = INT_TAB. *--Sending data to Application Server OPEN DATASET FNAME FOR OUTPUT IN TEXT MODE ENCODING DEFAULT. LOOP AT INT_TAB INTO WKA. TRANSFER WKA TO FNAME. ENDLOOP. CLOSE DATASET FNAME.
Read more