An integration or a job gets stuck in Processing in the Private Host portal, there is no button to cancel the process. The user is unable to run other integrations or jobs due to the process being "stuck".
This resolution only applies to Private Host users. If you are a Cloud user, please contact Solver Support.
To manually cancel an integration or a job, the database administrator will need to update the job status from "Processing" to "Fail" in the following tables in the Solver Data Warehouse database.
- Head to the SQL server and locate the SolverDW database. Look for the log.EtlJobStepLog table. Update the status of the integration that you want to cancel from "Processing" to "Fail".
- Head to the SQL server and locate the SolverDW database. Look for the log.JobLog table. Update the status of the job that you want to cancel from "Processing" to "Fail".
Once the status is update, manually refresh the web page and you should see the status change.
Important: If you simply delete the integration / job from the front end (portal) while it is stuck in processing, the task will be stuck in the back end (SQL). Therefore, please ensure you stop the task from the backend before deleting the task from the frontend.
If above steps don't resolve the issue, please ensure the services server and SQL server has minimum 16GB RAM.