I too have been experiencing issues with this particular bug and unsure how to proceed.
I have a workflow which has an initial wait state which then traverses to a fork which then concludes in a join, followed by a transition back to the initial wait state. My workflow never terminates as such. The issue I am seeing is on the persistence side. Given that my workflow never terminates and that I need there to be only one running instance, I use a mechanism which replaces the running workflow with a newer version when one comes along. During JBoss startup, a check is made for a newer PAR version and that is then deployed as necessary. In order to keep my dbase tidy, I call the following methods in order to clear up the old instance: - cancelTimersForProcessInstance - deleteProcessInstance The problem I am now seeing is that once I have > 2000 child tokens - the deleteProcessInstance method is throwing an exception "Prepared or callable statement has more than 2000 parameter markers." Essentially this is thrown because of the following operation in deleteProcessInstance: | private static final String selectLogsForTokens = | "select pl " + | "from org.jbpm.logging.log.ProcessLog as pl " + | "where pl.token in (:tokens)"; | The IN clause contains > 2000 tokens! I also note that none of these old tokens ever get deleted!!!!? Any thoughts on what the best strategy would be to fix this? Many thanks, Andy View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3940660#3940660 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3940660 ------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
