topic Survey123 error code 1000 in ArcGIS Survey123 Questions

Survey123 error code 1000

German_DarioGalvis — Mon, 04 Sep 2017 14:27:42 GMT

Hello

I am getting this error when I try to send a completed survey. It says "cannot insert duplicate key row in object" when I send a survey even confirming that the internet is OK, the session in the application closes automatically and I have to log in again, when this happens sometimes some surveys are lost and other times they are saved in the outbox. What could be the possible cause of this error? I attach the form that presents this error

Re: Survey123 error code 1000

Anonymous User — Mon, 04 Sep 2017 22:27:15 GMT

Hi Dario,

Could you provide a little more information:

1. What version of Survey123 Connect and App are you using?

2. Are you using ArcGIS Online or Portal?

3. Was the feature service created by Connect, or are you using an existing feature service?

4. Do you get this error when submitting newly collected features, or when using the Inbox to edit surveys?

Regards,

Phil.

Re: Survey123 error code 1000

German_DarioGalvis — Thu, 07 Sep 2017 16:33:36 GMT

Hello

1. I'm using the last version of Survey123

2. I'm using ArcGIS Online

3. The feature service was created using Connect

4. The error happens when trying to upload a survey saved in the outbox

Re: Survey123 error code 1000

TonyDaSilva1 — Wed, 20 Sep 2017 17:29:37 GMT

We are also getting this error on multiple forms with multiple users. They attempt to upload their data and then get the error. Upon investigation, the data has loaded the row but not the attachment. The only way to resolve the issue from the device is to submit the form as a new point creating duplicates. Please submit this as a bug and fix this.

Re: Survey123 error code 1000

JamesTedrick — Wed, 20 Sep 2017 17:42:13 GMT

Hi there,

With the 2.4 release of Survey123, we have addressed the primary cause of this problem - surveys data will not be submitted to the feature layer until attachments have been successfully submitted.

Re: Survey123 error code 1000

KingbrookRural_Water_System — Thu, 19 Oct 2017 14:08:43 GMT

Hi James,

We are still experiencing the same error. We are using the newest version of Survey 123. Below is what happened.

(1) This error occurred when we used a "laptop" and used a "Sent" survey.

(2) The program asked what we would like to do. Below shows the options. (I tried both options, and errors occurred in both cases.)

(3) I got in to our "sent survey" and made modification. Once I completed my update and I chose to "Send Now", below error message showed up.

Any thoughts on the causes for this error?

Thanks,

Derek

Re: Survey123 error code 1000

JamesTedrick — Fri, 20 Oct 2017 21:42:40 GMT

Hi,

The error that I mentioned was being addressed in 2.4 is the second issue mentioned in this thread, regarding attachment submissions.

Can you provide any more guidance on how your surveys and submission workflows are set up? Is this happening on every submission attempt, or occasionally? If the latter, what are the conditions that lead to it?

Re: Survey123 error code 1000

AlexNguepkap_Lemegne — Thu, 22 Feb 2018 04:46:02 GMT

Hi, I am having the same problem with my Survey.

I collected all the thd on the field, then when I am trying to send It on the web, "Erreur d'envoi Code 1000, incorrect syntax near '-' must declare the scalar variable "@nom_ecole_Menfoung"

Please how can I fix this problem without loose my data?

URGENCE PLEASE

Re: Survey123 error code 1000

JamesTedrick — Thu, 22 Feb 2018 20:36:30 GMT

Hi Alex,

Though the error code is the same (code 1000 translates to an issue writing the data into the database), the exact cause appears to be different (based on the message). In order to debug, it would be helpful to have more details - could you share the XLSX form, along with sample data that you were trying to submit that causes this error? Is this using ArcGIS Online hosted feature services, ArcGIS Enterprise hosted feature services, or an enterprise geodatabase (default is the first option)?

James

Re: Survey123 error code 1000

AlexNguepkap_Lemegne — Fri, 23 Feb 2018 05:55:59 GMT

Hi James.

this is the XLSX form that I am using, and even and sqlite file that i am triying to use to extract my data.

Re: Survey123 error code 1000

LynnBerni — Thu, 05 Apr 2018 22:45:20 GMT

Hi James,

I'm having a similar problem on a survey created with Survey123 Connect v2.6.6. Multiple forms were successfully sent this morning, but one from this afternoon is stuck in the outbox with Send Error Code 1000. I'm not the one filling out the surveys, so I'm not exactly sure what they might have done differently.

Thanks!
Lynn

Re: Survey123 error code 1000

Ohan — Mon, 25 Jun 2018 13:03:26 GMT

Hello,

Was this problem solved ? i am facing a similar problem when submitting the survey.

Re: Survey123 error code 1000

ChrisYoung2 — Tue, 13 Nov 2018 14:59:38 GMT

I am also having this same problem. I have been using the same form for about two months and only now encountered this problem. All my data is on an i-Pad, and I don't want to have to go repeat getting all the data. Any ideas how to get save the data I have collected?

Re: Survey123 error code 1000

BrandonArmstrong — Tue, 13 Nov 2018 17:22:24 GMT

Hi Chris,

Can you give more details related to the error that you are encountering (refer to the questions that were asked to others in previous comments within this thread)? Also, if you are able to share your XLSForm it might be helpful.

Thanks,

Brandon

Re: Survey123 error code 1000

ChrisYoung2 — Tue, 13 Nov 2018 17:53:44 GMT

Hi Brandon,

So the weird part about this is that even though I got an error message, it seems to have loaded the data onto the Survey 123 online site. At least from a preliminary look it is there. From the error message (attached picture) it seems I had duplicate key value. The XLSForm has not changed since I started using this in the beginning of October.

I know all of you folks at ESRI are working to make these apps better work smoother, but it gets frustrating for us when we spend a day out in the field and then look at a glitch in the system which makes it difficult for us to then use the data we have collected. I’ve had to redesign the general form I took this from twice in the past 5 months to allow for changes made in the software. Any way to introduce an update and have the old version usable as a back-up?

Thanks

Chris

An Accredited land trust

Chris Young

Conservation Easement Stewardship Associate

Columbia Land Conservancy

49 Main Street

Chatham, NY 12037

518.392.5252 ext. 221

chris.young@clctrust.org<mailto:chris.young@clctrust.org>

www.clctrust.org

Conserving rural landscapes.

Connecting people to the land.

Re: Survey123 error code 1000

BrandonArmstrong — Tue, 13 Nov 2018 21:28:42 GMT

Thank you for sharing the XLSForm and screenshot, Chris. I am currently looking into this further and will provide an update after investigation.

Best,

Brandon

Re: Survey123 error code 1000

Raefnabil — Wed, 14 Nov 2018 22:33:11 GMT

I have the same problem here but with different error ,this issue appeared from almost one week .

Re: Survey123 error code 1000

BrandonArmstrong — Thu, 15 Nov 2018 23:32:51 GMT

Hi Chris,

To share the information that we discussed offline, the reason for the issues that you are encountering is related to the usage of v. 2.8 of the field app. As your survey contains nested repeats (began support at v. 3.0), you will need to use v. 3.0 or later of the field app in order to submit without hiccups.

If you continue to encounter issues after attempting to submit with v.3.0 or later of the field app, please let us know.

Best Regards,

Brandon