nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I correct completed survey form sending error in survey123

sualesulemana

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.

Survey123 Sending Error2.jpg

model1A.JPG

Najděte více příspěvků označených jako

Accepted answers

All comments

JohnHasthorpe

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

sualesulemana

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

Thank you.

JohnHasthorpe

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.

sualesulemana

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!

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.