Database problem with activiti

[dooman]

Hi
I'm trying to use activiti in 3.4.e.
I've created simple workflow using Activiti. It deploys and assign successfully, but when I  want to see assigned tasks, I have this error:

25.04.2011 18:25:11 org.activiti.engine.impl.interceptor.CommandContext closeSEVERE: Error while closing command contextorg.apache.ibatis.exceptions.PersistenceException: ### Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction### The error may involve org.activiti.persistence.updateHistoricTaskInstance-Inline### The error occurred while setting parameters### Cause: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:100)   at org.activiti.engine.impl.db.DbSqlSession.flushUpdates(DbSqlSession.java:405)   at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:320)   at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:135)   at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:91)   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)   at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:130)   at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:40)   at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)   at org.activiti.engine.impl.AbstractQuery.list(AbstractQuery.java:102)   at org.alfresco.repo.workflow.activiti.ActivitiWorkflowEngine.getAssignedTasks(ActivitiWorkflowEngine.java:1239)   at org.alfresco.repo.workflow.WorkflowServiceImpl.getAssignedTasks(WorkflowServiceImpl.java:569)   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:597)   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)   at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:34)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)   at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:44)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)   at org.alfresco.repo.audit.AuditMethodInterceptor.proceedWithAudit(AuditMethodInterceptor.java:217)   at org.alfresco.repo.audit.AuditMethodInterceptor.proceed(AuditMethodInterceptor.java:184)   at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:137)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)   at $Proxy70.getAssignedTasks(Unknown Source)   at org.alfresco.web.bean.workflow.WorkflowBean.getTasksToDo(WorkflowBean.java:201)   at sun.reflect.GeneratedMethodAccessor938.invoke(Unknown Source)   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:597)   at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:457)   at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:85)   at org.apache.myfaces.el.ELParserHelper$MyPropertySuffix.evaluate(ELParserHelper.java:535)   at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)   at org.apache.commons.el.UnaryOperatorExpression.evaluate(UnaryOperatorExpression.java:156)   at org.apache.myfaces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:386)   at javax.faces.component.UIComponentBase.isRendered(UIComponentBase.java:1078)   at org.apache.myfaces.shared_impl.renderkit.RendererUtils.renderChild(RendererUtils.java:408)   at org.apache.myfaces.shared_impl.renderkit.RendererUtils.renderChildren(RendererUtils.java:400)   at org.apache.myfaces.shared_impl.renderkit.RendererUtils.renderChild(RendererUtils.java:417)   at org.apache.myfaces.shared_impl.renderkit.RendererUtils.renderChildren(RendererUtils.java:400)   at org.apache.myfaces.shared_impl.renderkit.RendererUtils.renderChild(RendererUtils.java:417)   at org.apache.myfaces.shared_impl.renderkit.html.HtmlGridRendererBase.renderChildren(HtmlGridRendererBase.java:229)   at org.apache.myfaces.shared_impl.renderkit.html.HtmlGridRendererBase.encodeEnd(HtmlGridRendererBase.java:101)   at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:539)   at javax.faces.webapp.UIComponentTag.encodeEnd(UIComponentTag.java:498)   at javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:366)   at org.apache.myfaces.shared_impl.taglib.UIComponentBodyTagBase.doEndTag(UIComponentBodyTagBase.java:57)   at org.apache.jsp.jsp.dashboards.layouts.single_002dcolumn_jsp._jspService(single_002dcolumn_jsp.java:301)   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)   at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)   at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)   at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)   at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)   at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)   at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)   at org.mortbay.jetty.servlet.Dispatcher.include(Dispatcher.java:192)   at org.apache.jasper.runtime.JspRuntimeLibrary.include(JspRuntimeLibrary.java:966)   at org.apache.jsp.jsp.dashboards.container_jsp._jspService(container_jsp.java:486)   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)   at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)   at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:362)   at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)   at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)   at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)   at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)   at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:285)   at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:126)   at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch(ServletExternalContextImpl.java:419)   at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)   at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:41)   at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:132)   at javax.faces.webapp.FacesServlet.service(FacesServlet.java:140)   at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:487)   at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1097)   at org.alfresco.web.app.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:116)   at sun.reflect.GeneratedMethodAccessor427.invoke(Unknown Source)   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:597)   at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:116)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)   at $Proxy212.doFilter(Unknown Source)   at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:82)   at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)   at org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:68)   at sun.reflect.GeneratedMethodAccessor427.invoke(Unknown Source)   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)   at java.lang.reflect.Method.invoke(Method.java:597)   at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:116)   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)   at $Proxy212.doFilter(Unknown Source)   at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:82)   at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1088)   at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:360)   at org.mortbay.jetty.security.SecurityHandler.handle(SecurityHandler.java:216)   at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:181)   at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:729)   at org.mortbay.jetty.webapp.WebAppContext.handle(WebAppContext.java:405)   at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)   at org.mortbay.jetty.handler.RequestLogHandler.handle(RequestLogHandler.java:49)   at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)   at org.mortbay.jetty.Server.handle(Server.java:324)   at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:505)   at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:843)   at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:647)   at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:211)   at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:380)   at org.mortbay.io.nio.SelectChannelEndPoint.run(SelectChannelEndPoint.java:395)   at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:488)Caused by: org.postgresql.util.PSQLException: ERROR: cannot execute UPDATE in a read-only transaction   at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)   at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)   at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)   at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)   at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:381)   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)   at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:169)   at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:22)   at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:51)   at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:29)   at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:72)   at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:43)   at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:98)   … 126 more‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[cjimenez2581]

dooman, could you solve the problem?

[granddams]

Hi,

this error was very annoying for me, i never managed to find the true cause of it or to solve it.
I suggest you to erase your previous modifications and to restart from an healthy workflow.
It's not an error on the database but from your process definition, you try to fill a variable whitch doesn't exist or something like this.
Good luck…

[itrub]

I guess, I know what is the problem. I had the same problem. The reason is that you should insert at <userTask> taskListener on create-event and  to initialize property task.priority, for example, as at standard adhoc process:
if (typeof bpm_workflowPriority != 'undefined') task.priority=bpm_workflowPriority;
After that eroor disappeared. Write, please, is this help for you.
Sincerely, Iliya