topic Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc." in Python Questions

Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

ChrisRado — Tue, 15 Jul 2014 15:45:02 GMT

I have a python script that runs 5 Spatial ETL tools that I wish to run as a scheduled task.

Each of the tools will run successfully from ArcCatalog and also from the ArcCatalog Command line.

If I try to run the tools from the DOS window, as would be done via python script for a scheduled task, arcpy cannot find the tools, although it does load the toolbox.

In the attached screenshot: 1) I open a cmd.exe window; 2) start python; 3) import arcpy; 4) Import my toolbox, which is verified as loaded on the next line; 5) Use arcpy.ListTools to see what tools are loaded. the result is "[]", meaning no tools are recognized from this tool box; 6) I use the same ListTools to show the Spatial Analyst tools that were loaded by import arcpy; 7) I attempt to execute one of the tools from my toolbox and forget a " (my mistake!); 😎 I attempt to execute one of the tools from my toolbox and receive the message "AttributeError: 'module' object has no attribute 'CopyFeatureClass_newgpetl'".

What is preventing my tools from being recognized from the DOS CMD.EXE window while ArcCatalog and ArcCatalog Command Line can run them?

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

ChrisRado — Wed, 16 Jul 2014 14:07:36 GMT

Just for anyone who comes across this same problem and searches out this discussion:

The key thing that I am missing (in this case) that causes the "AttributeError: 'module' object has no attribute..." is that I forgot to check out the Data Interoperability extension, with this:

arcpy.CheckOutExtension("DataInteroperability")

This fixed the problem on my local machine, but it did not fix the problem on our server. When I figure that out, I'll add a note about what it was to this discussion.

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

KristiBarry — Fri, 18 Jul 2014 18:02:23 GMT

Please share any results you may have. I am not able to make this work even after executing (and verifying) the arcpy.CheckOutExtension("DataInteroperability") has checked out the extension. We are getting the same AttributeError everyone else seems to be seeing on this problem.

thanks,

Kristi

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

ChrisRado — Tue, 22 Jul 2014 18:10:25 GMT

Kristi,

This is why Spatial ETL Tools are NOT being recognized on the server- in our particular case.

NIM09073:

"When calling a model with Python that contains a Data Interoperability Spatial ETL tool, the script will not run successfully from IDLE when Esri Production Mapping 10.1 is installed."

Spatial ETL Tools will not run if you have Workflow Manager (aka Esri Production Mapping) installed on the same machine. If I uninstall Workflow Manager and try the tools again, they become visible at the Windows command line.

I'm assuming you have already been through:

1) Proper names for Toolbox Name (no spaces) and Toolbox Label (any crazy thing you want).

2) Adding an all lower case Toolbox Alias

3) Proper names for Tool Name (no spaces) and Tool Label (any crazy thing you want).

Chris

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

SrijanaTuladhar — Mon, 18 May 2015 16:20:55 GMT

Hi Chris,

I am getting the same attribute error, even after adding the arcpy.CheckOutExtension("DataInteroperability") into the script.

The error message.

Traceback (most recent call last):

File "G:\....\Scripts\ETL_mb_test5.py", line 21, in <module>

arcpy.SpatialETLTool_test("G:\\....\\Source42015.gdb")

AttributeError: 'module' object has no attribute 'SpatialETLTool_test'

>>>

Here is the python script:

# Import arcpy module
import arcpy

# Load required toolboxes
arcpy.ImportToolbox("G:/..../testETLtool.tbx")

# Check out extension

arcpy.CheckOutExtension("DataInteroperability")

# Local variables:
Source42015_gdb = "G:\\.....\\Source42015.gdb"

# Process: SpatialETLTool
arcpy.SpatialETLTool_test("G:\\.......\\Source42015.gdb")

Thanks for your help.

Sri

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

BruceHarold — Mon, 18 May 2015 16:31:06 GMT

Do you have the Workflow Manager extension installed? There is a known incompatibility fixed in 10.3.1 that results in Data Interoperability tools not being licensed when Workflow Manager is present.

Regards

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

SrijanaTuladhar — Mon, 18 May 2015 16:36:00 GMT

Hi Bruce,

No, I do not have Workflow Manager extension installed.

Thanks

Sri

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

BruceHarold — Mon, 18 May 2015 16:43:53 GMT

Please check you have an alias 'test' set for the Toolbox containing your ETL tool - that is the value indicated by your Python code. If you do then you need to log a support call because something else is wrong.

Thanks

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

SrijanaTuladhar — Mon, 18 May 2015 16:57:32 GMT

Ok thanks. Yes, I just double checked, I have an alias 'test' for the Toolbox that contains the ETL tool.

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

ChrisBlinn1 — Sun, 12 Dec 2021 00:27:40 GMT

Also having this issue.

Workflow Manager and Production Mapping are not installed.

Checked out extension.

Toolbox has alias, and model has name.

Runs from ModelBuilder and from python console in ArcCatalog 10.2.2

# Import arcpy module
import arcpy

class LicenseError(Exception):
   pass

try:
   if arcpy.CheckExtension("DataInteroperability") == "Available":
  arcpy.CheckOutExtension("DataInteroperability")
   print "Checked out \"DataInteroperability\" Extension"
   else:
   raise LicenseError
except LicenseError:
   print "Data Interoperability license is unavailable"
except:
   print arcpy.GetMessages(2)

# Load required toolboxes
arcpy.ImportToolbox("C:/.../ETL.tbx")

# Script arguments
Source = arcpy.GetParameterAsText(0)
if Source == '#' or not Source:
  Source = "C:\\...\\Source.gdb" # provide a default value if unspecified

Destination = arcpy.GetParameterAsText(1)
if Destination == '#' or not Destination:
  Destination = "C:\\...\\Destination.gdb" # provide a default value if unspecified

FeatureTypes = arcpy.GetParameterAsText(2)
if FeatureTypes == '#' or not FeatureTypes:
  FeatureTypes = "Parcel_Project" # provide a default value if unspecified

# Local variables:

# Process: WalworthETL
arcpy.WalworthETL_ETL(Destination, Source, FeatureTypes)

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

ChrisBlinn1 — Thu, 02 Feb 2017 22:39:44 GMT

It turned out 64 bit background processing was installed. Uninstalling this fixed the issue.

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

Jim_Gay — Thu, 18 May 2017 14:31:31 GMT

I have the same issue.

Proper extensions are checked out and the correct toolbox is imported.

None of the problematic extensions are installed.

64 bit background processing is not installed.

My command looks like this:

arcpy.SpatialETLTool_cdwdev(Driving_Distance_gdb, Destination_ODBC_3_x_Dataset_)

Error message:

AttributeError: 'module' object has no attribute, 'SpatialETLTool_cdwdev'

My alias of cdwdev is set correctly.

Any ideas?

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

StephanieRinguet2 — Wed, 18 Mar 2020 19:41:46 GMT

Hello,

did you evey figure this out? I have the same issue.

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

ChrisRado — Wed, 18 Mar 2020 19:56:46 GMT

Hi Stephanie,

This was the first thing that helped, which may or may not solve your problem:

The key thing that I am missing (in this case) that causes the "AttributeError: 'module' object has no attribute..." is that I forgot to check out the Data Interoperability extension, with this:

arcpy.CheckOutExtension("DataInteroperability")

The other was that Workflow Manager could not be installed on the same server.

We ended up just getting an upgrade to the full version of FME desktop ESRI Edition. If you have the Data Interop extension you can get the upgrade for $800 from Safe Software:

ArcGIS Data Interoperability & FME Desktop Comparison

Hope one of those options works out for you!

Chris

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

StephanieRinguet2 — Thu, 19 Mar 2020 14:14:21 GMT

Thank you Chris for your answer!

Yes Data Interop extension is checked out, we don't have Workflow Manager installed on that server, and I am using the toolbos aliases in my script. Who knows what's going on, and apparently ESRI Tech Support is backed up during this coronavirus time, so I guess I may just have to launch my Spatial ETL toll manually for teh time being. Thanks for sharing the upgrade option, I'll bring this up to my manager! I'm taking that you haven't had any issues automating tools with the full FME version?

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

ChrisRado — Thu, 19 Mar 2020 14:23:14 GMT

No problems automating when we run the FME workspaces via .bat file on Task Scheduler.

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

StephanieRinguet2 — Thu, 19 Mar 2020 14:27:41 GMT

Convincing argument! Thank you.

Re: Spatial ETL Tools won't run "AttributeError: 'module' object has no attribute, etc."

HalilSiddique — Thu, 21 Sep 2023 16:09:17 GMT

Has anyone been able to get this to work? Works fine when runnining is VS Code and ArcGIS Pro, but cannot get it working on ArcGIS Enterprise (10.8.1).

😞