Hello. We are working with spatial views created in MS SQL Server Management Studio. We have linked servers allowing us to retrieve data (e.g., code violations) from other SQL databases and then join these data with parcel information retrieved from our ArcGIS sde SQL database. We then publish the view as AGOL hosted feature service (for public access as we do not have ArcGIS Enterprise/Portal yet). We noticed the published feature service does not honor the record count of the spatial view feature class when the service is published from ArcGIS Pro. If we pull the view into Desktop and publish to AGOL, the record count is honored. Desktop prompts us for a unique ID field during the “drag and drop” into the map frame from Catalog – Pro does not prompt for a unique ID. We are creating a dynamic unique ID attribute in the spatial view query on the server-side to ensure all records are returned.
We don’t understand why publishing from Pro would drop records - which is undesirable. We do not know how to remedy such an occurrence, so we publish from Desktop as a work around. We theorize that multiple records having identical information in each field (e.g., more than one of the same code violations in the same parcel, etc.) are being treated as one record when publishing to AGOL via Pro, ignoring the dynamically calculated unique ID values. We want to show all the code violations, even if they are the same, by parcel. Any thoughts?