AnsweredAssumed Answered

Search Cursor Scenario (Locks and Geoprocessing Services)

Question asked by MollyKFoley on Aug 31, 2018

I have two asynchronous geoprocessing services, both of which only allow one instance to be in use at a time as they edit and transfer data to other production databases. Each of the GP services accesses two databases, one of these databases is common between them. For illustration:

 

GP Service #1 accesses SDE geodatabases A and B.

GP Service #2 accesses SDE geodatabases B and C.

 

Geodatabase B is only accessed by search cursors in either GP service, it does not get edited or manipulated in any way. My question is, what happens if both the GP services are running and try to access geodatabase B at the same time? Will one of them error out? I can't figure out if search cursors have exclusive locks on a database or not.

Outcomes