Duplicate records in query results

Ticketclosed

Kelvinhaugh Pension Services: documents · Duplicate records in query results

Fiona reported duplicate records appearing in query results, some with different field values (e.g., client vs employer contact details). Duplicates are from the CRM and affect dozens of records.

Priority normal

made from

What happened

What this says

Current to 11 Oct 26

Fiona reported duplicate records appearing in query results, some with different field values (e.g., client vs employer contact details). Duplicates are from the CRM and affect dozens of records.

Problem: Query results contained duplicate records for the same people with different field values, undermining reporting accuracy. Fiona identified a few dozen affected records.

Handling: Connor asked which connector was affected and requested examples. Fiona confirmed all duplicates are from the CRM and demonstrated that they represent the same person with different contact details captured in separate records. The ticket was marked solved on 25 Sep 2025.

Watch: CRM data quality issues (duplicates) are affecting Fiona's trust in results. As Head of Scheme Relationships (senior stakeholder), her concerns may influence other team members' confidence in the brain.

AI · claude-haiku-4-5-20251001 · 11 Oct 2026

AImade from

Details

Updated 9 Oct 26

Prioritynormal

Statusclosed

Categorydata_quality

Channelemail

First response (min)257

CSAT3

Helpdeskmade from

Trail

created · Fiona Drummond 17 Sep 2025 08:01
Hi, I've been running some queries to check our scheme data and I'm seeing duplicate records coming back for the same members. Some of them have slightly different data in the fields, which is making it hard to trust the results. Have you come across this before? Can you help us clean this up?
public_reply · Connor Webb 17 Sep 2025 12:18
Hi Fiona, thanks for reporting this. Duplicates can happen if a record gets indexed twice from the same source, usually after a data sync. Can you tell me which connector or connectors the duplicates are coming from, and can you paste an example of a duplicated record so I can see the difference in the fields? Connor
public_reply · Fiona Drummond 19 Sep 2025 16:19
They're coming from the CRM. I've attached a couple of examples: you'll see that one has the client contact details and the other has the employer details, so they're clearly the same person even though the data is different. It's only affecting a few dozen records, but it's enough to cause problems in our reporting.
status_change · Connor Webb 25 Sep 2025 15:12
status_change · 29 Sep 2025 23:59

Helpdeskmade from

BB-Demo is a fictional company; every organisation and person here is invented. B-Brain is the tool. Built by site/build_site.py from the site tree, data as of Fri 9 Oct 2026. Help & Support

Help & Support

Open as a page

Help & Support

B-Brain is one place to read everything the company knows about its customers: the CRM, calls, emails, support tickets, product usage, invoices, documents, news and HR. Every page is built from those systems and the data is current to Fri 9 Oct 2026.

How to use the site

Summary is the landing page: what happened this week, the calls just held and the calls coming up, the risks and the renewals due.
Organisations lists every customer. Open one to see its key facts, the AI assessment and next step, platform usage, the ARR journey, deals, documents, contacts and activity, and the lineage of every block.
Conversations, Commercial, People, News and Documents cut the same data by topic. System explains how the brain is built and where each figure comes from.
Every card ends with a small made from link: it opens the lineage explorer focused on that card, so you can walk from the figure down to the raw rows it came from.
Use the sun and moon button at the top right to choose dark or light. Choose your device's own mode again to go back to following the device.

How to ask

Press Ask Brain in the header. Type a question, or pick one of the examples.

Search the brain finds the organisations, people, calls, emails, tickets, documents and news that match your words, with links to their pages.
Ask Claude copies your question and opens the B-Brain Claude Project, where Claude answers from the same data using the B-Brain tools and cites the pages it used.

The site itself does not call an AI model; answers in Claude come from the same figures you see here.

What the data covers

Data	Records
Organisations	150
People at customers	573
BB-Demo staff	48
Calls	1,382
Email threads	2,122
Support tickets	789
Documents	850
Deals	217
Invoices	187
Events	49
News items	84

Data as of Fri 9 Oct 2026. Text marked AI was written by the brain from the records listed in its made-from link; an AI output that cannot cite its evidence is refused and the previous text kept. Where two systems disagree (for example a contract and the CRM), the key facts show both values and mark the difference.

BB-Demo is a fictional company: every organisation, person and figure here is invented for this demonstration. B-Brain is the tool that reads its data.

Who to contact

Email support@b-brain.example or talk to your B-Brain account team. Tell us the page address and what looked wrong; a screenshot helps.

Help