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)

Sort by

Verified answer

Mea_ 60,286 on at

Like
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

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
a
(0)

Report
Copy link

Link copied!

Hi,

ievgen Miroshnikov and Vilmos Kintera

Thanks for detail explanation.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 10

#2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans