SAP Knowledge Base Article - Preview

2985927 - Troubleshooting '9300' and '10807' errors when loading Infocube

Symptom

When loading the data into InfoCube, 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"   

681770_dump.PNG

Corresponding developer trace is showing two errors bolded below:

C Fri Oct 9 10:56:55:911 2020

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


Read more...

Environment

SAP HANA, platform edition

Product

SAP NetWeaver 7.0

Keywords

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.