Can anyone khow how to retrieve process instances deleted ?
Thank you in advance for your help.
I tend to think you are out of luck.
The process instance do not have "mark for deletetion" or anything similar so when they are deleted or the job the deletes them are run, thy are gone byeond return unless you have a db back to roll back.
Thank you for you answer.
Yes I have the dump for the day before the deletion. I installed in our DEV environment. I wonder if it exist a way to xog out all the instances and after Xog in into PROD environment.
Not that I am aware of.
There are the files for xoging processes in an out (which is not covered in the XOG developers guide). However, that is not like XOGing objects where you can XOG the definitions and then you can XOG the instances. With processes you can only XOG the definitions as far as I am aware of. That is not help for you.
Why would you want to do that in the fisrt place?
If you just want the view what was there and doing that on your second environment is cumbersome you could query what you need with SQL and the create a custom object (eg flat like the view for intiated instances) and create a custom portlet for the users who need to view it. The same goes if you need to have the data archived for audit purposes.
That is create a look alike copy.
They want those instances for their audit purposes to know how many instances of the process are launched for projects.
Yes Im agree with you, they just want to have the view to see the instances. But They want them in the PROD environment.
So what you propose is I create the custom portlet on Production ?
you need a simple gel process to copy the Data to different table before it deletes from Clarity tables.
Create a backup table.
Find the differences between existing table and custom table.
Insert the differences in Custom table.
Create a Portlet using Custom table with date parameter.
Thanks for your answer.
The data are already deleted from Clarity PROD tables. I have the dump that contains all instances deleted.
And I installed the dump into the DEV and I have the instances. So I want to have those instances into PROD as they are in DEV.
Could you please give me more details for the solution you propose?
Gel process method explained is perfect if you are interested for Process Instances in Future.
If you are just interested in Dump Instances which are on the dev Database then just create new table on Prod database.
There are lot of ways to copy table from one database to another.
SQL> copy from niku/niku@development to niku/niku@Production create bpm_run_processes_backup
SQL> copy from niku/niku@development to niku/niku@Production create
using select * from bpm_run_processes;
using select * from
If you want to archive also future instances then you have to copy them to antoher table than bpm_run_processes so that when the cleaning job runs you still have them.
The common reason for suggesting a custom object is of course that contrary to ordinary tables you can also enter and edit data in supported manner in the GUI. gel and SQL queries work the same way for a custom object table and for non object standard table.
Options to the direct copy from DEV to PROD you could also use an SQL select to retrieve the data, turn that into XLM for the isntances of a custom object and XOG that into to PROD in a supported manner.
Until your are all done with your system you'd better keep on taking backups.
Thank you both Gurjeet and Martti K.
I will investigate for your suggestions . I will keep you updated.
Retrieving data ...