Saturday, 23 July 2016

Sharepoint 2013 The total size of the activity XAML is greater than the maximum allowed size of 51200 KB using SQL server Database

Sharepoint 2013 The total size of the activity XAML is greater than the maximum allowed size of 51200 KB
Summary:  The Default Size of the SharePoint 2013 workflow is 5 MB which is quite enough until you are writing very complex or multi-level approval workflow.  

Microsoft.Workflow.Client.ActivityValidationException: Workflow XAML failed validation due to the following errors:
The total size of the activity XAML including the referenced XAML is greater than the maximum allowed size of 51200 KB.
Solutions:
  • Open Microsoft SQL Management which is belongs to SharePoint

  • Open the database and choose WFResourceManagementDB table dbo.WorkflowServiceConfig
  • Push the right button and choose «Edit Top 200 Roww
  • Change the setting WorkflowServiceMaxWorkflowXamlSizeInBytes to 104857600

Make a restart in IIS WorkflowMgmtPool and Workflow Management Site
Hope this will help some one ☺

Posted by

1 comment:

  1. Rohit Devmore23 July 2016 at 21:20

    is there a solution to this problem in case of sharepoint online? where we will not have access to SQL

    ReplyDelete

Subscribe to: Post Comments (Atom)