You’re offline. This is a read only version of the page.
501
Hi everyone,
I completed Yun Zhu's Tutrorial on Custom Dataverse insert data from Business Central to Dataverse.
Everything works fine. I can Insert, delete and modify records in Dataverse.
I started with a Full Synchronization of the G/L Entry over the weekend. It's about 700,000 records.
After about 2 Days and 100,000 records later it seemed to have stopped inserting but there is no finished time.
My questions are the following.
Is there a limit on the amount of lines that can be inserted from Business Central to Dataverse?
Is there a way to check if records are still being inserted into Dataverse?
Can you fully stop the Synchronization process? I had a problem with duplicate insertion when Full synchronization is clicked twice.
Thank you in advance
Hi, Maybe the limitation is related to the following MS Docs.
We have submitted a Support Request to ask Microsoft to expand some settings before, for exampe, timeout. I don't know if this is still allowed, I think you can try to get in touch.
Hope this info will help.
Thanks.
ZHU
Hi Nitin and Marco,
I looked in the Job Queue Entry as Nitin suggested and I found the process did error because the process took longer than 12:00. It automatically restarted after the first 12:00 hours and then stopped.
Another user on another forum advised to rather do 50,000 rows at a time and run three jobs with the scheduler. This improves the insert time but leaves the user to check if the jobs have completed. is there maybe another method to insert 700,000+ records without doing 50,000 at a time?
Maybe up the time out to 72 hours?
Hi Hein,
Yes you can view what is being synchronized, by going to the JOB queue, you can start stop any time, everytime when you start synchronize, a job queue entry creates and delete it self when synchronize done.
Just go to the job queue entry and try to find which one is "In-Process" state
Thanks.
Hello,
Did the job queues time out and maybe do a couple of synchs where you do the synchronization in batches using filters may help?
Thanks.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (