topic Re: Timeout Error When Querying/Editing Data in ArcGIS API for Python Questions

Timeout Error When Querying/Editing Data

PatrickFilyer — Thu, 14 Feb 2019 12:51:59 GMT

I constantly receive Time-out errors and sql transaction errors when performing edits/queries on feature services hosted on AGOL.

Is there any way around this OR what are the limitations to querying and editing?

Examples of SQL transaction Error (Note: I am only querying 1000 features with the script tha tis returning these errors):

This SqlTransaction has completed; it is no longer usable.
RuntimeError: This SqlTransaction has completed; it is no longer usable.
Unable to apply edits.

Re: Timeout Error When Querying/Editing Data

matthewpgrasso — Mon, 05 Aug 2024 14:27:36 GMT

Hi @PatrickFilyer --I know you posted this a while ago, but it's still an issue today, at least for me. Did you ever find an explanation for this? I get this often as well. Seems to happen randomly. Sometimes I won't get this error for months and then it'll pop up again on the same, unaltered, code. Thank you!

Re: Timeout Error When Querying/Editing Data

abrown8 — Mon, 02 Sep 2024 14:56:38 GMT

I'd also love to know if this got solved - I've also started to get this same error 'This SqlTransaction has completed; it is no longer usable.' but on large tables (> 2mil entries). Wondering if it's timing out?

Re: Timeout Error When Querying/Editing Data

JBeasley — Mon, 06 Apr 2026 20:57:38 GMT

I am also getting this error inconsistently. Back to back runs of a process can have different results. I am working with AGOL and am performing deletes, never more than 250 features at a time. Unsure what to do to avoid this...