An opposition councillor has called for a review and apology after Rotherham Metropolitan Borough Council wrote off a long-standing debt of almost half a million pounds from a failed regeneration project.