Canceling a Query
The service operation QAS_CANCELQUERY_OPER is used to cancel a query after execution. You need to cancel a query using the query instance ID to clean up the PSQASRUN table. The QAS Administration page can also be used to clear any orphaned rows in the PSQASRUN table.
This service operation is used to cancel an executed query.
Request Message: QAS_CANCELQUERY_REQ_MSG
Element Name |
Description |
---|---|
QueryInstanceID |
Query Instance ID |
Example Request:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:qas="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_CANCELQUERY_REQ_MSG.VERSION_1"
xmlns:qas1="http://xmlns.oracle.com/Enterprise/Tools/schemas/
QAS_CANCELQUERY_REQ.VERSION_1">
<soapenv:Header/>
<soapenv:Body>
<qas:QAS_CANCELQUERY_REQ_MSG>
<qas:QAS_CANCELQUERY_REQ>
<qas1:PTQASWRK class="R">
<qas1:QueryInstanceID>
ab621810-5437-11dd-83cd-a32b27c3af6a
</qas1:QueryInstanceID>
</qas1:PTQASWRK>
</qas:QAS_CANCELQUERY_REQ>
</qas:QAS_CANCELQUERY_REQ_MSG>
</soapenv:Body>
</soapenv:Envelope>
Response Message: QAS_CANCELQUERY_RESP_MSG
Element Name |
Description |
---|---|
Status |
Return status. Valid values are:
|
Example Response:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:soapenc="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<QAS_CANCELQUERY_RESP_MSG xmlns="http://xmlns.oracle.com/Enterprise/
Tools/schemas/QAS_CANCELQUERY_RESP_MSG.VERSION_1">
<QAS_CANCELQUERY_RESP>
<PTQASSTATWRK class="R" xmlns="http://xmlns.oracle.com/
Enterprise/Tools/schemas/QAS_CANCELQUERY_RESP.VERSION_1">
<Status>success</Status>
</PTQASSTATWRK>
</QAS_CANCELQUERY_RESP>
</QAS_CANCELQUERY_RESP_MSG>
</soapenv:Body>
</soapenv:Envelope>
This service operation is used to cancel a query after execution. You need to cancel a query using the query instance ID to clean up the PSQASRUN table. The QAS Administration page can also be used to clear any orphaned rows in the PSQASRUN table.
Request Message: QAS_CANCELQUERY_TEMPL
Element Name |
Description |
---|---|
QueryInstanceID |
Query Instance ID. It is a required variable. |
json_response |
Enter true for JSON response type; enter false for standard XML response. If no value is provided, the default is standard XML response. |
Example of an URI template
cancelquery?instanceid={QueryInstanceID}&json_resp={json_response}
cancelquery?instanceid={QueryInstanceID}
Example Request:
https://<servername>:<port>/PSIGW/RESTListeningConnector/<defaultlocal node>/CancelQuery.v1/cancelquery?instanceid=489f86b1-2fa8-11e3-95a9-8782b6a978ba
Response Message: QAS_CANCELQUERY_RESP_MSG
Element Name |
Description |
---|---|
Status |
Return status. Valid values are:
|
Example Response:
<?xml version="1.0"?>
<QAS_CANCELQUERY_RESP_MSG xmlns="http://xmlns.oracle.com/Enterprise/
Tools/schemas/QAS_CANCELQUERY_RESP_MSG.VERSION_1">
<QAS_CANCELQUERY_RESP>
<PTQASSTATWRK class="R" xmlns="http://xmlns.oracle.com/Enterprise/
Tools/schemas/QAS_CANCELQUERY_RESP.VERSION_1">
<Status>success</Status>
</PTQASSTATWRK>
</QAS_CANCELQUERY_RESP>
</QAS_CANCELQUERY_RESP_MSG>
Example Response using json_resp = true:
{"status": "success","data": {"status": "success"}}