Users are unable to create Quick Apps using a datasource created in the Admin Console. The following error is shown in the browser at the end of the Quick Apps Wizard:
Quick App Not Created
Oops! Something went wrong and we couldn't create your Quick App. Nothing has currently been created. You can try to create your Quick App again, but if it continues failing please contact a system administrator.
At the time the above error occurs, the following stack trace is printed in the application server log:
2016-05-09 15:30:25,875 [ajp-/0.0.0.0:8009-15] ERROR com.appiancorp.object.quickapps.QuickAppObjectType - Failed to create a new quick app
com.appiancorp.type.external.config.DataStoreConfigNotPublishableException: The data store DATA_STORE [id=4742] was saved but cannot be published: An error occurred while trying to modify the data source schema: Auto-commit can not be set while enrolled in a transaction; Auto-commit can not be set while enrolled in a transaction; Auto-commit can not be set while enrolled in a transaction (APNX-1-4178-000)
This issue has been addressed via AN-69713 in the following hotfixes/versions:
Apply the latest hotfix to your Appian installation or upgrade to the latest version of Appian.
To work around the issue, create a data source using the steps in Configuring Relational Databases and use that data source for the Quick App.
This article applies to Appian 16.2.
Last Reviewed: February 2017
© 2020 Appian. All rights reserved.