2203415 - IDT: Failed to create OLAP connection to SAP HANA MDC ( Multitenant Database Containers)

Symptom

• Failed with the following error when creating OLAP connection to SAP HANA MDC ( Multitenant Database Containers) in IDT
  ErrorCode: -813
  Message: SAP DBTech JDBC: Cannot connect to jdbc:sap://<HOSTNAME>:3**15 [Cannot connect to host <HOSTNAME>:3**15 [Connection refused: connect], -813.]
• When creating HANA OLAP connection in CMC to SAP HANA MDC, it is giving error "Failed to get connections for connection [<HOSTNAME>] using session locale [English]"

Environment

• SAP BusinessObjects Business Intelligence Platform 4.1
• Information Design Tool (IDT)
• SAP HANA MDC

Reproducing the Issue

1. Launch IDT and create a new OLAP Connection.
2. Select SAP Hana Client driver.
3. Enter Hostname, Instance Number, User Name, Password in Parameters for SAP HANA window to SAP HANA MDC, whose port is not 3**15(i.e., 3**41)
4. Click Next button.
   =>Connection fails with error message "SAP DBTech JDBC: Cannot connect to jdbc:sap://<HOSTNAME>:3**15 [Cannot connect to host <HOSTNAME>:3**15 [Connection refused: connect], -813.]".

Resolution

Enter "<HANA server>:3**41;"(** is instance number of SAP HANA; 3**41 is the port of SAP HANA MDC) into Hostname field.

Note: the semicolon is necessary at the end.

Keywords

BI4, BI4.1, 4.1, IDT, HANA, MDC, Multitenant Database Containers, OLAP, port, host, hostname, 813, -813, jdbc, Cannot connect, SAP DBTech JDBC, Connection refused, how to, 30015, 3**15, 30040, 30041, 3**40, 3**41, Failed to get connections

Header Data

Released On	10.08.2015 04:32:14
Release Status	Released to Customer
Component	BI-BIP-IDT Information design tool
Other Components	BI-BIP-SL Semantic Layer
Priority	Normal
Category	Problem