topic Re: Alfresco DB Update Query in Running Production in Alfresco Forum

Alfresco DB Update Query in Running Production

krutik_jayswal — Thu, 26 Jul 2018 11:31:12 GMT

HI ,I want to update the act_ru_variable table while Alfresco is up and running. I want to update the value of an execution variable. The reason for doing this is , we want to cancel the workflow on the document. The usual "cancel workflow "and "end workflow" command will not work because we have a

Re: Alfresco DB Update Query in Running Production

yreg — Mon, 30 Jul 2018 08:28:45 GMT

Even though it seems like you've done your homework related to what you are trying to achieve, updating Alfresco DB while the system is running is usually a recipe for trouble.

I would recommend you to go through the options provided via the workflow admin-console and see if you can use that to solve your issue : The Workflow Console | Alfresco Documentation it would be far less risky and far more reliable.

Section 7.f seems particularly interesting for your case.

Re: Alfresco DB Update Query in Running Production

krutik_jayswal — Mon, 30 Jul 2018 10:48:12 GMT

Thank you for help.

Unfortunately, with the update task <variable details to update> command , I can only update the task variable which are defined inside the workflow task model.

Variable which we want to update is inside the execution temporary variable, which I think can not be updated from workflow console(Not 100% sure).