topic Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP' error in ArcGIS Survey123 Questions

Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP' error

GaryBowles1 — Wed, 04 Nov 2020 16:15:36 GMT

I have a survey that is embedded in an ops dashboard. The field user fills out the first half of the survey using the field app and then the project manager fills out the second half of the survey from ops dashboard. This has been working great for the past 3 months. Today however, when a user attempts to "approve" the survey in ops dashboard, we are receiving the following error:

Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP'

Is there something in the 3.11 update that may have caused this? Nothing on our end has changed.

Thanks,

--gary

Re: Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP' error

GaryBowles1 — Wed, 04 Nov 2020 16:20:05 GMT

Forgot to include this nugget in my original question. If I go into the inbox in Survey123, I can fill out the second half of a previously submitted survey and successfully submit.

--gary

Re: Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP' error

JamesTedrick — Wed, 04 Nov 2020 18:55:50 GMT

Hi Gary,

Based on the description, your second half operation is using the web form, correct? Can you provide details on the configuration of the form - what version was it published with, is version locking still on?

You are using ArcGIS Enterprise, correct? Which version? The error message looks to be one created by the feature service on submittal - can you check the ApplyEdits request being generated by the web form?

Re: Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP' error

GaryBowles1 — Wed, 04 Nov 2020 21:06:33 GMT

Second half is using webform from a dashboard.

Form was originally published using Connect 3.9.? It has been updated using Connect 3.10.?

Enterprise 10.7.1

Apply Edits

Thanks,

--gary

Re: Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP' error

GaryBowles1 — Wed, 04 Nov 2020 21:29:07 GMT

Hey James,

I upgraded Connect to 3.11, republished the survey and am now getting this error and cannot get the survey to load in ops dashboard:

Thanks,

--gary

Re: Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP' error

JamesTedrick — Thu, 05 Nov 2020 18:23:50 GMT

Hi Gary,

Is that when opening the form directly in a web page?

I'd suggest opening a formal support ticket - it appears there are potentially a couple of different issue occurring.

Re: Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP' error

GaryBowles1 — Thu, 05 Nov 2020 20:52:03 GMT

That was from an ops dashboard in chrome. I will open a ticket with support.

Thanks,

--gary

Re: Cannot convert a value of type 'java.lang.String' to 'TIMESTAMP' error

GaryBowles1 — Tue, 01 Dec 2020 18:47:02 GMT

James,

When embedding the survey and setting it to be edited in the dashboard, (as per

https://community.esri.com/t5/arcgis-survey123-blog/survey123-tricks-of-the-trade-embedding-a-survey-in-an-arcgis/ba-p/899140)

the following is added to the URL: &mode=edit&globalId={globalid}

If i remove this from the URL, the survey displays in the dashboard but it is not editable.

Any ideas?

Thanks,

--gary