[jboss-user] [jBPM] - The Data in the processInstanceinfo table get removed.

[snowstorm tech]

snowstorm tech [https://community.jboss.org/people/snowstormuser] created the discussion

"The Data in the processInstanceinfo table get removed."

To view the discussion, visit: https://community.jboss.org/message/804292#804292

--------------------------------------------------------------
Hi,

The data gets automatically removed from processInstanceinfo table when the process gets completed. Some one please help me with this problem?
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/804292#804292]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Olaf Sebelin]

Olaf Sebelin [https://community.jboss.org/people/osebelin] created the discussion

"Re: The Data in the processInstanceinfo table get removed."

To view the discussion, visit: https://community.jboss.org/message/804295#804295

--------------------------------------------------------------
You can configure jBPM to store the old processinstanceinfos to a table named processinstancelog.
See the docs about HistoryLog: http://docs.jboss.org/jbpm/v5.4/userguide/ch.core-persistence.html#d0e3856 http://docs.jboss.org/jbpm/v5.4/userguide/ch.core-persistence.html#d0e3856

Regards,
Olaf
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/804295#804295]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Shobhit Tyagi]

Shobhit Tyagi [https://community.jboss.org/people/roxy1987] created the discussion

"Re: The Data in the processInstanceinfo table get removed."

To view the discussion, visit: https://community.jboss.org/message/804298#804298

--------------------------------------------------------------
Add this 
before you start your process. It enables history..
JPAWorkingMemoryDbLogger logger2 = new JPAWorkingMemoryDbLogger(kSession);
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/804298#804298]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Maciej Swiderski]

Maciej Swiderski [https://community.jboss.org/people/swiderski.maciej] created the discussion

"Re: The Data in the processInstanceinfo table get removed."

To view the discussion, visit: https://community.jboss.org/message/804539#804539

--------------------------------------------------------------
this is in fact by design. process instance info should be only kept until process instance is finished (completed or aborted) to be able to resume it when needed. As colleagues above have already mentioned you should use history log to preserve information about process instance once it's finished.

HTH
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/804539#804539]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

[Murat Kilic]

Murat Kilic [https://community.jboss.org/people/mkilic] created the discussion

"Re: The Data in the processInstanceinfo table get removed."

To view the discussion, visit: https://community.jboss.org/message/827802#827802

--------------------------------------------------------------
But the information in the VariableInstanceLog is not accurate:
1. Everything is converted to string
2. Size of the field is 255. I even tried changing the field to a higher value and it did not work. Then I found the 255 character limit is imposed by the code itself.
3. It gets updated everytime a variable is submitted such as from a human task form. So we send up having multiple records for the same variable. Yes, the one with the biggest ID is the most current one, but this is not efficient for storing variable data

My question is how can we keep all he variables of the process even after the process ends, so we can always query that information later. In real life, for example, someone may want to go back and check a credit application even after it was declined(say this was being questioned by a manager) .

I am using 5.4, by the way.

Thanks!
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/827802#827802]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]