topic Code 500 Error: Inconsistency in the Field Definitions found in ArcGIS Survey123 Questions

Code 500 Error: Inconsistency in the Field Definitions found

DeonLengton — Mon, 18 Jun 2018 08:36:52 GMT

Publishing the attached survey to a clean, newly installed Portal 10.6 server gives the following error:

The problem seems to lie with changing a select_one field's data type to esriFieldTypeInteger even though the select_one points to integer choice values:

If I don't change the data type or change it to esriFieldTypeString then the publishing error doesn't occur.

The publishing error also does not occur when publishing to AGOL.

Your help will be appreciated.

Re: Code 500 Error: Inconsistency in the Field Definitions found

Anonymous User — Thu, 19 Jul 2018 05:57:39 GMT

Hi Deon,

Select_one question types are text only by design, you can not change them to be integer, hence the mismatch error when trying to publish. If you would like to use calculations and other integer based queries in your survey, you can set the bind type (not esri bind type) to be integer, and that way the app will treat it as an integer, but the data will stored be stored as text in the feature layer.

Phil.

Re: Code 500 Error: Inconsistency in the Field Definitions found

DeonLengton — Thu, 19 Jul 2018 11:56:52 GMT

Hi Philip

Any reason why it works on AGOL but not on a Portal installation then?

Regards

Deon

Re: Code 500 Error: Inconsistency in the Field Definitions found

Anonymous User — Thu, 19 Jul 2018 23:58:54 GMT

Hi Deon,

I am unsure why the difference, however I recommend leaving select_one questions as text fields.

Phil.

Re: Code 500 Error: Inconsistency in the Field Definitions found

Anonymous User — Sat, 22 Sep 2018 05:13:57 GMT

Same issue here. Works in AGOL but not in Portal

Re: Code 500 Error: Inconsistency in the Field Definitions found

DanielYaw_Jr__GISP — Thu, 01 Nov 2018 13:46:23 GMT

Same issue with me as well. ESRI folks - any update?

Re: Code 500 Error: Inconsistency in the Field Definitions found

ZacharyStauber1 — Tue, 02 Apr 2019 18:47:51 GMT

Same error, AGOL yes, Portal no. Survey123 version 3.3.51, Enterprise 10.6.1.

Re: Code 500 Error: Inconsistency in the Field Definitions found

Temple_Digital_DeliveryTeam — Fri, 23 Aug 2019 12:28:23 GMT

Hi All,

I have the same issue, has this been resolved by anyone yet?.

Re: Code 500 Error: Inconsistency in the Field Definitions found

TimLiponis — Mon, 26 Aug 2019 21:48:07 GMT

We encountered a similar issue when dealing with a select_one where we wanted an integer field bounded. The work around we found here was to publish a referenced feature service with the appropriate data type for the respective field and then utilize the submission URL in the survey to publish it to Portal.

Re: Code 500 Error: Inconsistency in the Field Definitions found

AlexLopez-Rogina — Fri, 09 Oct 2020 16:38:25 GMT

Philip Wilson‌ I am using a spreadsheet to create a survey in Connect, and I'm having the same problem. I need two Select_one questions to be numbers for calculations. The schema I received (from someone with Esri Canada) has the esri bind type as Double. Should I leave that one blank and make the blind type decimal? Or set the esri blind type as String as well? Thanks!

Update: Ismael Chivite‌ do you have some insight on this? Thanks!