Failing company merge

[chrome star]

I'm trying to merge 2 companies and one of the companies shows up in the merge 3 times. The merge fails because "One or more records not found"

[icy hound]

Searched merge companies records not found

Found 6 results

Searched merge duplicate records

Found 3 results

Searched merge companies people deduplication CRM

Found 2 results

The documentation doesn't cover the specific merge functionality for combining duplicate company records or the error you're encountering. This sounds like it could be a bug in Twenty's deduplication/merge feature, particularly with a company appearing three times in the merge dialog when you only intend to merge two.

Here are a few things to try:

• Refresh and retry: Reload the page and attempt the merge again, selecting only the two companies you want to merge.
• Check for actual duplicates: It's possible the company genuinely exists as three separate records in your database. You can verify this by searching for the company name in the Companies view. If there are indeed three entries, you may need to merge them in steps (merge two first, then merge the result with the third).
• Delete the extra duplicate first: If one of the three entries is clearly a duplicate with no unique data, consider deleting it before attempting the merge of the remaining two.

If the "One or more records not found" error persists, it may indicate that one of the records was already deleted or is in an inconsistent state. This does look like it could be a bug. I'd recommend reporting it on Twenty's GitHub issues with:

• Steps to reproduce
• The exact error message
• Whether the duplicate company was created via import, API, or manually

The docs don't have specific troubleshooting guidance for this merge scenario, so the engineering team would be best positioned to investigate further.

[severe root]

Hi @chrome star, sorry about the delay, could you please describe exactly what's the issue? Are you self-hosted or cloud? If self-hosted, what version are you using? Could you also please share steps to reproduce? Video or screenshots would significantly help reproducting this issue

[chrome star]

I'm using the cloud version. I'll try to provide more information, sorry if this gets overly long.

Issue:
I tried to merge two records via the Twenty UI. I selected two records but when I opened the merge tool, 3 records were present. This is extremely similar to what I've observed when a company is soft-deleted before it's fully deleted. Attempting to merge these records resulted in an error message: "One or more records not found"
Also, when selecting only the company with these "ghost duplicates", the Merge Duplicates option was available in the context menu. Just to be completely clear: only one company was selected in the UI but two companies show up in the Merge menu. Attempting the merge in this case also resulted in the same error message.

Resolution:
I changed the Company Name and the domain (a few times) and the ghost eventually went away. I know this is terrible for troubleshooting purposes and I'm really sorry about that 😬 FWIW, the ghost did not go away the first time I tried changing the domain.

How the records were created:
I built a series of ETL scripts to migrate our data via GraphQL API. Each script outputs a log so I know exactly what action was taken. The 'Company' load script imported 5084 companies. I reviewed the log for what was imported into Twenty and verified that the company domain and the Twenty ID only exist once. Unfortunately, this is our production CRM and re-running the load script isn't an option.

I know this isn't particularly helpful so if it comes up again, I'll be sure to gather more info from browser developer tools and the API. And see if I can surgically reproduce it.