Pages

Tuesday, May 6, 2014

Cross reference update never finishing on AX 2012 R2

I had a development box where I just couldn't get a cross reference update to finish. Even letting it run for days didn't help.

I finally got to run a SQL trace on what was going on. A thing that I probably should have tried a lot earlier. From the trace I could see that the cross reference for some reason was in an infinite loop on a particular form. I checked over a few hours and it never did seem to get past that form.

I killed the process and started a new cross reference agin, but this time I deleted the existing cross reference first:

When that was finished, I started a new cross reference update with the "Update all" option checked and this time cross reference was updated within the expected time frame.



3 comments:

Sakthi Ananth said...

Hey Thanks man. Even I'm also facing the same problem. I was not able to cross refer any of the objects before. Thanks

Aman Nain said...

Also if your server configuration is pointing to a wrong server, cause you restored your DB, xRef wont work.

Deepak Bhasin said...

Hi,
I am facing the same issue. It took around 12 hours & its still running. Can you guide me how to do it.

Thanks In ADVANCE.