Sap HanaOne on AWS – Migration and Upgrade Guide Rev 48 -> Rev 52.1 -> HANA SP6 Rev68

Sap HanaOne on AWS  – Migration and Upgrade Guide:

Rev 48 -> Rev 52.1 -> HANA SP6 Rev68

• Take backup of old instance  Rev 48 from Hana Studio or AWS HanaOne Console.
• The backup files are stored on the Hana One Server at /backup/HDB/data with the prefix (COMPLETE_DATA_BACKUP).
• Launch a new instance of 52.1 on AWS.
• Take Backup HANA database of the new instance of 52.1 ONLY from Hana One Console.
• Logon to the AWS Hana One console and check if everything is working properly.  Do the same with Hana Studio Administration Tab.
• Check that all services such as Nameserver, Indexserver, Preprocessor, Statisticsserver, XS Engine are showing green from AWS Hana One console as well as from Hana Studio.
• From AWS HanaOne console 52.1 -> select AddOns -> click on  HANASP6   Ver68 -> download and install.
• Wait 20-30 minutes for the Upgrade to take place.  After successful Upgrade the version changes to Rev68 and is shown in the installed tab.
• STOP the Hana EC2 instance on AWS console.
• START the Hana EC2 instance on AWS console.
• Next, one critical step to perform is to start the Scriptserver, from Hana Studio Administration tab by changing the parameters from 0 to 1 at 2 locations in the daemon.ini -> scriptserver.  Scriptserver is not started by default, which is leads to the HDBDAEMON FAILURE while recover, and hence resulting in complete FAILURE of hana instance.

Note : SAP has not mentioned anywhere about starting the scriptserver during backup and recovery operations and it is not a mandatory step, but we found out through server side research that the scriptserver is being called while recovery and hence leading to hdbdaemon failure when scriptserver is not running.

• Now, upload the backed-up files to the Upgraded HanaOne Rev68 at /backup/HDB/data using WinSCP.
• Login to this server from PuTTy as root and go to the above location and change the permissions of all the backed-up files to show the owner as hdbadm:sapsys with the following command:
• chown – R hdbadm:sapsys COMPLETE_DATA_BACKUP_*.*
• ls –lrt shows the listing of the files with changed owner.
• Download and Install the Rev 68 HanaStudio and Client from Downloads tab on AWS HanaOne Console.
• Check whether all servers are running as above, including the ScriptServer.
• Right click on Added Instance in HanaStudio -> click on RECOVER -> console opens up asking for HDBADM (<sid>ADM) password -> provide the password.
• Agree to shutdown the system and then select only a specific data backup option.
• Specify the backup files.
• Check all the parameter and click on Finish button to start recovery.  Ignore new license key install.
• Wait till recovery is complete and after successful recovery, you will see the following message.
• System HDB was recovered successfully.
• Open HanaStudio Rev68 and do Testing of the migrated Catalog Tables and Content Packages.

Thanks,

Shambhu Yadav