System Error when trying to Edit a Workflow

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

症状

Trying to edit a workflow results in Internal Server Error.

atlassian-jira.log に次のエラーが返されます。

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)

診断

JIRA instance using SQL Server as the database backend.

原因

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.

ソリューション

Method 1: Increase the max replication size within SQL Server

Method 2: Disable replication for the workflow tables. These are the tables you want to disabled replication for:
  • jiradraftworkflows
  • jiraworkflows
Last modified on Mar 30, 2016

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.