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

When the Form Field ID Value Entered is Greater Than 255 Characters a UI Validation Error Should be Displayed

    Details

    • Bug Priority:
      Category 3
    • ACT Numbers:

      00971526

      Description

      In APS there is a 255 maximum character length restriction on the “NAME” column in the ACT_HI_VARINST table.  However, when creating a form as part of a process you are able to add a form field ID value of greater than 255 characters and save the process without any error being displayed.  If you then execute the process and attempt to complete the form as part of a task an error is displayed and the task cannot be completed.

      Supporting Evidence

      Steps to Reproduce:

       

      1. Deploy an OOTB APS v1.9.0.
      2. Create a process model that contains a user task.
      3. Add a form to the user task.
      4. In the form add a text field.
      5. Override the text field ID.
      6. Create an ID that contains more than 255 characters.
      7. Close and then Save the form.
      8. Save the process.
      9. Create an App with the process model included and save it.
      10. Select to Publish the App Definition and save.
      11. Execute the App.
      12. Start the process.
      13. In the form add text to the text field.
      14. Save and Complete the task.
      15. An “Error occurred” is displayed in the UI.
      16. The error shown in the localhost.log is as follows:

      "SEVERE [http-nio-8080-exec-7] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [appDispatcher] in context with path [/activiti-app] threw exception [Request processing failed; nested exception is org.apache.ibatis.exceptions.PersistenceException: 

          1. Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Value too long for column "NAME_ VARCHAR(255) NOT NULL": "'testform55555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555555... (568)"; SQL statement: 
            insert into ACT_HI_VARINST (ID_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, CREATE_TIME_, LAST_UPDATED_TIME_) 
            values ( 
            ?, 
            ?, 
            ?, 
            ?, 
            ?, 
            ?, 
            ?, 
            ?, 
            ?, 
            ?, 
            ?, 
            ?, 
            ?, 

            ) [22001-176] 
            at org.h2.message.DbException.getJdbcSQLException(DbException.java:344) 
            at org.h2.message.DbException.get(DbException.java:178) 
            at org.h2.table.Column.validateConvertUpdateSequence(Column.java:332) 
            at org.h2.table.Table.validateConvertUpdateSequence(Table.java:726) 
            at org.h2.command.dml.Insert.insertRows(Insert.java:152) 
            at org.h2.command.dml.Insert.update(Insert.java:115) 
            at org.h2.command.CommandContainer.update(CommandContainer.java:79) 
            at org.h2.command.Command.executeUpdate(Command.java:254) 
            at org.h2.server.TcpServerThread.process(TcpServerThread.java:346) 
            at org.h2.server.TcpServerThread.run(TcpServerThread.java:160) 
            at java.lang.Thread.run(Unknown Source)"

      Expected Behavior:

      When overriding the Field ID value while creating the form, if an ID of greater than 255 characters is entered a UI validation error should be displayed and the value not allowed.

      Observed Behavior: 

      When overriding the Field ID value, while creating the form, if an ID of greater than 255 characters is entered a UI validation error is not displayed and the value is allowed.

        Attachments

          Structure

            Activity

              People

              • Assignee:
                mhowarth Mark Howarth
                Reporter:
                kwatson Kimberly Watson
              • Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Structure Helper Panel