Symptom

Could not execute 'EXPORT REORG_LOCATIONS_EXPORT AS CSV INTO '/tmp'' SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Solution

Execute with the same schema user and grant EXPORT in system privilege 

Hope this helps!!!

Abraham

Grant select privilege on table in sys schema

Symptom

SAP DBTech JDBC: [259]: invalid table name: REORG_PLAN_EXPORT: line 1 col 12 (at pos 11)

Could not execute 'CREATE TABLE REORG_PLAN_EXPORT AS (SELECT * FROM SYS.REORG_PLAN_)'

SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Solution

You need select authorization on schema SYS in order to execute this.

If you want to grant select access on SYS schema then you can grant SAP_INTERNAL_HANA_SUPPORT role to the user

How to check GPFS file systems logs

1.How to check  GPFS file systems logs

1. Go to path /var/ad/ras
2. ls -latr|grep mmfs
3. You will find the below files :

mmfs.log.previous
mmfs.log.latest

2. Start the GPFS file system:

Command :mmsatrtup

3. To identify which nodes in the cluster have daemons up or down, issue:

mmgetstate -L -a

Hope this helps!!!

Abraham

Copy User Variants for Table Controls

Symptom

You want to copy a variant created by 1 user to other users.

Solution 

1. Use program RSTCX_COPY_TCVARIANT.

2. In se38 execute the program .

3. Provide the input details :

Program name : Program name of the t-code in which you want to set the variant

User : User who created the variant

Variant Name: name of the variant to be assigned

For User : List of users to whom variant has to be copied

Hope this helps!!!

Abraham

How do you cancel a running backup in HANA

To cancel a running backup, please use the following 3 SQL statements in HANA studio:

1. Get the backup_id of your running backup:

select BACKUP_ID from "SYS"."M_BACKUP_CATALOG" where entry_type_name = 'complete data backup' and state_name = 'running'  order by sys_start_time desc

2. Cancel the backup

backup cancel <backup_id>

3. Confirm the backup has cancelled

select state_name from "SYS"."M_BACKUP_CATALOG" where backup_id = <backup_id>

4. Check to  make sure there are no running backups still

select * from  "SYS"."M_BACKUP_CATALOG" where STATE_NAME = 'running';

If the backup still exists, you can try to cancel the thread through the commands:

ALTER SYSTEM CANCEL SESSION <Session_ID> ;

ALTER SYSTEM DISCONNECT SESSION <Session_ID> ;

From backend Linux

1. As per the SAP Note 2452735 confirm there are no backup currently running.

select * from "SYS"."M_BACKUP_CATALOG" where STATE_NAME = 'running';

2. Run the ps command to get the listing of zombie hdbbackint processes belonging to the database backup

ps -ef | grep hdbbackint | grep COMPLETE

Sending signal 9 using the "kill" command will destroy the process running on the client. 

kill -9 PID

where PID is the process id of the zombie hdbbackint process. 

You will need to be a root user to execute the kill command

Include authorization profile in a role

Steps how to include a authorization profile in a role.

1. T-code PFCG --->Give Role Name --->Eg: TEST_SAP_ALL
2. Create as single role .

3. Provide a description and Click on Authorization TAB

4. Save Now Yes

5. Click on Change Authorization Data

6.Do not Select template

7.

8.

9.

10.Then you can see the role has complete authorization.

11. Generate the profile using the generate button .

Hope this helps!!!

Abraham

Resource Usage Exceeds Limit ,Resource =Number Buffer

Symptom

Logs in SM21

Resource Usage Exceeds Limit (Resource =Number Buffer,Limit =1000,Curr=1099)

Server Resources are exhausted with high usage ,too many number buffer

Reason and Prerequisites

Current Number Range Buffer exceeded the allocated number 

Check T-code - SM56

Solution

1. Check which objects are having maximum number of entries.

Goto -->Entries

2.  Reset the number range buffer in SM56

Goto--> Number Range Buffer --> Reset

Also a system restart will clear the number range buffer 

Hope this helps!!!

Abraham