SAP B1 HANA Crystal Report Connection Setup

 

SAP HANA Crystal Report setup required  ODBC to Setup.

ODBC:

ODBC RDO Connection String

DRIVER={B1CRHPROXY};SERVERNODE=Server IP:30013;DATABASE=SBODEMOAU;databaseName=HDB

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