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.

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