get all cpps without closing dbhandler