Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • swapnil keskar 1 post 21 karma points
    Jul 31, 2012 @ 08:42
    swapnil keskar
    0

    Issue coming when giving Member Groups access to page.

    We are working on Umbraco 5.1 version using Visual Studio 2010 Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272  with Windows 7 OS and IIS 7.

    I am giving public access of member groups to pages.It works fine upto 3 member groups that are selected from

    selection box.as soon as i select 4th member group and click to save it gives me following error.

    can you give me solution for this? is this datatype error of limited length?

    Server Error in '/TestVDir' 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: 

    Line 173:            try
Line 174:            {
Line 175:                _defaultFlushListener.OnFlush(@event);
Line 176:            }
Line 177:            catch (Exception ex)

    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) +2073486
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +5064444
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() +234
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2275
   System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +215
   System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +987
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
   System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +178
   System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +137
   System.Data.SqlClient.SqlCommand.ExecuteBatchRPCCommand() +38
   System.Data.SqlClient.SqlCommandSet.ExecuteNonQuery() +291
   NHibernate.AdoNet.SqlClientSqlCommandSet.ExecuteNonQuery() in d:\CSharp\NH\NH\nhibernate\src\NHibernate\AdoNet\SqlClientSqlCommandSet.cs:117
   NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\AdoNet\SqlClientBatchingBatcher.cs:79

[GenericADOException: could not execute batch command.[SQL: SQL not available]]
   NHibernate.AdoNet.SqlClientBatchingBatcher.DoExecuteBatch(IDbCommand ps) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\AdoNet\SqlClientBatchingBatcher.cs:95
   NHibernate.AdoNet.AbstractBatcher.ExecuteBatchWithTiming(IDbCommand ps) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\AdoNet\AbstractBatcher.cs:431
   NHibernate.AdoNet.AbstractBatcher.ExecuteBatch() in d:\CSharp\NH\NH\nhibernate\src\NHibernate\AdoNet\AbstractBatcher.cs:416
   NHibernate.Engine.ActionQueue.ExecuteActions(IList list) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:129
   NHibernate.Engine.ActionQueue.ExecuteActions() in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Engine\ActionQueue.cs:169
   NHibernate.Event.Default.AbstractFlushingEventListener.PerformExecutions(IEventSource session) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Event\Default\AbstractFlushingEventListener.cs:249
   NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Event\Default\DefaultFlushEventListener.cs:19
   Umbraco.Framework.Persistence.NHibernate.NhEventListeners.OnFlush(FlushEvent event) in E:\WFI-SVN-19july12\Source\Libraries\Umbraco.Framework.Persistence.NHibernate\NhEventListeners.cs:175

[InvalidOperationException: Error trying to flush]
   Umbraco.Framework.Persistence.NHibernate.NhEventListeners.OnFlush(FlushEvent event) in E:\WFI-SVN-19july12\Source\Libraries\Umbraco.Framework.Persistence.NHibernate\NhEventListeners.cs:179
   NHibernate.Impl.SessionImpl.Flush() in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:1472
   NHibernate.Transaction.AdoTransaction.Commit() in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Transaction\AdoTransaction.cs:187
   Umbraco.Framework.Persistence.NHibernate.NhProviderTransaction.PerformCommit() in E:\WFI-SVN-19july12\Source\Libraries\Umbraco.Framework.Persistence.NHibernate\NhProviderTransaction.cs:153
   Umbraco.Hive.ProviderSupport.AbstractProviderTransaction.Commit(IProviderUnit unit) in E:\WFI-SVN-19july12\Source\Libraries\Umbraco.Hive\ProviderSupport\AbstractProviderTransaction.cs:51
   Umbraco.Hive.ProviderSupport.ProviderUnit.ConditionalCommit(IProviderTransaction providerTransaction) in E:\WFI-SVN-19july12\Source\Libraries\Umbraco.Hive\ProviderSupport\ProviderUnit.cs:131
   Umbraco.Hive.ProviderSupport.ProviderUnit.Complete() in E:\WFI-SVN-19july12\Source\Libraries\Umbraco.Hive\ProviderSupport\ProviderUnit.cs:59
   Umbraco.Hive.ProviderGrouping.GroupUnit`1.Complete() in E:\WFI-SVN-19july12\Source\Libraries\Umbraco.Hive\ProviderGrouping\GroupUnit.cs:139
   Umbraco.Cms.Web.Editors.Extenders.PublicAccessController.PublicAccessForm(PublicAccessModel model) +1407
   lambda_method(Closure , ControllerBase , Object[] ) +109
   System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters) +17
   System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters) +208
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +27
   System.Web.Mvc.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12() +55
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +263
   System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +19
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +263
   System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +19
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation) +263
   System.Web.Mvc.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14() +19
   System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters) +191
   System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) +343
   Umbraco.Cms.Web.Mvc.ActionInvokers.ControllerExtenderActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) in E:\WFI-SVN-19july12\Source\Libraries\Umbraco.Cms.Web\Mvc\ActionInvokers\ControllerExtenderActionInvoker.cs:105
   System.Web.Mvc.Controller.ExecuteCore() +116
   System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +97
   System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +10
   Umbraco.Cms.Web.Mvc.ActionInvokers.ControllerExtenderActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName) in E:\WFI-SVN-19july12\Source\Libraries\Umbraco.Cms.Web\Mvc\ActionInvokers\ControllerExtenderActionInvoker.cs:95
   System.Web.Mvc.Controller.ExecuteCore() +116
   System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext) +97
   System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext) +10
   System.Web.Mvc.<>c__DisplayClassb.<BeginProcessRequest>b__5() +37
   System.Web.Mvc.Async.<>c__DisplayClass1.<MakeVoidDelegate>b__0() +21
   System.Web.Mvc.Async.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _) +12
   System.Web.Mvc.Async.WrappedAsyncResult`1.End() +62
   System.Web.Mvc.<>c__DisplayClasse.<EndProcessRequest>b__d() +50
   System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f) +7
   System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action) +22
   System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult) +60
   System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result) +9
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +8970061
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +184


    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft