Database error while executing activiti process

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

mohammed_amr

Dears,

I'm using 4.0.d alfresco explorer for exposing some of custom processes that not working now cause this type of exception.

Please correct the errors below then click OK.
A system error happened during the operation: ### Error updating database. Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction ### The error may involve org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.updateByteArray_postgres-Inline ### The error occurred while setting parameters ### Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction
‍‍‍‍

Can anyone tell me if he is familiar with this type of exception ? or he knows the exact causing.

Note: I'm using a lucene search as a replacement for solar.

Thanks

sergey_khariton

We had tha same issue. The problem is in Activiti/Alfresco integration. We used cm:title property for start task. And we got same error in the alfresco console. After workflow starting we could not get task list in the admin dashboard, we got errors.
We investigated, that if we use cm:title or any other property with mltext type, Alfresco tries to change this property in the code during read-only transaction. This error appears only when we use mltext.
We replaced cm:title with own propety etwf:title with d:text type and error gone.
Hope this helps.