Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Reg: Error in desktop while doing refresh

Hi everyone,please help me out. I am facing the below error while doing refresh for particular table.

1.There is no duplicate values at DB side.but still i am facing below error.

 

Interesting Links
Need Help

3 Replies

  • tchristy99's avatar
    tchristy99
    Helper II
    5 years ago

    Hi,

     

    The best way that I have found to troubleshoot this is to make the relationship a many to many temporarily and then attempt to figure out what is wrong with the value 329.

    • tchristy99's avatar
      tchristy99
      Helper II
      5 years ago

      Hey Anonymous 

       

      If this helped solve your problem, please mark it as the solution.

       

      Thanks!!!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous ，

    As the error indicates, the ‘_ID’ column can’t contain duplicate values when you create relationship using this column of  ‘Details’ table(one side) and other column of other table(many side).

    To make the refresh work properly, make sure that ‘_ID’ column contains distinct values when you use the column to create relationship, otherwise, you would need to delete the relationship.

     

    If you don't mind, could you provide me with a sample to test it ?

     

    Best Regards

    Community Support Team _ Ailsa Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.