web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) N jobs through XML imp...

Microsoft Dynamics AX (Archived)

N jobs through XML import/export

(0) Share

Report

Report

Posted on by Community Member

Hi,

We have AX 2012 R2. And there are some stores where internet connectivity is a challenge. Add to that, whenever i run N-1040 (Products, prices), the log shows approx 5M records affected (in the OutGoingMessages). And it takes 3-4 hours to complete.

Is there any way to push N-1040 to XML files for each table. These files can then be sent to the stores in an external memory drive. Once there, a batch program should load them into the store database.

Is this possible? Has anyone tried this approach?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

PCO 720 on at

Like (0)

Report
Copy link

Link copied!

Hello,

I would really not recommend doing that. You have to run the N-Jobs just once ,during the original deployment of a store, after that you can use the A-Jobs.

We had also multiple million records affected by a couple of N-Jobs, we just let it run over night.

Another option would be (and this saved us in the end) was splitting the N-Jobs in multiple ones.

Lets just say N-1040 has two Tables: InventTable and InventDim. Deactivate one Table and add another N-Job (N-1040 has InventTable and N-1040-2 has InventDim). This way you still have to push all the data, but you can do it in smaller pieces (in case of unstable internet connection).

Hope this helps.

--- This forum post is my own opinion and presented as is, without any warranty ---

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 24

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans