Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1107471

Summary: Cannot use Task Comment longer than 256 characters
Product: [Retired] JBoss BPMS Platform 6 Reporter: Toshiya Kobayashi <tkobayas>
Component: jBPM CoreAssignee: Kris Verlaenen <kverlaen>
Status: CLOSED DUPLICATE QA Contact: Marek Baluch <mbaluch>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.0.1   
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-06-10 03:38:23 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Toshiya Kobayashi 2014-06-10 03:22:33 UTC
Description of problem:

If you set text longer than 256 characters in "Comment" property of a Human Task, jBPM throws an Exception saying 'Value too long for column "SHORTTEXT VARCHAR(255)"' when a Task is added.


Steps to Reproduce:
1. Set text longer than 256 characters in "Comment" property of a Human Task
2. Start a process and reach to the Human Task Node.

(I will send a unit test as PR)

Actual results:

===
ERROR: Value too long for column "SHORTTEXT VARCHAR(255)": "'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa... (256)"; SQL statement:
insert into I18NText (id, language, shortText, text) values (null, ?, ?, ?) [22001-168]
Exception in thread "main" org.jbpm.workflow.instance.WorkflowRuntimeException: [com.sample.bpmn.hello:1 - Task 1:3] -- org.hibernate.exception.DataException: could not execute statement
	at org.jbpm.workflow.instance.node.WorkItemNodeInstance.internalTrigger(WorkItemNodeInstance.java:135)
...
Caused by: javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not execute statement
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1387)
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1310)
	at org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1316)
	at org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:881)
	at org.jbpm.services.task.persistence.JPATaskPersistenceContext.persistTask(JPATaskPersistenceContext.java:75)
	at org.jbpm.services.task.impl.TaskInstanceServiceImpl.addTask(TaskInstanceServiceImpl.java:107)
	at org.jbpm.services.task.commands.AddTaskCommand.execute(AddTaskCommand.java:105)
	at org.jbpm.services.task.commands.AddTaskCommand.execute(AddTaskCommand.java:53)
	at org.jbpm.services.task.commands.TaskCommandExecutorImpl$SelfExecutionCommandService.execute(TaskCommandExecutorImpl.java:65)
	at org.drools.core.command.impl.AbstractInterceptor.executeNext(AbstractInterceptor.java:41)
	at org.jbpm.services.task.persistence.TaskTransactionInterceptor.execute(TaskTransactionInterceptor.java:54)
	at org.jbpm.services.task.commands.TaskCommandExecutorImpl.execute(TaskCommandExecutorImpl.java:40)
	at org.jbpm.services.task.impl.command.CommandBasedTaskService.addTask(CommandBasedTaskService.java:471)
	at org.jbpm.services.task.wih.LocalHTWorkItemHandler.executeWorkItem(LocalHTWorkItemHandler.java:61)
...
Caused by: org.h2.jdbc.JdbcSQLException: Value too long for column "SHORTTEXT VARCHAR(255)": "'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa... (256)"; SQL statement:
insert into I18NText (id, language, shortText, text) values (null, ?, ?, ?) [22001-168]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
===

Expected results:

A Task is added.

Comment 2 Toshiya Kobayashi 2014-06-10 03:38:23 UTC

*** This bug has been marked as a duplicate of bug 1107473 ***