topic Re: Error Message : Unable to add Feature Service Definition in ArcGIS Survey123 Questions

Error Message : Unable to add Feature Service Definition

Anonymous User — Sun, 28 Jan 2018 22:55:57 GMT

Help with error message : "Unable to add feature service definition error code: 400". I am able to upload other surveys it is just this one that continues to produce this error. Are you able to help?

Re: Error Message : Unable to add Feature Service Definition

IsmaelChivite — Mon, 29 Jan 2018 04:23:56 GMT

Hi Jonathan. Thanks for sharing the XLSForm. It is always useful to dig into the problem. Rows 35 and 48 in your survey worksheet have exactly the same value in the name column. This causes an error when publishing the survey because a table cannot have two fields with the same name.

Typically, when you type two questions with the same name you will see them highlighted in red indicating that they are repeated. For some reason that escapes me, the yearssinceburnt duplicate is not being highlighted.

Renaming either row 35 or 48 will do the trick. Now, because Connect failed to publish it is most likely that you have a folder in ArcGIS Online as a left over and Connect will fail when you try to publish again. I suggest that after renaming the question, and before you attempt to publish, you go into your ArcGIS Online and completely delete the survey's folder in your Content tab.

Re: Error Message : Unable to add Feature Service Definition

Anonymous User — Mon, 29 Jan 2018 22:52:07 GMT

Ismael,

thank you very much you were right and I apologise that my error was purely a checking problem . I already knew that you weren't allowed to have questions with the same name - just missed it.

The survey is now uploaded and published

cheers

Jonathan

Re: Error Message : Unable to add Feature Service Definition

Anonymous User — Thu, 21 Jun 2018 19:43:34 GMT

Hi Ismael,

I am getting the same error as Jonathan while trying to publish a new survey, but I can not find any duplicate rows in the name column. What else could be causing this issue?

Re: Error Message : Unable to add Feature Service Definition

JoeChampagne — Wed, 10 Jul 2019 18:06:53 GMT

Is it possible to get taller rows or the ability to re-size rows in the publishing window in the desktop app? I was receiving this error and there was feedback apparently visible on which question name was the problem but that feedback was completely unreadable because it didn't fit within its 'Details' cell in that window.

I eventually figured out the issue, but it's a bit of an embarrassing oversight to provide error feedback in the tool itself that can't be read.

Re: Error Message : Unable to add Feature Service Definition

JamesTedrick — Tue, 06 Aug 2019 20:28:41 GMT

Hi Joe,

Thanks for the feedback - I've logged an issue to address this in the future.

Re: Error Message : Unable to add Feature Service Definition

PaulG — Wed, 27 Jan 2021 16:07:50 GMT

Hi @IsmaelChivite , I am experiencing a similar problem. I created questionnaires using an xlsx files. All the 5 surveys are giving me this error when publishing, yet there are no duplicates in the 'name' column. Attached is one of the files.

Am grateful for any assistance.

Paul..

Re: Error Message : Unable to add Feature Service Definition

msevierTPCHD — Fri, 12 Feb 2021 20:38:41 GMT

I am having the exact same issue. I have tried adding new fields/columns to my hosted feature service but it says that "Column names in each table must be unique. ". When I check there are no fields with the same name. I've even checked the service definition and it's not there. In addition I've downloaded the hosted feature service as a file geodatabase and in ArcGIS Pro I can add the new field. So why can I add it in Pro but not in AGO? Why does it see a field that doesn't exist? I've been adding fields to my hosted feature service for months now and this error just started occurring about a week ago. We haven't done anything to our HFS that would be a change that would generate this error. It's only used for managing records/features that are generated in AGO dashboards. I spent a 1.5 hours with an ESRI support tech trying different things. None of which worked.