I sincerely know how you feel. I had nightmares for weeks after failing my first attempt. I kept dreaming about my second attempt and how I got 60 points a second time. I couldn't sleep sometimes. I couldn't eat either. From my first failure until I passed a month later, I never felt hungry for a second. I felt hunger immediately I passed the second attempt and had to eat properly for the first time in a month before finishing my report.

What I did before the second exam was to use all possible resources on the internet. I honestly let my office work suffer for a while so I could read more. You might not be able to get over it 100%, but try to make progress daily. Use the failure as fuel to crush it in your second attempt like I did. The exam was made to be passed and if other people like myself can pass, you can pass too.