Community

Multiple JBPM4_VARIABLE records pointing to same LOB_ and different EXECUTIONID_

reply from Jorge Ferreira in jBPM - View the full discussion

The ONLY types of variables that are stored for any given process:

 

  • org.w3c.dom.Document
  • java.util.List<String>
  • java.lang.Boolean
  • TWO custom classes that implement java.io.Serializable

 

For setting a variable value we use several API, but all from publicly exposed jBPM interfaces:

  • OpenExecution.setVariable(...);
  • ActivityExecution.setVariable(...);
  • ExecutionService.setVariable(...);

 

At the moment JBPM4_VARIABLE has several pairs (2) of records that point to the same LOB_.

 

select lob_
from jbpm4_variable
group by lob_
having count(1) > 1
order by lob_

 

 

select v.key_, v.execution_, v.lob_

from jbpm4_variable  v

where v.lob_ in (

1970117,

1970123,

1970218,

2260229,

2260232)

order by v.lob_

 

key_execution_lob_
lastProcessTaskOutcome19402411970117
executionWarnings19701161970117
xmlObject19402411970123
processIdentifier19701161970123
xmlObject19701391970218
executionErrors19702121970218
executionErrors22601972260229
executionErrors22602232260229
executionWarnings22601972260232
xmlObject22602232260232

Reply to this message by going to Community

Start a new discussion in jBPM at Community