Cannot Export All tracks or tracks_view to Feature Class or Table

[mcj5533]

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

[Anonymous User]

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/updateDefinit... 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.

[mcj5533]

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

[Anonymous User]

Yes, it will only update the one property.

[mcj5533]

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

[Anonymous User]

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.