HANA connection error

[Former Member]

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.

[Former Member · Accepted solution]

Problem solved.It's a network issue.

[Former Member · Accepted solution]

Can you please share the fix you made to the network to solve this issue? We are running into a similar error when loading data from Oracle to HANA using Informatica.

[Former Member · Accepted solution]

Hello Amit -

I just wanted to check, how successful you were in migrating the oracle table(s) to HANA ?

BTW, which version of the informatica you are using for the purpose ?

Thanks,

Sharas

[Former Member · Accepted solution]

Are you able to describe the network issue or the solution at all?

[Former Member]

Hi Jason,

I am facing the similar issue with our HANA system during the migration. Failing with the same session not connected issue. We assume it is because of Network issue and currently contacting our network team to increase the latency between the system as our source and target at different geographical locations.

In case your issue is solved earlier, please do let us know. I will also update you if this is resolved from my side.

Thanks

Jaianandh V

[Former Member]

Hi Jaianandh,

I dont think there is a network issue.

What is the vendor of your SAP HANA appliance?

Our vendor is HP.

[Former Member]

Hi Jason,

It is HP for us as well. Raised an OSS message for this, awaiting reply.

Thanks

Jaianandh V