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 *** 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 for Me (Login required).

Search for additional results

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