Skip to main content

Column names in each table must be unique. Column name '' in table '' is specified more than once

Guidance on the error whilst trying to create a form: Column names in each table must be unique. Column name '' in table '' is specified more than once. Whilst trying to create a form.

C
Written by Connor Baeza

Issue

You may receive an error message stating that columns must be unique when saving a form, even though no changes have been made.

Cause

This happens when the form has a previous version where a column name uses different letter casing.

Example:

  • The form displays Field1, but the XML contains field1.

RIO treats Field1 and field1 as two different columns, which triggers the uniqueness error.

Resolution

A data change is required to update the form XML so that all versions use the same casing for the field name. This will resolve the duplicate column error.

Type talk to a person and the Digital Assistant will put you through to a live support agent.

Did this answer your question?