When it rains the lights on one or the two outdoor ceiling fans quits working, I pull the chain and it will come on for less than a second and go off. Both of my fans are identical and I have no problem wit the other one

First question, have you checked for moisture damage inside the canopy?

Next, can you measure the voltage to the lamp supply side with the lamps out?