Forum Discussion

Gllme's avatar
Gllme
New Member
26 days ago
Solved

Sharepoint lists mirroring issue

Hello, We currently face an issue with sharepoint lists mirroring in microsoft fabric and we have no clue what can happen because the error message is pretty useless : In fact, we are mirroring mor...
Mirroring
Need Help
  • Gllme's avatar
    Gllme
    8 days ago

    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.

Gllme's avatar
Gllme
New Member
21 days ago

Hi v-csrikanth​ ,

First of all, thank you for your help and your time, your message helped me a lot to find out what was going wrong.

In the eventhouse, each failing mirroring list (GI_*) was producing 2 rows with 2 different OperationName : 1 Replicating Schema and 1 FailTable. So I supposed the error was coming from the schema.

As you told me it cannot be an issue with special characters I tried to find out which column was causing the issue. Maybe a specific data type ? But every data type used in the GI_* lists was also used in the COI_* ones so it cannot be linked to datatypes.

Previously I have already find out that a missing mandatory value in a sharepoint list was causing that type of issue aswell so I fixed every missing mandatory values and I started removing columns 1 by 1 to find the misconfigured one.

Finally, I got it, the issue was caused by 2 different columns with the same name which is unfortunately permitted in a sharepoint list but forbidden for the Fabric replication component (which seems quite obvious though as it is also forbidden in a data table).

I have also previously suspected the number of columns as there are around 40 columns in the COI_ lists and more than 80 in the GI ones but everything seems good here :)

Again, thank you for your help and I hope this can help other people aswell in the future.