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