[MNT-1306] Error appears when creating Advanced Workflow with long description Created: 26-Jan-09  Updated: 19-Mar-13  Resolved: 25-May-10

Status: Closed
Project: Service Packs and Hot Fixes
Component/s: Alfresco Explorer
Affects Version/s: 2.2.5
Fix Version/s: 2.2.8

Type: Service Pack Request
Reporter: mkononovich Assignee: Closed Bugs (Inactive)
Resolution: Fixed Votes: 1
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Alfresco 2.2 SP3 Stack 2 Windows Server 2003 SP2, Jboss 4.2.3, MS Sql Server 2005 SP2, JDK 6u7 , NTLM, Vista, FF3

Attachments: JPEG File long description.JPG    
Issue Links:
relates to MNT-1667 Error appears when creating Advanced ... Closed
is related to by MNT-7744 2.2 SP8 retests Closed
Bug Priority:
Category 2
ACT Numbers:

8515 9751

Testcase ID:



Steps to reproduce:
1. Start creation of Advanced Workflow (Adhoc or Review and Approve);
2. In Description field enter any text (approximately 300 symbols);
3. Choose any reviewer and click Finish button; -> System error message appears:

Please correct the errors below then click Finish.

  • A system error happened during the operation: JDBC exception on Hibernate data access; nested exception is org.hibernate.exception.DataException: could not insert: [org.jbpm.context.exe.variableinstance.StringInstance]

Expected result:
Description field should have appropriate length limit or more friendly notification should inform the user;

Comment by mkononovich [ 30-Jan-09 ]

The same behavior on Alfresco 2.2 SP3 build 385 - Stack 1 RHEL 5.2 , Tomcat 6.0.18 ,Oracle 10.2 , JDK 5u16, OpenLDAP 2.3, WinXP SP2, IE7

Comment by Carl Nordenfelt (Inactive) [ 19-Feb-09 ]

This error does not only occurs for the description field but all d:text fields in a workflow-task type. What I have found the error is twofold:
1) https://jira.jboss.org/jira/browse/JBPM-1450
2) The JBPM_VARIABLEINSTANCE column STRINGVALUE_ is only 255 charachters (see https://jira.jboss.org/jira/browse/JBPM-2017)

1) has to do with JBPM logging and can be resolved by the workaround described in the JBoss JIRA. For 2) I had to manually alter the table to be able to store longer string values (ALTER TABLE `alfresco`.`JBPM_VARIABLEINSTANCE` MODIFY COLUMN `STRINGVALUE_` VARCHAR(4000) CHARACTER SET latin1 COLLATE latin1_swedish_ci DEFAULT NULL

I can also add the the error occurs for MySQL but not when using the Derby DB.

Comment by mkononovich [ 10-Jul-09 ]

The same happens on Alfresco 2.2 SP5 build 476 - Stack 1 RHEL 5.2, Tomcat 6.0.18, Mysql 5.1.34, JDK 5u16, Windows XP

Comment by mkononovich [ 16-Jul-09 ]

The issue also occurs on environment Alfresco 2.2 SP5 build 476 - Stack 2 Windows 2003 R2 SP2 x32, JBoss 4.2.3 GA. Oracle 10g, JDK 6u11, NTLM, Vista, FF 3.5

Comment by Derek Hulley [X] (Inactive) [ 04-May-10 ]

Modifying the JBPM schema is over-the-top; limiting the description field in the UI would be a simpler solution. If this was made configurable, then anyone who manually increased the size of the column could set the UI field size with the appropriate parameter - only rarely would this be required, but at least it would be an option for anyone wanting to change the storage themselves.

Comment by Dave Ward [X] (Inactive) [ 04-May-10 ]

Please limit the size of the description field in the UI so that it does not allow overflow in any of the supported databases.

Comment by Alfresco QA Team (Inactive) [ 03-Jun-10 ]

Successfully validated in Alfresco 3.2 EE build 554 using Windows 2008 SP1 x64, Tomcat 6.0.18, Mysql 5.1.34, JDK 6u20 x64.

Generated at Sun Mar 07 18:47:30 GMT 2021 using Jira 7.13.15#713015-sha1:7c5ddd2c3e1709974ae9c48c17df8edd3919fe2c.