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
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.