org.camunda.bpm.engine.test.api.repository.ProcessApplicationDeploymentTest FAILURE

[Frank Langelage]

Spent some more time to get current Camunda running with IBM Informix Database 12.10.

The first failing test of 5 alltogether is org.camunda.bpm.engine.test.api.repository.ProcessApplicationDeploymentTest. See below. Others might have similar causes.
Failure only related to database, not to platform. These tests succeed when running against H2, Oracle 12c and MS SQL Server 2012 independent if run on Windows 7 or Solaris 10.

From what I understand, this must be related to either selectProcessDefinitionsByQueryCriteria or selectProcessDefinitionCountByQueryCriteria not seeing the already deployed process.
Now I'm stuck. How can I find out what the problem is?
It would be very very helpful to see the final query which is send to the database including the content of the different variable used. There are many if's in this statement, conditionally adding joins and conditions.
And to play around with this query then it would be necessary to know which records were inserted into the different database tables at this point in time in the test run.
How can I get access to these information?
Any help and hints greatly appreciated.

Thanks, Frank
---------------------------------
Running org.camunda.bpm.engine.test.api.repository.ProcessApplicationDeploymentTest
Tests run: 6, Failures: 1, Errors: 1, Skipped: 0, Time elapsed: 7.029 sec <<< FAILURE! - in org.camunda.bpm.engine.test.api.repository.ProcessApplicationDeploymentTest
testProcessApplicationDeploymentNoChanges(org.camunda.bpm.engine.test.api.repository.ProcessApplicationDeploymentTest)  Time elapsed: 1.763 sec  <<< ERROR!
org.camunda.bpm.engine.ProcessEngineException: Query return 2 results instead of max 1
    at org.camunda.bpm.engine.impl.AbstractQuery.executeSingleResult(AbstractQuery.java:161)
    at org.camunda.bpm.engine.impl.AbstractQuery.execute(AbstractQuery.java:140)
    at org.camunda.bpm.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
    at org.camunda.bpm.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:97)
    at org.camunda.bpm.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:38)
    at org.camunda.bpm.engine.impl.AbstractQuery.singleResult(AbstractQuery.java:103)
    at org.camunda.bpm.engine.test.api.repository.ProcessApplicationDeploymentTest.testProcessApplicationDeploymentNoChanges(ProcessApplicationDeploymentTest.java:78)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at junit.framework.TestCase.runTest(TestCase.java:176)
    at org.camunda.bpm.engine.impl.test.PvmTestCase.runTest(PvmTestCase.java:85)
    at junit.framework.TestCase.runBare(TestCase.java:141)
    at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:91)
    at junit.framework.TestResult$1.protect(TestResult.java:122)
    at junit.framework.TestResult.runProtected(TestResult.java:142)
    at junit.framework.TestResult.run(TestResult.java:125)
    at junit.framework.TestCase.run(TestCase.java:129)
    at junit.framework.TestSuite.runTest(TestSuite.java:255)
    at junit.framework.TestSuite.run(TestSuite.java:250)
    at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
    at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
    at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
    at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
    at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
    at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
    at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)

testPartialChangesDeployChangedOnly(org.camunda.bpm.engine.test.api.repository.ProcessApplicationDeploymentTest)  Time elapsed: 1.845 sec  <<< FAILURE!
junit.framework.AssertionFailedError: expected:<3> but was:<4>
    at junit.framework.Assert.fail(Assert.java:57)
    at junit.framework.Assert.failNotEquals(Assert.java:329)
    at junit.framework.Assert.assertEquals(Assert.java:78)
    at junit.framework.Assert.assertEquals(Assert.java:159)
    at junit.framework.Assert.assertEquals(Assert.java:166)
    at junit.framework.TestCase.assertEquals(TestCase.java:324)
    at org.camunda.bpm.engine.test.api.repository.ProcessApplicationDeploymentTest.testPartialChangesDeployChangedOnly(ProcessApplicationDeploymentTest.java:170)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:606)
    at junit.framework.TestCase.runTest(TestCase.java:176)
    at org.camunda.bpm.engine.impl.test.PvmTestCase.runTest(PvmTestCase.java:85)
    at junit.framework.TestCase.runBare(TestCase.java:141)
    at org.camunda.bpm.engine.impl.test.AbstractProcessEngineTestCase.runBare(AbstractProcessEngineTestCase.java:91)
    at junit.framework.TestResult$1.protect(TestResult.java:122)
    at junit.framework.TestResult.runProtected(TestResult.java:142)
    at junit.framework.TestResult.run(TestResult.java:125)
    at junit.framework.TestCase.run(TestCase.java:129)
    at junit.framework.TestSuite.runTest(TestSuite.java:255)
    at junit.framework.TestSuite.run(TestSuite.java:250)
    at org.junit.internal.runners.JUnit38ClassRunner.run(JUnit38ClassRunner.java:84)
    at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:264)
    at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:153)
    at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:124)
    at org.apache.maven.surefire.booter.ForkedBooter.invokeProviderInSameClassLoader(ForkedBooter.java:200)
    at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:153)
    at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:103)

[Sebastian Menski]

Hi Frank,

I think you can configure MyBatis to log the final query. Maybe the MyBatis logging documentation helps you.

http://mybatis.github.io/mybatis-3/logging.html

Cheers,

Sebastian