Gorilla Super Glue, Fast‑Setting, Impact‑Tough All‑Purpose Adhesive with Anti-Clog Cap, 4 -3 g Tubes, (Pack of 1) - Clear

That one has the thing to puncture the metal built into the top of the lid. It shows turning it upside down to punch a hole in the metal seal. OP specifically said it doesn't fit after it is assembled which would indicated the lid isn't attached. Like these guys where the lid isn't screwed on at all.