KB-1498 Unable to publish data store 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-98899 in the following hotfixes/versions:
Action
Apply the latest hotfix to your Appian installation or upgrade to the latest version of Appian.
Workaround
This workaround should only be considered after discussing with a DBA on whether synonym objects are significant for the 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 and 17.4.
Last Reviewed: February 2018