Symptom
- The ABAP system experiences a DBSQL_SQL_ERROR dump.
- The error message details of in the ABAP dump shows
"Database returned the SQL code 10807-. Error text: Connection down"
and..
C SQLCODE : -10807
C SQLERRTEXT : Connection down: [89006] System call 'recv' failed, rc=10054:An existing connection was forcibly closed by the remote host
- The error occurs during the execution of a Bex query connected to a Power BI report with a daily data refresh.
- During the Bex query the database load history (from transaction dbacockpit) shows service cpu consumption at 95-100%.
Read more...
Environment
- SAP BW/4HANA
- SAP HANA Platform 2.0
Product
SAP BW/4HANA 2.0 ; SAP HANA, platform edition 2.0
Keywords
SAP BW/4HANA, DBSQL_SQL_ERROR, Bex query, Power BI report, daily data refresh, Database returned the SQL code 10807-, Connection down, high CPU load. , KBA , HAN-DB-CLI , SAP HANA Clients (JDBC, ODBC) , HAN-DB-PERF , SAP HANA Database Performance , 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