Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM (Archived)

Business Process Error - Cannot find record to be updated

Posted on by 12,159

I have a real-time workflow activated to update the Account field in an Opportunity when the originating Lead is qualified. This is because OOB CRM 2013 maps the Full Name of the Lead (as a Contact) to the customerid field in the Opportunity. My workflow works when run as System Administrator, but as any other user it fails with the error: "Sync workflow failed with error message - Unhandled Exception: Microsoft.Crm.CrmException: Cannot find record to be updated." The security role has full access to both the Lead and Opportunity so something else is preventing them from executing the workflow.

The logic of the workflow is as follows:

Workflow type: Real-time

Run on entity: Lead

Start when: Status Changes

Actions: Update: Qualifying Opportunity

*This post is locked for comments

  • Suggested answer
    barry.carter Profile Picture
    barry.carter 85 on at
    RE: Business Process Error - Cannot find record to be updated

    Hi Joe,

    I am using CRM 2013 SP1 and if you map the fields it should populate automatically.

    Lead to Opportunity mapping:

    Parent Account for Lead (parentaccountid) to Account (parentaccountid)

    Parrent Contact for Lead (parentcontactid) to Contact (parentcontactid)

    Hope this helps

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Business Process Error - Cannot find record to be updated

    Hi Joerbs,

    Could you try to set Administration role to another user and retry?

    Thanks

  • Joe Woltering Profile Picture
    Joe Woltering 12,159 on at
    RE: Business Process Error - Cannot find record to be updated

    Yes, it is set to Organization

  • purwar purwar Profile Picture
    purwar purwar 2,836 on at
    RE: Business Process Error - Cannot find record to be updated

    Kindly check scope of workflow: it should be organizational , Kindly check it.

  • Joe Woltering Profile Picture
    Joe Woltering 12,159 on at
    RE: Business Process Error - Cannot find record to be updated

    When I convert it to a background process, it does nothing. When I qualify the Lead, the workflow doesn't fire at all.

  • Joe Woltering Profile Picture
    Joe Woltering 12,159 on at
    RE: Business Process Error - Cannot find record to be updated

    Thanks Adam, I should've mentioned that I did try your second suggestion with the same result.

    I guess the curious thing to me is why it should run ok as System Admin, but not as another user. This would seem to imply that it isn't a timing issue.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Business Process Error - Cannot find record to be updated

    It is obviously running too soon, when the Lead is Qualified but the Opp has not been created yet. Running it as a background workflow might work, but will probably still break occasionally.

    You could run it as a background workflow and add a short wait (1 minute?)

    Best bet though, would be to run the workflow on create of the Opportunity, check if it has an originating lead, and the customer is a contact, then update it to the parent account of the contact (check that it has one)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans