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.

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