How to enable and disable HANA Client Trace

Use hdbodbc_cons for tracing applications based on ODBC and hdbsqldbc_cons for tracing applications based on SQLDBC.

Use blow syntax

hdbodbc_cons.exe trace <level> <on/off>

Where levels are:
             api: tracing of ODBC api calls
             debug: detailed tracing of whole call stack
             sql: tracing of sql commands as well as output and parameter handling

Before you trun on trace, first configure the trace file name.

C:\Program Files\sap\hdbclient>hdbodbc_cons.exe config trace filename C:\temp\hdbodbc_trace.log

To turn on/off trace use below examples

Tracing of sql commands as well as output and parameter handling
          C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace sql on
          C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace sql off

Detailed tracing of whole call stack
          C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace debug on
          C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace debug off

Tracing of ODBC api calls
           C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace api on
           C:\Program Files\sap\hdbclient>hdbodbc_cons.exe trace api off

Reference:-
SAP Note: 1993254 - Collecting ODBC Trace
SAP Note: 1993251 - Collecting SQLDBC Trace

Regards,

Satishbabu Gunukula, Oracle ACE

http://www.oracleracexpert.com

error while loading shared libraries: libSQLDBCHDB.so

While installing SAP HANA Database system I have received following error.

Do you want to create a customer incident? You can now:
Choose OK to create the support SAPCAR archive SUPPORT.SAR
Choose Stop to stop the task and continue later

We don't know what causing the issue and need to find the error from log file.

I found below error in log file "R3load.exe.log" under "/install/tmp/sapinst_instdir/BS2013SR2/ERP607SR2/HDB/INSTALL/DISTRIBUTED/ABAP/DB"
usr/sap/BWE/SYS/exe/uc/linuxx86_64/R3load: error while loading shared libraries: libSQLDBCHDB.so: cannot open shared object file: No such file or directory

By looking the error it looks like shared libraries libSQLDBCHDB is missing. This library is related to hana client and installation will use the client to connect to the database.

I want to make sure that library exists or not and ran find command. I was able to find the library

find . -name libSQLDBCHDB.so -print
./HANA/hdbclient/libSQLDBCHDB.so

That means library exists but not able to use this connect to HANA database. It looks like the issue is with Environment variable

When you come across this issue with HANA Client, make sure to check following
1. LD_LIBRARY_PATH is set properly
2. SAPSYSTEMNAME & DBMS_TYPE is set

In my case LD_LIBRARY_PATH library path does not have "hdbclcient" path, after updating correct path I was able to install successfully.

LD_LIBRARY_PATH=/usr/sap/HANA/SYS/exe/run:/usr/sap/HANA/SYS/exe/uc/linuxx86_64:/usr/sap/HANA/hdbclient

Note: You might receive this error during the maintenance also

Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com