2403538 - The database driver is misconfigured error when trying to connect to SQL databases from SAP Analytics Cloud

SAP Knowledge Base Article - Public

2403538 - The database driver is misconfigured error when trying to connect to SQL databases from SAP Analytics Cloud

Symptom

Creating a connection to a SQL Database, the following error appears in the screen:

  • SERVER_ERROR_500
    The database driver is misconfigured. Contact your SAP Analytics Cloud agent administrator.
  • SERVER_ERROR_500
    The database driver is misconfigured. Contact your SAP BusinessObjects Cloud agent administrator.

Error_SQL_Server.png

 

In the traces area of the application you will find the following stack:

  • Message: Exception@/sap/fpa/services/core/system/Exception.xsjslib:106
    ExceptionCSAgent@/sap/fpa/services/dm/agent/cs/CSAgent.xsjslib:22
    @/sap/fpa/services/dm/agent/cs/CSAgent.xsjslib:96
    @/sap/fpa/services/dm/agent/cs/CSAgent.xsjslib:108
    @/sap/fpa/services/dm/RestDataIntegration.xsjslib:155
    handleRequest@/sap/fpa/services/GetResponse.xsjs:304
    @/sap/fpa/services/GetResponse.xsjs:343

If you examine the Tomcat log file: stderr.log you will find the following line:

  • SEVERE [http-nio-8080-exec-7] com.sap.fpa.cloud.internal.DAException.logException ERROR_DRIVER_NOT_CONFIGURED

 

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. Configure SQL Database access as indicated in SAP Analytics Cloud User's Guide.
  2. Configure accordingly the file Driverconfig.properties with an entry for the SQL database, for example SQL server:
  • MS SQL Server 2014="C:\BOC_Agent_JDBC_Driver\sqljdbc_6.0\enu\sqljdbc4.jar"

Cause

The double quotes characters are not necesary and are read as part of the path.

Resolution

Remove the double quote characters from the path to the JAR file:

  • MS SQL Server 2014=C:\BOC_Agent_JDBC_Driver\sqljdbc_6.0\enu\sqljdbc4.jar

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating facility at the top right-hand corner of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0