Home

SAP Learning Topics: (Double click on required topic)

1. HANA Cockpit                                                   
2. SAP License installation at OS level
3. SAP Router Configuration File - SAPRoutertab
4. SAP Router configuration and renew of the SAP router Certificate
5. Router-stopstart 
6. SAP HANA Studio
7. SAP Solution Manager 7.1 installation
8. HANA DB Locks
9. SAP HANA CPU
10. Information about HANA
11. SAP IDES ECC6 Installation - In The Cloud
12. HANA Memory management
13. To display the current size of the used memory in HANA
14. HANA Column/Row store Utlization
15. HANA Questions and answers
16. SAP HANA Export and Import Views
17. How to check SAP HANA table lock
18. How to check SAP HANA Schema Owner
19. HANA : Inactive version error while Object Import
20. Creating SAP HANA user
21. List all privileges granted to user
22. Backup for HANA system
23. HANA log and trace files path
24. How to create HANA DB schema and assign authorization
25. How to check HANA user's last login time and invalid connect attempts made
26. How to list and export all HANA configuration parameters
27. How to use SAP HANA HDBSQL to execute SQL commands at OS level
28. How to reset the HANA SYSTEM User password.
29. HANA BASIS Administrator roles and responsibilities
30. To stop/start HANA Database Services
31. Third Party ETL Tool Certification Program for SAP HANA
32. SAP NetWeaver BW on SAP HANA
33. HANA to Netweaver Gateway - connectivity steps
34. HANA (High performance analytics appliance)
35. SAP
36. XI/PI Error: HTTP 403 Forbidden
37. XI/PI -- Error: HTTP 400- Bad Request- ICM_HTTP_CONNECTION_FAILEDXI/PI
38. XI/PI - HTTP Code 200
39. XI/PI -- Error: HTTP_RESP_STATUS_CODE_NOT_OK 401
40. SSO (Single sighn on)
41. OPS$ Schema user creation
42. SUM TOOLS
43. SINGLE SIGN-ON TO SAP SYSTEMS
44. CREATING USERS AND ASSIGNING ROLES IN CUA AND TESTING
45. ONLINE AND OFFLINE REDOLOG FILES
46. SUM
47. INDEX
48. SAP Tables
49. SAP BASIS Transaction codes
50. Gateway start/stop
51. SAP Email configuration
52. SAP user lock problems
53. Oracle Performance
54. Trusted and Trusting RFC connections
55. RSMEMORY
56. SQL Quickviewer (SQVI) instead of use SE16
57. Program to change mass password in SAP
58. Oracle Startup, Parameter File and Oracle Cache Management: System Global Area (SGA) and Program Global Area (PGA)
59. Idle session time out / Logging off inactive users
60. To unlock the SAP system to perform correction(s) during an upgrade.
61. To initialize the live cache data in APO/SCM
62. Volume Manager
63. What is APO/Live cache ?
64. Oracle tables
65. Solaris Commands
66. TSK files (SWPM)
67. HANA Loads
68. Error 'different nametabs for table while transporting between two Systems that are on different releases or support pack levels.
69. Mismatch of component versions while import TR -STMS
70. System Rename
71. RFC error in STMS with 223
72. SSLERR_PEER_CERT_UNTRUSTED (peer certificate is not trusted)
73. SUM -HTTPS connection issue with SSLERR_PEER_CERT_UNTRUSTED
74. If TMSADM user get locked to unlock automatically
75. SUM-SAP ECC 6.0 EHP Upgrade errors and solutions
76. SAP ECC 6.0 Installation on linux
77. SAP After System Copy/Refresh ST03n if shows source name data in work analysis
78. Brief description of kernel executable files
79. DB2 Parameters
80. Time Zone difference issue between 000 and other clients
81. Shell Script to Check status of SAP whether Up or not
82. Configuration of Bar Code Printing in SAP
83. Export/Import Tables through BRTOOLS
84. Tables to edit
85. How to setup a trusted RFC connection between SAP systems

Router stop/start

Home

                                                                                                           
SAP Router Stop/Start

<Hostname>:usr/sap/saprouter/saprouter -r -R /usr/sap/saprouter/saprouttab
/usr/sap/saprouter> ./saprouter -r -K "p:CN=<hostname>, OU=000013449, OU=SAProuter, O=SAP, C=DE"


<Hostname>:/usr/sap/saprouter>  /usr/sap/saprouter/saprouttab -K “p:CN=<hostname>, OU=0003400660, OU=SAProuter, O=SAP, C=DE”

For starting..
saprouter@<hostname>:/usr/sap/saprouter> nohup ./saprouter -r -K "p:CN=<hostname>, OU=00003246449, OU=SAProuter, O=SAP, C=DE" &

For stopping..
./saprouter –s

Saprouter usful commends

start router : ./saprouter -r
stop router  : ./saprouter -s
soft shutdown: ./saprouter -p
router info  : ./saprouter -l (-L)
new routtab  : ./saprouter -n
toggle trace : ./saprouter -t
cancel route : ./saprouter -c id
dump buffers : ./saprouter -d
flush   "    : ./saprouter -f
hide errInfo : ./saprouter -z

SAP HANA Studio

Home


1.  HANA Studio?

The SAP HANA Studio is both the central development environment and the main administration tool for SAP HANA.


2. Execute individual SQL statements with SAP HANA Studio?

You can execute individual SQL statements (e.g. taken from the SQL statement collection in SAP Note 1969700) using the SQL console of SAP HANA Studio.

It is possible to open multiple SQL consoles and run several SQL statements in parallel.


3. To stop an individual SQL statement started with SAP HANA Studio?

If you have started to execute a SQL statement with SAP HANA Studio and problems arise (e.g. high memory consumption), you can terminate this statement via the "Cancel operation" button in the Progress View (Windows -> Show View -> Progress).


4. How to SQL statements in the SQL editor be formatted automatically?

You can optimize the formatting of SQL statements using the keyboard combination CTRL - SHIFT - O, e.g.:

Original statement:

sqlOriginal.JPG

Formatted statement:

sqlFormatted.JPG


5. SAP HANA Studio delivered with version number 2.x as of SPS 09?

As of SAP HANA SPS 09 SAP HANA Studio is delivered with version number 2.x while the SAP HANA software still has version number 1.x. This change is caused by the intension of SAP to decouple the versions of SAP HANA Studio and the SAP HANA database. It doesn't impact the compatibility, so you can use SAP HANA Studio version 2.x in combination with SAP HANA databases 1.x.


6. How to resolve problems displaying the load graph?

The load graph ("Administration" -> "Performance" -> "Load") is a useful tool to check for historic database figures like CPU consumption, memory consumption or SQL throughput, but there can be situations where it's not working properly or the performance is slow. In this case you can access the underlying information differently (e.g. via DBACOCKPIT or SQL) or adjust the memory limit for SAP HANA Studio. See SAP Note 2222110 ("What can I do if displaying the SAP HANA Studio load graph doesn't work?") for more information.


7. What can we do if other memory-intensive activities in SAP HANA Studio don't work?

If other activities in SAP HANA Studio with a high memory requirement like a large PlanViz evaluation fail, the adjustment of the SAP HANA Studio memory configuration as described in SAP Note 2159510 can help.


8. What can we do if opening the overview tab in the administration console takes a long time?

Opening the overview tab in the administration console often suffers from a high amount of SAP HANA alerts. If it takes many seconds or even minutes to open the overview tab, you can check according to SAP Note 2147247 if the number of alerts in table STATISTICS_ALERTS_BASE is too high and perform a cleanup.

9. Which SAP HANA Studio version should be used for a certain SAP HANA database?

SAP HANA Studio is downward compatible, but not upward compatible. This means that you should always use at least the SAP HANA Studio Revision that was delivered together with the SAP HANA server software in order to perform monitoring and development tasks.

In some cases a SAP HANA Studio version higher than the SAP HANA server version can also result in errors, see e.g. SAP Note 2337716. To be on the save side, you should use identical versions for SAP HANA Studio and SAP HANA whenever possible.

10. How does the SAP HANA Studio version correspond to the SAP HANA Revisions?

The SAP HANA Studio version and the SAP HANA SPS level correspond in the following way:

SAP HANA Studio	SAP HANA
2.0.x	SPS 09
2.1.x	SPS 10
2.2.x	SPS 11
2.3.x	SPS 12

Install SAP license at OS level

Home


1) Sample warning message of license expired

B) Steps to renew the license from SAP marketplace
1) Ensure the installation number for the license renewal:  System -> Status

2) Login to SAP marketplace: Keys & Requests -> License Keys -> Click on the relevant installation
    number

3) Click on the "Change details" icon for system that required license renewal.

4) Click "Continue"

5) Select the Certificate that required renewal and click "Change selected entry".

6) Click "Save"

7) Once the "Valid Until" shown the new date, click "Continue".

8) Enter the email address to receive the certificate and click "Submit".

9) Click "OK".

10) Request is being process ...

11) Wait for the email from SAP containing the new certificate details

12) Sample content of the new certificate.

C) Steps to perform the renewal at OS level

1) Example of insufficient permission to perform license renewal from SAP GUI

2) By using WINSCP or FTP, transfer the certificate received into the "prdadm" folder

3) File transfer successfully.

4) With PUTTY, login to OS level with root permission and perform the steps below:
    With root permission:
    - cd /home/prdadm
    - chmod 777 CERTICATE_FILE (change mode of the file)
    - chown prdadm:sapsys CERTICATE_FILE (change owner for the file)
    - su - prdadm

5) Execute the command highlighted below with prdadm
    With prdadm permission
    - cdpro
    - ls (to get the correct DVEBMGS name)
    - pwd (to get the correct path name)
    - ls (to get the copied certificate filename)
    - saplikey pf=path name + "/" + DVEBMGS name -install certificate filename

6) Once license installed successfully, the warning message no longer appear

SAP Router Configuration File - SAPRouter tb

Home


1) SAP Support team having problem to remote access the Solution Manager page (HTTP Access)
for further remote support

2) Initial finding shown the connection is ok.

3) Further finding shown, additional port required to be configure on the SAP router for HTTP access.

4) Sample of the configuration settings required.

5) To perform any changes on the SAP router configuration file, stop the SAProuter service.

6) Locate the "saprouttab" file (ex: c:/usr/sap/saprouter) and add the required ports.

7) Once the "saprouttab" changes complete, restart the "SAProuter" services.

8) SAP Global team should be able to remote access the page by now.

SAP Router configuration and renew of the SAP router Certificate

Home


The first thing needs to do, is to send a customer message to SAP
Support (component XX-SER-NET-OSS-NEW) and tell them to register the
hostname and IP of your new SAProuter.

You have to register it with a official IP address (no internal IPs
allowed), but it’s allowed to use NAT in the firewall/router.

After you’ve received a confirmation from SAP that your SAProuter has
been registered, you are ready to configure your SAProuter.

If your SAProuter directory is C:\usr\sap\saprouter, these are the steps
to follow.


1. Set two environment variables: SECUDIR and SNC_LIB

C:\usr\sap\saprouter

The environment variable SNC_LIB needs to be set for the user account
   SAProuter is running under.

   variable Name : SNC_LIB
   Variable Value : D:\usr\sap\saprouter\ntintel\sapcrypto.dll


Set the environment SECUDIR = <directory_of_saprouter>

   variable Name : SECUDIR
   Variable Value : D:\usr\sap\saprouter

                         

2. Download the SAP Crypto Library  from service market place.

Create folder d:\usr\sap\saprouter   - on system where you are installing
unpack the downloaded softwere into folder

Copy these files to saprouter folder
saprouter.exe
niping.exe
sapgen.exe

Then copy these files to saprouter folder
LEGAL.TXT
Ticket
LICENSE.txt
Saprouttab

Copy ntintel this folder to saprouter folder



3. To generate a certificate request, run the command:

sapgenpse get_pse -v -r certreq -p local.pse "CN=SOLMAN, OU=0000491517, OU=SAProuter, O=SAP, C=DE"

Note: You will be asked for a PIN code. Just pick your own 4 numbers, but
you’ll have to use the same PIN every time you’re asked to enter one.

Please enter PIN:
Please reenter PIN:

Supplied distinguished name: "CN=SOLMAN, OU=0000491517, OU=SAProuter, O=SAP, C=DE"
Generating key (RSA, 1024-bits) ... succeeded.
certificate creation... ok
PSE update... ok
PKRoot... ok
Generating certificate request... ok.


4. Then you have to follow the guide and request the certificate from
http://service.sap.com/tcs -> Download Area -> SAProuter Certificate

Go to http://service.sap.com/saprouter-sncadd

Request certificate for SAP Router

which will give the certifcate like below.

SAP Solution Manager 7.1 installation

Home

Installation of SAP Solution Manager in Windows platform compatible with Amazon / Azure Cloud / Hyper-V / Standalone server
The SAP Solution Manager 7.1 installation steps below suitable on all Windows server environment including Amazon Web Services (AWS), Microsoft Azure, Microsoft Hyper-V or standalone server installation.

These configurations including:

A) Prerequisite
B) Oracle Database Installation
C) SAP Solution Manager 7.1 Installation with SWPM
D) SAP GUI Installation and login the SAP Solution Manager for the first time
E) Others


A) Prerequisite:
1) Windows server 2008 be ready

2) Minimum SAP Solution Manager 7.1 installation files

Download Object	Title
50118243_6	NW 7.0 Presentation - 7.30 Compilation 2 Present. ½
51041940	ORACLE Client 11.2.0.3
51042334_1 – 6	ORACLE RDBMS 11.2.0.3 Windows x64
51042607_1 - 12	SAP SOLMAN 7.1 SR1 Inst. Export (2)
51042609_1 – 5	SAP SOLMAN 7.1 SR1 Java Comp
51042616_9	SL CONTROLLER 700
51046511_6	720 UC Kernel for SWPM SP03 - Windows Server on x64 64bit
70SWPM10SP02_4-20009707.sar	Software Provisioning Manager 1.0 SP2 for NW 7.0x

3) Recommended server specifications:

Type	Descriptions
OS	Windows Server 2012 Data Center
RAM	12GB
Hard disk	400GB (c:\ 100GB d:\300GB)

4) Reference for OS environment setup on AWS Cloud and Microsoft Hyper-V 

- AWS Cloud:  Section: AWS AMI Setup and Configurations (SAP IDES Installation)

- Microsoft Hyper-V: Section: A) Creating new VM in Hyper-V (setup Red Hat Enterprise Linux Server in Microsoft Hyper-V Server 2012)

5) Assumption:

     - The Windows OS will be configure as workgroup instead of joining a domain / active directory.

     - All the installation are mostly with default settings and further configurations or fine tune will be perform

        after the installation.

     - Windows OS been patched to latest update and some prerequisite steps as in SAP IDES Installation

     - The installation time estimation was based on a installation on Microsoft Hyper-V 2012 environment

        with the above mentioned hardware. In fact, the actual installation time might vary.

B) Oracle Database Installation:

1) Run the Oracle setup batch file "sapserver,cmd" to begin the database installation

 2) Enter the installation drive and SID

 3) Installation splash screen

 4) Click "Next"

 5) Click "Next" ignore the warning

 6) Select "Skip the software updates"

 7) Select " Install database software only"

 8) Select "single instance database installation"

 9) Click "Next"

 10) Select "Enterprise Edition"

 11) Choose the installation drive

 12) Wait for the verification process

 13) The verification process

 14) Click "Install" to begin the installation

 15) Click "Details" button to shown the installation progress

 16) The additional installation progress screen

 17) Wait until the installation complete and the click "Close" button

 18) Confirm the database been installed

B) SAP Solution Manager 7.1 Installation with SWPM

The installation process estimate will take about ~5 hours to complete with the above mentioned hardware specifications

1) Double click the "sapinst" extracted from SWPM - Section E) Others below shown how to extract the installation file with sapcar program

 2) Select "SAP Solution Manager 7.1 Support Release 1"

 3) Select "typical"

 4) The installation splash screen

 5) Select the SWPM kernel

 6) Enter the SAPSID and installation drive

 7) Configure the FQDN or it can be configure after the installation

 8) Enter the master password

 9) Enter the Oracle database ID created during the database installation

 10) Select the installation export package

 11) Select the other installation export package

 12) Click  "Next" with all the default settings

 13) Select the Java component package

 14) Ensure the installation drive are correct

 15) Click "Next" to accept the default listener configuration or change the port according to existing firewall

        policy

 16) Select the kernel package

 17) Select the Oracle client package

 18) Select "Configure a local SLD" in this example

 19) Enter the computer name in "Object Server Name"

 20) Click the "Next" button

 21) Click "Yes" button

 22) Click "No SLD destination" in this example

 23) Verify the selected options and click "Next" to accept all the settings

 24) The installation begin

 25) Example of the installation process

 26) Example of the installation process

 27) Example of the installation process

 28) Around ~5 hours for the installation to complete

 29) SAP management console and listener status command showing the SAP services are up and running

D) SAP GUI Installation and login the SAP Solution Manager for the first time

1) Perform the SAP GUI installation from the media kit: 50118243_6

2) The settings for the SAP logon

3) Login with user: "sap*"

4) The information screen

5) The relevant SAP system information

6) Login to the portal (http: port: 5<SID>00, https: port: 5<SID>01)

7) Main Menu of the portal

8) Use the default login: "j2ee_admin" and master password entered during installation

9) Sample of information screen

10) Again using the "j2ee_admin" for access

11) Sample of information screen

12) That's all on the basic steps to perform a new SAP Solution Manager installation.

13) Please refer to the common troubleshooting on SOLMAN_WORKCENTER post for further configurations or common errors troubleshooting

E) Others

How to extract the SWPM installation file with SAPCAR

1) Download the "Software Provisioning Manager 1.0 SP2 for NW 7.0x" from SAP marketplace

 2) Extract the sar file with SAPCAR -xvf <swpm filename.sar>

 3) The "sapinst" program use for the SAP Solution Manager installation

How to clear SWPM cache or resolve the SAP Solution Manager 7.1 selection node was not available for installation

After running the "sapinst", the "SAP Solution Manager 7.1 Support Release 1" option was not available and it seem appearing with different option ex: SAP Solution Manager 7.1 for HANA.

This happen due to the other SWPM was executed before and the files were cache and causing the other SWPM relevant selection node not updated.

1) Locate to "c:\users\Administrator\AppData\Local\Temp\2", delete all the files and folders contains in it

 2) Re-run the correct SWPM "sapinst" and the correct node would appear