U4-6901 - Table cmsPropertyData, column dataNvarchar needs max char limit removed

Created by Rob Scott 30 Jul 2015, 12:46:37 Updated by Shannon Deminick 26 Jun 2017, 07:13:12

I was unable to properly save and/or publish a content node when the Umbraco property, "umbracoUrlAlias" was used, and my character string was longer than 500 chars. I looked in the table, "cmsPropertyData", and the column that the property was being saved in was "dataNvarchar", which had a max character limit of 500.

To get around this issue, I set it to nvarchar(max). I do not know if this is different in Umbravo v7+ or not. Using Umbraco v6.2

When the content node was saved and/or published, I would get a blank (right section) screen. Console error (2093 was my node ID):

POST http://local.websiteName.com/umbraco/editContent.aspx?id=2093 404 (Not Found) editContent.aspx?id=2093:1

2015-07-30 08:16:46,868 [82] WARN uComponents.DataTypes.DataTypeGrid.DataType - [Thread 68] [User 0] [Page 2093] DTG: ViewState did not contain data. 2015-07-30 08:16:51,019 [82] INFO Umbraco.Core.Publishing.PublishingStrategy - [Thread 68] Content 'Formas De Sacarle Tiempo A Todo Y No Morir En El Intento' with Id '2093' has been published. 2015-07-30 08:16:51,209 [82] INFO Umbraco.Core.Persistence.UmbracoDatabase - [Thread 68] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteScalar() at Umbraco.Core.Persistence.PetaPocoCommandExtensions.<>c__DisplayClassa.b__9() at Umbraco.Core.Persistence.FaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) at Umbraco.Core.Persistence.Database.Insert(String tableName, String primaryKeyName, Boolean autoIncrement, Object poco)

Comments

Shannon Deminick 26 Jun 2017, 07:13:12

Closing issue due to inactivity - see blog post for details https://umbraco.com/blog/issue-tracker-cleanup/


Priority: Normal

Type: Exception

State: Closed

Assignee:

Difficulty: Easy

Category: Architecture

Backwards Compatible: True

Fix Submitted:

Affected versions: 6.2.3, 6.2.4

Due in version:

Sprint:

Story Points:

Cycle: