How do I correct completed survey form sending error in survey123

[NDA-GISGhana]

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.

[JohnathanHasthorpe]

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

[NDA-GISGhana]

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

Thank you.

[JohnathanHasthorpe]

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

[SteveOchieng]

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?

[JamesTedrick]

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?

[SteveOchieng]

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.

[NDA-GISGhana]

Thank you Steve. I am highly grateful

[RickyJones]

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!