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

1 comment:

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

    ReplyDelete