Forum Discussion
Sharepoint lists mirroring issue
Hi Murtaza_Ghafoor ,
Thank you for your message.All the replicated lists contained many fields with complex ones aswell. Some were succeeded and others no so it was obviously not a problem with the types of the fields. They all seem to be accepted, even the most complex ones.
Also I had already tried to clean and re-establish the connection dozens of times so there was another issue with the list I needed to find. As mentionned in my previous comment, it was a naming issue with the columns. The sharepoint lists replicating component was not able to manage different columns with the same name causing this kind of unexpected and not documented issue.
Again thank you for your help, this is now solved.
Super UserI would simply compare the schema of SharePoint lists those are succeeding and the one are failing and try to compare it’s schema, if failed lists have some unusual schema like
Person, Lookup, Managed Metadata, multi-value Choice, Attachments, or complex SharePoint fields
that could be the reason for the failure.
I would also try a clean and re-establish the connection again.
For one failed list:
- Open the Fabric Mirroring item.
- Go to Configure replication.
- Remove/uncheck the failing SharePoint List.
- Save.
- Wait a few minutes.
- Add the same list again.
- Start/refresh mirroring.
- Reseeding/re-enabling affected objects is a documented troubleshooting approach for this class of generic Mirroring error.
Generic Mirroring Link Error given below:
Error in Mirrored google Big query | Microsoft Fabric Community
If this helps, ✓ Mark as Kudos | Help Other