1879272 - While trying to connect to HANA in BI Explorer 4.0 error " java.sql.sqlexception No suitable driver found for jdbc: sap://;&" is seen

Symptom

• Unable to create Information space based on HANA.
• The HANA based Analytical views are not visible and give "java.sql.sqlexception No suitable driver found for jdbc: sap://<servername or ip address>;<port number>&" error.

Environment

SAP BusinessObjects Business Intelligence Platform 4.0 SP04
SAP BusinessObjects Explorer 4.0 SP04

Reproducing the Issue

1. Login to Explorer
2. Hover the mouse on HANA DB alias name. It will show the error message:
java.sql.sqlexception No suitable driver found for jdbc: sap://<server name or ip address>;<port number>&

Cause

Colon was missing in the parameter under Advanced Configuration in Explorer Application properties.

Resolution

1. Login to CMC.
2. Go to Applications and select Explorer.
3. Right click and select Properties.
4. Under Advanced Configuration make sure the below parameter is set properly.
newdb.url=jdbc:sap://server1:30015
NOTE: Do not skip any colons in the parameter.

See Also

1828518 - HOW TO: Point BI4 Explorer to a HANA cluster via a JDBC connection

Keywords

java.sql.sqlexception, No suitable driver found, jdbc: sap://<servername or ip address>;<port number>&, Explorer, unable to connect, HANA

Header Data

Released On	26.06.2013 20:00:34
Release Status	Released to Customer
Component	BI-RA-EXP Polestar, Explorer
Priority	Normal
Category	Problem