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 persist it.

Thanks again!

Cheers,

David.