Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Mass Calculate Rollup ...
Microsoft Dynamics CRM (Archived)

Mass Calculate Rollup Field jobs stuck as Cancelled

(1) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

While trying to import a solution to one of our Dev tenant, we encountered following error. Error was due to one of our custom rollup field. 

The state transition requested is not valid for the current state. Current state: 3, current status: 32, target state: 3.

Quick look shows the tenant where I am importing this solution have bunch of Mass Calculated Rollup Fields Jobs (all related to different custom tollup fields) in statecode = 3 and statuscode = 32. 

AsyncOperation state diagram

Considering I can't change status of this job from Cancel to anything else (apart from delete which shouldn't work as these are system required jobs), what can I do to resume these jobs? How can I import solution with existing job in cancelled state? 

If I try any of the option from UI (Resume, Postpone or Pause) I am getting error (below is when I tried to Resume it. 

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=7.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #C227C07DDetail: 
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
  <ErrorCode>-2147220970</ErrorCode>
  <ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
  <Message>System.Web.HttpUnhandledException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #C227C07D</Message>
  <Timestamp>2019-01-10T13:49:47.4199015Z</Timestamp>
  <InnerFault>
    <ErrorCode>-2147204762</ErrorCode>
    <ErrorDetails xmlns:d3p1="schemas.datacontract.org/.../System.Collections.Generic" />
    <Message>The state transition requested is not valid for the current state. Current state: 3, current status: 32, target state: 0.</Message>
    <Timestamp>2019-01-10T13:49:47.4199015Z</Timestamp>
    <InnerFault i:nil="true" />
    <TraceText i:nil="true" />
  </InnerFault>
  <TraceText i:nil="true" />
</OrganizationServiceFault>

Are Mass Calculate Rollup Field Jobs supposed to be in Cancel state?

*This post is locked for comments

  • David_Williams_TCW Profile Picture
    David_Williams_TCW 10 on at
    RE: Mass Calculate Rollup Field jobs stuck as Cancelled

    We are experiencing the same/similar issue.  All of our system jobs for calculating rollup fields are stuck in canceled.  No way to resume, postpone, delete or anything.  Hence, none of our rollup fields are updating and have to be manually refreshed.  Need to find a solution.

  • JZot Profile Picture
    JZot 185 on at
    RE: Mass Calculate Rollup Field jobs stuck as Cancelled

    Hi @kmria,

    Experiencing the same issue as well. Did you manage to find a workaround and force resume the system jobs?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass Calculate Rollup Field jobs stuck as Cancelled

    [quote user="Rawish Kumar"]

    Unfortunately you cannot manually resume the job and you will get the same error.

    These are just some child jobs those were created at a scheduled time and tried to ran but failed/cancelled. THEY ALL HAVE A PARENT JOB WHICH YOU WILL FIND IN "INPPROGRESS" or "WAITING" status. worry about that job.

    you can go ahead and delete others?

    [/quote]

    There were few other jobs related to the rollup field in question (though nothing to say parent/child). I did delete them way before trying to change status of this system job in question. I can't resume or delete this cancelled job. (usually, you can delete cancelled job but because this job is required by system, I get error when I try to delete it).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Mass Calculate Rollup Field jobs stuck as Cancelled

    [quote user="Sreevalli"]

    Hi,

    Under Action flowout button you should be having Resume option.

    Settings -> System Jobs. Select Recurring System Jobs view from dropdown, then you can apply filter on name to find the job

    [/quote]Tried that already with no success.

  • Rawish Kumar Profile Picture
    Rawish Kumar 13,756 on at
    RE: Mass Calculate Rollup Field jobs stuck as Cancelled

    Unfortunately you cannot manually resume the job and you will get the same error.

    These are just some child jobs those were created at a scheduled time and tried to ran but failed/cancelled. THEY ALL HAVE A PARENT JOB WHICH YOU WILL FIND IN "INPPROGRESS" or "WAITING" status. worry about that job.

    you can go ahead and delete others?

  • Sreevalli Profile Picture
    Sreevalli 3,256 on at
    RE: Mass Calculate Rollup Field jobs stuck as Cancelled

    Hi,

    Under Action flowout button you should be having Resume option.

    Settings -> System Jobs. Select Recurring System Jobs view from dropdown, then you can apply filter on name to find the job

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,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans