Open Data download issues

[JimCourson]

I'm having trouble downloading polygon data from Open Data since the latest updates were applied. Three datasets that previously worked now fail to download. In some cases the data gathering completes, then I get "The spreadsheet you requested is currently unavailable". In other cases the data gathering fails with the following message "spreadsheet – An error occurred while processing this dataset". Point data still downloads fine, but polygon data fails. The services work fine outside of Open Data. Any ideas?

[DanielFenton1]

Hi Jim,

Can you please post the datasets you are having issues with?

Thanks,

Daniel Fenton

Product Engineer | Open Data

[ChristopherBoland]

Daniel,

I'm having the same problem with some of my datasets.  In particular, I have had problems with the ones listed below:

• http://geodata.myfwc.com/datasets/4d1b4e758e704def90773bd49806dd4c_6
• http://geodata.myfwc.com/datasets/20ab7447d9424929bf0e7a2a633d6407_3
• http://geodata.myfwc.com/datasets/a78160f5acaf4439b49f9fbef4c100ac_5
• http://geodata.myfwc.com/datasets/bcd7aee1108a4e01b6c9bf32f5cbadbc_8

If I find others, I'll add to the list.

Thanks,

Chris

[DanielFenton1]

Have you tried hitting the reset button in your admin data repor?

[ChristopherBoland]

I hadn't before now, but because the data were not reporting any Errors or Warnings, I didn't think I had to.  It is a little unclear to me what that button is actually supposed to do.

[DanielFenton1]

That’s good feedback.

The button will both drop the download cache and reharvest the dataset. It’s the equivalent of jiggling the handle…as in, it usually works.

[DanielFenton1]

To clarify a bit more:

Sometimes services will fail when requesting data to buid the downloads. This can cause the download process to have issues and never finish generating the cached file. Dropping the download cache via the ‘Resync button’ restarts this process.

We are adding more processing checks to hopefully prevent these intermittent issues from occurring, you’ll see those start to show up very soon. We are also working on alerting you when there are download errors.

[DanielFenton1]

Hey Chris,

The fish management dataset seems to be working fine. Are you still having issues?

Also, this dataset no longer exists: http://geodata.myfwc.com/datasets/a78160f5acaf4439b49f9fbef4c100ac_5

My initial analysis is that the complexity of the features in seagrasses and salt marches are giving us the trouble. I'm continuing to debug locally so we can figure out a solution.

[DanielFenton1]

We've zeroed in a fix for at least: http://geodata.myfwc.com/datasets/4d1b4e758e704def90773bd49806dd4c_6  and should be testing it soon. I'll keep you posted.

[DanielFenton1]

Hey Chris, it looks like this server is failing to execute queries at all now. Did you make any changes to your service?

http://atoll.floridamarine.org/arcgis/rest/services/FWC_GIS/OpenData_MarineEco/MapServer/6/query?whe...

{

• error: {
  • code: -2147209212,
  • message: "Failed to execute query.",
  • details: [ ]
  }

}