[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

This issue will be addressed via AN-99299 in the following hotfixes/versions:

Action

Please contact Appian Support for the fix until the Hotfix packages are made available.

Workaround

This workaround should only be considered after discussing with your database team on whether synonym objects are significant for your environment.

Run SELECT * FROM all_objects WHERE object_name = '<TABLE NAME>'
Drop the Synonym objects based on results returned from above query.

Affected Versions

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

Last Reviewed: February 2018