Latest Contributions by EmilySangster2

‎01-02-2019

Hi Andrew, The database is SQL and the record count error only occurs with one table that is in a relationship class with a feature class that has several relationships to other tables. The relationships are set up with the same parameters but only one table had an issue where a foreign key was deleted. Editing of this field was also restricted so I know field staff weren’t deleting them. I tried increasing the record count to 10,000 as a test to see if it would resolve the issue and the error continued. The total number of records in the database was 3,500 so I thought 10,000 would cover it if that was the issue. There were coded value domains in the feature class and table. The max number under the parameters is set to 25,000 which is the default. Does the 25,000 relate to the different domains in the database or all of the possible values of all of the domains? The error occurred when viewing the data in AGOL in a web map and when data was viewed in the Collector app. Cheers, Emily Sangster, Adv. Dip. | GIS Mapping Technician McElhanney Consulting Services Ltd. D 604 424 4847 | T 604 683 8521 esangster@mcelhanney.com<mailto:esangster@mcelhanney.com>

‎01-02-2019

Hi Michael, All the features involved in the relationship including the tables were stored in one geodatabase and performed as expected when tested through ArcMap. They were set up as 1:M with no message sent between feature classes. I guessed the relationships might be the issue only because it was my first time using them in the Collector app. Cheers, Emily

‎01-02-2019

Hi Joe, I didn't resolve it! I was using feature classes with relationships to non spatial tables in the Collector app. I'm not sure but I suspect the issue was related to how I had set up those relationships. The error would appear when viewing the feature service in AGOL as well as when it was viewed in the collector app. It didn't cause any errors on the field users side when they collected data and synced but a foreign key was being removed from one table and I thought the count error might have been related to that. I did have the search function enabled on the web map in AGOL so perhaps the errors are similar? I didn't use any custom search widgets. Cheers, Emily

‎08-03-2018

Hi John, My survey does contain a related table. I'll have to give it another try once we have an upgraded server. Thanks for your help! Emily

‎08-02-2018

Hi John, After posting this I realized the feature service was hosted as I had added it to ArcGIS online incorrectly. I was able to add it correctly as an item and create a survey from it but I did get the error while publishing related to the ApplyEditsWithGlobalIds requirement. I tried downgrading survey123 Connect to the classic version and received the same error when publishing. Is there any way that it can be done or does ArcGIS server need to be updated first? The version of the field app is 3.0.134 and not 3.1.68. Cheers, Emily

‎07-27-2018

Hello, I've followed the documentation for creating a Survey123 survey using an existing feature service (https://community.esri.com/groups/survey123/blog/2017/09/25/working-with-existing-feature-services-in-survey123-for-arcgis ) and am having two main issues. I am unable to see the data collected in the survey in the SQL enterprise database and I am also unable to get the photo attachments collected in the survey in the child table to appear. My general work flow was as follows: Created two layers which have a one to many relationship which is using the parent global ID as a foreign key in the child table Enabled archiving on both tables and enabled attachments on the child table Published layers as a service with feature access and sync enabled Added the feature service as an item to our companies ArcGIS online account Created a new survey in Survey123 Connect version 3.0.127 using the existing feature service Published and collected sample data I am using the following: ArcMap 10.5.1 ArcGIS for Server 10.3.1 SQL Server 2012 Survey123 Connect 3.0.127 Survey123 for Android 3.1.68 Any tips would be greatly appreciated! Thanks for your time Emily

‎07-19-2018

I have a service which is displaying the following error on our ArcGIS server log: MaxRecordCount limit reached; ignoring any remaining objects in the query result for Table: Asset Existing Deficiencies. The service has a max record count in the parameters set to be 10,000 and the total number of records in the tables in the service adds up to 3,500. Is there anything else that could be causing this error?

Online Status	Offline
Date Last Visited	‎11-11-2020 02:25 AM

My Ideas

Latest Contributions by EmilySangster2

Re: Max record count error for service error

Re: Max record count error for service error

Re: Max record count error for service error

Re: Survey data appears in feature service but not enterprise database

Re: Survey data appears in feature service but not enterprise database

Survey data appears in feature service but not enterprise database

Max record count error for service error

Max record count error for service error

Re: Survey data appears in feature service but not...