The Chicago Cubs made quite a splash at the trade deadline, and they ended up acquiring Clay Holmes and Tyrone Taylor in a massive deal with the New York Mets.

When it comes to the Arizona Diamondbacks, that's a trade they believe they should've been able to pull off.

Now, a report has come out that the D-backs were closer than ever to landing Holmes, but the Mets backed out at the last minute.

AZCentral's Nick Piecoro revealed that his sources said the reason the Mets got cold feet was "due to concerns they had after reviewing medical records of a Diamondbacks prospect."

Instead of making a deal with Arizona, they opted to go for the No. 63 prospect in baseball, infielder Jefferson Rojas.

There's nothing that can be done at this point, but it stings quite a bit knowing Holmes nearly came to Arizona for the final three months of the season. Piecoro's report suggests, "The teams tried to rework the deal with different players involved but were unable to reach an agreement."

Obviously, no one is going to reveal the prospect whose medical records prevented the deal from taking place. It's an interesting piece of information to know, but at the end of the day, it's not like Arizona can go back in time and acquire Holmes for a better package.

It's clear they were aggressive and wanted to make something work, but all they ended up with was Lars Nootbaar.

Acquiring a pitcher was at the top of this team's list, but at least Brandon Pfaadt is firing on all cylinders, and Zac Gallen should be back sooner rather than later. While he hasn't been too great recently, there's nothing wrong with having a veteran presence as part of this extremely young rotation.

"During the time the Diamondbacks were waiting on an answer from the Mets, this was roughly three hours before the trade deadline on Monday afternoon, other potential starting pitching targets came off the board in other trades," Piecoro said.

It's not like the Mets were intentionally trying to hurt the Diamondbacks, far from it, but they definitely left Arizona in a terrible situation.

The D-backs had no choice but to learn about all of these other trades while they had to sit back and wait for the Mets to make a decision, one that turned out to be not in Arizona's favor.

Arizona Diamondbacks general manager Mike Hazen briefly touched on this failed trade attempt after the deadline, but is still happy with where the team is at, "We had some things go awry on us in the middle of the day. But there’s no excuses.”