topic Re: Publishing Error - Code 500 - Dataset not found in ArcGIS Survey123 Questions

Publishing Error - Code 500 - Dataset not found

AlexandrePrado — Wed, 31 Oct 2018 21:17:34 GMT

Hello!

So I have been trying to publish a form (attached below) that I created in Survey123 Connect to our ArcGIS Portal, but show me this error code 500: Dataset not found. I don´t know why!!!

I have attached the excel spreadsheet as well.

Any help would be most appreciated.

Re: Publishing Error - Code 500 - Dataset not found

megan_r — Thu, 01 Nov 2018 16:06:43 GMT

Hello, Alexandre!

I downloaded the XLS document you provided, opened Survey123 Connect, and created a new survey from that file and I was able to publish the service. Is your Portal federated with your Server? If so, we should try checking the Server Logs in server manager to see if they provide a more detailed error message. Check out some documentation below about accessing the server logs if you need any additional assistance on that:

You will also want to verify that your Portal account has the permissions to create feature services in your Portal Organization. Log into your Portal account in a browser and view your profile to see what 'Role' and 'Level' are assigned to your account.

Levels, roles, and privileges—Portal for ArcGIS (10.6) | ArcGIS Enterprise

Re: Publishing Error - Code 500 - Dataset not found

Jay_Gregory — Tue, 17 Sep 2019 21:03:14 GMT

Any solution to this Alexandre Prado‌? I'm getting the same errors you are, except using the Survey123 website (with my Portal).

Re: Publishing Error - Code 500 - Dataset not found

JamesTedrick — Thu, 19 Sep 2019 21:51:49 GMT

Hi Jay,

It is probably best to log this with Esri Support to determine what the problem is. In most cases where this type of error occurs, there is an issue with the Portal timing out or otherwise not providing the expected response to teh creation of the feature class.

Re: Publishing Error - Code 500 - Dataset not found

Juan_JoséPino_Povedano — Wed, 20 Nov 2019 12:12:54 GMT

Any suggestion about that issue, I´ve the same problem when I try to publish. I try to publish with Admin Role and Publishing (with extra grants) Role and It sent the same message.

Regards

Re: Publishing Error - Code 500 - Dataset not found

Amanda__Huber — Mon, 09 Dec 2019 22:27:19 GMT

I also am running into this error message with Survey 123 3.7.6 and Portal 10.7.1

We've opened an Esri case regarding it (case #02455902) and hopefully can determine the issue.

Re: Publishing Error - Code 500 - Dataset not found

JamesTedrick — Tue, 10 Dec 2019 18:33:58 GMT

Hi Amanda,

The 'Unable to create folder' occurs when a previous publishing attempt has created a folder and is not cleared out. The 'Dataset not found' error is an issue with the ArcGIS Data Store component of your ArcGIS Enterprise deployment; one cause for this is if the Data Store has been placed in read-only mode. Otherwise, examining the Data Store and ArcGIS Server's logs should identify the issue.

Re: Publishing Error - Code 500 - Dataset not found

Amanda__Huber — Tue, 10 Dec 2019 22:23:55 GMT

Hi James,

Thanks so much for the reply. It did appear to be an read-only mode issue and the issue has been resolved.

That being said we're further investigating why the data store was placed in a read-only mode since we have not recently run out of space, but in the mean time S123 can successfully publish data.

Thanks again!

Re: Publishing Error - Code 500 - Dataset not found

EricAnderson_DHS — Thu, 10 Dec 2020 17:20:39 GMT

To help anyone else seeing this error, we got the same 500 "Dataset not found" error with the latest version of Survey123 Connect (3.11.123) and publishing to Portal 10.8.1. We found the XLSX had a reserved field name - "current_date". The XLSX does spit back an error when adding a field with a reserved name, so I understand this maybe a tough ask to classify this as a bug, but possibly the error messaging could be improved?

Thanks!

@JamesTedrick

Re: Publishing Error - Code 500 - Dataset not found

Henry — Wed, 10 Feb 2021 17:29:21 GMT

Hi EricA, I believe I'm having that same issue - specifically with the XLSX Advanced Form Template. Publishing from older forms that don't have the reserved name sheet works fine.

What was your workaround? I couldn't find anything else in my form schema that references the "current_date" reserved field name. Although its possible there's another field unfortunately . . . Is there a recommended method for trawling through the list of reserved names and comparing the two to make sure there's no conflicts? Would simply removing the reserved name datasheet work in the interim?

Thank you,

Henry

Re: Publishing Error - Code 500 - Dataset not found

EricAnderson_DHS — Wed, 10 Feb 2021 17:34:45 GMT

Hey @Henry ,

Yeah "current_date" was just a particular reserved field name that we were using, but there's obviously a lot more than that. If you're using the latest version of Survey123 Connect there should be a sheet in there with the list of reserved field names, and if you're savvy enough with Excel, you can probably do some type of lookup function.

It's funny you bring this up because I just published a new survey earlier this week with the field name "current_date" (guess i completely forgot about this post) and it automatically changed it to "_current_date". This was publishing from Connect v. 3.11.123 to Portal 10.8.1.

Re: Publishing Error - Code 500 - Dataset not found

AndrewSouthern — Mon, 18 Oct 2021 20:42:38 GMT

EricA,

Thank you for this advise as it helped lead me to my problem. I wasn't using a reserved word for a field name, but noticed that I had used the same name for multiple note fields. XLS didn't flag the error, and I don't often use notes in survey designs, so I didn't realize that notes style "questions" are included in the table schema and therefore must follow the same rules as far as not being duplicated. I have attached a screen grab of the XLS that shows the two note fields with same names not flagged red, and two other question types with same name that are flagged as red as a comparison.

Thanks again.

Re: Publishing Error - Code 500 - Dataset not found

EricAnderson_DHS — Thu, 03 Feb 2022 16:32:46 GMT

Thanks @AndrewSouthern ! My team just hit this 500 "Dataset not found" error again in Survey123 Connect 3.13.251 and your comment saved us. There were duplicate field names in the survey form.

@JamesTedrick - Is the product team still planning on fixing this error?? Or make the error more descriptive to the actual issue.