How to manage tables in Camunda 7

[cpbpm]

@bijoy

ACT_HI_VARINST

The same question is answered in this thread:

Insert into ACT_HI_VARINST suddenly started failing due to Data truncation error

Hi Rob! Thank you very much, that was it. A JSON Object from a web service ended up growing much more than expected, so it took me by surprise, specially since the troublesome table was supposed to contain only historical data. Now, I agree that my understanding of Camunda’s data model is not too deep, and still haven’t dived a lot into it. I ended up giving the data a proper JSON serialization using the spin plugin, and took the opportunity to trim it into only the useful bits and only then …