High ranking security chiefs were among the hundreds of mourners that attended the memorial service