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.

See Using QAS Administration.

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:

  • idNotFound

    Used when the queryInstanceID isn't correct.

  • fail

  • success

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:

  • idNotFound

    Used when the queryInstanceID isn't correct.

  • fail

  • success

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"}}