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
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.