ST client is throwing error "Cannot add a column to the table: the size of the row will exceed the allowable maximum."

0 Likes

Problem:

ST client is throwing error "Cannot add a column to the table: the size of the row will exceed the allowable maximum."

Resolution:

  • Product Name: StarTeam client
  • Product Version: 2005 R2
  • Product Component: Client
  • Platform/OS Version: Windows XP

Description:
When trying to create new custom field, ST client is throwing error "Cannot add a column to the table: the size of the row will exceed the allowable maximum."




Answer/Solution:
When ever you create a custom field, it creates a new column in the database table (for example in C36 table for change request custom field). Every column in table will have certain length. By SQL 2000 design, the total length of columns in a table should not exceed 8060 bytes. Above error is thrown when table C36 has already exceed this limit. Hence it will not allow you to create new custom field unless you delete existing fields. There are 2 ways to resolve the issue

1. First you should try to deleting some of the disabled custom fields if exist, using DDF Utility. This Utility is available as a StarTeam server patch 23(for MS-SQL DB) & 20( For Oracle DB) @ http://support.borland.com/download.jspa?categoryID=30

2. If you still can not create new custom fields after deleting disabled custom fields then you may want to "Migrate" server configuration using Actions---> Migrate tool in Server Administration GUI. This will recreate all the DB tables and correct if there is any discrepancy in database schema.




Author: Praveen Boyineni

Old KB# 27650
Comment List
Related
Recommended