Bug 1312753 - Not possible to set Task "description" longer than 255 chars
Not possible to set Task "description" longer than 255 chars
Status: NEW
Product: JBoss BPMS Platform 6
Classification: JBoss
Component: jBPM Core (Show other bugs)
Unspecified Unspecified
unspecified Severity unspecified
: ---
: ---
Assigned To: Maciej Swiderski
Radovan Synek
Depends On:
  Show dependency treegraph
Reported: 2016-02-29 03:20 EST by Anton Giertli
Modified: 2016-06-29 21:57 EDT (History)
1 user (show)

See Also:
Fixed In Version:
Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of:
Last Closed:
Type: Bug
Regression: ---
Mount Type: ---
Documentation: ---
Verified Versions:
Category: ---
oVirt Team: ---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Attachments (Terms of Use)

  None (edit)
Description Anton Giertli 2016-02-29 03:20:30 EST
Description of problem:

It is not possible to configure a Task with a description longer than 255 chars
Version-Release number of selected component (if applicable):

BPM Suite 6.2.0
How reproducible:

Steps to Reproduce:
1. In business-central Web Designer, create a simple process with single human task
2. Fill the "Description" column with text longer than 255 chars
3. Run this process - it will fail

Actual results:
It will fail with exception similar to this:

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

Expected results:
It will store the Task Description

Additional info:
It will fail to persist Task into two Tables:

1) Task
2) AuditTaskImpl

Both of these table have "description" column defined as varchar(255)

This is a different bug than
Since that was solved by code fix on I18NTextImpl.java

Note You need to log in before you can comment on or make changes to this bug.