topic Re: value too large for column 'X'.'ACT_RU_IDENTITYLINK'. in Alfresco Archive

value too large for column 'X'.'ACT_RU_IDENTITYLINK'.

rodiaz — Thu, 02 Jun 2011 08:16:59 GMT

Hi guys,We are identifying the groups with their distinguishedName in one LDAP active directory. So, we have an error saying that the id for the groups is too long. ACT_RU_IDENTITYLINK"."GROUP_ID_" (actual: 68, maximum: 64) Could be possible for you make them bigger??Thanks a lot

Re: value too large for column 'X'.'ACT_RU_IDENTITYLINK'.

ronald_van_kuij — Thu, 02 Jun 2011 21:53:27 GMT

Can't you just use the rdn? Or maybe even just the cn of the group? The reason I ask this is that it is hard to define how big it should become then… 70? 100? 128? But you can always increase this yourself in the database and maybe the ibatis mapping file.

Re: value too large for column 'X'.'ACT_RU_IDENTITYLINK'.

rodiaz — Fri, 03 Jun 2011 07:23:29 GMT

Hi,

thanks for your quick reply. You´re all right but the cn could be repeated, so we can´t use it like identifier. I think that 255 for the id could be good, like the column name. what do you think?

Re: value too large for column 'X'.'ACT_RU_IDENTITYLINK'.

frederikherema1 — Mon, 06 Jun 2011 08:21:52 GMT

In activiti, all ID's are 64 lenght varchars, but nothing stops you from altering the schema, once it's created…