web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Customer Service forum / Import failed: Column ...
Customer Service forum

Import failed: Column names in each table must be unique. Column name 'Column A' in table 'Table A' is specified more than once

(0) ShareShare
ReportReport
Posted on by SwathiD 200

Below error while trying to import a solution into UAT.

Import failed: Column names in each table must be unique. Column name 'Column A' in table 'Table A'  is specified more than once. Any solutions please?

Thanks in advance.

Categories:
Other
I have the same question (0)
  • LeoAlt Profile Picture
    LeoAlt 16,331 Moderator on at

    Hi partner,

    According to the error message, please check the following points:

    1.Is there any other column named "Column A" in "Table A".

    2.Check if "Column A" isn't defined in another table (in addition to "Table A") in the same table hierarchy. If it isn't, verify that there are no ID conflicts.

    3.Whether the database field and UAT field are defined

    By the way, if you want to change the field, you should do this through solutions instead of Database.

    If the issue still exists, you could raise a ticket to Microsoft and let them help you in the background.

    Hope it helps.

    Best Regards,

    Leo

  • Suggested answer
    Darshik Profile Picture
    Darshik 295 on at

    Hi SwathiD,

    Please check whether the field name is same and data type is different for the field then delete the filed and migrate the field with the solution .

    you can export the target table schema and matched with the source schema.

    also check whether the field name is the case sensitive.

    Regards,

    Darshik

  • SwathiD Profile Picture
    SwathiD 200 on at

    Thank you for the replies. Our organisation uses online Dynamics 365. And this is an underlying Microsoft SQL table (so we cannot check the field type or edit the table)

  • Dynamics365 Rocker Profile Picture
    Dynamics365 Rocker 7,755 on at

    in Dynamics 365, GoTo-->Settings-->Solutions-->Open your solution -->Open entity A and check if there is field with duplicate display name.

    If you find duplicate field then change display name of field.

  • SwathiD Profile Picture
    SwathiD 200 on at

    Sorry but this is not custom entity. This is a MS SQL table.

  • Dynamics365 Rocker Profile Picture
    Dynamics365 Rocker 7,755 on at

    An entity in CRM will be table in SQL.

  • Suggested answer
    SwathiD Profile Picture
    SwathiD 200 on at

    This is a Microsoft issue. 

  • Lynda Joyner Profile Picture
    Lynda Joyner 32 on at

    Hi

    Did you get a resolution to this error as I have also encountered this error today and struggling to resolve. Many thanks

  • Verified answer
    SwathiD Profile Picture
    SwathiD 200 on at

    Hello Lynda,

    This is a Microsoft issue and below is the resolution they provided.

    1. Open the solution and click on the entity with the issue (Ex: Contact) .

    2. Uncheck the “Offline capability for Dynamics 365 for Outlook” (you should be able to see this field when you click on the entity )

    3. Check “Business Process Flows” field as well.

    4. Then export and import the solution into the target.

    3. Once the import is successful, again check the “Offline capability for Dynamics 365 for Outlook” field and again export and import the solution.

    Thanks,

    Swathi

  • Lynda Joyner Profile Picture
    Lynda Joyner 32 on at

    Thank you for your response Swathi, this did indeed resolve my error.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Customer Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans