5 Replies Latest reply on Jul 12, 2007 8:25 AM by kukeltje

problem to start a taskinstance

galvino Jul 10, 2007 9:46 AM

i am try to get tasklist of a user but i have the same error:

15:39:53,808 WARN [JDBCExceptionReporter] SQL Error: 1054, SQLState: 42S22
15:39:53,808 ERROR [JDBCExceptionReporter] Unknown column 'taskinstan0_.ISSIGNA
LING_' in 'field list'
15:39:53,808 DEBUG [JbpmContext] closing JbpmContext
15:39:53,808 DEBUG [Services] closing service 'persistence': org.jbpm.persisten
e.db.DbPersistenceService@1590164
15:39:53,808 DEBUG [DbPersistenceService] committing hibernate transaction
15:39:53,855 DEBUG [DbPersistenceService] closing hibernate session
15:39:53,855 DEBUG [Services] closing service 'authentication': org.jbpm.securi
y.authentication.DefaultAuthenticationService@13c2ac3
15:39:53,855 WARN [RequestProcessor] Unhandled Exception thrown: class org.hib
rnate.exception.SQLGrammarException
15:39:53,855 ERROR [[action]] Servlet.service() for servlet action threw except
on
org.hibernate.exception.SQLGrammarException: could not initialize a collection:
[org.jbpm.taskmgmt.exe.TaskMgmtInstance.taskInstances#9]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.
ava:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHel
er.java:43)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1926)
at org.hibernate.loader.collection.CollectionLoader.initialize(Collecti
nLoader.java:36)
at org.hibernate.persister.collection.AbstractCollectionPersister.initi
lize(AbstractCollectionPersister.java:541)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onI
itializeCollection(DefaultInitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java
1705)
at org.hibernate.collection.AbstractPersistentCollection.initialize(Abs
ractPersistentCollection.java:344)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractP
rsistentCollection.java:86)
at org.hibernate.collection.AbstractPersistentCollection.readSize(Abstr
ctPersistentCollection.java:109)
at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:12
)
at com.actions.StartProcessInstance.performAction(StartProcessInstance.
ava:52)
at com.actions.BaseAction.execute(BaseAction.java:19)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reque
tProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j
va:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11
6)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDis
atcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applic
tionDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(Application
ispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDi
patcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor
java:1085)
at org.apache.struts.action.RequestProcessor.processForwardConfig(Reque
tProcessor.java:398)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j
va:241)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11
6)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderF
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContext
alve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securi
yAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextVal
e.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.
ava:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.ja
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.jav
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndp
int.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWo
kerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Unknown column 'taskinstan0_.ISSIGNALLING_' i
'field list'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3026)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.j
va:1137)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java
1231)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuer
(WrappedPreparedStatement.java:236)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java
186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(L
ader.java:224)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)
... 47 more
15:39:53,870 ERROR [[action]] Servlet.service() for servlet action threw except
on
org.hibernate.exception.SQLGrammarException: could not initialize a collection:
[org.jbpm.taskmgmt.exe.TaskMgmtInstance.taskInstances#9]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.
ava:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHel
er.java:43)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1926)
at org.hibernate.loader.collection.CollectionLoader.initialize(Collecti
nLoader.java:36)
at org.hibernate.persister.collection.AbstractCollectionPersister.initi
lize(AbstractCollectionPersister.java:541)
at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onI
itializeCollection(DefaultInitializeCollectionEventListener.java:60)
at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java
1705)
at org.hibernate.collection.AbstractPersistentCollection.initialize(Abs
ractPersistentCollection.java:344)
at org.hibernate.collection.AbstractPersistentCollection.read(AbstractP
rsistentCollection.java:86)
at org.hibernate.collection.AbstractPersistentCollection.readSize(Abstr
ctPersistentCollection.java:109)
at org.hibernate.collection.PersistentSet.isEmpty(PersistentSet.java:12
)
at com.actions.StartProcessInstance.performAction(StartProcessInstance.
ava:52)
at com.actions.BaseAction.execute(BaseAction.java:19)
at org.apache.struts.action.RequestProcessor.processActionPerform(Reque
tProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j
va:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11
6)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDis
atcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(Applic
tionDispatcher.java:463)
at org.apache.catalina.core.ApplicationDispatcher.doForward(Application
ispatcher.java:398)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDi
patcher.java:301)
at org.apache.struts.action.RequestProcessor.doForward(RequestProcessor
java:1085)
at org.apache.struts.action.RequestProcessor.processForwardConfig(Reque
tProcessor.java:398)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.j
va:241)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:11
6)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432

at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderF
lter.java:96)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(App
icationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Application
ilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapper
alve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContext
alve.java:178)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securi
yAssociationValve.java:175)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextVal
e.java:74)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.
ava:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.
ava:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVa
ve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.ja
a:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.jav
:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.
rocessConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndp
int.java:527)
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWo
kerThread.java:112)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.sql.SQLException: Unknown column 'taskinstan0_.ISSIGNALLING_' i
'field list'
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3026)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.j
va:1137)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java
1231)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuer
(WrappedPreparedStatement.java:236)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java
186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1669)
at org.hibernate.loader.Loader.doQuery(Loader.java:662)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(L
ader.java:224)
at org.hibernate.loader.Loader.loadCollection(Loader.java:1919)
... 47 more

i do the simple execution :

jbpmcontext.getTaskList("ernie");

i dont understand this error.
firstly i thought it ISSIGNALLING field on my database,

please help me

1. Re: problem to start a taskinstance

koen.aers Jul 11, 2007 3:52 AM (in response to galvino)

Please list your version array and provide some more info on what you are trying to achieve. It looks like your client program runs against a jbpm database from another version.

Regards,
Koen
Actions
2. Re: problem to start a taskinstance

galvino Jul 11, 2007 9:56 AM (in response to galvino)

hi, thanks to response to my first post.

iam using

jbpm-3.1.4
jboss-4.0.4.GA (download with jems-installer-1.2.0.GA.jar)
mysql server 5.0

i want to do an struts application by using jbpm API.
so i set some configurations and i want to get a task list for one user i have this error.

this my workflow :

<process-definition
xmlns="" name="holiday-request">
<swimlane name="participant"></swimlane>
<swimlane name="hr"></swimlane>
<start-state name="enter request">
<task name="request entry" swimlane="participant">
<controller>
<variable name="start date " access="read,write,required"></variable>
<variable name="duration" access="read,write,required"></variable>
</controller>
</task>
<transition name="" to="evaluate request"></transition>
</start-state>
<task-node name="evaluate request">
<task name="request evaluation" swimlane="hr">
<controller>
<variable name="start date " access="read"></variable>
<variable name="duration" access="read"></variable>
<variable name="info" access="read"></variable>
<variable name="decision"></variable>
</controller>
</task>
<transition name="more info need" to="give additional info"></transition>
<transition name="approve/disapprove" to="end"></transition>
</task-node>
<task-node name="give additional info">
<task name="additional info entry" swimlane="participant">
<controller>
<variable name="start date" access="read"></variable>
<variable name="duration" access="read"></variable>
<variable name="info"></variable>
</controller>
</task>
<transition name="" to="evaluate request"></transition>
</task-node>
<end-state name="end"></end-state>
</process-definition>

this is that i do:

protected ActionForward performAction(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws Exception {

System.out.println("\n................StartProcessInstance.............................\n");
JbpmContext jbpmContext=null;
GraphSession graphSession=null;
TaskMgmtSession taskMgmtSession=null;
ArrayList<String> tasks;

jbpmContext=this.getJbpmContext(request).getJbpmConfiguration().getCurrentJbpmContext();
graphSession=jbpmContext.getGraphSession();
taskMgmtSession=jbpmContext.getTaskMgmtSession();

try{

ProcessDefinition processDefinition = graphSession.loadProcessDefinition(2);

// create a new process instance to run
ProcessInstance processInstance = new ProcessInstance(processDefinition);

// create a new taskinstance for the start task
TaskInstance taskInstance = processInstance.getTaskMgmtInstance().createStartTaskInstance();
taskInstance.setActorId(jbpmContext.getActorId());

// Save the process instance along with the task instance
jbpmContext.save(processInstance);

this.setJbpmContext(request, jbpmContext);

}catch(JbpmException e){
e.printStackTrace();
}finally{
if(this.getJbpmContext(request) != null) {
try {
this.getJbpmContext(request).close();
} catch (JbpmException e) {
e.printStackTrace();
}
}
}
return mapping.findForward("success");
}
Actions
3. Re: problem to start a taskinstance

kukeltje Jul 11, 2007 12:32 PM (in response to galvino)

what error?
Actions
4. Re: problem to start a taskinstance

galvino Jul 12, 2007 5:19 AM (in response to galvino)

i gave you error in the first post
Actions
5. Re: problem to start a taskinstance

kukeltje Jul 12, 2007 8:25 AM (in response to galvino)

hmmm sorry... i missed that :-( and btw, please repost the workflow and put it in code tags
Actions

Go to original post