Did it have a flared end?

If yes:

It’s in the toilet, he sleep walked and took a shit and doesn’t remember.

or

He pooped it out while sleeping and his dog ate it.

If no:

Butt plug goblins.

They can be warded away with a metamucil potion.