[jbpm-issues] [JBoss JIRA] Created: (JBPM-2321) Error while fetching latest version
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