topic Re: Survey123 publishing error, code: 500 in ArcGIS Survey123 Questions

Survey123 publishing error, code: 500

JustinO_Brien — Tue, 27 Mar 2018 21:25:41 GMT

I'm getting an Error getting result parameter message when attempting to publish new surveys to Portal. I can modify surveys that have already been published, but not create new ones. A folder is created as normal, but the form is absent and the feature layer is corrupt. We just upgraded ArcServer and Portal 10.6. Any insights as to what may be causing the issue would be very helpful, thank you.

Re: Survey123 publishing error, code: 500

JamesTedrick — Tue, 27 Mar 2018 21:42:40 GMT

Hi Justin,

Do your surveys have either questions of type 'start' or 'end'? There is a bug in 10.6 Portal with regards to time settings, which are set when those questions are present. If possible, can you try using the 2.7 beta from the Early Adopter Community- it should be addressed in the next version (or wait a few days, as release will occur shortly).

Re: Survey123 publishing error, code: 500

JustinO_Brien — Tue, 27 Mar 2018 21:47:59 GMT

Hello James,

I just tried to submit a default template form that only contains one text question and got the same error, no time fields were present in the form. We just looked over our permission settings for my account and turned on every option that looked relevant for content creation.

I'll give the beta version a shot, thank you.

Re: Survey123 publishing error, code: 500

JustinO_Brien — Tue, 27 Mar 2018 23:27:10 GMT

No luck with the 2.7.13 beta.

Re: Survey123 publishing error, code: 500

RyanUthoff — Wed, 28 Mar 2018 12:14:42 GMT

After looking in the ArcGIS Server logs, Justin and I get this error message: Instance of the service 'System/PublishingToolsEx.GPServer' crashed.

The only thing that has changed is we upgraded to 10.6 over the weekend. I can't publish a simple survey with only one question.

Re: Survey123 publishing error, code: 500

JamesTedrick — Wed, 28 Mar 2018 15:47:24 GMT

Hi Ryan,

Thanks for the additional information. Can you attempt to publish a zipped shape file or fGDB into a service?

Re: Survey123 publishing error, code: 500

JustinO_Brien — Wed, 28 Mar 2018 16:49:08 GMT

We were able to publish a hosted feature layer from a FGDB that was uploaded to Portal.

Re: Survey123 publishing error, code: 500

JamesTedrick — Wed, 28 Mar 2018 16:54:10 GMT

Interesting... Can I ask you to capture a log file of the publishing process from Survey123? During the publishing process, Connect interacts with the publisher in a couple of places. The log file can be captured by clicking on hte gear button on the initial screen, selecting diagnostics and turning on logging (ignore the 'loading' image - it's representing the availability of interactive consoles).

Re: Survey123 publishing error, code: 500

RyanUthoff — Wed, 28 Mar 2018 17:21:26 GMT

Thank you! Is there a way we can send the log file directly to you? I don't necessarily want to post the log publicly.

I also have the Crash Dump File the ArcGIS Server created from the GP tool when publishing the survey if you need that.

Re: Survey123 publishing error, code: 500

RyanUthoff — Wed, 04 Apr 2018 11:39:04 GMT

Just to update everyone (and to anyone else who might be experiencing this), we have a resolution to this issue. I contacted ESRI technical support and all I had to do was stop and start the PublishingToolsEx geoprocessing service through the ArcGIS Server Admin endpoint.

In my troubleshooting before contacting support or posting on geonet, I restarted the PublishingTools service through server manager, but didn't realize there was another service that is only found through the ArcGIS Server Admin endpoint and not through server manager.

Re: Survey123 publishing error, code: 500

RenatoSalvaleon — Tue, 24 Apr 2018 16:03:32 GMT

Thanks for identifying a workaround but the workaround may not be an ideal solution for our shop with an enterprise portal deployment across different companies.

JTedrick-esristaff , after installing 2.7.72 I published my form and I continue to get the same error. Our Portal is 10.6.1. Any suggestions beside restarting the geoprocessing service?

Re: Survey123 publishing error, code: 500

JamesTedrick — Tue, 24 Apr 2018 16:11:23 GMT

Hi Renato,

First, can I ask that you doubt-check the server version - 10.6.1 is currently under development; the latest release was 10.6 . Aside from the restart Ryan mentioned, we also think there may be a relationship to spectre/meltdown patches for Windows- if those have been applied, please look to apply the ArcGIS Server patch as well; see https://www.esri.com/arcgis-blog/products/product/uncategorized/meltdown-and-spectre-processor-vulnerabilities/ for more info.

Re: Survey123 publishing error, code: 500

MatthewDowning2 — Wed, 11 Jul 2018 20:11:56 GMT

Following these instructions worked for me. Survey123 3.0 and Enterprise 10.6

Re: Survey123 publishing error, code: 500

MirandaMuller1 — Fri, 08 Feb 2019 09:35:17 GMT

I followed these instructions, but I still get the same error. Any further avenues to explore?

Re: Survey123 publishing error, code: 500

GaryBowles1 — Fri, 22 Feb 2019 15:20:54 GMT

James,

I tried to publish a new survey yesterday and received the attached error. It appears to be very similar to this thread. I went to the ArcGIS Server Admin REST endpoint and stopped then started the PublishingToolsEx and the Publishing Tools geoprocessing service.

Portal 10.6

Survey123 Connect 3.2.196

No start or end questions in survey

Thanks,

--gary

Re: Survey123 publishing error, code: 500

ChrisBlinn1 — Fri, 31 May 2019 14:41:58 GMT

Hi James,

I am replicating this issue with beta version 3.5.124 and Portal 10.7.

No start or end questions, but I do have type time. Publishing services have been restarted using Server Admin.

Server Logs only report that the Manage Feature Service failed.

ERROR: Table not found. Failed to execute (Manage Feature Service).

Server Logs only report that the Manage Feature Service failed.

I also see that the feature class and tables from the survey are not being created. Even though that step in the survey publishing appears to have worked. Service is created without any layers/tables.

My survey is large - around 400+ inputs in the survey.

*** UPDATE ***

I was about to post the above when I thought of testing this. I removed 300+ inputs from my survey (easy to do with my survey containing many groups - I simply cut/paste them to an excel file). I then successfully published the survey. Because my service was created, I then copied back in the 300+ inputs I originally removed, and republished the survey, selecting the option to add all of the new fields to my existing service. It's been about 1 hour and it's still on this action:

I cancelled that process, closed Survey123 Connect, reopened, removed 200+ of the 300+ inputs I tried to add, and started the process again. No improvement. So perhaps it is a limitation in survey size, however I doubt that is a Survey123 limitation vs. an ArcGIS Server limitation like heap size or something of the likes.

I'll continue testing to see if I can get more inputs added.

Thanks,

Chris B.

Re: Survey123 publishing error, code: 500

JordanMiller4 — Fri, 31 May 2019 15:23:09 GMT

I would try stopping and restarting the feature service in server manager. This often fixes our fairly large forms when we're doing multiple updates.

Re: Survey123 publishing error, code: 500

ChrisBlinn1 — Fri, 31 May 2019 17:12:22 GMT

Thanks, Jordan. My services are hosted in the data store, so I have to stop them via the REST Admin page. This did not seem to help however.

Re: Survey123 publishing error, code: 500

RyanUthoff — Fri, 31 May 2019 18:02:32 GMT

One thing that we have to do is restart the ArcGIS Data Store Windows service in order to publish/republish Survey123 forms. We constantly have to do that. I don't know what's causing it to hang up where we have to restart the entire service, but that always fixes our problems.

Re: Survey123 publishing error, code: 500

ChrisBlinn1 — Mon, 03 Jun 2019 14:00:57 GMT

Thanks, Ryan. Unfortunately I still cannot update my Survey. I am now down to just adding 16 new fields, and it just hangs on this screen: