Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Why do I receive the error "Cannot create a row of size XXXX which is greater than the allowable maximum of 8060"?

Why do I receive the error "Cannot create a row of size XXXX which is greater than the allowable maximum of 8060"?

Problem:

Why do I receive the error "Cannot create a row of size XXXX which is greater than the allowable maximum of 8060"?

Resolution:

Problem Description:

Datamart Extraction Fails and the log file has a message similar to the following example:

(EXAMPLE LOG EXCERPT)

04/22/04 14:54:55 COM Error Code: 800a0c93 Description: Unknown error 0x800A0C93 Source: ADODB.Recordset Description: Operation is not allowed in this context.
04/22/04 14:54:55 There are 0 Connection Errors
04/22/04 14:54:55 [COM] BuildRequirementInfo() Recordset Error
04/22/04 14:54:55 COM Error Code: 80004005 Description: Unspecified error Source: Microsoft OLE DB Provider for SQL Server Description: Cannot create a row of size 8293 which is greater than the allowab e maximum of 8060. 04/22/04 14:54:56 *** Failed to populate Requirement Info table
04/22/04 14:54:56 *** Failed to build database The problem you are running into with the datamart extraction is being caused by a row size limitation in the SQL database. The max row size has a limitation of 8060 characters, which means that if the total number of characters in the UDA"s and system attributes combined = more than 8060 for a given row, you will either need to reduce some of the the field sizes or decrease the number of projects included in the extraction.

Resolution:

There are some registry settings at Hkey Current User\Software\Borland\extractor\settings, that can be used to reduce field sizes manually.

  • MultiSelectColumnSize =
  • DescriptionColumnSize =
  • MultiLineColumnSize =
  • ValidationColumnSize =

Making these changes will truncate the attribute value during the extraction; therefore you will want to determine the settings for each field. For example, you may want ValidationColumnSize to be lower and Description to be higher. You will have to play around with these until you find a combination that works based on your UDA"s and reporting needs. Please refer to the datamart user guide for more detailed information regarding these settings.

http://techpubs.borland.com/caliber

Old KB# 16177

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 18:30
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.