Symptom
You are using JDBC adapter to connect to onpremise DB from CPI system.
There are multiple hosts for DB which you would like to configure as a high availability way.
So once one of the host is down then one of the other will be used.
For such a configuration the multiple hosts of Cloud Connector added in below format in the JDBC material:
jdbc:sap://<Host1>:<Port>;<Host2>:<Port>;<Host3>:<Port>;<Host4>:<Port>;<Host5>:<Port>;<Host6>:<Port>/?autocommit=false
Running the Iflow is working fine, however when one of the host is down the following error faced:
com.sap.it.rt.adapter.jdbc.exceptions.JDBCException: The processing has failed due to error in creating metadata table. : com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: Cannot connect to
jdbc:sap://<Host1>:<Port>;<Host2>:<Port>;<Host3>:<Port>;<Host4>:<Port>;<Host5>:<Port>;<Host6>:<Port>
[None of the hosts could be reached: [Receive of connect failed.; host = <Host1>:<Port> error = Unknown host <Host1>:<Port> [null], ...
Read more...
Environment
- Cloud Integration
- SAP Integration Suite
Product
Keywords
SAP Cloud Platform Integration, SAP HCI, SAP CPI, SCPI, SAP Integration Suite, JDBC, hosts, multiple, JDBCDriverException , KBA , LOD-HCI-PI-CON-RFC , RFC Adapter , 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.