That error message usually means that there are other acs objects with a context_id pointing at the object you are trying to delete. You can find out which objects these are with a query like
select object_type, object_id from acs_objects where context_id in (select object_id from acs_objects where object_type = 'your_object_type');