locked
Error when importing customizations RRS feed

  • Question

  • Dynamics MS CRM 4.0 Rollup#15

    I'm trying to Import a customizations file from a production system over to a dev system.

    i get the following error:

    "Failure: activitypointer: A record with these values already exists..."

    Friday, June 24, 2011 7:56 PM

All replies

  • Modify record in the file to which you are importing, that exists, remove it, but save it somewhere and import again.
    Saturday, June 25, 2011 6:32 PM
  • Can you post the server trace?
    Monday, June 27, 2011 9:39 PM
  • Exception when executing non-query: insert into SavedQueryBase(OrganizationId, IsCustomizable, IsQuickFindQuery, FetchXml, CustomizationLevel, CreatedBy, IsDefault, ReturnedTypeCode, SavedQueryId, IsUserDefined, ModifiedOn, LayoutXml, ModifiedBy, InProduction, QueryType, CreatedOn, Name) values ('70f62233-ae04-e011-aea4-8923a31bf967', 1, 0, '<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"><entity name="activitypointer"><attribute name="activitytypecode" /><attribute name="regardingobjectid" /><attribute name="modifiedby" /><attribute name="scheduledend" /><attribute name="actualend" /><attribute name="subject" /><order attribute="actualend" descending="false" /><filter type="and"><condition attribute="ownerid" operator="eq-userid" /><condition attribute="activitytypecode" operator="not-in"><value>4406</value><value>4402</value><value>4206</value><value>4209</value><value>4211</value><value>4214</value><value>4202</value></condition><condition attribute="statecode" operator="in"><value>2</value><value>1</value></condition></filter><attribute name="activityid" /></entity></fetch>', 1, 'db6d5e3b-ae04-e011-aea4-8923a31bf967', 0, 4200, 'e27d927d-616f-e011-b69e-0050569b0003', 1, '08/16/2011 20:29:14', '<grid name="resultset" object="4200" jump="subject" select="1" preview="1" icon="1"><row name="result" id="activityid" multiobjectidfield="activitytypecode"><cell name="activitytypecode" width="100" /><cell name="regardingobjectid" width="200" /><cell name="subject" width="300" /><cell name="scheduledend" width="100" /><cell name="actualend" width="100" /><cell name="modifiedby" width="125" /></row></grid>', 'db6d5e3b-ae04-e011-aea4-8923a31bf967', 0, 0, '08/16/2011 20:29:14', 'My Closed Activities') Exception: System.Data.SqlClient.SqlException: Cannot insert duplicate key row in object 'dbo.SavedQueryBase' with unique index 'UQ1_SavedQueryBase'.

    The statement has been terminated.

       at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

    Tuesday, August 16, 2011 9:44 PM