nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Problem calling historyService.createHistoricDetailQuery()

wolpert

Folks-

Using activiti 5.4, I'm getting an error when I try to generate a createHistoricDetailQuery() request. Specific code calling is this:

historyService.createHistoricDetailQuery().activityInstanceId(instance.getId()).orderByTime().desc().list()

though I've tried different ways to call it, all with the same response. Any clues to guide me?

Exception trace is below:

org.codehaus.groovy.grails.web.pages.exceptions.GroovyPagesException: Error evaluating expression [historyService.createHistoricDetailQuery().activityInstanceId(instance.getId()).orderByTime().desc().list()] on line [114]: 
### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for org.activiti.persistence.selectByteArrayById_postgres
### The error may involve org.activiti.persistence.selectHistoricDetailsByQueryCriteria_postgres-Inline
### The error occurred while setting parameters
### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for org.activiti.persistence.selectByteArrayById_postgres

   at mnt_Fast_wolpert_repo_PhaseThree_code_nuke_grails_app_views_processInstance_show_gsp$_run_closure2_closure40.doCall(mnt_Fast_wolpert_repo_PhaseThree_code_nuke_grails_app_views_processInstance_show_gsp:105)

   at mnt_Fast_wolpert_repo_PhaseThree_code_nuke_grails_app_views_processInstance_show_gsp$_run_closure2.doCall(mnt_Fast_wolpert_repo_PhaseThree_code_nuke_grails_app_views_processInstance_show_gsp:83)

   at mnt_Fast_wolpert_repo_PhaseThree_code_nuke_grails_app_views_processInstance_show_gsp$_run_closure2.doCall(mnt_Fast_wolpert_repo_PhaseThree_code_nuke_grails_app_views_processInstance_show_gsp)

   at mnt_Fast_wolpert_repo_PhaseThree_code_nuke_grails_app_views_processInstance_show_gsp.run(mnt_Fast_wolpert_repo_PhaseThree_code_nuke_grails_app_views_processInstance_show_gsp:144)

   at java.lang.Thread.run(Thread.java:662)

Caused by: org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for org.activiti.persistence.selectByteArrayById_postgres
### The error may involve org.activiti.persistence.selectHistoricDetailsByQueryCriteria_postgres-Inline
### The error occurred while setting parameters
### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for org.activiti.persistence.selectByteArrayById_postgres

   at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:8)

   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:61)

   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:53)

   at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:171)

   at org.activiti.engine.impl.db.DbHistorySession.findHistoricDetailsByQueryCriteria(DbHistorySession.java:113)

   at org.activiti.engine.impl.HistoricDetailQueryImpl.executeList(HistoricDetailQueryImpl.java:82)

   at org.activiti.engine.impl.AbstractQuery.execute(AbstractQuery.java:126)

   at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)

   at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)

   at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:42)

   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.activiti.engine.query.Query$list.call(Unknown Source)

   at mnt_Fast_wolpert_repo_PhaseThree_code_nuke_grails_app_views_processInstance_show_gsp$_run_closure2_closure40_closure55.doCall(mnt_Fast_wolpert_repo_PhaseThree_code_nuke_grails_app_views_processInstance_show_gsp:105)

   … 5 more

Caused by: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for org.activiti.persistence.selectByteArrayById_postgres

   at org.apache.ibatis.session.Configuration$StrictMap.get(Configuration.java:462)

   at org.apache.ibatis.session.Configuration.getMappedStatement(Configuration.java:349)

   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getNestedQueryMappingValue(FastResultSetHandler.java:343)

   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getPropertyMappingValue(FastResultSetHandler.java:235)

   at org.apache.ibatis.executor.resultset.FastResultSetHandler.applyPropertyMappings(FastResultSetHandler.java:221)

   at org.apache.ibatis.executor.resultset.FastResultSetHandler.getRowValue(FastResultSetHandler.java:196)

   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleRowValues(FastResultSetHandler.java:145)

   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSet(FastResultSetHandler.java:121)

   at org.apache.ibatis.executor.resultset.FastResultSetHandler.handleResultSets(FastResultSetHandler.java:98)

   at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:40)

   at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:55)

   at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:41)

   at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:94)

   at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:72)

   at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:59)

   … 18 more
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Find more posts tagged with

Comments

jbarrez

Are you using the out of the box Activiti. More specifically, are you using a different version of MyBatis?

wolpert

Its stock activiti, but via the grails-activiti-plugin. It should be the same version of MyBatis that ships with activiti 5.4.

jbarrez

We have a test suite, which would certainly have catched this error.
Any chance you can retry it on a stock activiti without Grails?

wolpert

The grails plugin uses activiti-engine-5.4.jar and mybatis-3.0.1.jar… is this the correct version?

wolpert

I can verify that the grails activiti plugin works fine. Specifically, using the 5.4 version of the grails activiti plugin and the sample vacation app, adding the historyDetailQuery() usage doesn't cause the same problem. So its probably something I'm doing…

But what could I do that causes this error? What should I look for?

wolpert

One question on the test case… does it run for each database supported? I.E., postgres in my case?

wolpert

(Sorry for writing so many separate posts)

I can't find the test case you have that executes createHistoricDetailQuery() with live data. Can you point it out to me?

limcheekin

(Sorry for writing so many separate posts)

I can't find the test case you have that executes createHistoricDetailQuery() with live data. Can you point it out to me?

Hi Ned,

Please look into test cases shipped with Activiti 5.4 distribution instead activiti examples in the grails plugin. Sorry to tell you that I didn't upgrade the activiti examples to 5.4 due to time constraints.

Best regards,
Chee Kin

wolpert

Actually, I did do that. I couldn't find any example that called createHistoricDetailQuery() in the svn repo here:

http://svn.codehaus.org/activiti/activiti/tags/activiti-5.4/modules/activiti-engine/src/test/java/org/activiti/engine/test/history/

I may have missed it, so I figure I'd ask… but searching for Detail or detail comes up blank…so it looks like its not tested. I'll download the whole src and give it a grep…

wolpert

Found it…

http://svn.codehaus.org/activiti/activiti/tags/activiti-5.4/modules/activiti-engine/src/test/java/org/activiti/standalone/history/FullHistoryTest.java

So I'm not doing anything different… still could use pointers for where to look.

jbarrez

All our test cases run on all the databases we support, hence why I'm so certain.

The error is really strange - as the mapped statement has nothing to do with your query … I'm actually puzzled