Mass Calculate Rollup Field jobs stuck as Cancelled

(1) Share

Report

Posted on by Community Member

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

All responses (6)

Answers (0)

David_Williams_TCW 10 on at

Like (0)

Report

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 193 on at

Like (0)

Report

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 on at

Like (0)

Report

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 on at

Like (0)

Report

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 13,758 on at

Like (1)

Report

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 3,256 on at

Like (0)

Report

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