Uploaded image for project: 'camunda BPM'
  1. camunda BPM
  2. CAM-7391

Creating a user group with long ID failed with "value too long for column"

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Open
    • Priority: L3 - Default
    • Resolution: Unresolved
    • Affects Version/s: 7.6.0
    • Fix Version/s: None
    • Component/s: admin
    • Labels:
      None
    • Environment:
      Windows Tomcat 8.0.24
    • Title Keywords:
      persistence

      Description

      I tried to create a user group in app admin with a very long id.

      On Save the following Database error occured, stating, that the DB column is limited to varchar(64):
      Server Error : ENGINE-03004 Exception while executing Database Operation 'INSERT AuthorizationEntity[b4a1773d-e6f7-11e6-aa20-18dbf21c9f0c]' with message ' ### Error updating database. Cause: org.h2.jdbc.JdbcSQLException: Value too long for column "RESOURCE_ID_ VARCHAR(64)": "'12345678901234567890123456789012345678901234567890123456789012345678901234567890' (80)"; SQL statement: insert into ACT_RU_AUTHORIZATION ( ID_, TYPE_, GROUP_ID_, USER_ID_, RESOURCE_TYPE_, RESOURCE_ID_, PERMS_, REV_ ) values ( ?, ?, ?, ?, ?, ?, ?, 1 ) [22001-168] ### The error may involve org.camunda.bpm.engine.impl.persistence.entity.AuthorizationEntity.insertAuthorization-Inline ### The error occurred while setting parameters ### SQL: insert into ACT_RU_AUTHORIZATION ( ID_, TYPE_, GROUP_ID_, USER_ID_, RESOURCE_TYPE_, RESOURCE_ID_, PERMS_, REV_ ) values ( ?, ?, ?, ?, ?, ?, ?, 1 ) ### Cause: org.h2.jdbc.JdbcSQLException: Value too long for column "RESOURCE_ID_ VARCHAR(64)": "'12345678901234567890123456789012345678901234567890123456789012345678901234567890' (80)"; SQL statement: insert into ACT_RU_AUTHORIZATION ( ID_, TYPE_, GROUP_ID_, USER_ID_, RESOURCE_TYPE_, RESOURCE_ID_, PERMS_, REV_ ) values ( ?, ?, ?, ?, ?, ?, ?, 1 ) [22001-168]'. Flush summary: [ INSERT AuthorizationEntity[b4a1773d-e6f7-11e6-aa20-18dbf21c9f0c] INSERT GroupEntity[12345678901234567890123456789012345678901234567890123456789012345678901234567890] ]

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            lejaf Frank Leja
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated: