DevForce Community Forum : String or binary data would be truncated. http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : String or binary data would be truncated. Wed, 13 May 2026 07:20:33 -700 Thu, 22 Mar 2012 16:12:44 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3321 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ String or binary data would be truncated. : Found the issue. It wasn't... http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=13071#13071 Author: orcities
Subject: 3321
Posted: 22-Mar-2012 at 4:12pm

Found the issue. It wasn't the field causing the problem it was the audit mechanism.]]> Thu, 22 Mar 2012 16:12:44 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=13071#13071 String or binary data would be truncated. : I was able to duplicate the issue... http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=13070#13070 Author: orcities
Subject: 3321
Posted: 22-Mar-2012 at 4:02pm

I was able to duplicate the issue on an outside project. It allows me to alter the text when I am only using the DomainModel. As soon as I add in the Server portion it doesn't work.

Any ideas.
]]> Thu, 22 Mar 2012 16:02:16 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=13070#13070 String or binary data would be truncated. : A couple of reasons that I can... http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12942#12942 Author: DenisK
Subject: 3321
Posted: 08-Mar-2012 at 6:01pm

A couple of reasons that I can think of are:

1. The connection string in your .config file on your main solution is not pointing to the same database as the .config file in your test solution.

2. If you are using a DataSourceKey with different data source extensions, you might be connecting to a different database instance. For eg: a test database rather than a prod database.

Other than that, you're probably in a better position to investigate as you're familiar with the solution's and database configuration.


Edited by DenisK - 09-Mar-2012 at 12:11pm]]> Thu, 08 Mar 2012 18:01:07 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12942#12942 String or binary data would be truncated. : In putting together a sample.... http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12938#12938 Author: orcities
Subject: 3321
Posted: 08-Mar-2012 at 3:14pm

In putting together a sample. I used the same DomainModel project with only programatically made the change then saved. And it saved successfully.
 
Why would it not work with the same DataModel in a different solution?
]]> Thu, 08 Mar 2012 15:14:20 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12938#12938 String or binary data would be truncated. : Hmm, interesting. Your screenshot... http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12937#12937 Author: DenisK
Subject: 3321
Posted: 08-Mar-2012 at 2:47pm

Hmm, interesting. Your screenshot does show that both Entity.Summary and dbo.Event.Summary string length are set to Max. I have no other suggestion than to ask you to isolate this in a unit test and send it over through our customer support form. I'll be able to do better investigation this way.]]> Thu, 08 Mar 2012 14:47:00 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12937#12937 String or binary data would be truncated. : Database table: SummaryEntity:... http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12930#12930 Author: orcities
Subject: 3321
Posted: 08-Mar-2012 at 8:20am

Database table: Summary
Entity:
]]> Thu, 08 Mar 2012 08:20:18 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12930#12930 String or binary data would be truncated. : It is, and I can take the... http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12929#12929 Author: orcities
Subject: 3321
Posted: 08-Mar-2012 at 8:16am

It is, and I can take the same string value and update the database using and update script.]]> Thu, 08 Mar 2012 08:16:19 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12929#12929 String or binary data would be truncated. : Hi orcities,Please verify that... http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12916#12916 Author: DenisK
Subject: 3321
Posted: 07-Mar-2012 at 4:58pm

Hi orcities,

Please verify that the string property is also set to Max on the Sql database column.
]]> Wed, 07 Mar 2012 16:58:20 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12916#12916 String or binary data would be truncated. : I am having an issue updating... http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12909#12909 Author: orcities
Subject: 3321
Posted: 07-Mar-2012 at 11:43am

I am having an issue updating text to a string property that has the Max size of String.Max.

It gives me the following error: String or binary data would be truncated.
The statement has been terminated.
 
Source: IdeaBlade.EntityModel
 
StackTrace:
  at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues)
   at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter)
]]> Wed, 07 Mar 2012 11:43:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3321&PID=12909#12909