topic Re: How do I correct completed survey form sending error in survey123 in ArcGIS Survey123 Questions

How do I correct completed survey form sending error in survey123

NDA-GISGhana — Sun, 09 Jul 2017 19:24:13 GMT

Please I successfully published my xlsform in survey123 connect but when I download the form and pick survey data I am getting error which state:

'Send Error'

"This survey was not able to be sent due to the following error:

Code 1000

Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.

Please I have attached a screen shot of the error. Thank you.

Re: How do I correct completed survey form sending error in survey123

JohnathanHasthorpe — Mon, 10 Jul 2017 00:58:39 GMT

Hi - are you able to share your survey? Additionally, are you using Portal for ArcGIS (if so which version) or ArcGIS Online. Thanks

Re: How do I correct completed survey form sending error in survey123

NDA-GISGhana — Tue, 11 Jul 2017 06:15:24 GMT

Yes please. I have been able to share my survey. I am using ArcGIS Online.

Thank you.

Re: How do I correct completed survey form sending error in survey123

JohnathanHasthorpe — Wed, 12 Jul 2017 01:31:40 GMT

Can you add the survey xls as an attachment to this thread? Thanks

Re: How do I correct completed survey form sending error in survey123

SteveOchieng — Fri, 18 Jan 2019 07:20:27 GMT

I have a similar issue and here is a snippet of the logs

<15>1 2019-01-18T06:36:08Z localhost Survey123forArcGIS 25361 - [AppStudio@11205 category="qml" function="onSuccess" filename="XFormFeatureService.qml" line="726"] qml: applyEdits:errors: [
{
"code": 1000,
"description": "Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.",
"tableId": 0
}
]
<15>1 2019-01-18T06:36:08Z localhost Survey123forArcGIS 25361 - [AppStudio@11205 category="qml" function="onFailed" filename="SubmitSurveysPage.qml" line="351"] qml: Feature service error: [
{
"code": 1000,
"description": "Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.",
"tableId": 0
}
]
<15>1 2019-01-18T06:36:08Z localhost Survey123forArcGIS 25361 - [AppStudio@11205 category="qml" function="" filename="XFormsDatabase.qml" line="363"] qml: updateStatus: {
"rowsAffected": 1,
"insertId": "",
"rows": {}
}
<15>1 2019-01-18T06:36:08Z localhost Survey123forArcGIS 25361 - [AppStudio@11205 category="qml" function="onFeatureServiceInfoChanged" filename="XFormFeatureService.qml" line="936"] qml: featureServiceInfo: null
<15>1 2019-01-18T06:36:08Z localhost Survey123forArcGIS 25361 - [AppStudio@11205 category="qml" function="update" filename="FilteredListModel.qml" line="62"] qml: Empty filterText
<12>1 2019-01-18T06:36:08Z localhost Survey123forArcGIS 25361 - [AppStudio@11205 category="default" filename="XFormWebhooks.qml" line="102"] qrc:/qml/XForms/XFormWebhooks.qml:102: TypeError: Cannot read property 'itemId' of null
<15>1 2019-01-18T06:36:12Z localhost Survey123forArcGIS 25361 - [AppStudio@11205 category="qml" function="editSubmitError" filename="SurveysListPage.qml" line="622"] qml: error: {
"code": 1000,
"description": "Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.",
"tableId": 0
}
<15>1 2019-01-18T06:36:22Z localhost Survey123forArcGIS 25361 - [AppStudio@11205 category="qml" function="closePage" filename="Page.qml" line="186"] qml: backPage undefined
<15>1 2019-01-18T06:36:22Z localhost Survey123forArcGIS 25361 - [AppStudio@11205 category="qml" function="update" filename="FilteredListModel.qml" line="62"] qml: Empty filterText
<15>1 2019-01-18T06:36:24Z localhost Survey123forArcGIS 25361 - [AppStudio@11205 category="qml" function="editSubmitError" filename="SurveysListPage.qml" line="622"] qml: error: {
"code": 1000,
"description": "Implicit conversion from data type nvarchar to varbinary is not allowed. Use the CONVERT function to run this query.",
"tableId": 0
}

Kindly, did you sort out this issue and how?

Re: How do I correct completed survey form sending error in survey123

JamesTedrick — Fri, 18 Jan 2019 16:35:57 GMT

Hi Steve,

To understand what's going on, more information on the survey and feature service/table is needed. Is this form using an existing feature service/database table or one created by Survey123? Did you make any modifications from initial publishing of the form?

Re: How do I correct completed survey form sending error in survey123

SteveOchieng — Mon, 21 Jan 2019 06:06:08 GMT

Hi @James, so the featureService was one created by Survey123 in ArcGIS Online. I did my checks and found that we used esriGeoPointZ for the latitude in the xlsform, but in the feature service the datatype to altitude was registered as unknown, I changed the esriGeopintZ to Double and it worked fine. I;m still not sure why this was so.

Re: How do I correct completed survey form sending error in survey123

NDA-GISGhana — Mon, 21 Jan 2019 06:10:59 GMT

Thank you Steve. I am highly grateful

Re: How do I correct completed survey form sending error in survey123

RickyJones — Fri, 28 Feb 2020 23:19:12 GMT

I had the exact same problem as described in the original post, and changing my elevation field from esriFieldTypePointZ to esriFieldTypeDouble did the trick. Thanks Steve!