How to execute Spatial ETL Tool using AecGIS 10.1 Server Interop extension License

Question

Hi all,

I have created a simple Spatial ETL tool to download the WFS data from a local weather service provider into ArcSDE feature class. I want to run this tool periodically as Windows Scheduled Task using ArcGIS for Server 10.1 Data Interop Extension. I created a python script that I thought will execute the Interop Tool and I can use it to schedule a windows task. However, the python script refuses to identify the Spatial Interop tool from the toolbox. Here is what I tried in the python script.

1. Set python exe path as C:\Python27\ArcGISx6410.1 to ensure the script runs as server site package. 
2. Confirmed that arcpy.ProductInfo() returns ArcServer
3. Check out DataInterop extension using arcpy.CheckOutExtension("DataInteroperability"). No error.
4. Imported the toolbox. Toolbox has alias. No error
5 Executed the tool passing two parameters, source WFS URL and destination ArcSDE workspace. Tool failed to execute. No meaningful error.
6. Added debug steps to list each tool in the toolbox using arcpy.ListTools(). It fails to list any Spatial ETL tool in this tool box. But it lists other python and model builder tools, which means toolbox is imported OK. Is this works as designed that I cannot use ArcGIS for Server Interop Extension license to run a Spatial ETL tool. Above workflow works fine if I use ArcGIS for Desktop (32bit python and arcpy) and Desktop Interop extension.

I also tried to publish the toolset as ArcGIS for Server service. It got published OK. However, the tool fails to execute from ArcCatalog. I have destination ArcSDE registered with the server and source WFS URL definitely works. The error is "Error Occurred" Any idea?

Thanks,
Vish

VishApte · Answer

Hi,

The issues is resolved. Happened to be incorrect ECP for Server data interop extension.

Regards,
Vish

VishApte · Answer

Vish

Please log a support call for this issue, we will replicate it (assuming the WFS service is public and you can share your script) and resolve the issue.

Regards

Hi Bruce,

Thank you for your reply. I have raised an issue with our local Esri support who will investigate and log a support request with Esri Redlands. The procedure...

In the meanwhile, I am attaching a zip file that has ETL toolbox, python scripts, one for server and one for desktop, that call the ETL tool from the toolbox and batch scripts, one for desktop and one for server that call appropriate python script. Also included is FGDB (cannot give my ArcSDE but problem remains with FGDB) with feature classes needed. You should be able to run the tools if you wish and reproduce the issue. Log files are generated in the same folder as python script. The source URL is publicly available I am sure.

To test, simply run batch script from command prompt. The desktop one succeeds, server one fails to list any Spatial ETL tool and fails to run the tool with no error description. I definitely have Data Interop Server Extension license. The line in keycode file below

interopserver,101,ecpxxxxxxxxxxx,27-jul-2014,xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Thanks for looking into the issue...:)

I also tried to publish the tool to my ArcGIS 10.1 Server. Published ok, but running the tool as service from ArcCatalog throws the infamous "ERROR 000816: The tool is not valid" error. The FGDB used is registered with the server.

Regards,
Vish

SpatialETL.zip

bharold · Answer

Vish

Please log a support call for this issue, we will replicate it (assuming the WFS service is public and you can share your script) and resolve the issue.

Regards