On the student profile's Support Tab, each Primary SEN Need has to be unique for that particular SEN Provision.
To resolve this, it is best to place an end date to the SEN Provision of SEN Support then set up a new SEN Provision with a new Primary SEN Need.
Recalculate the census and the Error will no longer appear.