Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Ainsley Jackson]

Hi,

We have a large data set (17 million rows) which we are exporting to BYDO. 

We accidentally unchecked ‘skip staging’ and now the job is taking forever (20+ hours so far) to move the data into staging. 

We tried the following with no success:
– Checked SQL currently executing queries. Nothing there.
– Deleted the DMF export project. 
– Restart DIXF service

Any ideas?  

——————————
Ainsley Jackson
Software development
——————————

[Denis Macchinetti]

Hi Ainsley,

let me understand better.

do you are saying that the export take around 20+ hours also after recreating the Export with skip staging enable?

——————————
Denis Macchinetti
AX Technical & Solution Architect
Deloitte Consulting
Padova
——————————
——————————————-

[Nandita Nityanandam]

Hi Ainsley,

Restart the IIS service.

If you perform restart while the job is still in executing mode, the system will stop the job in the backend. It will show the job status as Executing although the job is stopped in the backend. Then you can rerun the export job with skip staging as checked.

I hope this helps.

This answer is provided by Surbhi Agarwal, Sr. Software Engineer, Dynamics 365FO, Synoptek.

 

——————————
Nandita Nityanandam
Marketing Head
Synoptek
Oakbrook Terrace IL
——————————
——————————————-

[Rahul Mohta]

also restart batch and data management services

——————————
Regards
Rahul Mohta
Advisor – D365FO
Real Dynamics
——————————
——————————————-