Solus 3 stuck in Rolling Back deployments

[denzal2k4]

So I deployed some updates on the 21st Dec and a couple of them have been stuck in Rolling in progress mode since then, despite me trying various things and going through operating system upgrades from 2008 to 2012 to 2019, we have also been getting errors in SOLUS such as Error retrieving agent package site records, the wait operation timed out, I have also just seen the operating timed out on a client machine when trying to get the update.

 

The updates that are stuck are SIMS discover 2019 Autumn and SIMS Autumn 2019 Consolidated workstation patch 2.

 

Trying to log into the Capita support portal is proving useless despite having used it before.

 

Any thoughts??

Edited January 2, 2020 by denzal2k4

[denzal2k4]

For anyone else that gets this particular issue, run this SQL query on the solus database, hopefully save you a week and a half waiting for support:

 

USE [sOLUS3_DEPLOYMENT_SERVER]

UPDATE [sOLUS3].[DISTRIBUTED_DEPLOYMENT_PLAN] SET status = 4 WHERE status = 9