web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Business Process Error - Cannot find record to be updated

(0) ShareShare
ReportReport
Posted on by 12,163

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

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    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)

  • Joe Woltering Profile Picture
    12,163 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.

  • Joe Woltering Profile Picture
    12,163 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.

  • purwar purwar Profile Picture
    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
    12,163 on at
    RE: Business Process Error - Cannot find record to be updated

    Yes, it is set to Organization

  • Community Member Profile Picture
    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

  • Suggested answer
    barry.carter Profile Picture
    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans