How to cancel a data run from the database
This section describes how to manually stop the data run from the database in case of a failing data run.
Follow these steps.
- Retrieve the App ID of the process app for which you want to cancel the data run. Check outProcess App properties.
- Contact you database administrator to run the following SQL query in the AutomationSuite_ProcessMining_Metadata database:
with Ingestion_tbl as (select top 1 * from dbo.Ingestions where AppId = '<app ID>' and [Status] = 1 order by LastUpdated desc) update Ingestion_tbl set [Status]=3 where <app ID> should be replaced with the App ID retrieved in Step 1.
The following illustration shows an example.
3. Refresh Process Mining Portal page.
4. Upload data for the process app.