You are currently reviewing an older revision of this page.

[DRAFT] KB-XXXX Unable to publish datastore due to "Missing column" error using Oracle

This issue has been resolved in an Appian hotfix/new Appian version. Please apply the latest hotfix to your Appian installation or upgrade to the latest version of Appian.

Symptoms

When trying to save and publish a data store object, an "Unable to automatically create tables" error is experienced. The application server log and looking at "More Info" shows the following error:

The data source schema does not match the type mapps: Missing colum: <ID> in <PREFIX>.<TABLE NAME> (APNX-2-4056-000)

Cause

Action

Apply the latest hotfix to your Appian installation.

Affected Versions

This article applies to Appian 17.3 on Hotfix Package D and 17.4 Hotfix Package B.

Last Reviewed: February 2018