Overwrite an output on SDE

806
3
Jump to solution
11-23-2016 07:12 AM
PanGIS
by
Regular Contributor

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

0 Kudos
1 Solution

Accepted Solutions
JoeBorgione
MVP Esteemed Contributor

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.

That should just about do it....

View solution in original post

3 Replies
JoeBorgione
MVP Esteemed Contributor

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.

That should just about do it....
PanGIS
by
Regular Contributor

 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.

0 Kudos
PanGIS
by
Regular Contributor

Indeed, that was the problem.

Thank you for your help Joe !

0 Kudos