When you attempt to import a solution in Dynamics 365, the import fails and you see the following message:
"The import file is too large to upload.
Error code 80040375"
Although the error message indicates a problem with the import file being too large to upload, another issue such as a SQL error may be the cause.
Click the Download Log File button to see a more detailed message. You may see details such as the following message:
"The import failed. For more information, see the related error messages. : System.Data.SqlClient.SqlException (0x80131904): Column names in each table must be unique. Column name '<column name>' in table '<entity/table name>' is specified more than once..."
The example message above is a SQL error that can occur if you try to import a field that already exists in that entity.
Example: If you had created a custom field in the organization with a schema name called new_field1 on the Account entity. Now you are trying to import a solution that contains a field with that same schema name on the Account entity. SQL does not allow multiple columns with the same name in the same table so this will cause the import to fail. You may find that in the target environment you already had a field with the same schema name but different casing such as new_Field1 and the field in the solution you are importing is new_field1. If the field with the same name is not needed in the target environment, delete it and then try the import again.
If the error persists and you are not able to resolve the issue using the details in the log file, contact Microsoft Support for assistance. You can also use the information in the log file to search for potential solutions in the Dynamics 365 Communities.