R3trans -d is hanging

[former_member236893]

Hi All,

I'm facing an issue where R3trans -d is hanging while being executed from the application server. According to the log it successfully reaches the database but doesn't give back the prompt.

Extract from the logfile is below:

4 ETW000  [	dev trc,00000]  Loading SQLDBC client runtime ...
4 ETW000  [	dev trc,00000]  SQLDBC Module  : /usr/sap/RFD/hdbclient/libSQLDBCHDB.so
4 ETW000  [	dev trc,00000]  SQLDBC Runtime : libSQLDBCHDB 1.00.110.00 Build 1447753075-1530
4 ETW000  [	dev trc,00000]  SQLDBC client runtime is 1.00.110.00.1447753075
4 ETW000  [	dev trc,00000]  Try to connect via secure store (DEFAULT) on connection 0 ...
4 ETW000  [	dev trc,00000]  Attach to HDB : 1.00.110.00.1447753075 (fa/newdb100_rel)
4 ETW000  [	dev trc,00000]  fa/newdb100_rel : build_weekstone=0000.00.0
4 ETW000  [	dev trc,00000]  fa/newdb100_rel : build_time=2015-11-17 10:50:04
4 ETW000  [	dev trc,00000]  Database release is HDB 1.00.110.00.1447753075
4 ETW000  [	dev trc,00000]  INFO : Database 'RFD/01' instance is running on 's4devbackend'
4 ETW000  [	dev trc,00000]  INFO : Connect to DB as 'SAPRFD', connection_id=215582
4 ETW000  [	dev trc,00000]  INFO : set parameter for SQLSCRIPT, Enable_Select_Into_Scalar_UDF
4 ETW000  [	dev trc,00000]  INFO : DATA AGING feature is supported by HANA
4 ETW000  [	dev trc,00000]  INFO : FDA feature is supported by HANA
4 ETW000  [	dev trc,00000]  INFO : FAE with FDA feature is supported by HANA
4 ETW000  [	dev trc,00000]  INFO : DEFERRED LOB WRITING is activated
4 ETW000  [	dev trc,00000]  DB max. input host variables  : 32767
4 ETW000  [	dev trc,00000]  DB max. statement length	: 1000000000
4 ETW000  [	dev trc,00000]  DB max. array size	: 100000
4 ETW000  [	dev trc,00000]  use decimal precision as length
4 ETW000  [	dev trc,00000]  ABAPVARCHARMODE is used
4 ETW000  [	dev trc,00000]  use DBSL marker map
4 ETW000  [	dev trc,00000]  use DBSL session variable handling
4 ETW000  [	dev trc,00000]  INFO : DBSL buffer size = 1048576
4 ETW000  [	dev trc,00000]  Command info enabled
4 ETW000  [	dev trc,00000]  Now I'm connected to HDB
4 ETW000  [	dev trc,00000]  00: s4devbackend-RFD/01, since=20151208085438, ABAP= <unknown> (0)
4 ETW000  [	dev trc,00000]  Connection 0 opened (DBSL handle 0)
4 ETW000  [	dev trc,00000]  INFO : SAP RELEASE (DB) = 750
4 ETW000  [	dev trc,00000]  NTAB: Structure of NTAB on DB is VERS_B, unicodelg of executable is 2, unicodelg of SVERS in nametab is

2

Normally I should also see the following entries in the log:

4 ETW000 Connected to DBMS = HDB ---  SERVER = '' PORT = '' --- SYSTEM = 'RFD'.

4 ETW690 COMMIT "0" "0"

4 ETW000  trace to file pointer closed

4 ETW000  trace at level 1 opened for a given file pointer

4 ETW000

4 ETW000 ================== STEP 1 =====================

4 ETW000 date&time        : 08.12.2015 - 13:36:35

4 ETW000 function         : CONNECT

4 ETW000 buffersync       : YES

4 ETW000 clients          : default

4 ETW000 purgedocu        : YES

4 ETW000 commit           : 100000

4 ETW000 table cache      : dynamic

4 ETW000

4 ETW000  [     dev trc,00000]  Disconnecting from ALL connections:

4 ETW000  [     dev trc,00000]  Disconnecting from connection 0 ...

4 ETW000  [     dev trc,00000]  Now I'm disconnected from HDB

4 ETW000  [     dev trc,00000]  Disconnected from connection 0

4 ETW000  [     dev trc,00000]  statistics db_con_commit (com_total=1, com_tx=1)

4 ETW000  [     dev trc,00000]  statistics db_con_rollback (roll_total=0, roll_tx=0)

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

Your help would be greatly appreciated.

Regards,

Attila

[behlau_carlos]

Hello Attila,

did you already replace r3trans with the latest version from SAP Support portal?

If not, make sure to replace also tp program.

Best regards

Carlos

[former_member236893]

Hi Carlos,

Yes, but it did not help.

Moreover, the issue doesn't seem to be NW 7.5 specific since NW 7.4 R3load shows the same symptom on the same host.

Connection from hdbsql is working fine.

Regards

Attila