cancel
Showing results for 
Search instead for 
Did you mean: 

HANA connection error

Former Member
0 Kudos

Hi Gurus,

I am working on BW on HANA DB migration project.We face an error on IMPORT ABAP phase.

the log from SAPSSEXC.log

DbSl Trace:   writeLob() of C_0151, rc=1, rcSQL=-10807 (System call 'recv' failed, rc=10054:An existing connection was forcibly closed by the remote host)

DbSl Trace: LOB_WRITE on connection 0, rc=-10807 (System call 'recv' failed, rc=10054:An existing connection was forcibly closed by the remote host)

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

  rc = 99, table "REPOSRC"

  (SQL error -10807)

  error message returned by DbSl:

System call 'recv' failed, rc=10054:An existing connection was forcibly closed by the remote host

DbSl Trace:   execute(), rc=1, rcSQL=-10821 (Session not connected)

DbSl Trace: EXECUTE on connection 0, rc=-10821 (Session not connected)

(DB) ERROR: DDL statement failed

(CREATE  INDEX "REPOSRC~SPM" ON "REPOSRC" ( "R3STATE" , "PROGNAME"  ) )

DbSlExecute: rc = 99

  (SQL error -10821)

  error message returned by DbSl:

Session not connected

DbSl Trace:   execute(), rc=1, rcSQL=-10821 (Session not connected)

DbSl Trace: EXECUTE on connection 0, rc=-10821 (Session not connected)

(DB) ERROR: DDL statement failed

(CREATE ROW  TABLE "REPOTEXT" ( "PROGNAME" NVARCHAR(40) DEFAULT '' NOT NULL , "R3STATE" NVARCHAR(1) DEFAULT '' NOT NULL , "LANGUAGE" NVARCHAR(1) DEFAULT '' NOT NULL , "UNAM" NVARCHAR(12) DEFAULT '' NOT NULL , "UDAT" NVARCHAR(8) DEFAULT '00000000' NOT NULL , "UTIME" NVARCHAR(6) DEFAULT '000000' NOT NULL , "DATALG" INTEGER DEFAULT 0 NOT NULL , "DATA" BLOB  , PRIMARY KEY ( "PROGNAME", "R3STATE", "LANGUAGE" ) ) )

DbSlExecute: rc = 99

  (SQL error -10821)

  error message returned by DbSl:

Session not connected

(DB) INFO: REPOTEXT~0 created #20120810003846

DbSl Trace:   execute(), rc=1, rcSQL=-10821 (Session not connected)

DbSl Trace: EXECUTE on connection 0, rc=-10821 (Session not connected)

ERROR : execute for HDBCreateAndLockTable for table /NEWDB/R3LOADCONTROLTABLE failed(dbrc=99).

  (SQL error -10821)

  error message returned by DbSl:

DbSl Trace:   execute(), rc=1, rcSQL=-10821 (Session not connected)

DbSl Trace: EXECUTE on connection 0, rc=-10821 (Session not connected)

Pls help me ?

Thanks in Advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

System call 'recv' failed, rc=10054:An existing connection was forcibly closed by the remote host


Is a network glitch.  You need to maintain the host name of the target machine in /etc/host entries.

0 Kudos

James,

This appears to be a connectivity problem between the machine running the HANA client and the HANA Appliance. Please check the network for basic connectivity and any firewalls or other network elements that could interfere with the connection. Other than the network the best thing in this situation is to open a CSS ticket at service.sap.com.

Thank You,

Doug