NOTICE: Our Community is moving. Get more information.
Why do I receive the error "Cannot create a row of size XXXX which is greater than the allowable maximum of 8060"?
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
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.
There are some registry settings at Hkey Current
User\Software\Borland\extractor\settings, that can be
used to reduce field sizes manually.
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