Select to view content in your preferred language

Timeout Error When Querying/Editing Data

911
2
02-14-2019 04:51 AM
PatrickFilyer
Frequent Contributor

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.
2 Replies
matthewpgrasso
New Contributor

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!

0 Kudos
abrown8
Occasional Contributor

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?

0 Kudos