SAP Knowledge Base Article - Public

2403538 - Error: The database driver is misconfigured on SAP Analytics Cloud when creating a SQL connection

Symptom

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

  • 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. 

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 the Driverconfig.properties file with an entry for the SQL database, for example SQL server:
  • MS SQL Server 2014="C:\SACBOC_Agent_JDBC_Driver\sqljdbc_6.0\enu\sqljdbc4.jar" or "C:\Program Files\Apache Software Foundation\Tomcat 9.0\sqljdbc.jar"

Cause

  • The double quotes characters are not necessary and are read as part of the path.
  • The path to the library file  may not be correct or is not accessible due to security reasons.

Resolution

Remove the double quote characters from the path to the JAR file and confirm the path is correct / accessible:

  • MS SQL Server 2014=C:\SAC_Agent_JDBC_Driver\sqljdbc_6.0\enu\sqljdbc4.jar
    OR
  • MS SQL Server 2014=C:\Program Files\Apache Software Foundation\Tomcat 9.0\sqljdbc.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

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, 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, SQL connection, SQL driver, database driver is misconfigured, , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0