Transaction record concerned to api call that received 504 gateway error

[madhuv]

Hi All,

We have an integration with third party system which consumes our Scripted Rest API and updates some records in SNOW. 

Sometimes they complain that they are receiving 504 , Gate way Timeout error and some times 202 status code.

I don't see any transaction record (syslog_transaction) created for these REST calls.

Could you please help me to understand whether transaction records will be created in these scenarios or not?

Regards

Madhu

[madhuv]

Hi Abhijit, @Abhijit 

I am aware that Transactions records will be there generally. I am asking specifically if there will be anything for the API call that resulted in 504 error?

[Abhijit]

@madhuv : there is no much details provided based general information, here are my suggestions

if  table data api

    - check for number of records returned , by default 10k records 

    - for more than 10k use pagination and offset values in your api call

   - add more parameters to filter out that data it will reduce processing time and load

  -  if payload is more 10 MB - 12 MB in that case also it will show error( sysparam_limit=10) records or less to verify this

Scripted REST API(alongwith above suggestions)

   - If you have custom built Scripted REST API, check for code if it is taking longer time for processing data, there might be certain scenario when loop or logic takes longer time to execute.

  - try to use try and catch block