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..:)
