Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Patch Manager > Patch Manager upgrade error: An exception occurred while executing a Transact-SQL statement

Patch Manager upgrade error: An exception occurred while executing a Transact-SQL statement

Created by Justin Rouviere, last modified by Aileen de Lara_ret on Apr 19, 2017

Views: 85 Votes: 0 Revisions: 8

Updated August 2, 2016


This article addresses the following error that occurs when upgrading Patch Manager:

Running version specific database script failed.  Details:  An exception occurred while executing a Transact-SQL statement...

Update installation failed.

The update was not successfully installed.



To view the full error, check the DBHelper logs located in Program Data (default:  C:\ProgramData\SolarWinds\PM\Log):


[ERROR] ExecuteSqlScript() failed. Message: An exception occurred while executing a Transact-SQL statement or batch. Details: Could not allocate a new page for database 'EminentWare' because of insufficient disk space in filegroup 'PRIMARY'. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Could not create constraint. See previous errors.
The statement has been terminated.


All Patch Manager versions


The error occurs when the database file is out of space.


  1. Verify the Eminentware Data Grid Server service account has the correct permissions to the database.
  2. Check the database space and run a cleanup. Refer to Error:Could not allocate space for object 'sys.syscolpars'.'clst' in database (© 2016 Microsoft, available at, obtained on June 2, 2016.)
  3. Run the Configuration Wizard.

If any additional errors appear, contact Support.


Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.


Last modified