Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Rollup fields Async Jo...

Rollup fields Async Jobs Fail

(0) Share

Report

Posted on by Eric Blanco

Hi, using SDK code our system jobs were updated from Suspended/Waiting to Completed/Canceled. Now our Rollup fields on Account are broken and we cannot publish the account entity. Here is the error message: "The state transition requested is not valid for the current state. Current state: 3, current status: 32, target state: 0." Using SDK code, we tried deleting the system jobs related to the rollup fields, and also changing them back to "waiting", but CRM will not allow it. We tried restarting the async services to see if we can get the jobs restarted are recreated, but it didn't work. It also will not allow us to change the recurrence schedule from the front end. We called and MS support and are waiting to hear back, but in the meantime, has anybody encountered a similar issue? Thanks in advance.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Eric Blanco 95 on at

Like (0)

Report

RE: Rollup fields Async Jobs Fail

Microsoft recommends we update the AsyncOperationBase table directly. Sample below:

update asyncoperationbase

set

statecode = 1

,statuscode = 10

where asyncoperationid in ('BAEA319E-3231-4240-9567-711FD2F47B77')