cancel
Showing results for 
Search instead for 
Did you mean: 

Database error while executing activiti process

mohammed_amr
Champ in-the-making
Champ in-the-making
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
1 REPLY 1

sergey_khariton
Champ in-the-making
Champ in-the-making
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.