web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Update cross reference...

Microsoft Dynamics AX (Archived)

Update cross reference in batch in Dynamics AX 2012

(0) Share

Report

Report

Posted on by Kothamasu pavan

40

This post is based on Dynamics AX 2012 R3.

static void UpdateCrossRefBatch(Args _args)

{

;

xRefUpdate::truncateXrefTables();

xRefUpdateIL::updateAllXref(true, false, true);

info("Done, cross reference update batch job created.");

}

Can someone please explain me this code, thanks.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Verified answer

Mea_ 60,284 on at

Like (0)

Report

Hi Kothamasu pavan ,

First line will drop all data from cross references table and second will kick off batch job to rebuild it. If you don't familiar with cross references you need to read this article msdn.microsoft.com/.../aa626961.aspx

Was this reply helpful? Yes No
Verified answer

Vilmos Kintera 46,149 on at

Like (0)

Report

Running the xRef update from the menu to execute within the AX client is taking a very long time, 10-12 hours easily. If you kick it off in a batch job by running an X++ job, it could finish in 2-3 hours server-side instead. That is the purpose of the above code, rebuilding cross-references faster.

Please mark helpful answers as Verified next to each post with the checkbox.

Was this reply helpful? Yes No
Kothamasu pavan 40 on at

Like (0)

Report

Hi,

ievgen Miroshnikov and Vilmos Kintera

Thanks for detail explanation.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans