Data update batch job in waiting status Microsoft Dynamics AX 2012

Data update batch job in waiting status AX 2012

While AX 2012 upgrade steps in Data upgrade checklist AX 2012. it is required to follow checklist steps without skipping.

In Pre-Synchronization step, Many times it happens that Dataupdate batch jobs is scheduled to run. But it goes in waiting mode for long time. For that verify below setups

·         System service accounts

o   enter admin user in the business connect

·         Server configuration

o   Select ISBATCH for the current AOS server

o   Verify that the Batch groups to process are in selected group under Batch server groups tab

·         Batch group

o   Check that dataupdate group is available

o   Batch server tab, assign the current active batch server is in selected group

Now if everything looks perfect then also batch not showing executing,

Two options to follow

1)      Update batch server id from SQL

2)      Delete all batch job and recreate

1)      Update batch server id from SQL

               

                It’s time to go backend (SQL)

Go to SQL server management studio and create new query selecting AX database.

Select * from Batch

Select * from BatchJob

If you find any rows showing old ServerID then update it

update batch set SERVERID = '<01@NewAOS>' where serverid = '<02@OldAOS>'

Wait for few minutes and check that any batch showing in executing or ended.

2)      Delete all batch job and recreate

If still not running the any batch on option 1. Just delete all batch jobs. Take backup before deleting.

Run the Pre-Synchronize form again from checklist. Load scripts and click on RUN.

Open batch job form and review the batch running or not



This helped you..!! Then comment below..:)