How to Refresh Ivy Case Cache After Bulk SQL Update to iwa_caselocalized?

Khanh Tran

Hi team,

I am about to run a migration to update case description for around 200-300k cases.
If I do setDesciption for each case, then the performance is not good
ICase icase = CaseUtils.findCase(order.getCaseId()); if (icase != null) { icase.setDescription(description); }

Instead, I run bulk update sql query to update 'description' column in iwa_caselocalized table, but after finishing updating the table, the data is not reflected on the UI, it is still showing the old value.

I have done some research and found out that Ivy Case being cached, then if I update manually by running SQL, it will not know to refresh.

So, is there any way to evict Ivy Cache so that new description value can be shown on the UI?

Thank you

Alexander Suter

Khanh Tran If you modify data directly in Axon Ivy System Database, then I would highly recommend stopping the Axon Ivy Engine, run the scripts and start the Axon Ivy Engine afterwards. There are no APIs available to invalidate the cache for the system database.

Khanh Tran

Thank you @Alexander Suter

Reto Weiss

Hi
I would also strongly recommend to stop the Engine and start it again after the SQL update.
However, to clear the internal cache, you can use the Engine Cockpit.
In the Engine Cockpit, go to Monitor > Engine > Cache. Search for CaseLocalized Entity and press the Clear button.

Khanh Tran

Reto Weiss
Oh that Engine Cockpit solution is a really good option
Thank you