locked
Desperate for help, error re-assigning leads, contacts, accounts, and etc. RRS feed

  • Question

  • Ok,

    I have been researching this problem for a week now, I am getting the dreaded "There should be only one owner party for an activity" error when re-assigning records such as leads, accounts, and contacts at a client site.  I have upgraded to the latest service pack release and have looked through the database for any glaring issues and nothing stands out yet.  Has anybody actually solved this problem?  It is happening on thousands of records so addressing each one manually is not an option. 

    Here is the trace stack:
    Microsoft CRM Error Report:
    Error Description:
    There should be only one owner party for an activity

    Error Details:
    There should be only one owner party for an activity

    Full Stack:
    [CrmException: There should be only one owner party for an activity]
       at Microsoft.Crm.ObjectModel.GenericActivityServiceBase.InternalAssign(BusinessEntity entity, SecurityPrincipal assignee, ExecutionContext context)
       at Microsoft.Crm.BusinessEntities.CascadeEngine.CascadeAssign(CascadeRecordSet recordSet, Dictionary`2 monikerToEntity, SecurityPrincipal assignee, ExecutionContext context)
       at Microsoft.Crm.BusinessEntities.CascadeEngine.AssignDB(BusinessEntityMoniker moniker, SecurityPrincipal assignee, ExecutionContext context)
       at Microsoft.Crm.BusinessEntities.BusinessProcessObject.Assign(BusinessEntityMoniker moniker, SecurityPrincipal assignee, ExecutionContext context)
    
    [TargetInvocationException: Exception has been thrown by the target of an invocation.]
       at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
       at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
       at System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
       at Microsoft.Crm.Extensibility.InternalOperationPlugin.Execute(IPluginExecutionContext context)
       at Microsoft.Crm.Extensibility.PluginStep.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.Pipeline.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.MessageProcessor.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.InternalMessageDispatcher.Execute(PipelineExecutionContext context)
       at Microsoft.Crm.Extensibility.ExternalMessageDispatcher.Execute(String messageName, Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, PropertyBag fields, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.RequestBase.Process(Int32 primaryObjectTypeCode, Int32 secondaryObjectTypeCode, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.RequestBase.Process(CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.CrmServiceInternal.Execute(RequestBase request, CorrelationToken correlationToken, CallerOriginToken originToken, UserAuth userAuth, Guid callerId)
       at Microsoft.Crm.Sdk.InProcessCrmService.Execute(Object request)
       at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.ExecuteInternal()
       at Microsoft.Crm.Application.Platform.DataSource.Assign(Guid entityId, String entityType, SecurityPrincipal principal)
       at Microsoft.Crm.Application.Platform.CommunicationListeners.AssignRouteOnCreateUpdateListener.AssignEntity(Entity entity, LookupValue owner)
       at Microsoft.Crm.Application.Platform.CommunicationListeners.AssignRouteOnCreateUpdateListener.AssignRouteEntity(Entity entity, LookupValue owner)
       at Microsoft.Crm.Application.Platform.CommunicationListeners.AssignRouteOnCreateUpdateListener.HandlePostEvent(PlatformCommand command, Response response, Boolean wasForUpdate)
       at Microsoft.Crm.Application.Platform.CommunicationListeners.CommunicationListener.HandlePostEvent(PlatformCommand command, Response response)
       at Microsoft.Crm.Application.Platform.ServiceCommands.PlatformCommand.ExecuteInternal()
       at Microsoft.Crm.Application.Platform.ServiceCommands.UpdateCommand.Execute()
       at Microsoft.Crm.Application.Platform.EntityProxy.Update(Boolean performDuplicateCheck)
       at Microsoft.Crm.Application.Platform.EntityProxy.Update()
       at Microsoft.Crm.Application.Forms.AppForm.HandleFormEventAssign(Boolean gridRefreshCallbackAdded)
       at Microsoft.Crm.Application.Forms.AppForm.RaiseDataEvent(FormEventId eventId)
       at Microsoft.Crm.Application.Forms.EndUserForm.Initialize(Entity entity)
       at Microsoft.Crm.Application.Forms.CustomizableForm.Execute(Entity entity, String formType)
       at Microsoft.Crm.Application.Forms.CustomizableForm.Execute(Entity entity)
       at Microsoft.Crm.Web.SFA.LeadDetailPage.ConfigureForm()
       at Microsoft.Crm.Application.Controls.AppUIPage.OnPreRender(EventArgs e)
       at System.Web.UI.Control.PreRenderRecursiveInternal()
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    
    [HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown.]
       at System.Web.UI.Page.HandleError(Exception e)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
       at System.Web.UI.Page.ProcessRequest()
       at System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
       at System.Web.UI.Page.ProcessRequest(HttpContext context)
       at ASP.swfeast_sfa_leads_edit_aspx.ProcessRequest(HttpContext context)
       at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
       at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
    
    

    Other Message:
    Error Number:
    0x80040203

    Source File:
    Not available

    Line Number:
    Not available


    Date: 01-01-2010

    Time: 18:50:01

    Server: crm
    Request URL:
    Friday, January 1, 2010 11:57 PM

Answers

  • Have you tried this:

    Another option to try is to turn off the cascading action to activities when re-assigning records like Accounts, Leads, etc.  I actually prefer to turn off the cascading action to these records because having the ownership cascade to associated activities can be misleading.   You can try to turn off the ownership cascading action on the Account entity for activities and see if that works.  However, the company will still have bad data in the database.
    Best Regards, Donna
    • Marked as answer by Jim Glass Jr Friday, February 26, 2010 9:24 PM
    Monday, January 11, 2010 8:53 PM

All replies

  • These errors usual pointing to the SQL data problems. Did you upgrade your CRM from previous versions ?
    Do you have any custom applications like callouts, plugins ?

    Check this article: http://social.microsoft.com/Forums/en-US/crmdeployment/thread/d82cedee-e24e-4abc-9ec6-41306b89ed3b/

    especially David Jennaway post:


    The following SQL queries may help diagnose the problem.

     

    -- Check if any activities have more than one owner. This should return no data

    select activityid, count(*) from filteredactivityparty
    where participationtypemask = 9
    group by activityid
    having count(*) > 1

     

    -- Check if any account records have been set as an activity owner. Again, this should return no data

    select activityid, partyid, partyidname
    from filteredactivityparty
    where participationtypemask = 9
    and partyobjecttypecode = 1

     

    -- Read information about activityparties for a given account. Replace <Account Name> with the name of an account

    select a.ownerid, a.owneridname, ap.partyid, ap.partyidname, ap.participationtypemask
    from filteredactivityparty ap
    join filteredaccount a
    on ap.partyid = a.accountid
    where a.name = '<Account Name>'

    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Saturday, January 2, 2010 12:06 PM
  • All right. no callouts or anything, I checked.  I ran the three queries and the first two return no results, the third one I pasted the results of it when ran against one of the accounts having problems.  If you look to the bottom of the list there are some records with a null partyidname, could this be the problem?  If so what should I do just run some mass updates to fill in the appropriate partyid or should I delete the offending records.

    a.ownerid, a.owneridname, ap.partyid, ap.partyidname, ap.participationtypemask
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 2
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C NULL 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 2
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C NULL 8
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C I Designs 2
    85A25DF4-6B2D-DC11-AE41-000A5E4CC6A0 Bill Richards FA344DF8-DE26-DD11-8CF5-0002B3F04D4C NULL 8
    Saturday, January 2, 2010 1:55 PM
  • I would probably engage Microsoft support to ensure that the action you take against the database is a supported action. 

    Another option to try is to turn off the cascading action to activities when re-assigning records like Accounts, Leads, etc.  I actually prefer to turn off the cascading action to these records because having the ownership cascade to associated activities can be misleading.   You can try to turn off the ownership cascading action on the Account entity for activities and see if that works.  However, the company will still have bad data in the database.


    Best Regards, Donna
    Wednesday, January 6, 2010 4:45 PM
  • The only thing I can think of would be to check what option you have set in System Settings for "Share ReAssigned Records with the Original Owner" checkbox... by default, it is set to "No"... I would check whether or not yours is set, and also, what version of CRM are you running on the server? Update Rollup 8 that came out 4 weeks ago? That has some fixes, that aren't documented that might assist your problem.

    If that doesn't work... definitely call Microsoft Business Solutions (Dynamics) CRM Support, I think the phone number is (888) 477-7877.


    Wednesday, January 6, 2010 10:16 PM
  • Thanks for the reply Paul,

    Unfortunately the problem is still persisting.  Still working on a few ideas to try to fix it before calling MS, if anybody else has any suggestions feel free.  I have installed the Update Rollup 8 already.

    Jeremy
    Monday, January 11, 2010 7:41 PM
  • Have you tried this:

    Another option to try is to turn off the cascading action to activities when re-assigning records like Accounts, Leads, etc.  I actually prefer to turn off the cascading action to these records because having the ownership cascade to associated activities can be misleading.   You can try to turn off the ownership cascading action on the Account entity for activities and see if that works.  However, the company will still have bad data in the database.
    Best Regards, Donna
    • Marked as answer by Jim Glass Jr Friday, February 26, 2010 9:24 PM
    Monday, January 11, 2010 8:53 PM