Upgrading from CRM4 to CRM2011 lost entity.
-
mercoledì 11 luglio 2012 03:06
I have met a strange problem today.
We had created a customer entity Techdispatch, and it's has been working well since the beginning.
A few weeks ago, I setup an experiment crm2011 server using the data from CRM4.
I did not notice the missing Entity until today, I need to perform some Javascript upgrade for this Entity, and I discovered the entity was gone! I tried a few places in GUI and found nothing, and I went to database did a
SELECT * FROM MetadataSchema.Entity where Name LIKE '%tech%'
also found nothing. The same query in CRM4 database will return the metadata for this entity.
I am wondering what is the cause of this problem, and if anyone have encountered similar things?
I am running RollUp 7, but since the database is broken, I guess the version really doesn't matter.
Thanks for your input.
Tutte le risposte
-
mercoledì 11 luglio 2012 05:34
How did u setup the CRM 2011 environment? Did you import the CRM 4 database to CRM 2011 machine?
The import process brings in everything from the CRM 4 database during upgrade and i havent seen any entity being lost in the upgrade process. Are you sure no one accidentally deleted it?
Sam
Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com
If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"
-
mercoledì 11 luglio 2012 05:42
How did u setup the CRM 2011 environment? Did you import the CRM 4 database to CRM 2011 machine?
The import process brings in everything from the CRM 4 database during upgrade and i havent seen any entity being lost in the upgrade process. Are you sure no one accidentally deleted it?
Sam
Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com
If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"
I did a backup from CRM4 and restore to SQL Server 2012(Because we are planning to using some bleeding edge features of SQL Server 2012).
I am the only developer working with the upgrading. And I am hundred percent sure I didn't delete the Entity. As a matter of fact, I didn't even know we had this Entity until today, when I had to customize Javascript code to work with it.
Now, the only thing I can think of is that there is no record in the Tables of the Entity, and therefore CRM was "smart" enough to remove it from the system. I will have to check the database when I go back to work tomorrow.
By the way, the Tables are dropped as well.
I did a Select * from Information_schema.Tables where Table_name like '%tech%' also found nothing in the new database.
-
mercoledì 11 luglio 2012 05:45
I dont think... the upgrade has any logic to delete entities if they do not have records... :)
You can give this another try by importing the CRM 4 database again in CRM 2011and if it is still missing... open a ticket with support...
Sam
Dynamics CRM MVP | Inogic | http://inogic.blogspot.com| news at inogic dot com
If this post answers your question, please click "Mark As Answer" on the post and "Mark as Helpful"
-
mercoledì 11 luglio 2012 05:47Thanks. I will try again tomorrow and post the updated result.
-
giovedì 12 luglio 2012 04:38I performed a restore again and this time I got the entities back. But import organization failed with error message saying cannot find Microsoft.crm.SdkProxy. Seems my installation of CRM has been contaminated with dlls with CRM 4. Maybe I will need to re-install CRM2011 :(
