Receiving SQLCMD returned error code: -1073741819 or 255 during installation of Venus 1500; database SQL scripts failed

Potential Symptoms

  • Install error with "SQLCMD returned code: -1073741819" or "SQLCMD returned error code: 255"
  • SQLCMD.exe - Application Error: The instruction at 0x00fa1470 referenced memory at 0x004af000. The memory could not be read. Click OK to terminate the program.
  • Error Updating Database, Microsoft SQL Server 2014 SP1 requires the latest cumulative update.
    SP1pic1.pngSQL.PNG
    • NOTE: This does not apply if the error has a value of 1.  The specified log file will contain more information in those situations.
  • Error log entry Application log in Windows Event Viewer.
    • SQLCMD.EXE crashes during the install with an exception code of 0xC0000005.
      SP1pic2.png     
  • When installing SQL getting error 
    • Microsoft SQL Server 2014 Setup
    • The following error has occurred:
      The MOF compiler could not connect with the WMI server. This is either because of a semantic error such as an incompatibility with the existing WMI repository or an actual error such as the failure of the WMI server to start.
      2020-02-27_15-35-11.png

Environment

  • Product Family: Software
  • Product:
  • Component: SQL database
  • Control System: Venus 1500 v4.22 or newer

Cause

  • During a first time install of Venus 1500 4.22, the database SQL scripts have sometimes failed due to an access denied error.

Resolution

  1. Uninstall initial installation of Microsoft SQL Server 2014.
  2. Download and install Microsoft SQL Server 2014 SP3 Express 
  3. Run Venus 1500 installer.

For Temporary Operation

  1. Download and install Cumulative Update 5 (or newer) for SQL Server 2014 Express SP1 using the following link:
    • https://www.microsoft.com/en-us/download/details.aspx?id=51186.
    • Note: Always use the x86 version.
    • Be sure to manually start Nucleus Service prior to running installation, otherwise installer may hang during "Nucleus Update: MSITimingAction" process.
    • If appears to hang, make sure all V1500 install windows are closed.
    • Running the update: Important to make sure that the NUCLEUS instance is the feature to update.
    • SP1pic4.png
  1. Run Venus 4.22 installer again.

   

KB ID: DD3302767


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.