Delete Process instances from environment

Hi Gaurav 

There isn't anything out of the box. There are relevant utilities in the AppMarket (e.g. https://community.appian.com/b/appmarket/posts/process-management-services) which, I presume, you would use in conjunction with a Process Report, the latter with which you can get the list of process instance identifiers.

gauravp0003

You can create a process report to to get the process ids of the instances and then pass those Process ids to Delete Process Smart service.

Thank you , will it work for parent child process as well ? like parent is deleted but child still active or it will be deleted too. 

For this case you need to configure your subprocess in a way that while generating the process report of parent you should be able to capture sub process details as well.

Thereby passing all the process instance Ids you can delete all.

Thank you i created an expression with a!queryProcessAnalytics() and it provides the process id's of sub process to delete as well.

Great.. :) Please validate my response as answer

Gaurav,

In the Process Report configuration also should we mention, include data from sub-process as  YES?

or only configuring in PM is enough?

include data from sub-process as  YES? should suffice and show subprocess in report . For us we have to because not all the process configured to show subprocess

Hello,

I'm trying to clean the completed processes from lthe ower environment. (currently this Env has 4k completed instances)

I created a process report for completed processes and used a!queryProcessAnalytics() with batching to retrieve the process IDs.

However, I’m encountering the following issues during the deletion process:

1. The process can delete a few instances (with a batch size of 50), but after several batches, a!queryProcessAnalytics() throws the following error and fails to retrieve the remaining process id's, "There was an error querying the Analytics report. (APNX-1-4275-000)"
2. I tried adding a delay before fetching the next batch of process IDs (after deleting the previous batch), but the issue persists, the remaining process instances still failed to fetch and delete.
3. In the process report display settings, when I set "Rows per page" to 25, the report loads correctly. However, increasing this to 50 causes the report to fail with the error: "An error occurred while retrieving the report."
4. Additionally, I can see errors in both the Analytics log and Tomcat logs, indicating that the process report query is failed to fecth the information.

Has anyone else encountered these issues? If so, were you able to resolve it?

Has anyone successfully deleted a large number of process instances using this smart service?