topic Re: Persisting variables that are long Strings throws Exception in Alfresco Archive

Persisting variables that are long Strings throws Exception

jmaru — Mon, 24 Sep 2012 18:12:04 GMT

Hi all,I am running the Activiti engine against H2 database with history level set to 'full'. When I set a variable with a value which is a large XML string, I get the following exception. First of all, is this just specific to H2 and will it go away if I move to PostGres/Oracle? If not, how can I s

Re: Persisting variables that are long Strings throws Exception

ronald_van_kuij — Mon, 24 Sep 2012 18:23:17 GMT

Create a bytearray from it…. That way it is stored in te bytearray table which does not have te limit of 4000 chars. The other solution is to change the table definition…

Re: Persisting variables that are long Strings throws Exception

adevore — Fri, 27 May 2016 20:30:33 GMT

Are there any side effects of removing the limit of 4000? Preferably, I would rather not have a limit but I understand that removing the limit could affect things like indices. So is there anything internal that depends on the limit 4000 for the "text_" column in ACT_HI_DETAIL?

For more context we're using Postgres, which shouldn't make a difference, and getting the a similar error: "org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000)". After completing a task it tries to insert all our data into the "text_" column of ACT_HI_DETAIL.

Re: Persisting variables that are long Strings throws Exception

martin_grofcik — Mon, 30 May 2016 09:35:49 GMT

Hi Anton,

LongString has changed during the last 3 years. Are you aware of these changes?
e.g. https://forums.activiti.org/content/insert-acthivarinst-causes-ora-01401-inserted-value-too-large-column

Regards
Martin

Re: Persisting variables that are long Strings throws Exception

adevore — Wed, 01 Jun 2016 20:24:39 GMT

I wasn't aware of that article but unless the fix introduced works with Postgres then I don't see how it would help. We're on version 5.19.0 of Activiti which I believe is higher than the version in that forum.

We haven't written any code to touch ACT_HI_DETAIL specifically, this is internal to Activiti in terms of how it tries to complete a User Task. We try to complete a task and Activiti attempts to store all the information from a form in the "text_" column in ACT_HI_DETAIL. I'm simply asking if there is a known reason for setting a limit to 4000 characters and what are the repercussions of removing that limit.

Re: Persisting variables that are long Strings throws Exception

martin_grofcik — Thu, 02 Jun 2016 07:02:14 GMT

Hi Anton,

I am not sure now (it was a long time ago) :-), but oracle has limit for varchar2 column size (2000 or 4000 chars). That's why there is this limit.

Regards
Martin

Re: Persisting variables that are long Strings throws Exception

adevore — Fri, 03 Jun 2016 17:14:18 GMT

Okay, but I'm using Postgres, not Oracle. So it sounds like there is no significant reason for the limit and no negative side effects or removing the limit.

Anton