• Not Answered

Exception-After reset password and try to login(exception message : "String or binary data would be truncated")

user getting below exception after reset the password and try to login. 

Steps to re-produce the issue:

Step 1: Go Sitecore “User Manager” select the user and click change password on top left. In popup window, click on “Generate” button which will reset the password.

Step 2: Login with new user name and password. User getting below exception.

 

Note : This exception occurs only for some users not for all users.

 

 

 

Server Error in '/' Application.


String or binary data would be truncated.
The statement has been terminated.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

Exception Details: System.Data.SqlClient.SqlException: String or binary data would be truncated.
The statement has been terminated.

Source Error: 

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace: 

[SqlException (0x80131904): String or binary data would be truncated.
The statement has been terminated.]
   System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) +265
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) +714
   System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) +4514
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) +443
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) +3307
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +650
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) +529
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +758
   Sitecore.Data.DataProviders.Sql.DataProviderCommand.ExecuteNonQuery() +75

[DataException: Error executing SQL command:  INSERT INTO [Properties] (   [Key], [Value] ) VALUES (   @name, @value )]

[Exception: String or binary data would be truncated.
The statement has been terminated.]
   Sitecore.Data.DataProviders.Sql.DataProviderCommand.ExecuteNonQuery() +281
   Sitecore.Data.DataProviders.Sql.<>c__DisplayClass33_0.<Execute>b__0() +73
   Sitecore.Data.DataProviders.NullRetryer.Execute(Func`1 action, Action recover) +218
   Sitecore.Data.Properties.SqlPropertyStore.SetStringValueCore(String prefixedName, String value) +561
   Sitecore.Data.Properties.PropertyStore.SetStringValue(String name, String value) +76
   Sitecore.Web.Authentication.DefaultTicketManager.CreateTicket(String userName, String startUrl, Boolean persist) +376
   Sitecore.Pipelines.LoggedIn.Ticket.Process(LoggedInArgs args) +161

[TargetInvocationException: Exception has been thrown by the target of an invocation.]
   System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) +0
   System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) +92
   System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) +231
   System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters) +33
   Sitecore.Nexus.Pipelines.NexusPipelineApi.Resume(PipelineArgs args, Pipeline pipeline) +298
   Sitecore.Pipelines.Pipeline.Start(PipelineArgs args, Boolean atomic) +136
   Sitecore.sitecore.login.Default.LoggedIn() +248
   Sitecore.sitecore.login.Default.LoginClicked(Object sender, EventArgs e) +76
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +114
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +149
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2755