topic Re: Overwrite an output on SDE in Geoprocessing Questions

Overwrite an output on SDE

PanGIS — Wed, 23 Nov 2016 15:12:16 GMT

Hi,

I am trying to run a custom model on my Arcmap 10.2.

I published the GPserver on REST

The tool should be able to read a SQL table and give me the points on a map.

Yesterday was working, today I can't run the tool as I get this:

ERROR 000258: Output Database Connections\Connection to localhost.sde\Output already exists
Lock request conflicts with an established lock [Lock request conflicts with an established lock[
DBO
DBO
DBO]]
Failed to execute (Feature Class to Feature Class).

The overwrite option on my arcmap is checked, of course.

I need to overwrite as the table will be changing from time to time.

The tool published and added in WAB doesn't work as well.

Where is the mistake?

Thanks

Re: Overwrite an output on SDE

JoeBorgione — Wed, 23 Nov 2016 16:49:56 GMT

This is total shot from the hip, but since it was working and now it's not, I wonder if you have a hung process in SDE that is creating the lock the error is complaining about. If possible, can you shut down and restart the SDE service? That should get rid of any user that's attached to it.

Re: Overwrite an output on SDE

PanGIS — Wed, 23 Nov 2016 20:38:09 GMT

Joe thank you for you reply.

The only user hunged on that same process could be only myself (I hope ) trying to run the GP on WebAppBuilder most probably at th very same time.

As soon as I can re-test the Model I will update here.

Anyway thank you for the hint.

Re: Overwrite an output on SDE

PanGIS — Fri, 25 Nov 2016 14:57:29 GMT

Indeed, that was the problem.

Thank you for your help Joe !