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.

Find out about the July 2025 ARC Changes coming in to force from April 2025. Read now and don’t be caught off guard!

Databases have a habit of growing quietly in the background until, one day, they’re suddenly everyone’s problem. Storage might feel cheap, but the ripple effects of an oversized database are anything but. Longer nightly ETL runs, sluggish reporting, bloated backups, and clogged networks all trace back to unchecked growth. The result? Your business loses precious time and flexibility, especially when jobs that should finish in an hour creep into the early morning. This post i

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