REST API request time out.

[skymak]

Hi,

We are using REST API table endpoint for sys_audit table to get the data from ServiceNow, but it is timing out with an 500 Internal Server Error. Following is the error response:

{
       "error": {
               "detail": "Transaction cancelled: maximum execution time exceeded Check logs for error trace or enable glide.rest.debug property to verify REST request processing",
               "message": "com.glide.sys.TransactionCancelledException: Transaction cancelled: maximum execution time exceeded"
       },
       "status": "failure"
}

Once we get this HTTP response from ServiceNow REST API for sys_audit table, all our calls for other tables return with HTTP code 202 and there is no data in response for a few minutes. We also tried to limit the query breadth by limiting it using sys_created_on but we are still getting error code 500 for sys_audit table.

Thanks,

Malik Lalani.

[vab_13]

I reckon log a call on Hi, we can actually look at what you are trying to fetch and what can be tweaked.

That way, we can actually connect to your instance and look at what your query is and what can be tweaked.

Official recommendation can be provided via Hi.

[Liju John1]

I have the same issue when I use the Database View as a table in the REST API Explorer.

[ThunderDev]

Have you found a solution?

[ThunderDev]

Were you able to find a solution to this type of issue?