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