Data Audit variable value sze limited to 255

[Adrian Apthorp]

I've enabled the data-audit extension as I migrate to Kogito 10.0.0 and have hit what looks like a length limitation on variable size. See exception:

2025-02-16 14:56:59,784 xxxx ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper:150] (executor-thread-4) ERROR: value too long for type character varying(255)
2025-02-16 14:56:59,789 xxxx WARN  [com.arjuna.ats.arjuna:356] (executor-thread-4) ARJUNA012125: TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple< 0:ffffc0a80265:8733:67b18b96:40, org.hibernate.resource.transaction.backend.jta.internal.synchronization.RegisteredSynchronization@776a398c >: org.hibernate.exception.DataException: could not execute statement [ERROR: value too long for type character varying(255)] [insert into process_instance_variable_log (business_key,event_date,event_id,parent_process_instance_id,process_id,process_instance_id,process_type,process_version,root_process_id,root_process_instance_id,variable_id,variable_name,variable_value,id) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?)]

I suspect this is due to a java object that I have as a process variable.

Looking at the data-audit code I'm assuming this is due to the variable value being a String, which defaults to a column size of VARCHAR 255.

[Pere Fernandez]

You are right @Adrian Apthorp , that's because of the size of the content you want to store, for objects the data is stored in JSON format and that might be a problem depending on the object you are storing in the variable. I guess that's your case right?

BTW are you experiencing the same problem with Process Variables?

--
You received this message because you are subscribed to the Google Groups "Kogito development mailing list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to kogito-developm...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/kogito-development/c5b4bdf9-6bad-410d-a27f-1f87c23ba8b3n%40googlegroups.com.

[Pere Fernandez]

@Adrian Apthorp Just raised this issue (https://github.com/apache/incubator-kie-issues/issues/1833) to tackle it. Will try to find to some time to work on it ASAP

[Adrian Apthorp]

Pere, Thanks. To answer your question, yes you're right it's an object that would stored in JSON. I had a look at the just the basic JSON structure of the object, and it was > 255 char.

[Pere Fernandez]

Hi @Adrian Apthorp 

We finally addressed the issue upstream setting the columns to max size for now, Let me know how it goes.

Pere

To view this discussion visit https://groups.google.com/d/msgid/kogito-development/304d8078-1c50-434d-9d52-2604d88814e0n%40googlegroups.com.