Services error and not running . Can't restart SLD or server tools

 ERROR:

SAP HANA System is not responding or services is not running.

If SLD can't access or HANA Studio status in RED, you need to run this command in SUSE Linux terminal;

1)  su - hdbadm

2) To stop HANA Database Engine service

    ./HDB stop

3) Wait until service stopped and run below command to start HANA Database Engine service

    ./HDB start

4)  Wait until service fully started

    exit

5) Return to root. Run below command to restart SLD services

    /etc/init.d/sapb1servertools restart

6)Wait until service fully restarted.

optional:

7) To restart service layer services

   /etc/init.d/b1s restart

8) SAP B1 HANA 2208 (Authentication Server required)

   service sapb1servertools-authentication restart

9) web Client 

     Goto /usr/sap/SAPBusinessOne/WebClient

     Type the below Commond

   

     ./startup.sh stop

     ./startup.sh start

    ./startup.sh restart

 

useful SUSE Linux command

 

1. How to check the version of SUSE  and Status

SUSEConnect --status-text

2.Make a directory(Folder) 

    =>mkdir testabc

 3.Listing Directory

     =>ls

4.Delete direcotory

   =>rmdir testabc

5.Navigate to folder

   =>cd testabc     =>cd ..           =>cd  \     navigate to root directory

--------------------------------------------------------------------------------------------

6.copy files to same directory

   =>testabc# cp testfile testfilecopy 

7.copy files to another directory

   =>cp testfile /home/software

8.pwd (print view directory)

The security certificate is not from a trusted certifying authority. SAP Business One is unable to connect to server

ERROR:

SOLUTION:

If certificate issues need to do the following:

1.     Delete existing certificate in Control Panel > Internet Option - under certificates tab

If there is no existing certificate, you can just ignore this one. If there is existing certificate you can delete it.

2.     Turnoff Anti-Virus / Firewall

3.     Go to C:\Users\USERNAME\AppData > Go to Local & Roaming and delete the SAP folder

4.     Edit the Conf file based on screenshot and change the localhost same as SLD (IP Address of the Server)

5.     Right click the SAP and run as Administrator

SAP HANA installation error Import of delivery units failed Cannot import delivery unit /hana/shared/HDB/global/hdb/auto_content/HANA_XS_BASE.tgz

 Error:

Solution:

try to run the the installation using the below command   

./hdblcm --action=install --hdbinst_server_import_content=off

or

./hdblcmgui --action=install --hdbinst_server_import_content=off

Crystal Report previous() Function

 sometimes we may need to check the duplicate record based on our  query . 

let's you have scenario  PO Number :1  have 2 GRPO which repeat the PO Qty  in another line of GRPO 2.

 to get rid of this we can use  Previous() Function in crystal report .

----------------------------------- Formula -----------------

if not onfirstrecord and {SP_PurchaseReport;1.POLineNum}=previous({SP_PurchaseReport;1.POLineNum}) and {SP_PurchaseReport;1.PODocEntry}=Previous({SP_PurchaseReport;1.PODocnry})

then 0

ELSE

{SP_PurchaseReport;1.Ordered Qty}

--------------------------formula ---------------------------------

 

2892338 - SAP HANA DB installation fails on SUSE 15 SP01 - /sbin/insserv - no such file or directory

 Symptom

When installing SAP HANA Database 2.0 SP04 on SUSE 15 SP01, the installer fails with the error message:

Installation of SAP HANA Database System failed.
INFO: Summary of critical errors
ERR :   Installation of SAP HANA Database System failed.
ERR :     Installation of SAP HANA Database failed
INFO:       Installation failed
INFO:         error installing
INFO:           Cannot create system
INFO:             installsapinit.sh FAILED
INFO:               Starting external program <PATH>/hana/shared/H09/global/hdb/saphostagent_setup/installsapinit.sh
INFO:                 Command line is: <PATH>hana/shared/H09/global/hdb/saphostagent_setup/installsapinit.sh
INFO:                 Output line 1: /sbin/insserv: No such file or directory

Environment

SAP HANA PLATFORM EDITION 2.0

Reproducing the Issue

1. Configure a new machine or a VM with SUSE 15 SP01
2. Login as a root
3. Run the installation of SAP HANA Database
4. Error occurs as indicated in the Symptom

Cause

The reason for this error is because the VM is missing the following insserv-compat package.

Resolution

To solve this issue, execute this command: zypper install insserv