topic Re: Cannot Export All tracks or tracks_view to Feature Class or Table in ArcGIS Tracker Questions

Cannot Export All tracks or tracks_view to Feature Class or Table

mcj5533 — Thu, 18 Jun 2020 12:25:44 GMT

I am trying to export all of the location tracks and one of my track views to a GDB Feature Class and table using ArcGIS Pro. In each case only 32,001 features/records are returned out of ~400K or ~300K respectively. The reason for doing this is that we want to use non-ESRI tools to interrogate the data (Power BI). I have a support case open with ESRI right now that was just escalated today (#02571392). Just wanted to throw this out to the community to see if anyone else is having this issue and knows of a solution.

Thanks,

Matt

Re: Cannot Export All tracks or tracks_view to Feature Class or Table

Anonymous User — Thu, 18 Jun 2020 13:05:07 GMT

This is due to the maxResultWindow property of the the tracks layer on ArcGIS Enterprise. If you go to the admin REST API for the layer you can increase this value.

Go to https://server.com/server/rest/admin/services/Hosted/location_tracking/FeatureServer/0/updateDefinition and increase it to more than the number of tracks you have.

{
"maxResultWindow": 5000000
}

It limits the number of objects returned in Elastic Search which effects the paging that the tool you are using likely uses.

Re: Cannot Export All tracks or tracks_view to Feature Class or Table

mcj5533 — Thu, 18 Jun 2020 14:08:47 GMT

There is nothing currently in the Input box. Should I just add in the parameter you have listed?

Re: Cannot Export All tracks or tracks_view to Feature Class or Table

Anonymous User — Thu, 18 Jun 2020 14:14:27 GMT

Yes, it will only update the one property.

Re: Cannot Export All tracks or tracks_view to Feature Class or Table

mcj5533 — Thu, 18 Jun 2020 15:06:25 GMT

That did the trick. I made the update on the main tracks service and now both 'tracks' and 'tracks_view' export. Appreciate the help! May want to do some coaching with front line tech support.

Thanks,

Matt

Re: Cannot Export All tracks or tracks_view to Feature Class or Table

Anonymous User — Thu, 18 Jun 2020 17:22:35 GMT

That's great. After the export is completed, you should revert that setting back to 32,001. If you leave it at a large number, you may suffer performance and stability issues when multiple queries are executed that result in a large number of features being returned.