Question

remove sde locks, stop service for ags and portal

  • 4 August 2022
  • 2 replies
  • 61 views
gisbradokla
Rank
Badge +10

I have a scheduled workspace that needs to truncate an sde table. The table is shared as aservice in AGS and portal. I see a customtransformer to start/stop the arcgisserver.  

But if i'm not mistaken this would not remove any locks that are on the sde table.

do i need to put this into an automation in order to make all this happen? since i don't see any specific transformers to accomplish this. is it going to have to be through the rest api or python? does anyone have a workflow and or script to do this?

I assume i would need to...

  1. stop the AGS service (to keep someone from connecting while the rather lengthy trunc/load is happening)
  2. then remove the locks (I think i have only heard of doing this through the rest api).
  3. run the fme wkspc and truncate then load the new data.
  4. restart the service.

 

2 replies

hkingsbury
Rank
Userlevel 5
Badge +29

Hey, so stopping the service will remove any locks on SDE that the service had. If another user/service has a lock on the data, this will still remain.

To fully drop all locks from SDE you'd need to use ArcPy.

The rough steps would be:

  1. stop service(s)
  2. disable connections - https://pro.arcgis.com/en/pro-app/2.8/arcpy/functions/acceptconnections.htm
  3. disconnect users - https://pro.arcgis.com/en/pro-app/2.8/arcpy/functions/disconnectuser.htm
  4. perform the truncate
  5. enable connections
  6. start service(s)
Check out the Abley FME Firesides on Youtube: https://www.youtube.com/@ableyltd
gisbradokla
Rank
Badge +10

Hey, so stopping the service will remove any locks on SDE that the service had. If another user/service has a lock on the data, this will still remain.

To fully drop all locks from SDE you'd need to use ArcPy.

The rough steps would be:

  1. stop service(s)
  2. disable connections - https://pro.arcgis.com/en/pro-app/2.8/arcpy/functions/acceptconnections.htm
  3. disconnect users - https://pro.arcgis.com/en/pro-app/2.8/arcpy/functions/disconnectuser.htm
  4. perform the truncate
  5. enable connections
  6. start service(s)

hmm, Thank you! Now if i can just figure out how to implement that into a scheduled wksp

Reply


Community Stats

28,741
Posts
109,576
Replies
36,579
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.