Symptom
Data load/DTP is stuck and multiple ABAP dumps are seen on the BW side:
Category Installation errorRuntime Errors DBSQL_SQL_ERRORExcept. CX_SY_OPEN_SQL_DBDate and Time **/**/** **:**:**
Short TextSQL 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.
SAP Knowledge Base Article - Preview