Solved

Download ArcGIS Online Feature Service to File Geodatabase Fails

  • 11 September 2017
  • 4 replies
  • 22 views
R

I have an ARCGISONLINEFEATURES reader that correctly reads in the features from my feature service hosted on ArcGIS Online. I can successfully write the feature service to an Esri Shapefile, but I cannot write it to an Esri File Geodatabase. I get the generic error "Error running translation" and Windows returns and error message saying "FME EXE has stopped working" (though FME workbench still remains open). I have tried changing several of the writer's parameters to try and get the download working, including overwriting the database, dropping the table, specifying the exact schema, and setting the attribution definition to automatic. None of these changes have worked. I also tried downloading the File Geodatabase from ArcGIS Online directly and then having the writer simply truncate the table of the identical geodatabase I downloaded, and it still throws an error. I was able to get the workflow to process all the way through a few times, but it was never successful; the only time it was able to run through without crashing it stated that a dataset was not set, even though it was.

icon

Best answer by fmelizard 13 September 2017, 22:13

View original

4 replies

mygis
Badge +8

Hi @mbradbury,could you please share with us your workspace and please let us know which version are you using.

Thank

Lyes

R

Hi @mbradbury,could you please share with us your workspace and please let us know which version are you using.

Thank

Lyes

I'm using FME Workbench v2017.1.0.0 build 17539.

 

 

I don't have a working workspace, so I'm not sure which one to share. I've even tried just zipping the output to a GDB, but I'm unaware of how that would be done properly. I tried using the methods on this post, but it still fails. I can get it to download the data to a shapefile, so I know it's not a problem with the reader or access to ArcGIS Online, so the issue has to be with the writer. Is there a post that outlines exactly how to setup to write to a file geodatabase? I've been able to write to a number of other formats no problem, but I just can't get File Geodatabases to work.
fmelizard
Rank
Userlevel 4
Badge +13
Hi @mbradbury,

 

To me it sounds like either a problem with the install OR a bug. Your fme.exe process shouldn't be crashing, not good to hear :-(. If it was a problem with your configuration then we would expect a bit more of an error in your log file not a crash like this

Here are a few things which I would try to help to isolate the issue by ruling things out, once the issue is isolated we can try and fix the crash, either way it's not good to hear!

  • Will the workflow work work with the other File Geodatabase writer (FILGDB)
  • You mentioned that you were able to write your data to a shapefile, are you able to write the data from the shape into file geodatabase with FME?
  • Can you write any data to an ESRI Geodatabase?
    • Try out this Workspace (data included in the .fmwt) all you need to do is open it an run it. If you get the same crash again then something is likely up with your install.

Follow these steps to reinstall FME: https://knowledge.safe.com/articles/962/re-installing-fme-if-there-is-a-problem-with-the-i.html

If you can run the workspace from above then it's possible there is something in the data from ArcGIS online which the ESRI Geodatabase writer isn't liking. In this case please contact support@safe.com and include the link to this discussion. We would need a copy of the source data or a link to the feature service causing the problem.

R
Hi @mbradbury,

 

To me it sounds like either a problem with the install OR a bug. Your fme.exe process shouldn't be crashing, not good to hear :-(. If it was a problem with your configuration then we would expect a bit more of an error in your log file not a crash like this

Here are a few things which I would try to help to isolate the issue by ruling things out, once the issue is isolated we can try and fix the crash, either way it's not good to hear!

  • Will the workflow work work with the other File Geodatabase writer (FILGDB)
  • You mentioned that you were able to write your data to a shapefile, are you able to write the data from the shape into file geodatabase with FME?
  • Can you write any data to an ESRI Geodatabase?
    • Try out this Workspace (data included in the .fmwt) all you need to do is open it an run it. If you get the same crash again then something is likely up with your install.

Follow these steps to reinstall FME: https://knowledge.safe.com/articles/962/re-installing-fme-if-there-is-a-problem-with-the-i.html

If you can run the workspace from above then it's possible there is something in the data from ArcGIS online which the ESRI Geodatabase writer isn't liking. In this case please contact support@safe.com and include the link to this discussion. We would need a copy of the source data or a link to the feature service causing the problem.

Here's the error I'm getting. This is a shapefile reader from a working shapefile with just a regular file geodatabase writer. It runs for a bit before hitting the file geodatabase and FME.exe stops working. ArcGIS 10.5.1 Advanced is installed on the same server.

 

 

I couldn't find any other geodatabase writer other than the one's called out for other uses (Open API, and Raster Datasets).

 

 

I ran the template you gave me, and it failed at the same place as my other attempts.

 

 

I have also noted that FME.exe will crash if connection to AGOL stutters, and I'd say the connection to AGOL is stable about 80% of the time.

Reply


Community Stats

28,710
Posts
109,486
Replies
36,559
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.