KB-2289 Can't publish Data Store or download DDL scripts - Caused by: java.sql.SQLException: Non-supported character set (add orai18n.jar in your classpath) on customers with Oracle Database.

Symptoms

Given a data store backed by an Oracle database, and a CDT with a text field containing an invalid character (ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏĞÑÒÓÔÕÖ×ØÙÚÛÜİŞßàáâãäåæçèéêëìíîïğñòóôõö÷øùúûüışÿ), the following error is thrown when verifying the data store, downloading the DDL script or creating a CDT from a table/view:

The following error is seen in the app server log:

 Caused by: java.sql.SQLException: Non supported character set (add orai18n.jar in your classpath): WE8ISO8859P9

Cause

The orai18n.jar library is missing under <APPIAN_HOME>/tomcat/apache-tomcat/lib/. This issue has been hotfixed via AN-208781 in Appian 22.2.300.0 and 22.1.620.0 for Cloud customers.

Action

Cloud

Apply the latest hotfix to your Appian Cloud installation.

Self-managed

Deploy orai18n.jar under <APPIAN_HOME>/tomcat/apache-tomcat/lib/ and restart the application server. This library can be obtained from Oracle here.

Affected Versions

This article applies to all self-managed versions of Appian and Appian Cloud 22.1 and later.

Last Reviewed: December 2024