Python error (arcgis10): SpatialETLTool not found

JaneWickers — Wed, 14 Jul 2010 01:09:31 GMT

I've been successfully running the following python script which runs a Spatial ETL Tool that I have created in a custom toolbox.

# ---------------------------------------------------------------------------
# daily_etl_repln.py
# Created on: Mon Mar 30 2009 02:38:54 PM
#   (generated by ArcGIS/ModelBuilder)
# ---------------------------------------------------------------------------

# Import system modules
import sys, string, os, arcgisscripting

# Create the Geoprocessor object
gp = arcgisscripting.create()

# Load required toolboxes...
gp.AddToolbox("Z:/ESRI/Data/Replication/Replication.tbx")
gp.AddToolbox("C:/Program Files/ArcGIS/Desktop10.0/ArcToolbox/Toolboxes/Data Management Tools.tbx")
gp.AddToolbox("C:/Program Files/ArcGIS/Desktop10.0/ArcToolbox/Toolboxes/Analysis Tools.tbx")

gp.CheckOutExtension("DataInteroperability")

gp.overwriteoutput = 1

# Local variables...
Destination_Geodatabase_ = "Z:\\ESRI\\Data\\test_Basemap.gdb"
Destination_Geodatabase___2_ = "Z:\\ESRI\\Data\\Basemap.gdb"
Destination_Geodatabase___3_ = "Z:\\ESRI\\Data\\Community_Facilities_Services.gdb"
Destination_Geodatabase___4_ = "Z:\\ESRI\\Data\\Surveying.gdb"
Destination_Geodatabase___5_ = "Z:\\ESRI\\Data\\Water_Reticulation.gdb"
Destination_Geodatabase___6_ = "Z:\\ESRI\\Data\\Infrastructure.gdb"
Destination_Geodatabase___7_ = "Z:\\ESRI\\Data\\Stormwater.gdb"
Destination_Geodatabase___8_ = "Z:\\ESRI\\Data\\Sewer_Reticulation.gdb"
Destination_Geodatabase___9_ = "Z:\\ESRI\\Data\\LEP2000_Gazetted.gdb"
Destination_Geodatabase___10_ = "Z:\\ESRI\\Data\\DCP_Consolidated.gdb"
Destination_Geodatabase___11_ = "Z:\\ESRI\\Data\\Planning_Section94.gdb"
Destination_Geodatabase___12_ = "Z:\\ESRI\\Data\\Draft_LEP09_CEN.gdb"
Destination_Geodatabase___13_ = "Z:\\ESRI\\Data\\Draft_LEP08_Constraints.gdb"
Destination_Geodatabase___14_ = "Z:\\ESRI\\Data\\Draft_LEP08.gdb"

### Process: DAILY: Oracle to FGDB Replication...
gp.toolbox = "Z:/ESRI/Data/Replication/Replication.tbx";
gp.SpatialETLTool("gisp", Destination_Geodatabase_, Destination_Geodatabase___2_, Destination_Geodatabase___3_, Destination_Geodatabase___4_, Destination_Geodatabase___5_, Destination_Geodatabase___6_, Destination_Geodatabase___7_, Destination_Geodatabase___8_, Destination_Geodatabase___9_, Destination_Geodatabase___10_, Destination_Geodatabase___11_, Destination_Geodatabase___12_, Destination_Geodatabase___13_, Destination_Geodatabase___14_,"gisp")

print "ETL Tool finished"

I have updated the paths for the system toolboxes for arcGIS 10.0, but still get the following error:

Traceback (most recent call last):
File "C:\Python26\ArcGIS10.0\Lib\site-packages\pythonwin\pywin\framework\scriptutils.py", line 325, in RunScript
    exec codeObject in __main__.__dict__
File "Z:\ESRI\Data\Replication\daily_etl_repln_arcgis10.py", line 41, in <module>
    gp.SpatialETLTool("gisp", Destination_Geodatabase_, Destination_Geodatabase___2_, Destination_Geodatabase___3_, Destination_Geodatabase___4_, Destination_Geodatabase___5_, Destination_Geodatabase___6_, Destination_Geodatabase___7_, Destination_Geodatabase___8_, Destination_Geodatabase___9_, Destination_Geodatabase___10_, Destination_Geodatabase___11_, Destination_Geodatabase___12_, Destination_Geodatabase___13_, Destination_Geodatabase___14_,"gisp")
AttributeError: Object: Tool or environment <s> not found.

Any ideas?

Thanks.Jane

topic Python error (arcgis10): SpatialETLTool not found in Geoprocessing Questions

Python error (arcgis10): SpatialETLTool not found