SAP Knowledge Base Article - Preview

2719969 - Jobs fail during failover of HANA Host Auto-Failover

Symptom

You have a HANA Database with High Availability - Host Auto-Failover configured and during a switch to the standby node, the running jobs fail with the dump below:

Runtime errors DBSQL_SQL_ERROR
Except. CX_SY_OPEN_SQL_DB

Short Text
SQL error "SQL code: 139" occurred while accessing table "<tablename>".
 
What happened?
Database error text: "SQL message: current operation cancelled by request and transaction rolled back"
 


Read more...

Environment

  • SAP HANA DB Version 1.0
  • SAP HANA DB Version 2.0

Product

SAP HANA, platform edition all versions

Keywords

failover takeover jobs HA , KBA , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , HAN-DB , SAP HANA Database , 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.