Import ABAP failed when installing ERP6.0 EHP7 on HANA

[Former Member]

Hi, everyone. I have encounter an issue when installing ERP6.0 EHP7 on HANA. An error occurs during Import ABAP phase which says Program “Migration Monitor” exits with error code 103.  I have check import_monitor.log, where there is a package import fail. The failed package is SAPSSEXC. I have check the HANA DB, a DB dump had been observed during import phase. And in the SAPSSEXC.log, there is an error says "

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

  rc = 99, table "DYNPSOURCE"

  (SQL error -10807)

  error message returned by DbSl:

System call 'recv' failed, rc=104:Connection reset by peer

after this, all the errors looks like this

(DB) ERROR: DDL statement failed

(CREATE COLUMN TABLE "ENHA_TMDIR" ( "CLASSNAME" NVARCHAR(30) DEFAULT '' NOT NULL , "METHODINDX" NVARCHAR(5) DEFAULT '00000' NOT NULL , "METHODNAME" NVARCHAR(61) DEFAULT '' NOT NULL , "ENHANCEMENT" NVARCHAR(30) DEFAULT '' NOT NULL , "COMPUNIT" NVARCHAR(30) DEFAULT '' NOT NULL  ) )

DbSlExecute: rc = 99

  (SQL error -10821)

  error message returned by DbSl:

Session not connected

Can anybody help me on this? I have stucked in this phase for over a week.....  Thanks in advance.

[Former Member · Accepted solution]

Actually this error is due to import timeout, change a parameter in HANA DB, this will solved.

Thanks for all your reply.

[lohitkumar_ap · Accepted solution]

Hi Roy,

What parameter did you change in HANA?

Best Regards,

Lohit

[Former Member · Accepted solution]

Hi Lohit,

You can change the parameter under Configuration -> indexserver.ini ->thread_limit ->timeout_aggregate  into a large number like 60000 or larger.

Kind regards,

Roy

[karthikeyan_natarajan4]

Hi Roy,

Connection to Hana database is disconnected, Please check whether your DB is online, check the free space in data and log folders,

regards

kartik

[Former Member]

Thank you for your answer.

yes, actually the DB encounter a dump during import abap phase, the indexserver is crashed. But it automatically recovered after a few minutes. What I confuse about is I don't know why db is crashed, cuz both DB and ERP is clean installation.

[karthikeyan_natarajan4]

Hi Roy,

Please check the index server trace file.

Use Hana studio - diagnosis files - check indexserver_alert.Hostname.trc file for further details.

regards

kartik

[Former Member]

The trace file is as follows, could you please take a look at this? I have little knowledge of this.

[10941]{-1}[-1/-1] 2013-12-02 06:27:53.222870 e TrexNet          BufferedIO.cpp(04148) : ERROR on channel 113 <127.0.0.1:30007>: protocol mismatch - trying to read type Int but EOF reached

[10941]{-1}[-1/-1] 2013-12-02 06:27:53.223089 e TrexNetIO        BufferedIO.cpp(01332) : dump of TrexNet buffer: size 104, current position 0x00007f1d82f917c4 (104 bytes), mode incoming, channel 113, peer 127.0.0.1:30007, content:

[10904]{-1}[-1/-1] 2013-12-02 06:27:53.223177 e TrexNet          BufferedIO.cpp(04148) : ERROR on channel 105 <127.0.0.1:30005>: protocol mismatch - trying to read type Int but EOF reached

[10904]{-1}[-1/-1] 2013-12-02 06:27:53.223201 e TrexNetIO        BufferedIO.cpp(01332) : dump of TrexNet buffer: size 104, current position 0x00007f1d82f8f554 (104 bytes), mode incoming, channel 105, peer 127.0.0.1:30005, content:

[10941]{-1}[-1/-1] 2013-12-02 06:27:53.223089 e TrexNetIO        BufferedIO.cpp(01332) : BLOB START (Addr: 0x00007f1d82f9175c Len: 104)

[10904]{-1}[-1/-1] 2013-12-02 06:27:53.223201 e TrexNetIO        BufferedIO.cpp(01332) : BLOB START (Addr: 0x00007f1d82f8f4ec Len: 104)

[10941]{-1}[-1/-1] 2013-12-02 06:27:53.223089 e TrexNetIO        BufferedIO.cpp(01332) : BLOB END

[10904]{-1}[-1/-1] 2013-12-02 06:27:53.223201 e TrexNetIO        BufferedIO.cpp(01332) : BLOB END

[10941]{-1}[-1/-1] 2013-12-02 06:27:53.223507 e TrexNet          BufferedIO.cpp(04153) : Stacktrace for Context Name:JobWrk0009

[10904]{-1}[-1/-1] 2013-12-02 06:27:53.223542 e TrexNet          BufferedIO.cpp(04153) : Stacktrace for Context Name:JobWrk0005

1: 0x00007f1db3cac2e5 in Execution::Context::dumpStackTrace(char const*, ltt::basic_ostream<char, ltt::char_traits<char> >&) const+0x31 at Context.cpp:1457 (libhdbbasis.so)

2: 0x00007f1dc15ff8fc in TrexTrace::Tracer::stack(char const*, unsigned int, TrexTrace::TraceLevel const&)+0xa8 at TrexTrace.cpp:1409 (libhdbbasement.so)

3: 0x00007f1dc15ab810 in TrexNet::BufferedNetInput::checkType(unsigned char)+0x4c0 at Channel.h:481 (libhdbbasement.so)

4: 0x00007f1dc15ae600 in TrexNet::BufferedNetInput::operator>>(int&)+0x20 at BufferedIO.cpp:3422 (libhdbbasement.so)

5: 0x00007f1dc6b6a367 in Executor::X2::runCommThread(Executor::X2::SendTaskInfo&, Execution::TraceContext&, Executor::X2Job*)+0x793 at X2.cpp:1848 (libhdbexecutor.so)

6: 0x00007f1dc6b713e0 in Executor::X2Job::run(Execution::JobObject&)+0xd0 at X2.cpp:4022 (libhdbexecutor.so)

[10941]{-1}[-1/-1] 2013-12-02 06:27:53.223507 e TrexNet          BufferedIO.cpp(04153) :  1: 0x00007f1db3cac2e5 in Execution::Context::dumpStackTrace(char const*, ltt::basic_ostream<char, ltt::char_traits<char> >&) const+0x31 at Context.cpp:1457 (libhdbbasis.so)

[10904]{-1}[-1/-1] 2013-12-02 06:27:53.223542 e TrexNet          BufferedIO.cpp(04153) :  7: 0x00007f1db3cc3e16 in Execution::JobObjectImpl::run(Execution::JobWorker*)+0x392 at JobExecutorImpl.cpp:349 (libhdbbasis.so)

[10904]{-1}[-1/-1] 2013-12-02 06:27:53.223542 e TrexNet          BufferedIO.cpp(04153) :  8: 0x00007f1db3cd5da3 in Execution::JobWorker::runJob(ltt::smartptr_handle<Execution::JobObjectForHandle>&)+0x260 at JobExecutorThreads.cpp:260 (libhdbbasis.so)

[10941]{-1}[-1/-1] 2013-12-02 06:27:53.223507 e TrexNet          BufferedIO.cpp(04153) :  2: 0x00007f1dc15ff8fc in TrexTrace::Tracer::stack(char const*, unsigned int, TrexTrace::TraceLevel const&)+0xa8 at TrexTrace.cpp:1409 (libhdbbasement.so)

[10904]{-1}[-1/-1] 2013-12-02 06:27:53.223542 e TrexNet          BufferedIO.cpp(04153) :  9: 0x00007f1db3cd9ad7 in Execution::JobWorker::run(void*&)+0x173 at JobExecutorThreads.cpp:460 (libhdbbasis.so)

10: 0x00007f1db3cf2bb5 in Execution::Thread::staticMainImp(void**)+0x681 at Thread.cpp:457 (libhdbbasis.so)

11: 0x00007f1db3cf2d5d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:525 (libhdbbasis.so)

[10904]{-1}[-1/-1] 2013-12-02 06:27:53.247922 e Executor         X2.cpp(01872) : X2::runCommThread()() caught TrexNet exception "a protocol mismatch occured" during serialize returns, plan plan1@dewdflhana320:30003, server dewdflhana320:30005

[10941]{-1}[-1/-1] 2013-12-02 06:27:53.223507 e TrexNet          BufferedIO.cpp(04153) :  3: 0x00007f1dc15ab810 in TrexNet::BufferedNetInput::checkType(unsigned char)+0x4c0 at Channel.h:481 (libhdbbasement.so)

4: 0x00007f1dc15ae600 in TrexNet::BufferedNetInput::operator>>(int&)+0x20 at BufferedIO.cpp:3422 (libhdbbasement.so)

5: 0x00007f1dc6b6a367 in Executor::X2::runCommThread(Executor::X2::SendTaskInfo&, Execution::TraceContext&, Executor::X2Job*)+0x793 at X2.cpp:1848 (libhdbexecutor.so)

6: 0x00007f1dc6b713e0 in Executor::X2Job::run(Execution::JobObject&)+0xd0 at X2.cpp:4022 (libhdbexecutor.so)

7: 0x00007f1db3cc3e16 in Execution::JobObjectImpl::run(Execution::JobWorker*)+0x392 at JobExecutorImpl.cpp:349 (libhdbbasis.so)

8: 0x00007f1db3cd5da3 in Execution::JobWorker::runJob(ltt::smartptr_handle<Execution::JobObjectForHandle>&)+0x260 at JobExecutorThreads.cpp:260 (libhdbbasis.so)

9: 0x00007f1db3cd9ad7 in Execution::JobWorker::run(void*&)+0x173 at JobExecutorThreads.cpp:460 (libhdbbasis.so)

10: 0x00007f1db3cf2bb5 in Execution::Thread::staticMainImp(void**)+0x681 at Thread.cpp:457 (libhdbbasis.so)

[10941]{-1}[-1/-1] 2013-12-02 06:27:53.223507 e TrexNet          BufferedIO.cpp(04153) : 11: 0x00007f1db3cf2d5d in Execution::Thread::staticMain(void*)+0x39 at Thread.cpp:525 (libhdbbasis.so)

[10941]{-1}[-1/-1] 2013-12-02 06:27:53.273968 e Executor         X2.cpp(01872) : X2::runCommThread()() caught TrexNet exception "a protocol mismatch occured" during serialize returns, plan plan1@dewdflhana320:30003, server dewdflhana320:30007

[10972]{-1}[5/-1] 2013-12-02 06:27:53.274240 e Executor         PlanExecutor.cpp(00593) : plan plan1@dewdflhana320:30003 failed with rc 2613; executor: communication problem

[10972]{-1}[5/-1] 2013-12-02 06:27:53.274301 e Executor         PlanExecutor.cpp(00593) : -- returns for plan1@dewdflhana320:30003:

[10972]{-1}[5/-1] 2013-12-02 06:27:53.274319 e Executor         PlanExecutor.cpp(00593) : pop=<all>, duration=06:27:53.196 to 06:27:53.274 +0.078

[10972]{-1}[5/-1] 2013-12-02 06:27:53.274348 e Executor         PlanExecutor.cpp(00593) : con=<all>, duration=+0.000

[10972]{-1}[5/-1] 2013-12-02 06:27:53.274353 e Executor         PlanExecutor.cpp(00593) : -- end executor returns

[Sriram2009]

Hi Roy

Kindly check this SAP KBA - 1827883

Regards

Ram