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

    • Icon: Bug Report Bug Report
    • Resolution: Won't Fix
    • Icon: L3 - Default L3 - Default
    • None
    • 7.6.0
    • admin
    • None
    • Windows Tomcat 8.0.24

      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] ]

        This is the controller panel for Smart Panels app

              Unassigned Unassigned
              lejaf Frank Leja
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: