question

Btempleton-3102 avatar image
0 Votes"
Btempleton-3102 asked NavtejSaini-MSFT commented

Azure Datasync Group keeps syncing same records

We have a Sync group that indicates the same number of records downloaded many many times -- when it has "real" work to do the number is higher, but then reverts to 182 records downloaded. It is reporting success, but it sure appears it is doing the same records over and over again. example message: Sync completed successfully in 38.84 seconds. Upload: 0 changes applied Download: 182 changes applied How can I determine what records were just processed, this sync group has 51 tables Thanks Brent Templeton

azure-sql-database
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Btempleton-3102 We are checking this and will get back to you.

0 Votes 0 ·

I have not -- I have to figure out how to do that. Do you have the URL of where I put in the ticket?

0 Votes 0 ·

Please go through this link for all the details.


0 Votes 0 ·

1 Answer

NavtejSaini-MSFT avatar image
0 Votes"
NavtejSaini-MSFT answered NavtejSaini-MSFT commented

@Btempleton-3102

We reviewed some of the previous cases where it can be a config issue where we have member win on transfer from On-Prem to HUB and again member win from HUB to member. This topology can cause a circular conflict resolution. The recommendation was to configure between Hub -> member, the Hub win is what the correct way.

But please do this after you check with Support as they need to check your Azure Sync topology and run sync health checker. Please raise the ticket and please share the ticket number and we will try to get traction for the same.

Regards
Navtej S

· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Btempleton-3102 Were you able to raise the ticket with Support.

0 Votes 0 ·

Thanks for this information we do have a combination of HUB and Member wins in the sync groups -- but it is what is logical -- some data is considered more authoratitive from the HUB and other from the on-prem member. I have attempted doing index rebuild/defrag on the datasync schema as that was referenced when I started to submit a ticket. I am now stuck as I don't have sufficient permissions to submit a ticket -- I am working with internal azure admin to see if that can be fixed.

Thanks for your assistance.

Brent

0 Votes 0 ·

@Btempleton-3102 Thank you for confirming. Do let us know if you need any further assistance regarding this.

0 Votes 0 ·