407-248-1481
QuoteWerks Logo - QuoteWerks Sales Quoting and Proposal Software - CPQ that integrates with leading CRM, PSA, and Accounting Solutions (ConnectWise, Autotask, QuickBooks, salesforce.com and more)
Start Free Trial
Customer Area

QuoteWerks Knowledgebase Topic (Article ID 6060)

SQL Execute Error (-2147217900) - When Saving a Document

This information applies to :

Article ID
6060

Created/Updated
September 21, 2005

Category
SQL

Are you using the most current release of QuoteWerks?
Version 24.0 Build 2
Issue:
Receive:
SQL Execute ErrorQuoteWerks Trapped error Warning: The Table'#{TableName}' has been created but its maximum row size (14839) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes. (-2147217900)

Followed by a SQL INSERT Statement

The maximum row size of 14839 may vary.

Cause:

There have been changes made to the SQL server such as a Trigger that joins tables. The Trigger's inert statement along with this insert may exceed the maximum number of bytes.

Solution:

If changes were made to the SQL server, change them back to the prior state.

New Search

  •            
©1993-2024 Aspire Technologies, Inc.
    407-248-1481 (9am-5pm ET M-F)