Select to view content in your preferred language

Error when sending data

1255
10
06-22-2023 01:25 AM
Labels (1)
GIS-KoordinatorLandkreis_Spree
New Contributor III

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.

0 Kudos
10 Replies
GIS-KoordinatorLandkreis_Spree
New Contributor III

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.

 

Error_QuickCapture.jpg

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

0 Kudos
JohnathanHasthorpe
Esri Regular Contributor

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

 

 

 

0 Kudos
GIS-KoordinatorLandkreis_Spree
New Contributor III

- 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

 

0 Kudos
JohnathanHasthorpe
Esri Regular Contributor

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

0 Kudos
GIS-KoordinatorLandkreis_Spree
New Contributor III

hi - how can i invite you to the group?

i can also post the json?

thanks

0 Kudos
JohnathanHasthorpe
Esri Regular Contributor

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

0 Kudos
GIS-KoordinatorLandkreis_Spree
New Contributor III

hi,

i have add the project json and hope it helps.

thx

0 Kudos
JohnathanHasthorpe
Esri Regular Contributor

Can you confirm the field types of truppzah and abstand?

0 Kudos
GIS-KoordinatorLandkreis_Spree
New Contributor III

Hello,

 

 the field types are string.

0 Kudos