topic Re: Script database connect in Python Questions

Script database connect

RenatoNogueira — Tue, 20 Mar 2012 11:09:36 GMT

Hi..
Is new programin in language python and problem connection database script arcsde.

Create script in arc catalog and export script to execute.

Script:

# ---------------------------------------------------------------------------
# processo_01.py
# Created on: 2012-01-13 11:30:03.00000
#   (generated by ArcGIS/ModelBuilder)
# Description:
# ---------------------------------------------------------------------------

# Import arcpy module
import arcpy

arcpy.env.workspace = "C:\\\connectionFiles\\GEO_DADOS.sde"

# Local variables:
gisvcc_dbo_INT_VW_SIG_IMOVEIS = "gisvcc.dbo.INT_VW_SIG_IMOVEIS"
gisvcc_GEO_DADOS_SIG_IMOVEIS = "gisvcc.GEO_DADOS.SIG_IMOVEIS"

# Process: Copy
arcpy.Copy_management(gisvcc_dbo_INT_VW_SIG_IMOVEIS, gisvcc_GEO_DADOS_SIG_IMOVEIS, "Table")

Before run script error:

C:\Python26\ArcGIS10.0>python.exe C:\Users\xxxx\Desktop\processo_01.
py
Traceback (most recent call last):
File "C:\Users\xxxx\Desktop\processo_01.py", line 18, in <module>
    arcpy.Copy_management(gisvcc_dbo_INT_VW_SIG_IMOVEIS, gisvcc_GEO_DADOS_SIG_IM
OVEIS, "Table")
File "C:\Program Files (x86)\ArcGIS\Desktop10.0\arcpy\arcpy\management.py", li
ne 3010, in Copy
    raise e
arcgisscripting.ExecuteError: ERROR 000258: Output C:\\connectionFiles\GEO_DADOS
.sde\gisvcc.GEO_DADOS.SIG_IMOVEIS already exists
Failed to execute (Copy).

which this error can be?!!?!?!?!?

Re: Script database connect

MikeMacRae — Tue, 20 Mar 2012 17:35:39 GMT

It looks like your output in arcpy.Copy_management already exists. I would either delete it or use an overwrite statement to overwrite your output.

Re: Script database connect

RenatoNogueira — Wed, 21 Mar 2012 17:00:11 GMT

It looks like your output in arcpy.Copy_management already exists. I would either delete it or use an overwrite statement to overwrite your output.

Inside the tool it deletes and then recreates the information. Can you tell me which statement you use to delete first and then reconstruct the data?

Re: Script database connect

MichaelVolz — Thu, 22 Mar 2012 01:30:24 GMT

renatognog:

Is your data being consumed by an ArcGIS Server service or ArcIMS service? If it is I would recommend a truncate and append process that bypasses schema locks that are in place from the above mentioned services. DeleteRows_Management followed by Append_Management