SAP Knowledge Base Article - Public

3558621 - Error "Database Driver is Misconfigured" when creating an Oracle 12c acquired connection in SAP Analytics Cloud (SAC)

Symptom

When creating a new Oracle 12c acquired connection, you get the error "The database driver is misconfigured.  Please contact your onsite SAP Analytics Cloud agent administrator..."

oracle1.png

SAP Analytics Cloud Agent trace will show errors such as:

  • ERROR_DRIVER_NOT_CONFIGURED or  
  • Caused by: java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): AR8ISO8859P6
  • Caused by: java.sql.SQLException: ORA-17056: Non-supported character set (add orai18n.jar in the classpath): AR8ISO8859P6

Environment

  • SAP Analytics Cloud Agent version: 1.0.421 or newer

Reproducing the Issue

  1. Add the Oracle orai18n.jar driver into the driver.properties file in the Oracle 12c area.
  2. Try to create a new connection using SQL Databases.
  3. The error will appear when saving the connection for the first time.

Cause

Tomcat is not able to properly find the orai18n.jar file from Oracle.

Resolution

The ora18n.jar file needs to be visible to the Tomcat server. To do this:

  1. Add the orai18n.jar into the tomcat lib directory.
  2. Restart Tomcat.
  3. Try to create the connection again.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAC, import, oracle, ora, ora18n, DRIVER_NOT_CONFIGURED, AR8ISO8859P6, java.sql.SQLException , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0