1968090 - Get explorer error "invalid username or password" when indexing an information space against HANA with SSO

Symptom

• When trying to index an information space against a HANA database with SSO enabled it fails. 
• The failure details show the following:
• "The execution of the specified analysis query failed.-[] <java.lang.RuntimeException: com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException: [10]: invalid username or password: >|com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorizationSpecException: [10]: invalid username or password:  |[10]: invalid username or password: " id="index_creation_failed">"
  
• The trace log of ExplorerIndexingServer show the following:
• "com.sap.connectivity.sso.SSOServiceError: Plugin Manager error: Unable to locate the requested plugin token on the server. (FWB 00006)"
• SSO tests ok and failure only occurs when indexing

Environment

• SAP BusinessObjects Business Intelligence 4.0 SP06 Patch8
• SAP BusinessObjects Business Intelligence Explorer 4.0 SP06 Patch8

Reproducing the Issue

1. Configure the end to end SSO to hana via kerberos by KBA:1877286 - How to setup kerberos SSO for explorer based on hana
2. Create a HANA connection in Information Designer Tool and set the authentication mode to SSO.
3. Login to Explorer
4. Go to Manage Spaces and select the HANA connection from Sources and click New button to create an Information Spaces.
5. Try to index it and it will fail.

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\Explorer14.0\plugins\com.sap.ngdbc_1.0.0\lib
The path in BI4.1 should be
[BI4_INSTALL_PATH]\SAP BusinessObjects\Explorer14.0\plugins\com.sap.ngdbc_14.1.1.r1036_vxxxx\lib
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

Explorer, Explorer HANA, Explorer SSO, HANA, SSO, HANA SSO, AD, com.sap.db.jdbc.exceptions.jdbc40.SQLInvalidAuthorization