Wednesday , 26 April 2017

Tag Archives: SAP

SAP Security Reports: Authorizations, Roles & Users

When we working on SAP tasks (implementation tasks, daily, weekly, mounthly operation tasks etc.), we have encounter the topic of Authorization, Roles & Users very often. SAP has provided a set comprehensive reports to help us on this. Under the User Information System (TCODE: SUIM), you can find a comprehensive reports as below can be used. Reports RSUSR000 : Currently …

Read More »

What is the importance of SYS_BIC, SYS_REPO, SYS_BI

A schema is just like a database folder. The relavant tabels are going to group together according to the particular schema definition. There are 3 types of schemas: User Defined Schema System Defined Schema SLT Derived Schema User Defined Schema is created by user (DBA or System Administrator) System Defined Schema Where all the list of tables views going to …

Read More »

Determining the Number of Work Processes

Procedure The context change for processes on Windows is more time-consuming compared to UNIX. Therefore, the recommended number of work processes is smaller than in UNIX systems. On Windows, the number of work processes is calculated according to the number of processor cores in the system and not according to the number of users. For more information, see the following …

Read More »

HANA Log Volume is full

Symptom The logvolume is full and the database doesn’t accept any new requests. Other Terms HANA, in-Memory, logvolume, full, no requests Reason and Prerequisites The log volume is full and the database does not respond or start anymore Solution 1. Stop the database: HDB stop 2. Change into the folder mnt00001 of the logvolume (Default: /usr/sap/<SID>/global/hdb/log): cd /usr/sap/<SID>/global/hdb/log/mnt00001 3. You …

Read More »

SAP Innovation Forum 2016 Presentations

     

Read More »

SAP HANA 403 Forbidden when accessing ALM (Application Lifecycle Management)

I am using SYSTEM login, which is no doubt the most “SAP_ALL” figures in SAP HANA Database. Unfortunately, without proper authorization you will see 403 – Forbidden just like the picture above. The problem starts when i access SAP HANA Application Lifecycle Management like picture below   Then I got this response   Then I added these roles: sap.hana.xs.lm.roles::Administrator sap.hana.xs.lm.roles::Display …

Read More »

How to unlock and reset Sap* and DDIC users

ABAP system running on Sybase ASE Server Login to Sybase ASE database using following command with Windows Command Prompt [crayon-59002bb7b6705600744846/] It will prompt for password [crayon-59002bb7b6716597458686/]   To check the account status for SAP* [crayon-59002bb7b671c097728926/] To unlock the SAP* account [crayon-59002bb7b6721003938605/]   To check the account status for DDIC [crayon-59002bb7b6725110845022/] To unlock the DDIC account [crayon-59002bb7b672a024084381/]   MANDT = SAP …

Read More »

SAP HANA Installation on the SandBox System for Educational Purpose

  Preparing system for SAP HANA installation Choosing hostname There are restrictions that apply to host names in SAP systems, see “SAP Note 611361 – Hostnames of SAP servers“. Basic rule as per this note: Maximum length of the hostname: up to 13 characters for SAP rel. 4.6 or higher In our case the hostname is “webserver“. Prepare the required …

Read More »