Show Control: When updating or installing Display Studio, receive error "Database 'msdb' cannot be opened."

Potential Symptoms

  • When updating or installing Venus 1500 or Display Studio, receive the following error:
    • Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information. Problems recording information in the msdb..suspect_pages table were encountered.
    • This error does not interfere with any activity except maintenance of the suspect_pages table. Check the error log for more information.
    • 9-6-2013 1-44-36 PM.jpg
  • When clicking Ok to the error, receive and SQLCMD Error Code 1, and directs to a specific log file. When reviewing the log file, you see the following error:
    • Database 'msdb' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

9-6-2013 1-53-49 PM.jpg 

  • When reviewing SQL Server ERRORLOG, you see the following errors:
    • Error: 9003, Severity: 20, State: 1.
      The log scan number ( ) passed to log scan in database 'msdb' is not valid. This error may indicate data corruption or that the log file (.ldf) does not match the data file (.mdf).
    • Error: 3414, Severity: 21, State: 1.
      An error occurred during recovery, preventing the database 'msdb' (database ID 4) from restarting.

9-6-2013 1-52-46 PM.jpg 

Environment

  • Product Family: Software, Control Systems
  • Product: Venus 1500 V4, Show Control (Display Studio)
  • Component: SQL Server 2005 (Only)
  • Control System:

Cause

  • The SQL Server Nucleus Database has become corrupted.

Resolution

  • Contact Daktronics Technical Support for assistance with this specific issue.

KB ID: DD2628345


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

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.