SAP Knowledge Base Article - Preview

2090915 - BW Data Loads fail with Dump DBSQL_SQL_ERROR and short text 'SQL error SQL code: -10709 occurred while accessing table'


  • BW Data loads fail with a Dump that has the header DBSQL_SQL_ERROR. In transacton st22 the dump has the short text SQL error "SQL code: -10709" occurred while accessing table.
  • In the work process trace file you see error SQLCODE: -10709 with SQLERRTEXT: Connect failed (no reachable host left).
  • In this case no failover/takeover was done beforehand. This is important as a similar error can occur if failover configuration is not correct and therefore this SAP Knowledge Base Article would not apply.
  • In general the connection from the BW application server(s) to the HANA Database is working well.



HANA Database 1.0.


SAP HANA, platform edition all versions


CX_SY_OPEN_SQL_DB; Infopackage; Data Transfer Process; HANA database client; HANA database Revision; communication problems , KBA , HAN-DB-ENG-BW , SAP HANA BW Engine , BW-WHM-DST , Data Staging , 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.