Display Studio: Error "Unable to retrieve workspaces from database", Corrupt database

Potential Symptoms

Display Studio crashes on launch.
Client server sync utility also crashed.
Error message "Unable to retrieve workspaces from database".

Environment

Display Studio 1.26.0.55 (other versions may apply)

Cause

Corrupt database.

Resolution

Confirm all three Windows Firewalls are off on all client and server machines.
Verify that the C:\Program Files (x86)\Daktronics and C:\Program Files (x86)\Microsoft SQL Server aren't compressed indicated by blue folder and file names (Similar to Nucleus service failing to start, Compressed files or Database needs repair. ).
Uncompressed those two folders and restart the computer
Load a backup or new nucleus database using the Nucleus Database Utility.

1. Go to the following location to locate the backup database:
  - Windows 32 Bit System: C:\Program Files\Daktronics\Nucleus Server\Backup
  - Windows 64 Bit System: C:\Program Files (x86)\Daktronics\Nucleus Server\Backup
2. Use the Nucleus Database Utility to restore the database to the computer.
  - Show Control: How do I use the Nucleus Server Database utility to transfer or save a database?
  - If restoring DB doesn't work see Display Studio giving error "Unable to retrieve workspaces from database" reloading database does not resolve issue

KB ID: DD2870165

DISCLAIMER: Use of this content may void the equipment warranty, please read the disclaimer prior to performing any service of the equipment.

Read the Full Disclaimer

DAKTRONICS DOES NOT PROMISE THAT THE CONTENT PROVIDED HEREIN IS ERROR-FREE OR THAT ANY DEFECTS WILL BE CORRECTED, OR THAT YOUR USE OF THE CONTENT WILL PROVIDE SPECIFIC RESULTS. THE CONTENT IS DELIVERED ON AN "AS-IS" AND "AS-AVAILABLE" BASIS. ALL INFORMATION PROVIDED IN THIS ARTICLE IS SUBJECT TO CHANGE WITHOUT NOTICE. DAKTRONICS DISCLAIMS ALL WARRANTIES, EXPRESS OR IMPLIED, INCLUDING ANY WARRANTIES OF ACCURACY, NON-INFRINGEMENT, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. DAKTRONICS DISCLAIMS ANY AND ALL LIABILITY FOR THE ACTS, OMISSIONS AND CONDUCT OF YOU OR ANY THIRD PARTIES IN CONNECTION WITH OR RELATED TO YOUR USE OF THE CONTENT. ADJUSTMENT, REPAIR, OR SERVICE OF THE EQUIPMENT BY ANYONE OTHER THAN DAKTRONICS OR ITS AUTHORIZED REPAIR AGENTS MAY VOID THE EQUIPMENT WARRANTY. YOU ASSUME TOTAL RESPONSIBILITY FOR YOUR USE OF THE CONTENT AND ANY LINKED CONTENT. YOUR SOLE REMEDY AGAINST DAKTRONICS FOR DISSATISFACTION WITH THE CONTENT IS TO STOP USING THE CONTENT. THIS LIMITATION OF RELIEF IS A PART OF THE BARGAIN BETWEEN THE PARTIES.

The above disclaimer applies to any property damage, equipment failure, liability, infringement, or personal injury claim arising out of or in any way related to your use or application of the content, whether such claim is for breach of contract, tort, negligence or any other cause of action.