topic Re: Error Code 1000 in ArcGIS Survey123 Questions

Error Code 1000

alyssajhnsn — Mon, 22 Jul 2024 21:11:53 GMT

I have a survey that is generating a code 1000 upon submission ([{"id":0,"addResults":[{"objectId":-1,"uniqueId":-1,"globalId":"{2DE2588F-5933-4E14-8CD4-A1B0058C11E0}","success":false,"error":{"code":1000,"description":"Incorrect syntax near '-'.\r\nMust declare the scalar variable \"@clean\".\r\nMust declare the scalar variable \"@_NewFeatureID_\"."}}]}])

I tried republishing and the error is still occuring.

I tried checking for syntax errors, but I'm inexperienced and don't see any.

Any help would be appreciated. The XLSform is attached.

Re: Error Code 1000

DougBrowning — Mon, 22 Jul 2024 21:27:39 GMT

Looks like your label column has a ton of word wraps. This often happens when you copy paste from somewhere. You have to make sure to use Paste - Values in 123. Looks like you may have copied formulas for clean-ups field also.

In Excel right click the column and pick Format Cells, then Alignment tab and check Work Wrap. You will see them jump out at you right away as seen below. Go in and delete the extra lines. (note you wont see a change until you move away then you will see it change like on the first line below. It is trying to make field Alias with \n is the problem.

Got to be very careful in a 123 Excel sheet and break the habit of Ctrl-C, Ctrl-V. It has a ton of formulas in it and cannot be used like a regular Excel sheet.

Some of these are warning you there is an issue.

That should fix it I think.

Re: Error Code 1000

alyssajhnsn — Fri, 26 Jul 2024 18:36:24 GMT

I can see the flags, but when I go and check I don't see word wrap enabled?

Re: Error Code 1000

alyssajhnsn — Fri, 26 Jul 2024 18:53:20 GMT

I found the error - I had a hyphen instead of an underscore in the type name.