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
- Configure SQL Database access as indicated in SAP Analytics Cloud User's Guide.
- 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
- 2358097 - SAP Analytics Cloud connecting to on-premise data *** Master KBA ***
- 2557071 - Error: The database driver is misconfigured on SAP Analytics Cloud when creating a SQL connection
- How to find User Assistance for SAP Analytics Cloud?
- Ask a question on the SAP Community!
- 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)
- Microsoft JDBC Driver 6.2 for SQL Server
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 (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem