2242403 - In CR4E 4.1 JDBC to HANA custom port number cannot be defined

Symptom

When you connect to a HANA database through JDBC from Crystal Reports for Enterprise 4.1, you can only define the instance number. The port number is generated automatically as 3XX15 where XX is the instance number.

Environment

Crystal Reports for Enterprise 4.1

Reproducing the Issue

1. Open Crystal Reports for Enterprise
2. Create new report
3. Connection by Vendor >> SAP >> SAP HANA database 1.0 >> JDBC
   
4. Try defining custom port number
   
5. Logon Error: SAP DBTech JDBC: Cannot connect to jdbc:sap://[Host]:[CustomPort]:[GeneratedPort] [Invalid host, missing port number.].
   

Cause

The port for HANA JDBC connection is automatically generated by CR4E designer as 3XX15 where XX is the instance number.

Resolution

Workaround

1. Open IDT (Information Design Tool)
2. Connect to the Repository
3. Create a new relational connection to the Repository
4. Select SAP >> SAP HANA database 1.0 >> JDBC Drivers
5. Use the "Multi Server" option and define host:port
   
6. Save the connection to the Repository
7. In CR4E in the "Choose a Data Source Connection" tab select the "SAP BusinessObjects Business Intelligence platform" >> "Browse Repository" and use the connection created above

Keywords

CRE CR4E Crystal Reports for Enterprise 4.1 HANA JDBC custom port number

Header Data

Released On	12.12.2015 08:26:37
Release Status	Released to Customer
Component	BI-RA-CRE Crystal Reports for Enterprise
Priority	Normal
Category	Problem