407-248-1481

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 5.5 Build 1
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