Error while fetching latest version ------------------------------------ Key: JBPM-2321 URL: https://jira.jboss.org/jira/browse/JBPM-2321 Project: JBoss jBPM Issue Type: Bug Security Level: Public (Everyone can see) Affects Versions: jBPM 4.0.CR1 Reporter: sri r The query generated for the below statement results in two records causing below error. Basically i'm trying to check the latest version deployed so as to proceed with deploying a newer version of process definition xml. repositorySession .createProcessDefinitionQuery() .processDefinitionKey(key) .orderDesc(ProcessDefinitionQuery.PROPERTY_VERSION) .page(0, 1) .uniqueResult(); Caused by: org.jbpm.api.JbpmException: result not unique: 2 at org.jbpm.pvm.internal.query.AbstractQuery.untypedUniqueResult(AbstractQuery.java:81) at org.jbpm.pvm.internal.query.ProcessDefinitionQueryImpl.uniqueResult(ProcessDefinitionQueryImpl.java:151) Queries: Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from public.JBPM4_DEPLOYMENT deployment0_, public.JBPM4_DEPLOYPROP deployment1_, public.JBPM4_DEPLOYPROP deployment2_, public.JBPM4_DEPLOYPROP deployment3_ where deployment0_.STATE_<>'suspended' and deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.OBJNAME_=? Hibernate: select deployment0_.DBID_ as DBID1_10_0_, deployment0_.NAME_ as NAME2_10_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_10_0_, deployment0_.STATE_ as STATE4_10_0_ from public.JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=? Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT7_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME8_1_, resources0_.DBID_ as DBID1_3_0_, resources0_.DBVERSION_ as DBVERSION2_3_0_, resources0_.BLOB_VALUE_ as BLOB3_3_0_, resources0_.BINARY_VALUE_ as BINARY4_3_0_, resources0_.CLOB_VALUE_ as CLOB5_3_0_, resources0_.TEXT_VALUE_ as TEXT6_3_0_ from public.JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=? Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_11_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_11_0_, objectprop0_.OBJNAME_ as OBJNAME3_11_0_, objectprop0_.KEY_ as KEY4_11_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_11_0_, objectprop0_.LONGVAL_ as LONGVAL6_11_0_ from public.JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=? Hibernate: select deployment0_.DBID_ as DBID1_10_0_, deployment0_.NAME_ as NAME2_10_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_10_0_, deployment0_.STATE_ as STATE4_10_0_ from public.JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=? Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT7_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME8_1_, resources0_.DBID_ as DBID1_3_0_, resources0_.DBVERSION_ as DBVERSION2_3_0_, resources0_.BLOB_VALUE_ as BLOB3_3_0_, resources0_.BINARY_VALUE_ as BINARY4_3_0_, resources0_.CLOB_VALUE_ as CLOB5_3_0_, resources0_.TEXT_VALUE_ as TEXT6_3_0_ from public.JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=? Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_11_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_11_0_, objectprop0_.OBJNAME_ as OBJNAME3_11_0_, objectprop0_.KEY_ as KEY4_11_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_11_0_, objectprop0_.LONGVAL_ as LONGVAL6_11_0_ from public.JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=? -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira