Script database connect

RenatoNogueira

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\xyz\Desktop\processo_01.
py
Traceback (most recent call last):
  File "C:\Users\xyz\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?!!?!?!?!?

mvolz47

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