KB-2191 Creating or importing Web API fails with error "could not insert: [com.appiancorp.webapi.WebApi]"


Creating or importing a Web API in Appian Designer fails with the following error in the application server log:

webApi <UUID> "<WEBAPI_NAME>": An error occurred while creating webApi [uuid=<UUID>]: org.hibernate.exception.ConstraintViolationException: could not insert: [com.appiancorp.webapi.WebApi] (APNX-1-4071-007)
Caused by: java.sql.SQLException: Duplicate entry '<ENDPOINT NAME>-<HTTP METHOD>-0' for key 'webapi_aliasmethod_idx'


A Web API with the same endpoint and HTTP method already exists in the environment. The combination of the HTTP method and endpoint for the Web API must be unique across all Web APIs in the system.


Rename the endpoint and/or HTTP method of the Web API to be unique. This can be the endpoint of the Web API being created/imported or the existing Web API.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: June 2021