cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShMi
New Member

Added new Table to Export to Data Lake - Now Sync is blocked

Hi,

I have been exporting a few tables to Data Lake since a few months. Now I added a new table to this data lane. The Initial sync status remains at "Not started" and is blocking the sync completely now.

 

Here a snap shot of the message!

ShMi_0-1617196590863.png

 

Can anyone help me explicitly trigger the sync.

 

Thanks

-S

5 REPLIES 5
ChrisPiasecki
Super User
Super User

Hi @ShMi,

 

This behavior is expected as described in the documentation. Your original tables will begin to sync again once the initial full sync for the newly added table is completed.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

 

Hi @ChrisPiasecki ,

Thanks. In fact I was expecting the "initial sync" for the new table to complete in a few minutes, before the sync for other tables would resume. The initial sync was blocked (or had not resumed) even after almost 3 weeks. So had to get help from Microsoft Support, who helped get the sync task reset.

 

Here some points (guesses) I derived at along the way:

  1. There are two ways you can mark a table to "export to data lake" - either by opening the table in make portal and then hitting the "Export to data lake" and then select the data lake. Or by opening the "Export to data lake" menu in the make portal, selecting the data lake, then open "Manage tables" widget and then select the new tables.
  2. The difference in the behavior of these two methods looks that the first one adds the table to data lake with "yearly partition strategy", while the second adds the table with "monthly partition strategy" by default (of course you have the option to chose the strategy in the second method, but the "show advanced configurations settings" is well hidden 🙂
  3. If you add a table with either widget, then remove it and then add the same table using the second method. The initial sync for the new table will get stuck.
  4. If that happens the fastest way to solve is to contact Microsoft Support and get the sync process reset

Hope this helps others as well.

-S

nishantrana
Helper II
Helper II

We had the same issue, we unlinked and linked back the data lake to get it working for one of the tables.

Symira
Helper III
Helper III

Thank you for the update @nishantrana

In fact, I had opened this post because the unlinking and (re) linking the tables had lead to the tables being blocked. In any case, I had to open a ticket with MS and they got the datalake sync reset from the product development team.

-S

Thanks Symira for the update. We were lucky in that case - that unlinking and linking back worked 🙂

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Users online (3,864)