1755535 - BI4:Request processing failed. (XLS 000009) No suitable driver found for jdbc when creating a query based on SAP HANA JDBC connection in SAP Dashboards

SAP Knowledge Base Article - Public

1755535 - BI4:Request processing failed. (XLS 000009) No suitable driver found for jdbc when creating a query based on SAP HANA JDBC connection in SAP Dashboards

Symptom

  • Unable to create a query based on SAP HANA JDBC connection
  • Request processing failed. (XLS 000009) [] <com.businessobjects.dsl.commons.exception.NestedException: com.sap.db.jdbc.Driver>
  • request processing failed. (XLS 000009)[] &lt;com.businessobjects.dsl.commons.exception.NestedException: No suitable driver found for jdbc: sap://<server name or ip address>;<port number>&gt;

Environment

  • BI 4.0
  • SAP HANA
  • JDBC drivers

Reproducing the Issue

  1. Create a universe in Information Design Tool (IDT) using SAP HANA JDBC connection
  2. Save the universe to the repository
  3. Open Dashboard Design
  4. Create a new Query and select the Universe
  5. Select the new universe just created
  6. Add an object in Query Panel
  7. Press Next
  8. The error will be generated if the jdbc drivers have not been configured on the system containing the Dashboard Design Processing Server

Cause

The Dashboard Processing Server cannot access the jdbc drivers or is not able to find the drivers. Dashboard Design is using the Dashboard Design Processing Server in order to run Queries from universes/connections stored in the CMS. The drivers needs to be configured on the server for Dashboard Design to be able to run Queries.

Resolution

Resolution:

  1. Download the SAP HANA jdbc drivers
  2. Extract the file 'ngdbc.jar'
  3. Navigate to the jdbc folder for the SAP BusinessObjects. (Default  is C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\dataAccess\connectionServer\jdbc\drivers)
  4. Create a folder called 'jdbc' (note do not use the single quotes around the folder name'
  5. Copy the file 'ngdbc.jar' in the folder 'jdbc'
  6. Test to validate that all is working fine.

Note: This needs to be done on each server hosting the Dashboard Design Processing Server if this is a distributed environment.

Keywords

XLS 000009 suitable driver found for jdbc request processing failed BI4 Xcelsius Dashboard Design Query Next , KBA , BI-BIP-ADM , BI Servers, security & CrystalReports viewing in BI platform , BI-BIP-SL , Semantic Layer , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1