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

Import Model store AX 2012

During AX 2012 upgrade steps there is the step required to import model store. The AX upgrade guide given the steps but it could not work to me. For that I found other way on technet steps as below:

- Create a temporary schema

- Import model store to temporary schema

- Apply the model store

Import model store

Create a temporary schema
Create a temporary schema in AX database to be used on next step during import model store.

Steps:
1. Open SQL Server Management Studio
2. Connect to the SQL Server instance where AX database resides
3. Expand to Databases > MicrosoftDynamicsAX_model > Security > Schemas
4. Right click > New schema
5. Type in the temporary schema name (TempSchema) and select the schema owner and click "OK"
6. Initialize the temporary schema

Initialize-AXModelStore -AOSAccount "Domain\AccountName" -SchemaName <NewSchema> -Server <ServerName> -Database <DatabaseName>)

Import model store to temporary schema
Syntax: Import-AXModelStore -File <filename> -SchemaName 

Example:

Import-AXModelStore -File “C:\AX_Model_and_ModelStore_Backup-Export\AXModels_11-9\AXModelStore.axmodelstore” -SchemaName “TempSchema” –IdConflict overwrite

This will take a long time (might be 2+ hours)

Apply the model store

Example: Import-AXModelStore -Apply:TempSchema  

Restrat AOS, compile and synchronize application

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