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 :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / AX 2012 - Batch Job re...
Microsoft Dynamics AX (Archived)

AX 2012 - Batch Job remains at Cancelling

(0) ShareShare
ReportReport
Posted on by BiffBaffBoff 830

I have a Batch Job which got stuck at Executing status and I read that by setting it to Cancelling and then restarting the batch server AOS, this will resolve the problem. However, after doing so the status is stuck at Cancelling and not changing. I'm also not able to change the status manually due to it being in a Cancelling status. Any idea how this is fixed?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at
    RE: AX 2012 - Batch Job remains at Cancelling

    Check to see what batch group is associated with the jobs, and what AOS is actually responsible for executing that group of batches. Are you sure there is a AOS picking them up?

  • BiffBaffBoff Profile Picture
    BiffBaffBoff 830 on at
    RE: AX 2012 - Batch Job remains at Cancelling

    I created a Batch Group called "Invoice". It has a Batch Server attached to it (My AOS) and it is configured to be a batch server (Server Configuration). What do you mean by AOS picking them up?

  • Verified answer
    Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at
    RE: AX 2012 - Batch Job remains at Cancelling

    Batch jobs are associated with a particular AOS at any time, and if this AOS is configured to be batch server, it will "pick them up" and run them according to the recurrence settings.

    If you can't stop the batches, and they remain stuck in Cancelling, you have two options; 1) kill the associated SPID on the SQL Server (in case it is stuck there), or 2) simply restart the AOS.

    What you could try, since this is your sandbox/playground AOS (afaik), is to stop the AOS, head over to the DB and update the table Batch by running this query; UPDATE BATCH SET STATUS = 0 WHERE STATUS > 6, then BatchJob with UPDATE BATCHJOB SET STATUS = 0 WHERE STATUS > 6. Then start the AOS and continue from there. There could be something wrong with the jobs themself. You should also just open the table browser (or SQL Query the tables) and see if the AOSID is correct for the jobs in question.

  • BiffBaffBoff Profile Picture
    BiffBaffBoff 830 on at
    RE: AX 2012 - Batch Job remains at Cancelling

    I have already tried restarting the AOS but this didn't work.

    How do I find out which SPID the batch is using? I've looked on SQL server and there were 0 results returned when I did a SELECT * FROM BATCH WHERE STATUS > 6. The task's in my Batch Job have a status of Ended

  • Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at
    RE: AX 2012 - Batch Job remains at Cancelling

    So this means it is no longer stuck in Cancelling. Have you tried to start them again?

    A batchjob with status Ended or Hold will surely not have any Process ID (SPID), since it is idle.

  • BiffBaffBoff Profile Picture
    BiffBaffBoff 830 on at
    RE: AX 2012 - Batch Job remains at Cancelling

    When I did SELECT * FROM BATCHJOB WHERE STATUS > 6 I can see my Batch Job and it has a status of 7. It seems BATCH show's the Tasks associated to a Batch Job?

  • Tommy Skaue Profile Picture
    Tommy Skaue Moderator on at
    RE: AX 2012 - Batch Job remains at Cancelling

    Well, it can be various reasons for it to be stuck in Cancelling, but I see no harm in setting it to STATUS = 0, so you can try start it up again. :-)

  • BiffBaffBoff Profile Picture
    BiffBaffBoff 830 on at
    RE: AX 2012 - Batch Job remains at Cancelling

    But it first got stuck in Executing, hence why I had to put it into Cancelling, so I think there is a wider issue here..

  • Kazinova Profile Picture
    Kazinova 1,500 on at
    RE: AX 2012 - Batch Job remains at Cancelling

    Hi Tommy, using exec sp_who, how can I find the spid of a batch process that is sleeping or tying up batch jobs? I have a batch job that has had no progress (relating to data upgrade cockpit), and I have verified all the tables and ensured no other batch jobs are running. I have automatic role assignment and user license counts on withhold and a status of '0'. I have set up three batch servers all with the dataupgrade batch job...still no progress, no logs or errors, nothing...any ideas?

  • Kazinova Profile Picture
    Kazinova 1,500 on at
    RE: AX 2012 - Batch Job remains at Cancelling

    FYI, the batch job has been sitting in waiting, not executing. I verified the batch groups, batch servers, etc are all configured correctly.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Community Member Profile Picture

Community Member 2

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans