topic Re: Publishing ETL Tool Model with Data Interoperability in ArcGIS Data Interoperability Ques.

Publishing ETL Tool Model with Data Interoperability

MuratDemircan — Mon, 03 May 2021 20:13:49 GMT

I'm new to Data Interoperability. I hope you can help me for solving my problem.

I'm trying to add ETL tool to web application by using ArcGIS Data Interoperability for Server. I created a tool which reads the WMS of feature class in sde and export the features of object to CAD file by combining in zip. Like ESRI suggested, I added ETL tool to model in toolbox. Everything is okay so far.

But after publishing ETL model, when I test ETL CAD model, I get an error which shows that the tool is not valid. I tried many different cases and changed different parameters in ETL Wizard. After many tries, I get the same result.

To specify the problem, I exported the model to Python script. I changed the necessary corrections on Python script. But unfortunately, I get the same result. When the function of spatial tool has been started, I get an error.

I searched different solutions for ERROR 000816. But I couldn't get the result from those posts for my situation. And finally, when I run ETL tool in python script, I get the error for parameters with some XML syntax which I don't know where they come from.

Btw, I checked that if when different model was published to Arcgis Server, it is successful.

Thank you for your help.

Re: Publishing ETL Tool Model with Data Interoperability

BruceHarold — Wed, 05 May 2021 13:45:57 GMT

Hi, the single most common 'invalid tool' cause is not having installed and licensed Data Interoperability on the server, please check this. If this checks out and you still have issues please open a support call and reference this thread so we can work with the analyst.

Re: Publishing ETL Tool Model with Data Interoperability

MuratDemircan — Sun, 09 May 2021 21:36:26 GMT

Hello Bruce,

Thank you for your comment. But I'm adding python script codes, and it checks that if there is any Data Interoperability license. https://support.esri.com/en/technical-article/000012387 I applied the process and checked the license like in this link. I didn't get any errors when checking the Data Interoperability license by Python code. The error comes when executing ETL toolbox function in the python geoprocessing service. Do you think this is caused by license?

Re: Publishing ETL Tool Model with Data Interoperability

BruceHarold — Wed, 02 Jun 2021 13:21:15 GMT

Murat have you checked Data Interop is installed on the server? This is separate to being licensed.

Re: Publishing ETL Tool Model with Data Interoperability

MuratDemircan — Thu, 10 Jun 2021 11:44:20 GMT

Hello Bruce,

Yes, I have installed it. But I can't see whether Data Interoperabilityis authorized or not.

Btw, I have installed ArcGIS Server to "D" named driver of the computer. And I also have installed Data Interop to the same D driver. My problem can be caused by this? How can I see that Data Interoperability for ArcGIS Server is installed successfully?

Re: Publishing ETL Tool Model with Data Interoperability

BruceHarold — Thu, 10 Jun 2021 12:48:57 GMT

Hi Murat

If Data Interop is installed and licensed on the server you should be able to start Workbench from this path (D drive in your case). Log onto the server as the arcgis service owner account.

"D:\Program Files\ESRI\Data Interoperability\Data Interoperability AO11\fmeworkbench.exe"

Re: Publishing ETL Tool Model with Data Interoperability

MuratDemircan — Thu, 10 Jun 2021 12:57:00 GMT

Hi Bruce,

Thank you for you quick reply.

My installation path seems : "D:\Data Interoperability"

When I try to open fmeworkbench.exe file, FME License is been seen.

Re: Publishing ETL Tool Model with Data Interoperability

BruceHarold — Thu, 10 Jun 2021 13:01:02 GMT

I haven't seen that install path before, can you open a support call please so we can help you get set up correctly.

Re: Publishing ETL Tool Model with Data Interoperability

MuratDemircan — Thu, 10 Jun 2021 13:27:23 GMT

Dear Bruce,

Thank you for your suggestions. One of our customers didn't want us to install Esri and FME installations to their C driver. That's why we had to install them to D driver. So, what I understand from you saying, we should change the installation paths (re-install the products) to run our products without any problem. Am I right?

I think after we discuss this with our customer, I will open a support call.

Re: Publishing ETL Tool Model with Data Interoperability

BruceHarold — Thu, 10 Jun 2021 13:40:41 GMT

Hi, I don't know if it is a problem the software is installed in a non-standard path, the support people will be able to advise. Regardless you are unable to start Workbench from the executable so there is something wrong with licensing, fmeworkbench.exe should start.

Re: Publishing ETL Tool Model with Data Interoperability

MuratDemircan — Thu, 10 Jun 2021 13:44:03 GMT

Thank you Bruce, you really helped me alot. I didn't know that fmeworkbench.exe have to be opened. I will contact and open the support about this problem.

Re: Publishing ETL Tool Model with Data Interoperability

BruceHarold — Thu, 10 Jun 2021 14:10:21 GMT

Workbench starting is a good test for licensing working.

Re: Publishing ETL Tool Model with Data Interoperability

RenatoSalvaleon3 — Tue, 10 Aug 2021 00:02:14 GMT

@MuratDemircan your original issue on using python to run your ETL tool is attributed to the incorrect Python version that you used. If you are using DI server and you want to run your Spatial ETL with python, use the version that is installed with DI Server located, as shown below in the FME Options dialog. While Data Interop will run Python 2.7 (which is deprecated) for legacy python scripts used in workspaces, it is not recommended.