SAP Knowledge Base Article - Preview

2621464 - SAP BW and HANA connection hanging

Symptom

Data load/DTP is stuck and multiple ABAP dumps are seen on the BW side:

Category          Installation error
Runtime           Errors DBSQL_SQL_ERROR
Except.           CX_SY_OPEN_SQL_DB
Date and Time     **/**/** **:**:**

Short Text
SQL error "SQL code: -10108" occurred while accessing table "V_OP".

or

SQL error "SQL code: -10807" occurred while accessing table "/BI0/PCUSTOMER"

In the HANA indexserver trace, entries similar to following are seen.

[53441]{-1}[-1/-1] 2018-02-08 00:30:59.902327 w SQLSession sm_codec_newdb.cc(01120) : superfluous part kind: 29
[32762]{-1}[-1/-1] 2018-02-08 00:31:20.065049 w SQLSession sm_codec_newdb.cc(01120) : superfluous part kind: 29
[46052]{-1}[-1/-1] 2018-02-08 00:31:21.064637 w SQLSession sm_codec_newdb.cc(01120) : superfluous part kind: 29
[54961]{-1}[-1/-1] 2018-02-08 00:31:22.064454 w SQLSession sm_codec_newdb.cc(01120) : superfluous part kind: 29
[22197]{-1}[-1/-1] 2018-02-08 00:31:42.241530 w SQLSession sm_handler.cc(01143) : (sockfd:138, part:11, channel:0x00007f43ae940180, event:0x00007f6334125c00) channel error: An existing connection was reset by the remote host
[48630]{-1}[-1/-1] 2018-02-08 00:31:42.242230 w SQLSession sm_handler.cc(01143) : (sockfd:134, part:24, channel:0x00007f8f5789c200, event:0x00007f92c36b7100) channel error: An existing connection was reset by the remote host
[31733]{-1}[-1/-1] 2018-02-08 00:31:42.242296 w SQLSession sm_handler.cc(01143) : (sockfd:128, part:27, channel:0x00007f4e5d37e900, event:0x00007f6dd5133700) channel error: An existing connection was reset by the remote host
[54961]{-1}[-1/-1] 2018-02-08 00:32:05.676776 w SQLSession sm_handler.cc(01230) : (sockfd:222, part:1, channel:0x00007f714317a580, event:0x00007f51e48ca200) need more data: total=5808, remained=4096
[29123]{-1}[-1/-1] 2018-02-08 00:32:19.378218 w SQLSession sm_codec_newdb.cc(01120) : superfluous part kind: 29

 


Read more...

Environment

SAP HANA 1.0

SAP HANA 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0 ; SAP NetWeaver 7.5

Keywords

BW, connectivity, HANA, network, DBSQL_SQL_ERROR, ABAP, dump, DTP,  CX_SY_OPEN_SQL_DB, SQL code: -10108, SQL code: -10107 , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , HAN-DB-ENG-BW , SAP HANA BW Engine , 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.