- Import Entities - SQL Error
- Posted by Rmelloni on July 2nd, 2008
Hello,
I exported all entities that a I have customized or not from my server to
import this entities in other server.
When I select any entitie or all entities return a message:
SQL Error. To obtain more information contact your system administrator.
Any idea that i do?
Thanks for your help.
- Posted by Dave Ireland on July 3rd, 2008
you may need to run a trace to know for sure, but often this is the case:
In environment 1, you have created an attribute (new_height for example) for
an entity.
In environment 2, you have created an attribute with the same name for the
same entity.
If you then export the customizations from either environment and try to
import it into the other, you will get a SQL error. It's because the unique
identifers for the attributes are different. so despite the fact that the
names are the same, the CRM thinks you are trying to add a new attribute
with a duplicate name.
Dave Ireland
"Rmelloni" <Rmelloni@discussions.microsoft.com> wrote in message
news:7DA72F76-6545-411E-8772-D482A3A2C98F@microsoft.com...
- Posted by Rmelloni on July 3rd, 2008
Hi Dave,
Resolve case.
Thanks
"Dave Ireland" wrote:
- cannot import 2 entities during customization import (Windows CRM) by Melissa Ragsdale
- Using Bulk Import Wizard for custom entities (Windows CRM) by Varsha
- Data import for custom entities (Windows CRM) by Gerd Gottschall
- Error creating new entities and editing existing entities (Windows CRM) by Howie
- How to import data to custom entities? (Windows CRM) by Gulzar

