SAP Knowledge Base Article - Preview

3353689 - R3trans -d runs for more than 60 seconds with HANA DB

Symptom

When running R3trans -d from an ABAP application server to test connectivity to the HANA database, the command runs for an abnormally long time (60 seconds+) yet ends in a successful code 0:

R3trans -d
This is R3trans version <version number> (<SAP kernel version details>).
unicode enabled version
R3trans finished (0000).

When reviewing the trans.log written to the directory where R3trans -d was run, you see the following:

cat trans.log
4 ETW000  [     dev trc,00000]  -------------------------------------------------------------
4 ETW000  [     dev trc,00000]  Now I'm connected to HDB
4 ETW000  [     dev trc,00000]  00: <hostname>/00, connection_id=<connection ID>, since=<timestamp>, ABAP=<unknown>
4 ETW000  [dbcon.c     ,00000]  *** ERROR => Opening of connection 0 took longer than 1000ms - Please check your network and connection settings.
4 ETW000  [     dev trc,00000]  Connection 0 opened (DBSL handle 0) -> DBSL operation took 180229 ms
4 ETW000  [     dev trc,00000]  INFO : SAP RELEASE (DB) = <SAP_BASIS version>
4 ETW000 Connected to DBMS = HDB ---  SERVER = '' PORT = '' --- SYSTEM = '<SID>'.


Read more...

Environment

  • SAP NetWeaver
  • SAP HANA, platform edition

Product

SAP HANA, platform edition all versions ; SAP NetWeaver all versions

Keywords

 SQLDBC Connection Properties, connectTimeout, nodeConnectTimeout, virtual hostname , KBA , HAN-DB , SAP HANA Database , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.