An internal investigation has confirmed security breakdowns that paved the way for an attempted assassination of Donald Trump, and revealed new failures.