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

Bug 1107473

Summary: Cannot use Task Comment longer than 256 characters
Product: [Retired] JBoss BPMS Platform 6 Reporter: Toshiya Kobayashi <tkobayas>
Component: jBPM CoreAssignee: Alessandro Lazarotti <alazarot>
Status: CLOSED EOL QA Contact: Marek Baluch <mbaluch>
Severity: medium Docs Contact:
Priority: high    
Version: 6.0.1CC: abhumbe, agiertli, kverlaen, sengork
Target Milestone: ER3   
Target Release: 6.1.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
: 1107498 (view as bug list) Environment:
Last Closed: 2020-03-27 20:03:28 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:
Bug Depends On:    
Bug Blocks: 1107498    

Description Toshiya Kobayashi 2014-06-10 03:24:19 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 1 Toshiya Kobayashi 2014-06-10 03:32:34 UTC 
Test case and fix:
https://github.com/droolsjbpm/jbpm/pull/204
Comment 2 Toshiya Kobayashi 2014-06-10 03:38:23 UTC 
*** Bug 1107471 has been marked as a duplicate of this bug. ***
Comment 3 Kris Verlaenen 2014-11-27 23:41:01 UTC 
Pull request was merged.
Comment 4 Marek Baluch 2014-12-18 08:28:03 UTC 
Verified on 6.1.0.ER3.
Comment 6 Anton Giertli 2016-02-22 14:39:39 UTC 
I tried to set Task "Description" column in Web Designer of 6.2.0 business-central and once this process is started, it fails with this exception:

Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2161)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1890)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:560)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:417)
	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:363)
	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186) [hibernate-core-4.2.20.Final-redhat-1.jar:4.2.20.Final-redhat-1]
	... 72 more

I see these three tables where the Task description is stored:
audittaskimpl
task
i18text

Their columns are limited to 255 characters, so I don't understand how the fix above can help that.

Is this the same issue
OR
should I report a new BZ
OR
are we saying it is not possible to use Task description longer than 255 chars?

Thanks,
Anton
Comment 8 Anton Giertli 2016-03-15 07:31:29 UTC 
Toshiya,

thanks for reminding this to me. You are absolutely right - my comment 6 resulted in a new BZ
https://bugzilla.redhat.com/show_bug.cgi?id=1312753

I am setting the status of this one back to Verified.