Uploaded image for project: 'Service Packs and Hot Fixes'
  1. Service Packs and Hot Fixes
  2. MNT-1667

Error appears when creating Advanced Workflow with long description

    Details

    • Type: Service Pack Request
    • Status: Closed
    • Resolution: Fixed
    • Affects Version/s: 3.1.1, 3.1.2, 3.1
    • Fix Version/s: 3.4.3
    • Component/s: Alfresco Explorer
    • Labels:
      None
    • Environment:
      Alfresco 3.0 Labs build 1303 Windows 2003 SP2, Tomcat 5.5.23, MySQL 5, JDK 5u11 FF3
    • Bug Priority:
      Category 2
    • ACT Numbers:

      13314

      Description

      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: Hibernate operation: could not insert: [org.jbpm.context.exe.variableinstance.StringInstance]; uncategorized SQLException for SQL [insert into JBPM_VARIABLEINSTANCE (VERSION_, NAME_, CONVERTER_, TOKEN_, TOKENVARIABLEMAP_, PROCESSINSTANCE_, STRINGVALUE_, CLASS_) values (?, ?, ?, ?, ?, ?, ?, 'S')]; SQL state [01004]; error code [0]; Data truncation: Data too long for column 'STRINGVALUE_' at row 1; nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'STRINGVALUE_' at row 1

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

        Attachments

        1. alfresco_3.4.3.jpg
          alfresco_3.4.3.jpg
          116 kB
        2. build_295.JPG
          build_295.JPG
          35 kB
        3. build_295.txt
          9 kB
        4. enter 300 symbols in discription.png
          enter 300 symbols in discription.png
          18 kB
        5. log long descr on Advanced workflow.txt
          11 kB
        6. long description on Advanced workflow.JPG
          long description on Advanced workflow.JPG
          168 kB

          Issue Links

            Structure

              Activity

                People

                • Assignee:
                  closedbugs Closed Bugs (Inactive)
                  Reporter:
                  mkononovich mkononovich
                • Votes:
                  4 Vote for this issue
                  Watchers:
                  1 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 2 hours
                    2h

                      Structure Helper Panel