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.
Hi - are you able to share your survey? Additionally, are you using Portal for ArcGIS (if so which version) or ArcGIS Online. Thanks
Yes please. I have been able to share my survey. I am using ArcGIS Online.
Thank you.
Can you add the survey xls as an attachment to this thread? Thanks
I have a similar issue and here is a snippet of the logs
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?
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.
Thank you Steve. I am highly grateful
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!