AnsweredAssumed Answered

What is the length limit of flow name ?

Question asked by aparneshgaurav on Aug 10, 2012
Latest reply on Aug 14, 2012 by aparneshgaurav
What is the length limit of flow name ?

I am getting this exception , is this due to the long length of my flow name ? ex : AccountSummary ?

## Error updating database.  Cause: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000)
### The error may involve org.activiti.engine.impl.persistence.entity.VariableInstanceEntity.insertVariableInstance-Inline
### The error occurred while setting parameters
### Cause: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000)
                at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:120)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:107)
                at org.activiti.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:437)
                at org.activiti.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:347)
                at org.activiti.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:149)
                at org.activiti.engine.impl.interceptor.CommandContext.close(CommandContext.java:105)
                at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:49)
                at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
                at org.activiti.engine.impl.RuntimeServiceImpl.startProcessInstanceByKey(RuntimeServiceImpl.java:46)
                at com.activitibpm.common.CronJob.execute(CronJob.java:26)
                at org.quartz.core.JobRunShell.run(JobRunShell.java:203)
                at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520)
Caused by: org.postgresql.util.PSQLException: ERROR: value too long for type character varying(4000)
                at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2101)
                at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1834)
                at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
                at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:510)
                at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:386)
                at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:379)
                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:75)
                at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:43)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:118)
                … 11 more

Outcomes