INT PH How-To: Manually End Integrations / Jobs

Summary:

This article details how to manually end integrations or jobs in the Privat Host portal due to the status being stuck in Processing despite there being no Cancel button.

Note: This article only applies to Private Host users. If you experience this as a Cloud user, please contact Solver Support.

Method:

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: 

For Integrations

• Go 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".

For Jobs

• Go 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 updated, manually refresh the web page and  the status should change. 

Note: 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 do not resolve the issue, please ensure the services server and SQL server has minimum 16GB RAM. 

Properties:

Private Host