My 2000 moonroof leaked off and on for 4 years.If I parked on a certain slope, it would leak in to my center console till I found 1 side of the drain tube cloged. The Dealer couldn't make it leak, and said it was fine.(Bull**it)
I used bailing wire to un clog the tube. It had foam insulation...