Procedure for BW on HANA migration – Import Phase

 Once the import preparations are done, you can start with the process.

Before starting the SWPM in the target system, check whether you can access the export directory. You can access it via network using \<server name>directory.

If you are not able to access the directory, check your firewall settings.

Now start SWPM in the target server, and choose SAP BW version and SAP HANA database as the target database. Then select SYSTEM COPY-TARGET SYSTEM-STANDARD SYSTEM-BASED ON AS ABAP STANDARD SYSTEM, and click next.

Select 'typical' or 'custom' installation method. In the next screen, specify the SID of your SAP BW system. Then, enter the path to the SAP kernel and specify the administrator password.

Do not select the option 'START MIGRATION MONITOR MANUALLY'. Choose the default copy method for running the heterogenous system copy. Next, enter the connection parameters to your SAP HANA database.

In the next screen, enter the path to the SAP HANA client and then specify the path to the export files.

You can keep the default settings in the other input screens.

Warning Messages-

You can ignore the below warnings-

" two files rowstorelist.txt and HDB_TABLE_CLASSIFICATION.txt are missing"

Once you click next, enter the path tp the .sql file which can be downloaded from SAP note 1900822. But this option is only required for distributed SAP HANA database.

If you are using a single SAP HANA instance, you can choose 'DO NOT USE A PARAMETER FILE' option and skip this step.

In the next screen, provide import specific information.

Give the number of parallel processes, migration key, communication directory, instance number of your SAP system and the password for DDIC user from Client 000.

Finally. check all the parameters once. When you click next, the system starts the import of SAP BW on HANA system. Analyse the log files if any error occurs. The path to these files is displayed in the error message.

Example Error Message

"<SID>adm user of the SAP BW application server has no access rights for the export files"

If you are not able to solve the error message yourself, open the SAP customer message. You can select the below application components for opening a SAP customer message-

BC-INS-MIG-TLA

BC-INS-MIG

BC-DB-HDB-INS

See the next post for Post migration steps.

Comments

Post a Comment

Popular posts from this blog

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

OPEN SQL EXAMPLES IN ABAP – PART 2

 ******************************************* **displaying Raw Materials and Finished products **only from MARA table. DATA WA TYPE MARA. * **--WHERE clause is for filtering the records SELECT * FROM MARA INTO WA WHERE MTART = 'ROH' OR MTART = 'FERT'. WRITE: / WA-MATNR, WA-MBRSH, WA-MTART, WA-MEINS. ENDSELECT. * **************************************************
Read more

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