Migration tips and tricks – Using latest software versions

No Comments

There are lot of pitfalls one may encounter in doing real life migration of BW on HANA. See this post for some tips to avoid them-

Use Latest Software versions

SAP HANA support packages are released quite frequently. Implement the latest SAP notes in your BW system using the tcode SNOTE.

SAP note 2021789 mentions which SAP HANA notes are specially verified for Production.

The following link provides latest revisions of SAP HANA software:

http://help.sap.com/hana/Whats_New_SAP_HANA_Platform_Release_Notes_en.pdf

Refer latest documentation

The HANA cookbook for BW for example, is not up to date for all topics. (http://cookbook.experiencesaphana.com/). You can use this cookbook as an introduction of basic concepts.

You should read available documents of SAP first Guidance Collection for SAP BW on SAP HANA present at below link-

http://scn.sap.com//docs/DOC-28467

SAP  has announced to update the cookbook soon.

Checking the Software Versions

You need to login to view the rest of the content. Please . Not a Member? Join Us

Post-Migration Steps – SAP BW on SAP HANA Specific

1 Comment

Below steps are specific for the BW system on HANA database-

Step 1: Deactivate password change for System Users

In the default settings, the system prompts at regular intervals for changing the passwords of SAP HANA users. This may cause issues for system users because the password may be stored in another system, or jobs are scheduled for them. If such kind of password changes and you don’t modify the environment accordingly, this may effect the operating procedure. So, you should deactivate the periodic password change for selected users. For security reasons, you must consider this carefully.

You can deactivate the  password change with the following statement:

ALTER USER SAP<SID> DISABLE PASSWORD LIFETIME.

Step 2: Adapt Privileges

As specified in SAP note 1897236, check whether the database user SAP <SID> has SELECT privileges for accessing the _SYS_REPO and _SYS_BIC schemas. You can use the following SQL command for this purpose:

SELECT GRANTEE, GRANTOR, OBJECT_TYPE, SCHEMA_NAME, PRIVILEGE, IS_GRANTABLE, IS_VALID FROM SYS.GRANTED_PRIVILEGES WHERE GRANTEE = 'SAP<SID>'

If the privileges are missing for these schemas, you must

You need to login to view the rest of the content. Please . Not a Member? Join Us

Post-Migration Steps – SAP BW Specific

No Comments

Once the Basis related activities are done after migration, you must carry out SAP  BW specific post migration activities.

Step 1: Restore Myself system and SAP BW source systems

The users are automatically locked out of SAP BW on HANA system. You should unlock the technical system users after migration. Do not release the end users still. In the source system tab in RSA1, check whether you can see the SAP BW myself system. Right click and select ‘Restore’.  Then also check and restore the other connected source systems. Here you may need to enter the passwords for the relevant background users. Check with the

You need to login to view the rest of the content. Please . Not a Member? Join Us

Post-Migration Steps – BASIS

No Comments

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

You need to login to view the rest of the content. Please . Not a Member? Join Us

Procedure for BW on HANA migration – Import Phase

No Comments

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.

You need to login to view the rest of the content. Please . Not a Member? Join Us

Procedure for BW on HANA migration – Import Preparations

No Comments

In Import phase, lesser activities are required. First step is to check the size of your file system so that sufficient storage is available for the target environment. As you generally deploy a certified SAP HANA appliance, this will be taken care automatically.

Before starting with the import, you should also set the log mode of the SAP HANA system to overwrite the existing log files during import. Otherwise migration may crash due to storage medium of log files becoming full in capacity.

You need to login to view the rest of the content. Please . Not a Member? Join Us

Procedure for BW on HANA migration – Export Phase

No Comments

After you’ve prepared your SAP BW system properly, you can start the export activities. First SAP BW system is exported, then the export files are made available in the target system for the new BW application server.

To reduce the time of the migration process, you can start the export and import process in parallel. In this case, you must save the export files in directory which you can access in the target environment. To create the necessary directory structures, you must call the SWPM in the SAP BW original system using the EXPORT PREPARATION option.

In your SWPM system, start sapinst or sapinst.exe with a user that has administrator rights. However don’t use the <SID>adm user for this purpose. Select your system version and currently used database from the overview. Choose SYSTEM COPY-SOURCE SYSTEM – BASED ON AS ABAP TOWARDS SAP HANA DB-EXPORT PREPARATION, and click NEXT.

You need to login to view the rest of the content. Please . Not a Member? Join Us

Procedure for BW on HANA migration – Export Preparations

No Comments

Below are listed some of the important Information material on BW on HANA migration-

After you have prepared your BW system for migration, it is time now to perform actual migration. The post will focus on manual migration in parts as this is the most used method in real scenarios.

We will take SAP BW 7.4 (ABAP stack) based on Oracle 11.2 as sample for describing migration steps. SAP BW application server is operated on separate hardware which is

You need to login to view the rest of the content. Please . Not a Member? Join Us

Additional Tools for BW Migration

No Comments

Online SAP resource to check the information on these tools for different versions:

http://scn.sap.com/docs/DOC-40984

ABAP Routine Analyzer

This tool enables you to analyze the performance of ABAP routines that are used in data flows. Here, you can see all the ABAP statements that should be optimized for performing on SAP HANA. To install the tool, download the attachment of the SAP note

You need to login to view the rest of the content. Please . Not a Member? Join Us

Preparing BW system for Migration – Validation and Checks

No Comments

After you have cleaned up your BW system successfully, you can go for sizing and identify the resource equipment for your SAP HANA appliance.

The next step now involves the system validation for smooth migration to BW on HANA. For this, SAP provides a checklist tool which you can use before migration.

This checklist tool details can be found in the SAP note 1729988. This note also has an attachment which allows you to download the zip file of the ABAP source code of the tool along with guide.

To install the tool, go to SE38 in your BW system and 

You need to login to view the rest of the content. Please . Not a Member? Join Us