topic Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_" in ArcGIS Survey123 Questions

Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

MikePordes1 — Wed, 09 Jan 2019 20:51:10 GMT

we are getting an error when uploading. repeating the same survey content works.

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

Anonymous User — Wed, 09 Jan 2019 21:12:49 GMT

Hi Mike,

How did you create your survey, via Survey123 Connect, if so what version and what version of the field app are you using? Can you share a copy of your survey form xlsx file and any external files in media folder so we can take a closer look.

Regards,

Phil.

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

MikePordes1 — Wed, 09 Jan 2019 21:39:47 GMT

I can, would it be ok through email? what is your email?

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

Anonymous User — Wed, 09 Jan 2019 21:43:18 GMT

I have just sent you a private message with my email details.

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

Anonymous User — Thu, 10 Jan 2019 04:11:30 GMT

Hi Mike,

Thanks for sharing your survey. I have published the survey xlsx form you provided to AGO and have tested submitted surveys to the feature layer with iPhone X running iOS 12.1.2 and also with Windows 10 and Android 8.0. With all these platforms I can submit successfully based on your xlsx form and the current 3.1 release version of the app. I also tested with our 3.2 beta version and that is working fine too.

Therefore I can not replicate your error, can you try and uninstall and reinstall the app again, download the survey and then submit on the same iOS device.

Does this happen on any other devices, either iOS or Android or Windows?

Phil.

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

MikePordes1 — Thu, 10 Jan 2019 04:36:28 GMT

Philip,

We have 3 surveys that won’t submit.

What happens when we uninstall the app? Do we lose those drafts?

What is the error message telling us?

Mike

Sent from my iPhone

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

Anonymous User — Thu, 10 Jan 2019 04:45:59 GMT

The error message is actually being returned by the server, and as I can not replicate it I am unsure why it is happening.

Yes you are right, if you uninstall the app on an iOS device, the existing surveys and data will be lost, the sqlite db is deleted. However if you follow these instructions you can back up the survey sqlite database and send it from another device (or Windows desktop machine) or after the update of the app on the device copy the sqlite db back to the same iOS device and try to send again: Troubleshoot—Survey123 for ArcGIS | ArcGIS

Hope this helps.

Phil.

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

MikePordes1 — Thu, 10 Jan 2019 04:56:52 GMT

Philip,

Sure but doesn’t the server have specific error / log outputs that we can be recognized? (Y’all wrote the code)

Have you tried this copy and paste exercise before?

Mike

Sent from my iPhone

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

Anonymous User — Thu, 10 Jan 2019 05:22:08 GMT

What do you mean exactly by copy and paste exercise? Creating a new survey and feature service by copy and pasting the xlsx information to new survey and publishing? Or do you mean copy the data off the device and sending from another device with an updated copy of the survey. In both cases yes and both work well.

Phil.

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

Anonymous User — Thu, 10 Jan 2019 05:25:43 GMT

And the server message appears to be a default SQL Server error message, unsure why the sever would return this when trying to submit. More info can be found here: SQL Server Helper

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

MikePordes1 — Thu, 10 Jan 2019 05:26:16 GMT

copy the data off the device and sending from another device with an updated copy of the survey

Sent from my iPhone

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

Anonymous User — Thu, 10 Jan 2019 05:27:58 GMT

Yes, have done this process many times successfully, and we also know of many customers that have followed the steps outlined and successfully recovered their data from devices that are unable to send surveys, and then sent them from their desktop or a different device.

Phil.

Re: Send Error Must declare scalar variable "@W10" "@_NewFeatureID_"

MikePordes1 — Thu, 10 Jan 2019 05:53:16 GMT

Sounds good, thank you. Will be in touch once get it working.

Sent from my iPhone