1960579 - Get error "Java Exception : java.lang.RuntimeException: com.sap.db.jdbc.exceptions.JDBCDriverException" when refreshing Web Intelligence documents using SSO to HANA

Symptom

When refreshing the Web Intelligence documents on top of connections to HANA using SSO throws the error
(CS) "Java Exception : java.lang.RuntimeException: com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [1033]: error while parsing protocol: " (IES 10901)

Environment

• SAP BusinessObjects Business Intelligence 4.0 SP06 Patch7
• HANA 1.0 SP1 6.9.1

Reproducing the Issue

1. Configure the end to end SSO to hana via kerberos by KBA:1811398 - How to setup BI components to login to hana via AD kerberos SSO
2. Create a connection in Information Designer Tool and set the authentication mode to SSO.
3. Create a Web Intelligence report on top of this connection.
4. Open the Webi report and refresh it from BI LaunchPad.

Note: The same Webi report is working fine in Web Rich client tool and the SSO connection is also working fine in IDT, the issue just occurred in BI LaunchPad

Cause

The JDBC driver in server was corrupt or older than the driver installed with HANA client.

Resolution

Copy ngdbc.jar from HANA client installation folder to:
[BI4_INSTALL_PATH]\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers\newdb (create newdb folder if required)
(On Unix platform, the install folder prefix may differ slightly eg: [BI4_INSTALL_PATH]/enterprise_xi40/dataAccess/connectionServer/jdbc/drivers/newdb
The default HANA client install folder locations (in Windows):

• 64-bit Client install: /program files/sap/hdbclient
• 32-bit Client install: /program files (x86)/sap/hdbclient 

The jar files in both the 32-bit and 64-bit client install are identical, for the exact same HANA Client revision level

Keywords

HANA, SSO, HANA SSO, AD, JDBCDriverException, SAP DBTech JDBC: [1033]:, error while parsing protocol