System Error when trying to Edit a Workflow
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Symptoms
Trying to edit a workflow results in Internal Server Error.
The following appears in the atlassian-jira.log:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
2012-09-21 09:24:58,606 http-80-9 ERROR [500ErrorPage.jsp] Exception caught in 500 page org.ofbiz.core.entity.GenericEntityException: while inserting: [GenericEntity:DraftWorkflow][id,10717][descriptor,<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE workflow PUBLIC "-//OpenSymphony Group//DTD OSWorkflow 2.8//EN" "http://www.opensymphony.com/osworkflow/workflow_2_8.dtd">
<workflow>
<meta name="jira.update.author.name">admin</meta>
<meta name="jira.description">Test Workflow</meta>
<meta name="jira.updated.date">1348241098591</meta>
<initial-actions>
...
(SQL Exception while executing the following:INSERT INTO dbo.jiradraftworkflows (ID, PARENTNAME, DESCRIPTOR) VALUES (?, ?, ?) (Length of LOB data (78788) to be replicated exceeds configured maximum 65536.))
at com.atlassian.jira.ofbiz.DefaultOfBizDelegator.createValue(DefaultOfBizDelegator.java:379)
at com.atlassian.jira.workflow.OfBizDraftWorkflowStore.createDraftWorkflow(OfBizDraftWorkflowStore.java:77)
at com.atlassian.jira.workflow.CachingDraftWorkflowStore.createDraftWorkflow(CachingDraftWorkflowStore.java:104)
at com.atlassian.jira.workflow.OSWorkflowManager.createDraftWorkflow(OSWorkflowManager.java:259)
at com.atlassian.jira.bc.workflow.DefaultWorkflowService.createDraftWorkflow(DefaultWorkflowService.java:95)
Diagnosis
Jira Data Center instance using SQL Server as the database backend.
Cause
Replication of tables is enabled for JIRA's workflow tables. The data being replicated exceeds the configured max replication size. By default this is 65536.
Solution
Resolution
Method 1: Increase the max replication size within SQL Server
See here for more specific directions on how to do this: http://msdn.microsoft.com/en-us/library/ms179573.aspx
Method 2: Disable replication for the workflow tables.
These are the tables you want to disabled replication for:
jiradraftworkflows
jiraworkflows
Was this helpful?