Flowable

Flowable Development

value too long

I spent several hours diagnosing a value too long error e.g:

workflow.activiti.ActivitiError:
'ActivitiError, 500 error: for url:
http://localhost:8080/flowable-rest/service/runtime/tasks/10a5a39-8ea7-11ee:
{"message": "Internal server error",
  "exception":
    ### "Error updating database. Cause: org.postgresql.util.PSQLException:
    ERROR: value too long for type character varying(255)
    ### The error may exist in org/flowable/task/service/db/mapping/entity/HistoricTaskInstance.xml
    ### The error may involve org.flowable.task.service.impl.persistence.entity.HistoricTaskInstanceEntityImpl.insertHistoricTaskInstance-Inline
    ### The error occurred while setting parameters
    ### SQL: insert into ACT_HI_TASKINST (
      ID_, REV_, TASK_DEF_ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_,
      SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_, SCOPE_DEFINITION_ID_,
      PROPAGATED_STAGE_INST_ID_, NAME_, PARENT_TASK_ID_, DESCRIPTION_,
      OWNER_, ASSIGNEE_, START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_,
      DELETE_REASON_, TASK_DEF_KEY_, FORM_KEY_, PRIORITY_, DUE_DATE_,
      CATEGORY_, TENANT_ID_, LAST_UPDATED_TIME_
    ) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
    ### Cause: org.postgresql.util.PSQLException:
    ERROR: value too long for type character varying(255)"}'

I checked the Postgres logs (SQL Logging) but this didn’t help because the parameters are not written if the query fails.
I also checked the data in the python code and none of it was over 255 characters.

The documentTitle field was 179 characters long:

The next task in the workflow had a fairly long name which also used the documentTitle e.g. Please review ${documentTitle} etc etc...
When combined, the name is too long (over 255 characters)

For more information, see https://www.kbsoftware.co.uk/crm/ticket/6958/