https://community.esri.com/t5/arcgis-enterprise-questions/web-tool-data-query-not-pulling-all-records/m-p/1377316#M38436 <P>I have published a model from ArcPro to ArcGIS Portal as a web tool. I am accessing the web tool from a simple Web AppBuilder map using the out of the box geoprocessing widget. The inputs to the tool are two arcgis rest services, a feature class of unique points and a related table with multiple records per point. They are related by a global id.&nbsp;The user chooses an input point and the tool pulls the related records and creates a table view as a result, which the user can then download as a csv file if they wish.</P><P>The tool/model performs fine in ArcPro but when used as a web tool it only returns some of the related records, though everything seems to be functioning successfully otherwise. For example, if there are 4 records, it returns only 2 but no other errors that I can see. The dataset is not large (3000 records or so). I have bumped up the wait time on the service and I have increased the number of records returned in Server Manager but neither of those things helped.&nbsp;<BR /><BR />Any ideas why this is happening and what changes could be implemented to return all data records?</P><P>Thanks for any help.</P> Thu, 01 Feb 2024 21:42:04 GMT EMiller_2 2024-02-01T21:42:04Z https://community.esri.com/t5/arcgis-enterprise-questions/web-tool-data-query-not-pulling-all-records/m-p/1377316#M38436 <P>I have published a model from ArcPro to ArcGIS Portal as a web tool. I am accessing the web tool from a simple Web AppBuilder map using the out of the box geoprocessing widget. The inputs to the tool are two arcgis rest services, a feature class of unique points and a related table with multiple records per point. They are related by a global id.&nbsp;The user chooses an input point and the tool pulls the related records and creates a table view as a result, which the user can then download as a csv file if they wish.</P><P>The tool/model performs fine in ArcPro but when used as a web tool it only returns some of the related records, though everything seems to be functioning successfully otherwise. For example, if there are 4 records, it returns only 2 but no other errors that I can see. The dataset is not large (3000 records or so). I have bumped up the wait time on the service and I have increased the number of records returned in Server Manager but neither of those things helped.&nbsp;<BR /><BR />Any ideas why this is happening and what changes could be implemented to return all data records?</P><P>Thanks for any help.</P> Thu, 01 Feb 2024 21:42:04 GMT https://community.esri.com/t5/arcgis-enterprise-questions/web-tool-data-query-not-pulling-all-records/m-p/1377316#M38436 EMiller_2 2024-02-01T21:42:04Z