Symptom
- You have a Java based application running on HANA Database e.g. Process Orchestration (PO), AS Java, Solution Manager
- You have configured System Replication in HANA to allow a failover from Primary to Secondary or vise versa
- When testing the failover, the Java engine may become unresponsive or inaccessable. A restart may be required to get it working again.
- In the Java application traces e.g. the defaultTrace file you may see errors like below:
- [EXCEPTION]
com.sap.sql.exception.OpenSQLNonTransientConnectionException: Internal error:Routing from secondary to primary system is not allowed.
OpenSQLExceptionCategories: [NON_TRANSIENT, DB_ADMINISTRATOR_REQUIRED]...
Caused by: com.sap.db.jdbc.exceptions.SQLNonTransientConnectionExceptionSapDB: Internal error:Routing from secondary to primary system is not allowed. - You may observe errors relating to Process Orchestration (PO) message processing, such as:
- The EOIO sequence may stop processing. Reason: com.sap.sql.exception.OpenSQLNonTransientConnectionException: Internal error:Routing from secondary to primary system is not allowed.
- Failed to check for duplicate entry. Reason: com.sap.sql.exception.OpenSQLNonTransientConnectionException: Internal error:Routing from secondary to primary system is not allowed.
- You may also be using a virtual hostname in HANA which should map to Primary and Secondary physical hosts.
Read more...
Environment
All HANA 2.0 revisions
Product
SAP HANA, platform edition all versions
Keywords
System Replication, Active/Active(Read Enabled), Takeover, Failback, HANA Client, SQL error, HA Cluster, PO, Process Orchestration, AS Java, NWA, pacemaker cluster, HP Serviceguard, virtual hostname, j2ee , KBA , HAN-DB-HA , SAP HANA High Availability (System Replication, DR, etc.) , BC-JAS-COR , Enterprise Runtime, Core J2EE Framework , BC-XI , NetWeaver Process Integration (PI) , How To
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.