Recent Civica Cx 25.x schema changes replacing ContactAssociate.AssociationTypeId with AssociationTypeIds are causing reports and ETL processes to fail unexpectedly. This article explains what changed, why your contact reports may have stopped working, and how to update your SQL using string_split() to handle the new CSV-based structure. It also explores the wider issue of schema stability, undocumented changes, and the downstream impact on integrations and reporting.

In the world of Business Intelligence (BI), it can be tempting to tidy up, or hide bad data so that it "looks right". When you're building dashboards or reports that will be seen by leadership teams or operational managers, you might feel the pressure to make things neat, consistent, and complete - it massively reduces trust if they're not. But here's the truth: sticking a plaster over poor user data doesn't fix the wound underneath. If you're reporting on unreliable or incom

The Post Office Scandal: What Do We Take from It? The Post Office scandal, one of the most significant miscarriages of justice in recent UK history. It highlighted the devastating consequences of flawed IT systems and governance failures. Hundreds of sub-postmasters were wrongly accused of fraud due to faults in the Horizon IT system, leading to wrongful prosecutions, financial ruin, and immense personal suffering. As the scandal unfolds, it provides a stark reminder of the