Why do I get the following error in the server log "Msg = String is longer than the corresponding database column allows"?

0 Likes

Problem:

Why do I get the following error in the server log "Msg = String is longer than the corresponding database column allows"?

Resolution:


  • Product Name: StarTeam
  • Product Version: 2005 - 2006
  • Product Component: Server
  • Platform/OS Version: Windows

Answer:

This error is usually generated when a value is entered into a custom field which is longer than the field expects. In the log you should see more information about the error immediately below the error message itself. For example, in the following excerpt from the server log we can see that the error was caused by user Mr Smith who tried to add a value into the custom field Usr_FullStory which was greater than 2048 characters. This is more likely to happen when someone copies and pastes a value rather than types it.

Msg = String is longer than the corresponding database column allows
Property Internal Name = Usr_Notes, Property Size = 2048
[ComponentID] = -1
[Client IP Address] = 199.129.444.20:19031
[Property Size] = 2048
[Property Internal Name] = Usr_FullStory
[User Name] = Mr Smith
[Table Name] = Requirement
[ClassID] = 43
[Function Name] = CStDbObjectSet::EditWithoutSP
[PropertyID] = 262144
[CommandID] = 2004
[ServiceID] = 524288

You should simply advise the user of the field limit so that they are aware of this in future. You can ignore the error also.


Old KB# 28572
Comment List
Related
Recommended