Glad you have found the issue. Annoying as it is, at least it is a straight forward repair requiring a simple c-clip. BMW should have this sorted very quickly.Result - of a kind!
I have identified the cause, Not what I expected. And seemingly entirely BMWs fault.
Went and had another look withe the endoscope camera and discovered that the bolt holding the end of the piston had come out. That means the piston has nothing on which to place opening force against until the ram itself was fully extended. Thankfully, it doesn't look like anything has been damaged.
View attachment 141685
So, I went in search of the offending bolt - which is actually a pin that should have been held in by a C-clip. After some searching, this pin was nicely nestling right at the bottom of the inner panel.
View attachment 141687
Completely inaccessible . I borrowed a magnetic screwdriver off my neighbour. Not magnetic
Even if I had been able to recover it, it looks like it's all but impossible to either get the pin in from the far side so a c-clip can be put on this side or inserted this side and the clip on the other side. Complete mechanism might have to come off to fix it.
I suspect that BMW didn't actually re-attach the c-clip when they re-assembled the car after the repairs last year, they damaged/broke it while do the work or simply didn't check it afterwards. The roof worked for the few times it was used late summer last year and then the pin finally gave out on popped out when we first came to use it two weeks or so ago.
Will advise what stance they take when I raise it with them Monday. Somewhat frustrating that on the only nice days we've have when we've had to go out, we've not been able to use the car with the roof down. In fact. despite the weight of the rear panel complete with boot lid I am unsure if it is safe or wise to use the car at all. There is risk that, being unattached at the rhs, that the whole lot might just get ripped out by the vacuum of air passing over it at speed.
The pressure from the rear window shell will be secure enough to hold the rear lid for the meantime.