No error message although dataset has been only partly uploaded due to timeout error of the endpoint

KatriM
KatriM Member
in General

Hi,

I've created a custom model for Autonomous REST API by using Progress DataDirect and uploads are working for multiple endpoints but we have noticed that rows are missing for some endpoints.

Testing via Bruno gives an error message at the end of json file: ""error": {
"message": "Transaction cancelled: maximum execution time exceeded",
"detail": "maximum execution time exceeded Check logs for error trace or enable glide.rest.debug property to verify REST request processing"
},
"status": "failure" "

Please advise what would be the best way to proceed with this issue. Thanks in advance!

Tagged:

Answers

  • Henry Simms
    Henry Simms Administrator

    Based on the error, this looks like a call to a ServiceNow endpoint and you most likely see this error because the REST API request's duration is greater than "Maximum Duration (seconds)" defined in the Transaction Quota Rule related to the type of request.

    It looks like such transaction cancellations can return with a 200 (OK) response, meaning the AutoREST JDBC driver won't know that there's been a problem retrieving the full dataset.

    If a error code such as 500 (internal server error) is returned by an API during a request, the AutoREST driver will pass this back to Data Studio and report and error, which can be handled in several ways:

    image.png

    My suggestions would be:

    1. Check the HTTP response code (in Bruno) for the failed request.
    2. Consider ways to prevent the call taking so long. Can the API call be paged or the query filtered?
    3. Check if the maximum duration can be increased in SNow

Categories