Due to heavy loads, sometimes the TIBCO Data Virtualization Studio sticks and freezes. In such scenarios, we are not able to cancel those requests because we were not able to log in to the server. In this article, we will see how we can cancel any request without logging in to the TIBCO Data Virtualization Server.

curl -X POST -u admin:<password> "http://localhost:<PORT>/rest/execute/v1/actions/cancel/invoke" -H "accept: */*" -H "Content-Type: application/json" -d "[\"<Request ID>\"]"

For example, if the Request ID is 12345:

curl -X POST -u admin:tdvadmin "http://localhost:10400/rest/execute/v1/actions/cancel/invoke" -H "accept: */*" -H "Content-Type: application/json" -d "[\"12345\"]"

Successful execution will result in 200 response, and the request status will be "TERMINATED" in the request panel.

Please note that this method cannot cancel a procedure request in TIBCO Data Virtualization. This can only cancel SQL requests.

Note: To get the request list or request ID without login into the TIBCO Data Virtualization Server then refer this article: https://support.tibco.com/s/article/000052154