Unable to delete WebApp - ERROR: duplicate key value violates unique constraint “xtkdictionarystring_name”

Description

Occasionally you may be unable to delete a WebApp  and may encounter the following error PGS-220000 PostgreSQL error: ERROR: duplicate key value violates unique constraint “xtkdictionarystring_name.”

DETAIL: Key (iobjectid, ssourceid, slocale) = (0, del_5818632_closedFormLog, en) already exists.

Resolution

If you encounter this error in ACC while deleting the web app that is no longer required, the resolution would be to delete the webApp via Workflow (As shown below)

  • Create a new workflow and drop a query and update activity on the canvas.

  • Query the primary key of the webapp and update the operation type as delete in update data activity. Please note once the app is deleted it cannot be retrieved unless a database restore is done.

On this page