Bug 1312753 - Not possible to set Task "description" longer than 255 chars
Summary: Not possible to set Task "description" longer than 255 chars
Keywords:
Status: CLOSED EOL
Alias: None
Product: JBoss BPMS Platform 6
Classification: Retired
Component: jBPM Core
Version: 6.2.0
Hardware: Unspecified
OS: Unspecified
unspecified
unspecified
Target Milestone: ---
: ---
Assignee: Alessandro Lazarotti
QA Contact: Radovan Synek
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-02-29 08:20 UTC by Anton Giertli
Modified: 2020-03-27 20:11 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2020-03-27 20:11:59 UTC
Type: Bug
Embargoed:


Attachments (Terms of Use)

Description Anton Giertli 2016-02-29 08:20:30 UTC
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:
always

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
https://bugzilla.redhat.com/show_bug.cgi?id=1107473
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.