Security Compliance

SQL database fills up

How to resolve errors while performing management tasks from Patch Manager that may be related to a full database.

First published date

10/22/2018 8:43 PM

Last published date

10/22/2018 8:43 PM

Overview

Receiving errors while performing Management tasks from Patch Manager may be related to a full database.

Product section

Patch Manager

Cause

If the SQL database is filling up you may see an error like this:

 

Exception occurred at <time>: Source: Application Server (<server>)
Reason: The Configuration Management Task failed to create the task transactions in the task results table. Reason: Could not allocate space for object 'dbo.ewtasksresults'.'PK_ewtasksresults' in database 'EminentWare' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlBulkCopy.RunParser(BulkCopySimpleResultSet bulkCopyHandler)
at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinuedOnSuccess(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestAsync(CancellationToken cts, TaskCompletionSource`1 source)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalAsync(CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServerAsync(Int32 columnCount, CancellationToken ctoken)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
at EminentWare.Core.Server.Jobs.HelperUtilities.InitializeConfigurationManagementTransactionsRecords(TaskBase task, ScopesContainer scopes)
at EminentWare.Core.Server.Jobs.ApplicationServerJobOrchestrator.ManufactureJobs()
Object: Upload Transactions Failed
Object Type: scope

Resolution

  1. Delete unneeded tasks from Task History.
  2. Migrate the database to a full instance of SQL 2008 or 2012 that supports larger database sizes.