Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

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: 66 Votes: 0 Revisions: 8

Updated August 2, 2016

Overview

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.

Environment

All Patch Manager versions

Cause 

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

Resolution

  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 https://msdn.microsoft.com/en-us/, 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
21:20, 18 Apr 2017

Tags

Classifications

Public