topic Re: Exception when process is about to end in Alfresco Archive

Exception when process is about to end

ruben1 — Thu, 29 Sep 2011 14:01:32 GMT

Hi,I've a process doing some things . When I complete the last task of this process I get the following exceptionEVERE: Error while closing command contextorg.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements

Re: Exception when process is about to end

ruben1 — Thu, 29 Sep 2011 14:14:18 GMT

PS: Is this core related and if so, how does this correlate with 'rock solid'?
PPS: Activiti 5.7

Re: Exception when process is about to end

ronald_van_kuij — Thu, 29 Sep 2011 14:32:55 GMT

I assume you have a small unit test and process definition that demonstrates this problem in a clean, not customized, Activiti using an officially supported database? The reason I ask this is that you seem pretty sure it is not your fault 😉

Re: Exception when process is about to end

ruben1 — Thu, 29 Sep 2011 15:51:16 GMT

Hi Ronald,

nope, it's /it's not standard activiti (pick one, I haven't found out what the standard might be). It's like that:


  <bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource">
    <property name="driverClass" value="org.postgresql.Driver" />
    <property name="url" value="jdbc:smileytongue:ostgresql://localhost:5432/activiti" />
    <property name="username" value="activiti" />
    <property name="password" value="activiti" />
  </bean>

  <bean id="processEngineConfiguration"
        class="my.custom.JSONFormRenderingProcessEngineConfiguration">
    <property name="dataSource" ref="dataSource" />
    <property name="transactionManager" ref="transactionManager" />
    <property name="databaseSchemaUpdate" value="true" />
    <property name="jobExecutorActivate" value="false" />
    <property name="customFormEngines" ref="customFormEngines" />
  </bean>
  
  <util:list id="customFormEngines">
      <bean class="my.custom.activiti.JSONFormRenderingEngine"/>
  </util:list>
  
  <bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean">
    <property name="processEngineConfiguration" ref="processEngineConfiguration" />
  </bean>

'JSONFormRenderingProcessEngineConfiguration' extends 'SpringProcessEngineConfiguration' and sets 'JSONFormRenderingEngine' as the default form renderer.

And I can reproduce it with a simple process 'Start' -> 'Script Task' setting a process var -> 'End'. The Exception occurs.

Greetz,
Ruben

Re: Exception when process is about to end

ruben1 — Tue, 04 Oct 2011 06:24:05 GMT

Hi,

I don't know why, but Ibatis does intitialize it's Configuration differently when started in the demo context. I changed the config of the demo's activiti-explorer to match my postgres. No Exception when executing my process.

I changed the configuration of my ProcessEngine to match that of the demo's ProcessEngine:


<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:smileytongue:="http://www.springframework.org/schema/p"
    xmlns:util="http://www.springframework.org/schema/util"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.0.xsd
                        http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-3.0.xsd">

  <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
    <property name="driverClassName" value="org.postgresql.Driver" />
    <property name="url" value="jdbc:smileytongue:ostgresql://localhost:5432/activiti" />
    <property name="username" value="activiti" />
    <property name="password" value="activiti" />
  </bean>

  <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource" />
  </bean>

  <bean id="processEngineConfiguration"
        class="org.activiti.spring.SpringProcessEngineConfiguration">
    <property name="dataSource" ref="dataSource" />
    <property name="transactionManager" ref="transactionManager" />
    <property name="databaseSchemaUpdate" value="true" />
    <property name="jobExecutorActivate" value="true" />
  </bean>
  
  <bean id="processEngine" class="org.activiti.spring.ProcessEngineFactoryBean">
    <property name="processEngineConfiguration" ref="processEngineConfiguration" />
  </bean>

<!– Activiti Service Beans –>
[…]
</beans>

No success. Same Exception occurs.

Maybe I do something wrong. At least something is different. The demo calls ProcessEngines.getDefaultProcessEngine() twice on bootstrapping cause of the IdentityService in the applicationContext.xml.

But how can I configure the Ibatis Configuration? What magic allows a successful lookup of the key 'org.activiti.persistence.selectJobCountByQueryCriteria' when running the demo but fails in my environment?

And why is this key in JobManager prefixed with 'org.activiti.persistence.' when no such id is in any of the xml files referenced by 'org/activiti/db/mapping/mappings.xml'? And most of the other classes using the Ibatis mappings have no prefix? Only JobManager.java and GetPropertiesCmd.java have it (and not consistently).

Any clues? Anyone? I don't.

tia,
Ruben

Re: Exception when process is about to end

ruben1 — Tue, 04 Oct 2011 12:37:36 GMT

Some more infos:

It seems to me, that this is a bug since activiti 5.5 (Upgrade to iBatis 3.0.4).

In revision 2566 the config xmls of ibatis are still under 'src/main/resources/db/ibatis/'

job.mapping.xml:


<mapper namespace="org.activiti.persistence">
[…]

In revision 2602 (ibatis config xmls are now under 'src/main/resources/db/mapping/entity/') job.mapping.xml has been renamed/moved.

Job.xml:


<mapper namespace="org.activiti.engine.impl.persistence.entity.JobEntity">
[…]

This perfectly explains to me why the lookup to 'org.activiti.persistence.selectJobCountByQueryCriteria' fails. Though I still don't know why it succeeds in the demo.

I fixed it for myself by stripping 'org.activiti.persistence.' from the strings in JobManager.java and GetPropertiesCmd.java.
This should be the same and expected behavior (that is: if there is no ambiguity e.g. another '*selectJobCountByQueryCriteria' beeing registered as a MappedStatement). Then iBatis will throw an Exception at me.

Would be great if you could agree with me in that this is a bug and fix this - or tell me that I'm "on the woodway".

After what I've seen in the code this is a refactoring issue.

@Ronald: 'It's not my fault!' - I can only repeat myself. True, it does not happen in the demo setup (which can hardly be seen as THE way to use activiti). And even if you don't officially support Postgresql I don't see any database related issues here. Yeah, yeah it's iBatis and thats database abstraction/management/handling… . But the configuration of iBatis itself should not differ from database to database nor should it be database dependent. At least not if it comes to registering MappedStatements which do not reflect different dialects.

So: it's not my fault! And how does this correlate to rock solid? And do correct me if I'm wrong, mistaken, arrogant, insulting or whatever does legitimately misplease someone.

Ruben

Re: Exception when process is about to end

frederikherema1 — Wed, 05 Oct 2011 06:22:16 GMT

Indeed an issue… However, out unit-tests don't fail even though the methods are used. So beats me why myBatis mapping can find the correct statement.

Will fix on trunk, JIT for the 5.8 release…

Re: Exception when process is about to end

rubensava — Thu, 13 Oct 2011 07:09:03 GMT

Hi all,

i have the same issue also yesterday.

SEVERE: Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for org.activiti.persistence.selectJobByQueryCriteria
### Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for org.activiti.persistence.selectJobByQueryCriteria

And then I try to run from activiti-explorer interface, and it works just fine.

So I copy all of the lib in activiti-explorer-5.7\WebContent\WEB-INF\lib to my workspace lib folder.
BAM!!! And the error gone.