In the CDF traces, it was seen that the monitoring database was failing. Looking in the monitoring database in SQL Manager, higher versions of the instal were present.
Monitoring database had incorrect entries in SQL server
Manually needed to remove incorrect entries in the SQL table. Once completed, Studio was able to open up without issue.
After performing a failed upgrade and subsequent rollback, Studio was failing to complete the Automatic Site upgrade.