Symptom
Short dump DBSQL_SQL_ERROR SQL is thrown with SQL Code 9300.
Category Installation error
Runtime Errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB
Short Text |
SQL error "SQL code: -9300" occurred while accessing table "*******". |
What happened? |
Database error text: "SQL message: Internal SQLDBC error" |
Corresponding developer trace is showing two errors bolded below:
C *** ERROR => fetch() of C_0460, #rec=32, rc=1, rcSQL=-10807
[dbsdbsql.cpp 2256]
C {root-id=00155E1010CD1EDB82BB4C0FCC76017D}_{conn-id=00000000000000000000000000000000}_0
C *** ERROR => FETCH C_0460 on connection 0, rc=-10807
[dbslsdb.cpp 10336]
C SQLCODE : -10807
C SQLERRTEXT : System call 'recv' failed, rc=10054:An existing connection was forcibly closed by the remote host {1\
C ********}
C sc_p=0000003CF28E74C0,no=460,idc_p=0000000000000000,con=0,act=1,slen=156,smax=512,#vars=1,stmt=0000003CF3D37370,table=*******
C SELECT /* FDA WRITE ************************[SQL statement 1 on a /BIC table]******************************
B ***LOG BYM=> severe DB error -10807; work process in reconnect status [dbsh 1191]
B ***LOG BY4=> sql error -10807 performing FET on table ******** C [dbdbslst 5137]
B ***LOG BY0=> System call 'recv' failed, rc=10054:An existing connection was forcibly closed by the remote host {xxx.xxx.xxx.xxx:30015} [dbdbslst 5137]
C SQLDBC error occurred, rc=1, but SQL Error Code is not set (0) -> use SQL error -9300
C *** ERROR => execute() of C_0636, #rec=0, rc=1, rcSQL=-9300
[dbsdbsql.cpp 2116]
C *** ERROR => EXECUTE C_0636 on connection 0, rc=-9300
[dbslsdb.cpp 10064]
C SQLCODE : -9300
C SQLERRTEXT : Internal SQLDBC error
C sc_p=0000003CF28EDD40,no=636,idc_p=0000003CF29428B0,con=0,act=1,slen=84,smax=1280,#vars=2,stmt=0000003CF3D1FE50,table=*******
C stmtid = <0/CL_RSBK_DP_STATE==============CP /420479040/20190719011244>
C ************************[SQL statement 2]******************************
B ***LOG BY4=> sql error -9300 performing FET on table *********** [dbdbslst 5137]
B ***LOG BY0=> Internal SQLDBC error [dbdbslst 5137]
B dumping DbDbslStatement ...
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Read more...
Environment
SAP HANA, platform edition
Product
Keywords
troubleshoot, 9300, 10807, Internal SQLDBC error, SQLCODE. rc=10054 , KBA , HAN-DB , SAP HANA Database , HAN-DB-ENG-BW , SAP HANA BW Engine , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , 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.