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: 98,758 mi (2,000 mi - 197,323 mi)
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.
Visitor, 2004 Cadillac SRX, 88,900 mi
sun roof jumps and stops and a clicking noise from gears
SUNROOF GOES ALL THE WAY BACK AND COMES HALF WAY FORWARD AND STRAINS THEN DIES , NO FIX YET BUT OPEN TO SUGGESTIONS THANKS
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, 2005 Cadillac SRX, 120,000 mi
the roof opens fine but makes a horrible " clacking" sound and does not want to close all the way. I have to keep hitting the close button to get it shut.
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, 2006 Cadillac SRX, 110,000 mi
would not close, clicking noise
Visitor, 2006 Cadillac SRX, 158,000 mi
The sunroof headliner jammed and rolled back and will not close.
Visitor, 2007 Cadillac SRX, 179,000 mi
the same its hang in middle and return to ope position automatically
Visitor, 2010 Cadillac SRX, 2,000 mi
Sunroof would not close when driving on highway