Created attachment 759106 [details] jenkins log Many jbpm-human-task-core tests fail on oracle11gR2 due to: ORA-00932: inconsistent datatypes: expected - got CLOB This happened on 2013-06-08 and the same error occurred in 65 other tests. Whole stack trace attached.
I don't know how to reproduce the issue. Can you make sure that you have the correct Oracle Driver for Java? and also if you can help us to identify which are the fields causing the issue, that will be much appreciated.
Yes, I am sure that I have correct Oracle driver, because other jBPM modules besides human-task one work with the same driver fine, see the whole db matrix: https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/Drools%20jBPM/view/All/job/jbpm-persistence-db-matrix/ Have you looked at the attached Jenkins log and analysed it? I am sorry, I forgot to attach the link to Jenkins job I added only the logs, but for analysis that could be enough. So now you can analyse through the failed tests directly on Jenkins: https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/Drools%20jBPM/view/All/job/jbpm-persistence-db-matrix/DATABASE=oracle11gR2,MODULES=jbpm-human-task%2Fjbpm-human-task-core,jdk=java16_default,label=RHEL_any/ To reproduce the problem you can either manually configure your test suite to use oracle11gR2 or you can use the job https://jenkins.mw.lab.eng.bos.redhat.com/hudson/view/Drools%20jBPM/view/All/job/droolsjbpm-persistence-db-single/ to reproduce the problem. You can also use its Groovy configuration file to setup the Jenkins environment on local computer. To run Groovy configuration scripts for Jenkins locally use help of this document: https://docspace.corp.redhat.com/docs/DOC-120911 Or ping me on IRC so we can discuss the result of your analysis. Please, do not ignore the database bugs by setting the to MODIFIED without fixing them.
This issue has been fixed on 6.0.x product branch. (QE does not have product build of binaries to check against. Cannot set verified, because it now requires target milestone of the fix.)
Verified.