[jBPM Development] - SessionInfo and ProcessInstanceInfo tables are not getting updated when starting the process using JPAKnoweldgeService
7:02 a.m.
uvijayreddy657 [http://community.jboss.org/people/uvijayreddy657] created the discussion
"SessionInfo and ProcessInstanceInfo tables are not getting updated when starting the
process using JPAKnoweldgeService"
To view the discussion, visit: http://community.jboss.org/message/626224#626224
--------------------------------------------------------------
I am able to start the process and also able to store the TASK details. But SessionInfo,
ProcessInstanceInfo and WorkItemInfo tables are not getting updated.
Queries are being generated only to insert data only into TASK and
PEOPLEASSIGNMENTS_POTOWNERS and PEOPLEASSIGNMENTS_BAS..etc tables. But not generating
insert statements to SessionInfo and ProcessInstanceInfo tables.
Do we need to do any extra configurations or add extra statements to the code?
Please somebody help. I am strucked with it from past 1 week.
Here is the piece of code which I am using to start the process.
kbase = kbuilder.newKnowledgeBase();
Properties properties = new Properties();
properties.put("drools.processInstanceManagerFactory",
"org.jbpm.persistence.processinstance.JPAProcessInstanceManagerFactory") ;
properties.put("drools.processSignalManagerFactory","org.jbpm.persistence.processinstance.JPASignalManagerFactory");
KnowledgeSessionConfiguration config =
KnowledgeBaseFactory.newKnowledgeSessionConfiguration(properties);
Environment env = KnowledgeBaseFactory.newEnvironment();
env.set(EnvironmentName.ENTITY_MANAGER_FACTORY, emf);
env.set(EnvironmentName.GLOBALS, new MapGlobalResolver());
userTransaction = TransactionManagerServices.getTransactionManager();
env.set(EnvironmentName.TRANSACTION_MANAGER, userTransaction);
env.set(EnvironmentName.TRANSACTION, userTransaction);
System.out.println("Loading session data ...");
if (ksession != null && Integer.valueOf(ksession.getId()) != null) {
try {
ksession = JPAKnowledgeService.loadStatefulKnowledgeSession(ksession.getId(),
kbase, config,env);
}catch (RuntimeException e) {
if (e instanceof IllegalStateException) {
Throwable cause = ((IllegalStateException) e).getCause();
if (cause instanceof InvocationTargetException) {
cause = cause.getCause();
if (cause != null && ("Could not find session data
for id "+ksession.getId()).equals(cause.getMessage())) {
System.out.println("Creating new session data
...");
ksession =
JPAKnowledgeService.newStatefulKnowledgeSession(kbase, config, env);
} else {
System.err.println("Error loading session data: " +
cause);
throw e;
}
} else {
System.err.println("Error loading session data:" +
cause);
throw e;
}
} else {
System.err.println("Error loading session data: " +
e.getMessage());
throw e;
}
}
} else {
ksession = JPAKnowledgeService.newStatefulKnowledgeSession(kbase,config,
env);
}
new WorkingMemoryDbLogger(ksession);
ksession.getWorkItemManager().registerWorkItemHandler("Human Task",new
CHumanTaskHandler());
// start the transaction
UserTransaction ut = getUserTransaction();
ut.begin();
ksession.startProcess(processId, params);
// commit the transaction
ut.commit();
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/626224#626224]
Start a new discussion in jBPM Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
2:29 a.m.
New subject: [jBPM Development] - Re: SessionInfo and ProcessInstanceInfo tables are not getting updated when starting the process using JPAKnoweldgeService
Francesco Pietrobelli [http://community.jboss.org/people/francesco.pietrobelli] created
the discussion
"Re: SessionInfo and ProcessInstanceInfo tables are not getting updated when starting
the process using JPAKnoweldgeService"
To view the discussion, visit: http://community.jboss.org/message/626612#626612
--------------------------------------------------------------
have you try to dispose the session before commit the transaction?
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/626612#626612]
Start a new discussion in jBPM Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
3:01 a.m.
New subject: [jBPM Development] - Re: SessionInfo and ProcessInstanceInfo tables are not getting updated when starting the process using JPAKnoweldgeService
uvijayreddy657 [http://community.jboss.org/people/uvijayreddy657] created the discussion
"Re: SessionInfo and ProcessInstanceInfo tables are not getting updated when starting
the process using JPAKnoweldgeService"
To view the discussion, visit: http://community.jboss.org/message/626622#626622
--------------------------------------------------------------
I added kession.dispose() statement. Still it is not persisting data into
ProcessInstanceInfo and SessionInfo tables.
Like this:
UserTransaction ut = getUserTransaction();
##ut.begin();
ksession.startProcess(processId, params);
++ksession.dispose();
++
// commit the transaction
ut.commit();
At the time of startProcess method invocation hibernate is generating only following
queries
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select user_.id from OrganizationalEntity user_ where user_.id=?
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into Task (allowedToDelegate, taskInitiator_id, priority,
activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType,
documentContentId, documentType, expirationTime, faultAccessType, faultContentId,
faultName, faultType, outputAccessType, outputContentId, outputType, parentId,
previousStatus, processInstanceId, skipable, status, workItemId, id) values (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into I18NText (language, text, id) values (?, ?, ?)
Hibernate: insert into Content (content, id) values (?, ?)
Hibernate: update Task set allowedToDelegate=?, taskInitiator_id=?, priority=?,
activationTime=?, actualOwner_id=?, createdBy_id=?, createdOn=?, documentAccessType=?,
documentContentId=?, documentType=?, expirationTime=?, faultAccessType=?,
faultContentId=?, faultName=?, faultType=?, outputAccessType=?, outputContentId=?,
outputType=?, parentId=?, previousStatus=?, processInstanceId=?, skipable=?, status=?,
workItemId=? where id=?
Hibernate: update I18NText set Task_Names_Id=? where id=?
Hibernate: insert into PeopleAssignments_BAs (task_id, entity_id) values (?, ?)
Hibernate: insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?)
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/626622#626622]
Start a new discussion in jBPM Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
7:28 a.m.
New subject: [jBPM Development] - Re: SessionInfo and ProcessInstanceInfo tables are not getting updated when starting the process using JPAKnoweldgeService
Mauricio Salatino [http://community.jboss.org/people/salaboy21] created the discussion
"Re: SessionInfo and ProcessInstanceInfo tables are not getting updated when starting
the process using JPAKnoweldgeService"
To view the discussion, visit: http://community.jboss.org/message/627187#627187
--------------------------------------------------------------
Is your process starting and finishing after the startProcess method call? If your process
is ended there will not be anything to persist in the ProcessInstanceInfo table, but you
should get something inside SessionInfo. Can you share the logs of your execution? You can
attach the KnowledgeRuntimeLoggerFactory.newConsoleLogger(ksession); to see what is going
on in the session.
Cheers
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/627187#627187]
Start a new discussion in jBPM Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
2:43 a.m.
New subject: [jBPM Development] - Re: SessionInfo and ProcessInstanceInfo tables are not getting updated when starting the process using JPAKnoweldgeService
uvijayreddy657 [http://community.jboss.org/people/uvijayreddy657] created the discussion
"Re: SessionInfo and ProcessInstanceInfo tables are not getting updated when starting
the process using JPAKnoweldgeService"
To view the discussion, visit: http://community.jboss.org/message/627392#627392
--------------------------------------------------------------
Thanks for the reply :)
*This is the ConsoleLogger stacktrace when I am starting the process*
-------------> Start process------>SDSProgramme
Loading session data ...
Hibernate: select sessioninf0_.id as id0_0_, sessioninf0_.lastModificationDate as
lastModi2_0_0_, sessioninf0_.rulesByteArray as rulesByt3_0_0_, sessioninf0_.startDate as
startDate0_0_, sessioninf0_.OPTLOCK as OPTLOCK0_0_ from SessionInfo sessioninf0_ where
sessioninf0_.id=?
Creating new session data ...
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
BEFORE RULEFLOW STARTED process:SDSProgramme[id=SDSProgramme]
BEFORE PROCESS NODE TRIGGERED node:Start[id=1] process:SDSProgramme[id=SDSProgramme]
BEFORE PROCESS NODE EXITED node:Start[id=1] process:SDSProgramme[id=SDSProgramme]
BEFORE PROCESS NODE TRIGGERED node:FormsDesigner[id=2]
process:SDSProgramme[id=SDSProgramme]
Hibernate: select hibernate_sequence.nextval from dual
ActorId
TaskName
379
In Human Task Handler.... :)
AFTER PROCESS NODE TRIGGERED node:FormsDesigner[id=2]
process:SDSProgramme[id=SDSProgramme]
AFTER PROCESS NODE TRIGGERED node:Start[id=1] process:SDSProgramme[id=SDSProgramme]
AFTER PROCESS NODE TRIGGERED node:Start[id=1] process:SDSProgramme[id=SDSProgramme]
AFTER RULEFLOW STARTED process:SDSProgramme[id=SDSProgramme]
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select user_.id from OrganizationalEntity user_ where user_.id=?
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: select hibernate_sequence.nextval from dual
Hibernate: insert into Task (allowedToDelegate, taskInitiator_id, priority,
activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType,
documentContentId, documentType, expirationTime, faultAccessType, faultContentId,
faultName, faultType, outputAccessType, outputContentId, outputType, parentId,
previousStatus, processInstanceId, skipable, status, workItemId, id) values (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into I18NText (language, text, id) values (?, ?, ?)
Hibernate: insert into Content (content, id) values (?, ?)
Hibernate: update Task set allowedToDelegate=?, taskInitiator_id=?, priority=?,
activationTime=?, actualOwner_id=?, createdBy_id=?, createdOn=?, documentAccessType=?,
documentContentId=?, documentType=?, expirationTime=?, faultAccessType=?,
faultContentId=?, faultName=?, faultType=?, outputAccessType=?, outputContentId=?,
outputType=?, parentId=?, previousStatus=?, processInstanceId=?, skipable=?, status=?,
workItemId=? where id=?
Hibernate: update I18NText set Task_Names_Id=? where id=?
Hibernate: insert into PeopleAssignments_BAs (task_id, entity_id) values (?, ?)
Hibernate: insert into PeopleAssignments_PotOwners (task_id, entity_id) values (?, ?)
SDSProgramme - Process name
FormsDesigner - First Human Task Node in the Workflow
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/627392#627392]
Start a new discussion in jBPM Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]
5309
days inactive
5316
days old
jboss-dev-forums@lists.jboss.org
4 comments
3 participants
participants (3)
-
Francesco Pietrobelli -
Mauricio Salatino
-
uvijayreddy657