nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Bug in oracle-DDL's

hbraun

Hi activiti-team,

we had a problem to store string variables with length greater than 2000 chars. An exception occurs only on oracle databases, with MySQL, H2, etc. it works as expected.
After a while, we found the reason: All DDL define varchars with 4000 chars, only the oracle DDL Scripts create textfields with length 2000.
Most times, it works fine. Only on oracle databases with a string variable with length between 2000 and 4000 you will get an exception. Less than 2000 chars, the string fits in database field, greater then 4000 chars the string is stored as a byte array.

We found the bug in activiti 5.16.1, the DDL in 5.16.3 looks still the same. In our system, we replaced all varchar(2000) with varchar(4000) and it looks fine until now.

Best regards,

Harry Braun

Find more posts tagged with

Comments

martin_grofcik

Hi Harry,

I had the similar problem -> https://github.com/Activiti/Activiti/pull/401

Regards
Martin

hbraun

Hi Martin,

I tried the database patch, but oracle returned an error message for NVARCHAR2(4000):
ORA-00910: specified length too long for its datatype

So, there is still a problem using the oracle database with activiti. We can't exclude strings with 2000-4000 chars. I also tried to override StringType and LongStringType with customPreVariableTypes, but the method only add a type, not replace the type.

Regards,

Harry

martin_grofcik

Hi Harry,

That's strange. I have tested it with oracle database and jUnit tests. (and tests passed) I would prefer DB patch instead of configuration changes.

If you want to set LongStringType length to 2000, change it in customPreVariableTypes in process engine configuration.

<br>&nbsp; protected void initVariableTypes() {<br>&nbsp;&nbsp;&nbsp; if (variableTypes==null) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes = new DefaultVariableTypes();<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; if (customPreVariableTypes!=null) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for (VariableType customVariableType: customPreVariableTypes) {<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(customVariableType);<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new NullType());<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new StringType(4000));<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; variableTypes.addType(new LongStringType(4001));<br>&hellip;<br>

Regards
Martin

hbraun

Hi Martin,

I know the code snippet, but we use activiti as a component with different databases, patching activiti isn't the preferred way. Patching the oracle scripts would be perfect, but oracle 11.2 rejects our DDL. I'm not an oracle expert, but I think NVARCHAR depends on the codepage. Perhaps varchar(4000) will fix it, but if there're side effects?
In my opinion, this is a critical bug in activiti. Using activiti 5.16.1 with oracle in production environment is dangerous. If you're lucky, all variables are smaller than 2000 or greater than 4000 chars. The day will come and somebody want to store a variable with 2001 chars, the system throws an exception and your well tested workflow break
Btw. there are other fields with length 2000 in oracle and 4000 in other databases, perhaps the variables are the first visible side effect.

Regards,

Harry

martin_grofcik

Hi Harry,

I can only agree with you.
Another possibility is to lower default string size limit to 2000 for all DBs and change DDLs to 2000.
(the side effect is that large strings are not taken into account for queries (variableValue….))

Regards
Martin

trademak

Hi Harry,

I don't agree that this is an critical bug. If Oracle is used in production it should also be used in your testing to my opinion.
The reason for the 2000 limit is the following:

"So an NVARCHAR2( 2000 ) with an AL16UTF16 national character set would occupy the maximum 4000 bytes and allow you to encode 2000 Unicode characters."

We might need to change the LongStringType logic in the Engine, so that we switch to LongStringType for Oracle already above 2000 characters, instead of above 4000, which is the logic right now. We'll investigate this further and will implement a fix.

Best regards,

hbraun

Hi Tijs,

we stopped using activiti with oracle db and stopped any activiti updates until the bug is fixed, in our case this issue is critical. Switching the database is not an option in financial sector, switching the BPMN-Engine is my next project. (But the target engine is activiti 🙂 )

If LongStringType uses 2000 characters for oracle it would be perfect.

Should I open a jira issue?

Best regards,

Harry

jbarrez

Yes, please. or a pull request would even be better 😉

hbraun

Well, you're already assigend to http://jira.codehaus.org/browse/ACT-2129 🙂

best regards,

Harry

jbarrez

**** auto-assignment of jira 😉

martin_grofcik

Hi Joram, Harry,
I would say that it is configuration issue. customPreVariableTypes in activiti process engine configuration can override default behavior.

<br>&nbsp;&nbsp;&nbsp; <util:list id="preVariableTypes"><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <bean class="org.activiti.engine.impl.variable.NullType"/><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <bean class="org.activiti.engine.impl.variable.StringType"><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <constructor-arg value="2000"/><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </bean><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <bean class="org.activiti.engine.impl.variable.LongStringType"><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <constructor-arg value="2001"/><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </bean><br>&nbsp;&nbsp;&nbsp; </util:list><br>

Regards
Martin

hbraun

Hi Martin,

after adding customPreVariableTypes, acitiviti adds the standard types with String(4000) and LongString(4001), see posting #4. AddType override the type in the hashtable, but add a second one to the list. So you can't override a standard type safely.

Best regards,

Harry

fandji

Hi

I did comment on the Issue: http://jira.codehaus.org/i#browse/ACT-2129 and https://github.com/Activiti/Activiti/pull/401.

Hopefully there will be a good solution found for this problem.

Best regards,

Philippe

martin_grofcik

Hi Harry,

yes, but custom types are applied first so default types are not used for the Strings.

Regards
Martin

martin_grofcik

Hi Philippe,

I put my comment there already too.
https://github.com/Activiti/Activiti/pull/401

Regards
Martin

denisgmarques

Hi,

We still use Activiti 5.17. Can I modify the Oracle datatype to VARCHAR(4000)? because I have a customer that can't change NATIONAL CHARACTER SET. So the max value to NVARCHAR type in this instance is 2000.

jbarrez

Sure, that won't be a probem.