407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6519)

SQL Execute Error - Could Not Allocate Space

This information applies to :

Article ID
6519

Created/Updated
July 17, 2019

Category


Are you using the most current release of QuoteWerks?
Version 24.0 Build 4
Issue:

Applies to the Corporate Edition (rehosted):

When trying to save a quote, the following error occurs:

(Note: The error message has been shortened so only the relevant details are shown.)

"SQL Execute Error - QuoteWerks trapped error. Could not allocate space for object "DocumentItems' in database 'QuoteWerks' because 'PRIMARY' filegroup is full (-2147217900) SQL=INSERT INTO Docoument Items (.....)

The error is then followed by a second error:

"An error occurred in the SaveDocumentToDTFFileEx function.
There are no line items in the database for this document(), so it must be corrupted in some way.
SQL=SELECT*FROM DocumentItems WHERE DocID =17839 ORDER BY ID"

Cause:

The drive that is hosting SQL is full.

Solution:

Check the drive to see if you can allocate more space. You may also try and trim down (purge) the sync transaction log. See knowledgebase article 6046 for more information on purging the SQL Transaction log

New Search