topic Error when sending data in ArcGIS QuickCapture Questions

Error when sending data

GISKoordinator_LK-SPN — Thu, 22 Jun 2023 08:25:38 GMT

Hello,

it happens from time to time that data from the QuickCapture can not be sent. In QuickCapture, polylines are recorded and sent after confirmation. Lately, the sending is not possible and we get the following error: "{"code":1000, "description": "String or binary data would be truncated.\r\nThe statement has been terminated."}"

And how to save or restore the data contained in it?

What can this be due to.

Attached is the qcr file.

Re: Error when sending data

GISKoordinator_LK-SPN — Thu, 22 Jun 2023 12:41:28 GMT

OK, I found a way to save at least the data.

rename the qcr file as zip and unzip it, then copy from the SQlite database the table "main.Features" from the column "Feature" the json and extend it with {"features":[ at the start and ]} at the end .... for testing you can use https://arcgisjson.togeojson.com/
and export a geojson right away, because the Attribute are unfortunately not taken over in the standard processing.

and here you can see the possible error.
the user has for whatever reason not entered anything at the ${userInput:002} as well as ${userInput:004}, although this is mandatory and so of course this text could not be stored in a numeric field.

greetings

Re: Error when sending data

JohnathanHasthorpe — Fri, 23 Jun 2023 03:47:51 GMT

For some reason the app is not writing the user input value to the feature.

- Did the device crash, was the project closed, or, was the line ended by the user using the project button?

- Was this a project or button user input?

- What QuickCaptue app version and operating system are you using?

- Could you share the project and target layer with the QCCreator user (via a group). We can see if we can repro.

Thanks

John

Re: Error when sending data

GISKoordinator_LK-SPN — Fri, 23 Jun 2023 06:51:50 GMT

- Did the device crash, was the project closed, or, was the line ended by the user using the project button?

no,but the project entries were not visible or not selectable

- Was this a project or button user input?

project user input

- What QuickCaptue app version and operating system are you using?

android latest version 1.17.47

- Could you share the project and target layer with the QCCreator user (via a group). We can see if we can repro.

sure

thx

Re: Error when sending data

JohnathanHasthorpe — Wed, 28 Jun 2023 23:44:08 GMT

Hi - were you able to share the project with QCCreator? I have not seen an invite to the group.

This sounds like an issue with the project JSON, I'd like to take a look.

Thanks

John

Re: Error when sending data

GISKoordinator_LK-SPN — Thu, 29 Jun 2023 06:06:21 GMT

hi - how can i invite you to the group?

i can also post the json?

thanks

Re: Error when sending data

JohnathanHasthorpe — Thu, 29 Jun 2023 23:27:22 GMT

To share the project, create a group and share the project and layers with it. Then invite the user QCCreator to the group. I'll get an invite.

But the JSON would help too, if you want to share this first.

Thanks

John

Re: Error when sending data

GISKoordinator_LK-SPN — Fri, 30 Jun 2023 05:59:32 GMT

hi,

i have add the project json and hope it helps.

thx

Re: Error when sending data

JohnathanHasthorpe — Mon, 03 Jul 2023 09:42:58 GMT

Can you confirm the field types of truppzah and abstand?

Re: Error when sending data

GISKoordinator_LK-SPN — Mon, 03 Jul 2023 10:35:29 GMT

Hello,

the field types are string.

Re: Error when sending data

JohnathanHasthorpe — Wed, 19 Jul 2023 04:17:19 GMT

Hi - Everything looks good in relation to what you have shared. Couls we get on a call to discuss?

Please email QuickCapture@esri.com and I'll send through an invite.

Many thanks

John