HSG disappointment

Well, I went for my HSG today and as soon as they started injecting the dye I started vomiting and they couldn't finish. I feel so stupid, wondering how I'll ever be able to give birth if my body can't even handle this test. Has this happened to anyone? Normally I have a very high pain tolerance but today was absolutely terrible and my cramps now are so ridiculous I can barely even walk.