Receiving SQLCMD returned error code: -1073741819 or 255 during installation of Venus 1500.

Potential Symptoms

  • Install error with "SQLCMD returned code: - 1073741819" or "SQLCMD returned error code: 255"
    SP1pic1.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     

Environment

  • Product Family: Software
  • Product:
  • Component:
  • 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 SP2 Express from Microsoft’s website https://www.microsoft.com/en-us/download/details.aspx?id=53167 .
    • Chose SQLEXPR_x86_ENU.exe from the download list.

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.
      SP1pic3.png
    • Running the update: Important to make sure that the NUCLEUS instance is the feature to update.
    • Be sure to manually start Nucleus Service prior to running installation, otherwise installer may hang during "Nucleus Update: MSITimingAction" process.
    • SP1pic4.png
  2. Run Venus 4.22 installer again.

   

KB ID: DD3302767


Fill out my online form.
DISCLAIMER: Use of this content may void the equipment warranty, please read this DISCLAIMER prior to performing any service of the equipment.