BPM, Workflow, and Case

I just need to know how to migrate process instances that are in a completed state previous snapshot to a new snapshot since we are encountering some problems when we create the reports with exposed variables. These exposed variables only show process instances that are in the current snapshot and it doesn't display the previous snapshot's process instances, because those are not migrated to new snapshot.

------------------------------
Harsha Randunna
------------------------------

Hi Harsha,

Officially, only Active, Failed and Suspended instances can be migrated, Completed instances cannot be migrated. 
But there is a crude way (I have done it once) - you need to change the Completed status as Suspended to make those eligible for migration.
Through APIs, you cannot change the status of an instance, so you need to directly change in the database and the sample SQL would look like - 

update LSW_BPD_INSTANCE set EXECUTION_STATUS = 6 where BPD_INSTANCE_ID = ?

Once the migration is done, set the status back to 2 (Completed).

Please note: This approach is definitely not recommended and if anything is broken, IBM won't provide support, do try it at your own risk and do not forget to take an offline DB backup before doing this experiment.

Thanks!

------------------------------
Atanu Roy
Solution Architect
Salient Process
------------------------------

Original Message:
Sent: Tue August 16, 2022 03:26 AM
From: Harsha Randunna
Subject: How to migrate process instances with a completed state source to target snapshot.

I just need to know how to migrate process instances that are in a completed state previous snapshot to a new snapshot since we are encountering some problems when we create the reports with exposed variables. These exposed variables only show process instances that are in the current snapshot and it doesn't display the previous snapshot's process instances, because those are not migrated to new snapshot.

------------------------------
Harsha Randunna
------------------------------

Dear Atanu,

Thanks for the prompt response.

Thanks,
Harsha Randunna

------------------------------
Harsha Randunna
------------------------------

Original Message:
Sent: Tue August 16, 2022 11:24 AM
From: Atanu Roy
Subject: How to migrate process instances with a completed state source to target snapshot.

Hi Harsha,

Officially, only Active, Failed and Suspended instances can be migrated, Completed instances cannot be migrated. 
But there is a crude way (I have done it once) - you need to change the Completed status as Suspended to make those eligible for migration.
Through APIs, you cannot change the status of an instance, so you need to directly change in the database and the sample SQL would look like - 

update LSW_BPD_INSTANCE set EXECUTION_STATUS = 6 where BPD_INSTANCE_ID = ?

Once the migration is done, set the status back to 2 (Completed).

Please note: This approach is definitely not recommended and if anything is broken, IBM won't provide support, do try it at your own risk and do not forget to take an offline DB backup before doing this experiment.

Thanks!

------------------------------
Atanu Roy
Solution Architect
Salient Process

Original Message:
Sent: Tue August 16, 2022 03:26 AM
From: Harsha Randunna
Subject: How to migrate process instances with a completed state source to target snapshot.

I just need to know how to migrate process instances that are in a completed state previous snapshot to a new snapshot since we are encountering some problems when we create the reports with exposed variables. These exposed variables only show process instances that are in the current snapshot and it doesn't display the previous snapshot's process instances, because those are not migrated to new snapshot.

------------------------------
Harsha Randunna
------------------------------