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

(0) Share

Report

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

All responses (11)

Answers (1)

Suggested answer

Nishant Rana 11,320 Microsoft Employee on at

Like (1)

Report

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

This is what worked for us

nishantrana.me/.../
Lynda Joyner 30 on at

Like (2)

Report

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

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

SwathiD 200 on at

Like (2)

Report

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

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 30 on at

Like (0)

Report

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

Hi

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

SwathiD 200 on at

Like (1)

Report

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

This is a Microsoft issue.
Dynamics365 Rocker 7,755 on at

Like (0)

Report

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

An entity in CRM will be table in SQL.
SwathiD 200 on at

Like (0)

Report

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

Sorry but this is not custom entity. This is a MS SQL table.
Dynamics365 Rocker 7,755 on at

Like (0)

Report

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

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 200 on at

Like (0)

Report

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

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)
Suggested answer

Darshik 295 on at

Like (1)

Report

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

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