Details
-
Bug Report
-
Resolution: Won't Fix
-
L3 - Default
-
None
-
7.6.0
-
None
-
Windows Tomcat 8.0.24
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] ]