×

Sap Support

- Sap Support - Dump files for support

Log & Trace file

- Log and trace directories - Investigate backup log content
<

Tools : Hana Studio

- Installation - Using hana studio - Using Studio SQL Console

Tools : hdbsql

- Using hdbsql - hdbsql parameters - Executing SQL - Hiding header welcome message - Hiding column header - Update column delimiter - Formating output result - hdbsql and shell script

Tools : hdbrsutil

- hdbrsutil tips & tricks

Tools : Hana Cockpit

- Install hana cockpit 2 complete example - Un-Install hana cockpit 2
<

Disk

- Disk space used by log segments - Reclaim space from log segments - Retrieve table index space used on disk

Specific Operations

- Adding physical memory

Sap Hana User Privileges

- Role and privileges - Grant read access to a schema

Stored procedures

- Creating a procedure - Dropping a procedure - Compiling a procedure - Executing a procedure - Working with procedures - Using anonymous block

Sap Hana functions

- DateTime : ADD_YEARS - DateTime : EXTRACT

Parameters

- Configuring sap hana - Kill long queries automatically

SQL

- Sql guide line - How to use SQL -Sql references - Sql tips & tricks for tables

SQL Query

- SQL & Tables - SQL & syntaxes - How to practice SQL
<

Sap Hana Tables

- Managing tables - Various ways to create Tables - Sap Hana Tables - Sap Hana Temporary Tables

Table description & DDL

- Retrieve table description - Table description using table-columns-view - Table ddl with hana studio - Table ddl using 'get_object_definition' procedure - Table ddl using hdbsql

SELECT data

- Various ways to select data

INSERT data

- Various ways to insert data

Sap Hana Users

- Managing Users - Create user with hana studio - Create user with sql Script - Create multiple users in one go - Copy a user - Create User with SQL script - Create User via Hana Studio - Update User - Drop User

Create Standard User

- Create standard & personal User

Create Technical User

- Create a technical User - Create backup users - Create administrator users - Create Modeler User - Create Data provisioning User - Create Cockpit User - Create a user to unlock any users
<

Troubleshooting sap hana minicheck error :number of tables exceeds its maximum 4095

Running a minicheck may generate the following error :
Cannot get data provider outline
"SAP DBTech JDBC: [463]: number of tables exceeds its maximum: table count in statement exceeds its maximum:4095"
This is a simple problem related to a default configuration on how many tables can be access via an sap hana SQL query. The maximum table access parameter value is set to 4095 by default. Running minicheck is not a simple sql query. It requires to access

In this current situation, the total tables used in a database are more than 4095 tables.

In order to resolve the problem, you have to take off the maximum tables usage limitation. The limitation is maintained via the parameter "max_table_count_in_statement". The sap hana maximum tables parameter value has to be updated to 0.

Default "max_table_count_in_statement" value using hana studio

Change "max_table_count_in_statement" value to unlimited using hana studio

Updated "max_table_count_in_statement" value via hana studio


Running sap hana minicheck for regular tenant database checkup

A quick wait to find out, how a tenant database is performing, is to run the minicheck now and then. Specialy now if the database is showing any performance weakness. A database is going to evolve as far as data is concerned. With time more analytical data is going to be recorded. Minicheck report will return more relevant details. A minicheck report takes around 3 minutes to complete.

Downloading, Installing, Running sap hana minicheck.

Sap hana SQL

Sap hana tools

- - -