Erection is a vascular event. The penis becomes rigid when blood flow to the corpora cavernosa increases sixfold and venous outflow is physiologically impeded. Penile perfusion is governed by three organ systems—the neurologic, circulatory, and endocrinologic systems—each necessary for potency. The neurologic system accounts for vasodilation and venoconstriction of the corporal blood vessels so that blood is shunted to the erectile tissues; the circulatory system provides adequate blood flow to the hypogastric-cavernous bed, a distal branch off the internal iliac vessels; and the endocrine system, mediated by testosterone, plays a permissive role through mechanisms that have yet to be elucidated.
Diabetes is a well-recognized risk factor for ED. A systematic review and meta-analysis found that the prevalence of ED was 37.5% in type 1 diabetes, 66.3% in type 2 diabetes, and 52.5% in diabetes overall—a rate approximately 3.5 times higher than that in controls.  The etiology of ED in diabetic men probably involves both vascular and neurogenic mechanisms. Evidence indicates that establishing good glycemic control can minimize this risk.
There are, as you listen to all of the advertisements, if your erection lasts for more than four hours, there are very, very unusual cases where that can happen. There are very rare cases of visual problems. There are even rarer cases of hearing problems. But with every medication, there always a potential downside. But the absolute contraindication is an unstable medical condition, an unstable cardiovascular condition, being on nitrates.
Stiffy Solution: Frustratingly enough, the only solution to exhaustion-based impotence is to get some rest, which is obviously difficult (or your dude wouldn't be having this problem in the first place). But if your guy has been resistant to getting help for his insomnia or asking for different hours at work, the inability to get his nine iron out on the putting green might be the thing that finally motivates him to make a life change. So, at least there's that.
Qaseem, A., Snow, V., Denberg, T. D., Casey, D. E., Forciea, M. A., Owens, D. K., & Shekelle, P. (2009). Hormonal testing and pharmacologic treatment of erectile dysfunction: A clinical practice guideline from the American College of Physicians. Annals of internal medicine, 151(9), 639-649. Retrieved from http://annals.org/aim/article/745155/hormonal-testing-pharmacologic-treatment-erectile-dysfunction-clinical-practice-guideline-from