a_nat [http://community.jboss.org/people/a_nat] created the discussion "Re: jbpm5 process instance persistence" To view the discussion, visit: http://community.jboss.org/message/608070#608070 -------------------------------------------------------------- When I try to complete the tasks, they get completed and they also complete the process instance, but my question is why aren't they being displyed in the process overview / execution history pages. The process is in a pending state and the process instance details are persisted in the db, but why aren't they displyed in the console? When pending tasks are being displayed after restart, why not pending process instances? Regards, Aparna -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/608070#608070] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

a_nat [http://community.jboss.org/people/a_nat] created the discussion "Re: jbpm5 process instance persistence" To view the discussion, visit: http://community.jboss.org/message/608419#608419 -------------------------------------------------------------- Hi, The table processInstancelog, doesn't get truncated after server restart, but i get the follwoing error during server restart... +2011-06-02 21:48:34,699 INFO  [org.hibernate.tool.hbm2ddl.SchemaValidator] (main) Running schema validator+ +2011-06-02 21:48:34,700 INFO  [org.hibernate.tool.hbm2ddl.SchemaValidator] (main) fetching database metadata+ +2011-06-02 21:48:34,759 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) table found: jbpm.eventtypes+ +2011-06-02 21:48:34,760 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) columns: [element, instanceid]+ +2011-06-02 21:48:34,786 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) table found: jbpm.nodeinstancelog+ +2011-06-02 21:48:34,787 INFO  [org.hibernate.tool.hbm2ddl.TableMetadata] (main) columns: [id, log_date, nodeinstanceid, type, processid, processinstanceid, nodeid]+ +2011-06-02 21:48:34,798 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=persistence.unit:unitName=#org.jbpm.persistence.jpa state=Create+ +javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory+ +...+ +...+ +...+ +Caused by: org.hibernate.HibernateException: Missing column: nodeName in jbpm.nodeinstancelog+ +at org.hibernate.mapping.Table.validateColumns(Table.java:277)+ +at org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1116)+ +at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)+ +at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:349)+ +at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)+ +at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)+ +at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)+ +... 61 more+ ++ If i add the column manually to the table, it truncates the values in all the tables mentioned in the peristence.xml. If I don't add the column, iam uanble to view the processOverview / execution history pages. It thows the aforementioned error. I'm using jbpm 5.1.0 against mysql 5.5.8 (using ApacheFriends XAMPP (Basispaket) version 1.7.4) All of my persistence.xml is configured like this --- <property name="hibernate.hbm2ddl.auto" value="validate" /> Am i missing anything / do you smell anything wrong? Thanks & Regards, Aparna -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/608419#608419] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

a_nat [http://community.jboss.org/people/a_nat] created the discussion "Re: jbpm5 process instance persistence" To view the discussion, visit: http://community.jboss.org/message/615421#615421 -------------------------------------------------------------- Hi all, Just updating my post to share my findings on how these wrt jbpm5.1.0. I used the same  AuditLog.hbm.xml, hibernate-cfg.xml and persistence.xml as attached in my post before, but only had to the following 2 steps apart from placing them in jbpm-installer\db and doing the ant install.demo. * jbpm-installer\runtime\jbpm-bam-5.1.0.M1.jar -- AuditLog.hbm.xml &  hibernate.cfg.xml * jbpm-installer\runtime\jbpm-human-task-5.1.0.M1.jar -- persistence.xml With these I was able to see the task instances even after the restart of the server. Regards, Aparna -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/615421#615421] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]

Sandeep Sapra [http://community.jboss.org/people/sandeepsapra] created the discussion "Re: jbpm5 process instance persistence" To view the discussion, visit: http://community.jboss.org/message/637424#637424 -------------------------------------------------------------- Hi Aparna, I have almost same scenario. I understand that the configurations you have told is to hold the data for tasks of a process into the database. Could you please let me know, what is the way out to retrieve those history data and show on the application view? I mean to say any APIs available in jBPM (5.x) to retreive the information. Thanks and Regards, Sandeep Sapra -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/637424#637424] Start a new discussion in jBPM at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]