I have a GP service published that updates a series of features then publishes a pdf. Several of the feature classes have attachments, so it is necessary to open an edit session when updating them. The script works, both within Arcmap and from the GP service.
But, after using the GP service several times (typically when several users start using it), I keep getting an error in the server manager logs:
Error: The current version does not support editing (base, consistent, or closed) [An open transaction was detected. All user transactions must be closed prior to StartEditing.].
Can anyone help troubleshoot how or why this error message keeps appearing? I'm assuming that somehow two users are calling the GP service at the same time and somehow it is causing a lock situation. Or maybe someone is accessing that feature layer at the same time (there are feature services that access the same layers) Restarting the gp service and feature service appears to fix the issue, until it occurs again.
Are there any script examples or advice on how a script should handle opening closing edit sessions when other instances of the script might be doing the exact same thing?