Introduction

This document is a technical FAQ about installation, upgrade and uninstalling of SAP HANA, SAP Business One, analytics powered by SAP HANA and SAP Business One, version for SAP HANA. Please refer to installation guide of SAP HANA, BUSINESS ONE ANALYTICS and BUSINESS ONE HANA admin guide for more details.
https://help.sap.com/hana_appliance
SAP Business One on HANA Products FAQ
SAP Business One, version for SAP HANA: Bare Metal to Live System

What are my choices for Linux graphical environments?

The Linux environment provides a Graphical Windows Desktop environment similar to what is available on a Microsoft Windows system.  The Desktop environment can be used to start graphical Linux applications referred to as xWindows, x-Windows or xApps depending on the Linux distribution.  In this document the term xWindows is used. When connecting to a Linux server from a MS-Windows system you can start xWindows applications using an xWindows client or you can start the Desktop and then start the xWindows application.  The details can be found below.

How to logon to Linux?

Option 1: Sitting at the Linux server and logging on as root
Sit at the server and logon using the attached keyboard.
The server will prompt you for user ID and password.  Enter root for user ID followed by the password for the root user. If there is a black screen with a flashing cursor, similar to the command line in windows, the graphical desktop is not started.  You start the graphical desktop with the command startx.
Option 2: Use Putty to log on, from Windows,  with console.
You can download the putty client from: https://www.putty.org/.
You can connect to the Linux host from Windows using the putty ssh client.  You will be presented with a Linux console window.  There is a screenshot of this window below.
Option 3: Logging on desktop environment with VNC/Xming etc.
The Linux environment provides a Graphical Windows Desktop environment similar to what is available on a Microsoft Windows system.  The desktop environment can be used to start graphical Linux applications referred to as xWindows, x-Windows or xApps depending on the Linux distribution.  Only SuSE is certified for SAP Business One.  In this document the term xWindows is used. When connecting to a Linux server from a MS-Windows system you can start xWindows applications using an xWindows client or you can start the Desktop and then start the xWindows application.  The details can be found below.
VNC and Xming are both X-Windows clients that display Linux graphical windows on a PC that is connected to the server.
In order to use VNC or Xming you need an SSH client like putty, described above.
VNC:  Can be configured to start the Linux graphical Desktop
Xming:  Uses an SSH connection and draws Linux graphics on a MS-Windows desktop
How to use VNC:
  1. Use an SSH client to logon the Linux Server
  2. Start the VNC server in the terminal using the command:  vncserver :1
    1. The :1 can be any number you must note the number because it is a required parameter to make a connection to the server using the VNC client
    2. If you are starting VNC for the first time you will be asked to input a password.  You will be prompted for this password when you connect from your windows desktop.
3. Open VNC client and logon with the password you just set. You can provide the VNC client Linux IP address: desktop number or Linux hostname: desktop number)
The VNC viewer(realvnc) can be download here
VNC starts with the setting in the file named xstartup in <>.
If you want the Linux desktop to start the file should contain:
#!/bin/sh
xrdb $HOME/.Xresources
xsetroot -solid grey
xterm -geometry 80×24+10+10 -ls -title “$VNCDESKTOP Desktop” &
/usr/bin/gnome-session
The last line “/usr/bin/gnome-session” in the file calls the desktop, if it is not there xterm will start and not the graphical desktop.
How to use Putty and Xming together:
  1. On the windows desktop start Xming it will now listen for including xWindows requests.
  2. Start putty, and input the remote Linux desktop IP address.
3. Configure X11 to enable X11 forwarding
Most likely, Xming is listening on port 0.0.  You can hover over the icon on the taskbar to confirm the port number.
If you see 0.0 you can enter :0, like we show below.

 
 
4.    Navigate to the session category enter a saved session name and click save.  This way you do not have to renter the logon details every time you want to connect.

5.    Press Open button, then input the user and password of the Linux server.
Now, with putty configured and Xming running, you can run graphical tools such hdbsetup or the open text editor using the command “gedit”.  A simple test of the graphical interface is a program called xeyes.  Entering xeyes on the console should show you pair of eyes watching you and following the mouse see the image below.

How do I rename the Linux host?

You can rename the Linux host using yast.  Select Network Devices ==> Network Settings
In Network Settings select the configured device (the one with an IP address).
Tab to the Edit option or press -i and tab to the hostname
hange the hostname to the desired value.  Tab to next followed by ok.
You can accomplish the same on the console.  The hostname is stored in the following files:
  • /etc/hostname
  • /etc/hosts there is a reference here defining local host and it must be updated.
After changing the hostname you should restart the server.  You can use the reboot command or shutdown –r “now”

Can I change the hostname after installing SAP HANA, SAP BUSINESS ONE HANA, or SAP BUSINESS ONE ANALYTICS?

If you change the name of you HANA host you can use hdbrename, described in note 1780950, to update your HANA system.
We do not recommend changing the hostname after installing SAP Business One software.  If you must change the hostname you must reinstall the SAP software post change. Details can be found in note 1719509.  Before reinstalling try note 1999390 – How to configure the SAP Business One, version for SAP HANA system after the network environment changes.

How to extract “SAR” file?

The HANA installation downloaded from SAP Service Market Place is a SAR file requiring “SAPCAR” tool to extract the installation program.
1. Download SAPCAR:
Support Packages and Patches | SAP Support Portal=>Support Packages and Patches=>Software Downlaod=>Search the download with keyword “SAPCAR”
=>Select the latest version of SAPCAR
=>Select the correct version for your target OS.
Recommendations:
  • Download the HANA Installation CD in the HANA linux server directly,
  • Download the latest version of the SAPCAR tool for your linux server,
  • Extract the HANA installation in Linux Server directly rather than extract in a windows machine, then transfer the HANA installation CD from the windows machine to Linux Server for the installation.
2. Copy the sapcar****.exe tool to the folder where SAR files locate.
For SAP HANA components to be installed in Linux, It is recommended to upload the SAR file to the Linux server and use the Linux version of SAPCAR to decompress them.  The next section provides the steps to do this on the Linux platform.

Often you download a program with a name like SAPCAR_315-20010449.EXE which makes no sense because the extension means nothing to Linux,so you can change the name to SAPCAR using the command below:

mv SAPCAR_315-20010449.EXE SAPCAR

3. Run the follow command with SAPCAR tool to extract
sapcar*****.exe –xvf  YOUR_SAR_FILE_NAME.SAR [-manifest SIGNATURE.SMF]

In the command above, replace the following file before execution.

–  sapcar*****.exe with the exact sapcar executable name

–  YOUR_SAR_FILE_NAME.SAR with the SAR file name.

–  The command is case sensitive

Optional Parameters:

-manifest SIGNATURE.SMF: This option is to generate SINGATURE.SMF required required by hdblcm/hdblcmgui tool to install the several SAP HANA Components since SAP HANA Rev 100.

You should only use the parameter when extracting SAP HANA DB Engine, not for the other components, for only one SINGATURE.SMF is needed.

 

For example:
SAPCAR -xvf “IMDB_SERVER100_102_3.SAR” -manifest SIGNATURE.SMF
The command above extract the SAP HANA DB Engine rev 102.3 and also generate a SINGATURE.SMF.
If the linux command above return with “Permission denied”, please run the following command to grant execute permission.
chmod 754 SAPCAR
Linux server steps:
1.    Is the same as Windows, except you download the Linux version not the Windows version.
2.   Upload the downloaded SAPCAR  file to the directory where you will use it
3.    Logon to the Linux server and set the execution bit on SAPCAR using chmod 754 SAPCAR
4.    Run the follow command with SAPCAR tool to extract SAPCAR –xvf

How to exchange files between Linux and Windows?

There are many tools that you can use to transfer files from Windows to Linux.  The list below is just a subset, Google can help you find more.
Tool Location
Windows ftp client Included with MS-Windows.  Called from command line using ftp
winscp https://winscp.net/eng/index.php
FileZilla https://sourceforge.net/projects/filezilla/files/FileZilla_Client/3.5.3/FileZilla_3.5.3_win32-setup.exe/download?_test=xmerch1
If you downloaded the files to your windows desktop you will have to transfer the files from the Windows system to the Linux system.  The Linux server ships with a version of Mozilla installed you can use this tool to download the Linux components directly to the server.

How to install SAP HANA?
Please refer to SAP HANA installation guide for detail, this section just brief the general procedure of SAP HANA installation for BUSINESS ONE ANALYTICS and BUSINESS ONE HANA.

  1. Download the SAP HANA DATABASE package version required.
https://support.sap.com/software/business-one.html (S-user required). Then select the path as below
-> Installation
-> Please select the product accordingly:
Option 1: for BUSINESS ONE ANALYTICS installation, please select SAP Business One, analytics powered by SAP HANA
Option 2: for BUSINESS ONE HANA installation, please select SAP Business One, version for SAP HANA
-> SAP B1 ANALYTICS ON HANA 1.0 or SAP B1 882 version for SAP HANA
-> Comprised software component Versions
-> SAP HANA PLATFORM EDIT. 1.0 FOR B1
-> Operating System
-> Linux on x86 64 64bit.
Download the HANA version recommended for your SAP Business One version
2. [Optional] only applicable when the installation CD is not downloaded in the HANA Linux Server.Then Copy the downloaded package in a folder inside the Linux server.
3. Extract the content of the package using SAPCAR tool. Refer to How to extract “SAR” file below for detail.
4. Enable the execute permission of HANA install program for root user with Linux commands:
“chmod 754 hdb*”
“chmod 754 sbrun”
Note: You need to navigate the folder before running the command “chmod 754 hdb*”.
“hdb*” files are the HANA installation program, which can be found in /SAP_HANA_DATABASE_41/.
“sbrun” file can be found in (/SAP_HANA_DATABASE_41/instruntime). You need to navigate the folder before running the command “chmod 754 sbrun.  This will give the files owner read, write, and execute.  Members of the group that owns the file will have read execute.
5.Run “./hdbinst” command from the SAP_HANA_DATABASE folder if you want to use the command line installer.
Or run “./hdbsetup” to launch the graphical installation wizard if you have enabled xWindows as described in the x-windows section above.
Since HANA 1.0 SP07(Rev 70 onwards), hdblcm installation are introduced to install the all HANA component in the same folder instead of install each HANA component one be one.
“./hdblcm”  –command line installation
“./hdblcmgui”  –[recommended]Graphical installation wizard
Prerequisite: To place all the target HANA component installation CD in the same folder, for example,
I would like to install HANA Rev 85.3 with hdblcm tool, I create the following HANA installation CD hierarchy in file system
<> –folder created by manual.
     <> –HANA server installer folder after extraction
     <> –HANA AFL installer folder after extraction
     <> –HANA Client 64 installer, extract it folder name as SAP_HANA_CLIENT, then rename to SAP_HANA_CLIENT_64 to differentiate from the 32 bit HANA client which by default has the same folder name as SAP_HANA_CLIENT.
     <> –As above.
Then just launch the hdblcm or hdblcmgui in <>
6. The following parameters are required for the SAP HANA Database installation:
HANA System ID: NDB
HANA Instance Number: 00
Note: The following paths /hana_shared, /hana_data, /hana_log are just samples of a HANA linux server partition, which may be different from vendor to vendor. You should select the following installation path, data path, log path etc. accordingly. It is recommended to install HANA, its data and log to the bigger partition instead of default path from the installation, which is pointing to the root partition.(/usr/sap/…)
HANA Installation Path: /hana_shared/sap
System Administration Home Directory: /usr/sap/NDB/home
Location of Data Volumes: /hana_data
Location of Log Volumes: /hana_log
Auto start when OS starts: Y

What do I do if the HANA installation hardware check fails?

If the HANA installation fails because the hardware check fails follow the steps in SAP Customer note 1658845

https://service.sap.com/sap/support/notes/1658845.

How to upgrade an existing SAP HANA?

  1. Download the SAP HANA DATABASE package version required.
https://support.sap.com/software/business-one.html (S-user required). Then select the path as below
-> Updates
-> Please select the product accordingly:
Option 1: for BUSINESS ONE ANALYTICS installation, please select SAP Business One, analytics powered by SAP HANA
Option 2: for BUSINESS ONE HANA installation, please select SAP Business One, version for SAP HANA
-> SAP B1 ANALYTICS ON HANA 1.0 or SAP B1 882 version for SAP HANA
-> Comprised software component Versions
-> SAP HANA PLATFORM EDIT. 1.0 FOR B1
-> Operating System
-> Linux on x86 64 64bit.
  2.Copy the downloaded package in a folder inside the Linux server.
  3.Extract the content of the package using SAPCAR tool. Refer the question about How to extract “.SAR” file
  4.Log on to the HANA Linux server with root user.
  5.Enable the execute permission of HANA install program for root user with Linux commands:
“chmod 754 hdb*”
“chmod 754 sbrun”
or simply with one command: “chmod 754 *”
Note: You need to navigate the folder before running the command “chmod 754 hdb*”.
“hdb*” files are the HANA installation program, which can be found /SAP_HANA_DATABASE_41/.
“sbrun” file can be found in (/SAP_HANA_DATABASE_41/instruntime). You need to navigate the folder before running the command “chmod 754 sbrun.  This will give the files owner read, write, and execute.  Members of the group that owns the file will have read execute.
6. Run “./hdbupd” command from the SAP_HANA_DATABASE folder that will be created after extracting the package content.

How to uninstall SAP HANA?

  1. Log on to the HANA Linux server with root user.
  2. Go to the installation path of your SAP HANA Database (by default /usr/sap/NDB)
  3. Then go to the folder where installation binaries are stored: For example: /usr/sap/NDB/global/hdb/install/bin
  4. Run “./hdbuninst” and follow the instructions

How to install SAP Business One, analytics powered by SAP HANA

The following section is just for reference, if you need to have detailed instructions on the installation of any SAP product, please read the Administration guide.
Please check the perquisites and installation steps from the SAP Business One Analytics Administrator guide.

Download:

Download BUSINESS ONE ANALYTICS installation or upgrade patch:
http://service.sap.com/sbo-swcenter
->SAP Business One Products
->Upgrade
->SAP Business One Analytics, powered by SAP HANA
->SAP B1 ANALYTICS ON HANA 1.0
->Comprised Software Component Versions

Prerequisite:

  1. HANA server should be able to telnet the B1 DB Server. E.g. with Linux command:
    telnet YOUR_B1_DB_SERVER_IP_OR_SERVERNAME 1433

    Make sure the port of SQL Server DB instance are enabled in the firewall.

  A configuration sample of /etc/hosts
     2. B1 DB Server should be able to telnet the HANA server. E.g:
telnet YOUR_HANA_Server_IP_OR_SERVERNAME 30015
You can disable the Linux firewall pre-install to ensure that it does not interfere where the required communication.  You do this in yast.
Yast ==> Security and Users ==> Firewall
If the firewall is running you can stop it using -t.  You can also change the setting to disabled so it does not start automatically.
Mare sure the port 8080, 8005, 8443, 30015 are enabled firewall of HANA server, if there is a firewall. It is recommended to add the IP and Server Name pairs of HANA server into the hosts of B1 DB Server. <<…WindowsSystem32Driversetchosts>>

General Installation Procedure:

  1. Copy the BUSINESS ONE ANALYTICS installation package to Linux server
  2. Log on Linux with root user
  3. Change the permission to enable execution of BUSINESS ONE ANALYTICS_Installation_CD/InstData/VM/ directory with Linux command:
    chmod –R 754 *
  4. Launch the installation by run ./install.bin from BUSINESS ONE ANALYTICS_Installation_CD/InstData/VM/ directory.  You must have an xWindows client running when you do this, there is no console mode install. 
During the installation, the following password will be required for
-ndbadm (Linux OS user for HANA administration)
-SYSTEM (HANA DB instance administrator)
You will be prompted to set the password for user admin which is used to access the BUSINESS ONE ANALYTICS Admin Console

How to upgrade SAP Business One Analytics powered by SAP HANA?

Please check the perquisites and installation steps from the SAP Business One Analytics Administrator guide.

General Installation Procedure:

  1. Before upgrading B1 Analytics, please stop all the replication from BUSINESS ONE ANALYTICS admin Console which already start the replication, otherwise you may have some error below during upgrade.
  2. Copy the BUSINESS ONE ANALYTICS installation package to Linux server
  3. Log on Linux with root user
  4. Change the permission to enable execution of BUSINESS ONE ANALYTICS_Installation_CD/InstData/VM/ directory with Linux command:
    chmod –R 754 *
  5. Launch the installation by run ./upgrade from BUSINESS ONE ANALYTICS_Installation_CD/InstData/VM/ directory

How to uninstall SAP Business One Analytics powered by SAP HANA?

  1. Log on to HANA Server with root user
  2. Go to /_BUSINESS ONE ANALYTICS_installation.
Example: /opt/sap/SAPBusinessOne/_BUSINESS ONE ANALYTICS_installation
  1. Run “./Change_BUSINESS ONE ANALYTICS_installation” to launch the uninstallation.

How to Install BUSINESS ONE version for SAP HANA?

Please refer to the Admin Guide of BUSINESS ONE HANA for detail.
Be sure to have HANA client installed in B1 Server machines. Otherwise, HANA DB type may not be listed during the installation.

How to install the analytics component for BUSINESS ONE HANA?

Please refer to the Admin Guide of BUSINESS ONE HANA for detail. BUSINESS ONE HANA have equivalent analytics component to BUSINESS ONE ANALYTICS, its installation package can be found at <>.
  1. Copy the B1 analytics folder to HANA server
  2. The installation of B1 analytics for BUSINESS ONE HANA is every similar to BUSINESS ONE ANALYTICS installation. Please refer to How to install BUSINESS ONE ANALYTICS for details.

How to reset password for HANA administrator “ndbadm”?

If you have a business reason to change the password for HANA OS user ndbadm follow the steps below.
  1. Open the Linux terminal on SAP HANA database server.
  2. Logon as root user.
  3. Reset the password of ndbadm with command “passwd ndbadm”

What HANA components need to be installed on the Business One Client machine?

HANA client is required for B1 Client, in order to use interactive analytics.  If you are running the 32-bit version of Business One please install the 32-bit version of the HANA client for Business One client. If the SAP HANA Studio is installed you will also need the 64-bit version of the HANA client.
If you are running the 64 bit version of the Business One you need to install the 64-bit version of the HANA client.

What Linux component are required for SAP Business One 9.0?

Before installing SAP Business One ServerTools and Server, please make sure the following software components are installed properly in HANA server.

SuSE Enterprise Linux components
libstdc++46 32 bit Used by Linux HANA client 32 bit installation
Libgthread 32bit Used by Linux HANA client 32 bit installation
Samba B1H Server installation for B1_SHR
libgcrypt B1H Server installation for SBO-COMMON and Demo DB creation)
libaio B1H Server installation for SBO-COMMON and Demo DB creation)
SAP HANA components