QAS_CANCELQUERY_REST_GET

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 4-10 Example of an URI template

  • cancelquery?instanceid={QueryInstanceID}&json_resp={json_response}

  • cancelquery?instanceid={QueryInstanceID}

Example 4-11 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"}}