Duplicate records in relationship tables

HI ALL,

We are facing duplicate entries issue in report, as per report record are duplicate but if you search the same in Account module list view, then there is only one entry

And after debugging we found that we have relationship between Accounts and custom module and duplicate entries are there in relationship table hence, it show duplicate entries in report also.
Can anyone let us know what is the root cause for the same.
Also please suggest on how to find such entries clear it.

Relationship is : 1 custom module to Many Accounts.

Kindest Regards,

Shreya

0 Andre Serrazina over 1 year ago

Hello shreya dalvi,

Can you share the following with us so we can have a better understanding of the question:

1 - Do you see duplicated entries in the relationship table in the database?

The table name should be something like this:
custom_module_name_accounts_1_c

2 - Can you share the query that your report in Sugar is generating?

This will help us understand if it's something with the report or with the data.

Looking forward to hearing from you.

André
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shreya dalvi over 1 year ago in reply to Andre Serrazina

Hi André,

Thanks for responding!!

Please see my comments below:

1 - Do you see duplicated entries in the relationship table in the database? Yes

2 - Can you share the query that your report in Sugar is generating? Apology but I can't share the query.

Kindest Regards,

Shreya
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Andre Serrazina over 1 year ago in reply to shreya dalvi

If you are seeing duplicates I would focus on the process that is creating records on that table.

How are you relating Accounts to your custom module?

Is this via Graphic User Interface, integration, import or are you using some other process?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel