You are currently reviewing an older revision of this page.
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)
This issue has been addressed via AN-99299 in the following hotfixes/versions:
Apply the latest hotfix to your Appian installation.
This workaround should only be considered after discussing with your database team on whether synonym objects are significant for your environment.
SELECT * FROM all_objects WHERE object_name = '<TABLE NAME>'
This article applies to Appian 17.3 on Hotfix Package D and 17.4 Hotfix Package B.
Last Reviewed: February 2018