There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ProcessInstanceQueryImpl'

[rakeshdesai]

Recently we got this error:
### Error querying database. Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ModelQueryImpl'
### Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ModelQueryImpl'

The issue got resolved after restarting the service.

I see that same error was reported more than three years back here:
https://community.alfresco.com/message/786956-re-there-is-no-getter-for-property-named-limitbefore-i...

We have been using Activiti V5.15 since long & faced this error for the first time. Hence databaseType should not be an issue as discussed in above question. Also we have adequate database processes.

As question was reported more than 3 years back. Just wanted to check if anybody has faced this recently or any changes thereafter would have addressed it?

[gdharley]

How often are you experiencing this problem? Is it intermittent or a "hard" error?

If it is intermittent, it may be difficult to locate the exact cause of the error.

Do you have a full stack?

Thanks,
greg

‌

[rakeshdesai]

Hi Greg,

This is a hard to get error, came across for the first time.

The error stack is as below:

Caused by: org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ModelQueryImpl'
### Cause: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ModelQueryImpl'
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
at org.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:332)
at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:323)
at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:313)
at org.activiti.engine.impl.persistence.entity.ModelEntityManager.findModelsByQueryCriteria(ModelEntityManager.java:125)
at org.activiti.engine.impl.ModelQueryImpl.executeList(ModelQueryImpl.java:219)
at org.activiti.engine.impl.AbstractQuery.executeSingleResult(AbstractQuery.java:158)
at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:141)
at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:35)
at org.activiti.engine.impl.AbstractQuery.singleResult(AbstractQuery.java:104)
... 125 more
Caused by: org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'limitBefore' in 'class org.activiti.engine.impl.ModelQueryImpl'
at org.apache.ibatis.reflection.Reflector.getGetInvoker(Reflector.java:377)
at org.apache.ibatis.reflection.MetaClass.getGetInvoker(MetaClass.java:167)
at org.apache.ibatis.reflection.wrapper.BeanWrapper.getBeanProperty(BeanWrapper.java:149)
at org.apache.ibatis.reflection.wrapper.BeanWrapper.get(BeanWrapper.java:45)
at org.apache.ibatis.reflection.MetaObject.getValue(MetaObject.java:113)
at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextMap.get(DynamicContext.java:94)
at org.apache.ibatis.scripting.xmltags.DynamicContext$ContextAccessor.getProperty(DynamicContext.java:113)
at org.apache.ibatis.ognl.OgnlRuntime.getProperty(OgnlRuntime.java:1657)
at org.apache.ibatis.ognl.ASTProperty.getValueBody(ASTProperty.java:92)
at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:170)
at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:210)
at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:333)
at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:413)
at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:395)
at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:45)
at org.apache.ibatis.scripting.xmltags.TextSqlNode$BindingTokenParser.handleToken(TextSqlNode.java:61)
at org.apache.ibatis.parsing.GenericTokenParser.parse(GenericTokenParser.java:50)
at org.apache.ibatis.scripting.xmltags.TextSqlNode.apply(TextSqlNode.java:38)
at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:29)
at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:37)
at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:275)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:79)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
... 143 more

Thanks
Rakesh

[gdharley]

I assumed this was something that was at best intermittent.

Not sure this is something we will be able to debug without a reproduction.

This isn't an uncommon error in the MyBatis/iBatis forums.

Greg