It is not uncommon for the sunroof to work incorrectly or not at all.Google+
Car Problem Reports
Cadillac SRX Sunroof May Not Work
Cadillac SRX Problem
Average Mileage: 76,939 mi (17,000 mi - 120,000 mi)
Visitor, 2004 Cadillac SRX, 88,900 mi
sun roof jumps and stops and a clicking noise from gears
Visitor, 2006 Cadillac SRX, 75,000 mi
My sunroof will not close all the way. It slides back fine but when i attempt to close it the sunroof will stop about 3/4 of the way.
SUNROOF GOES ALL THE WAY BACK AND COMES HALF WAY FORWARD AND STRAINS THEN DIES , NO FIX YET BUT OPEN TO SUGGESTIONS THANKS
Visitor, 2007 Cadillac SRX, 17,000 mi
Moon roof won't close all the way - no fix yet. My wife likes Cadillacs, but personally I believe they are poor quality puffed up Chevy's.
Visitor, 2004 Cadillac SRX
The torx bolt became loose and lodged in the UltraView sunroof track. Further attempts to use the sunroof caused the motor gears to become stripped. Replacing the sunroof motor solved the problem.
Visitor, 2006 Cadillac SRX, 109,055 mi
will not close all the way.. i have to manually pull it closed while holding down button ..
Visitor, 2006 Cadillac SRX, 45,000 mi
Roof retracts but will only come back 3/4 of the way to close. Dealer has repaired twice before. We have been out of warranty for some time now but we do not use sun roof anymore. Bad experiance with roof and will never have another one. Our other vehicle is an infinity and the roof has been flawless.
Visitor, 2006 Cadillac SRX, 108,000 mi
The sunroof "skips" backwards instead of sliding and often gets stuck. It usually takes a few tries to either get it open or shut. The technicians at the dealership tell me they see it all of the time. Thier recomendation was to WD 40 the track - it didn't really help.