Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Processing toolbox does not handle array fields #29601

Closed
qgib opened this issue Apr 8, 2019 · 12 comments
Closed

Processing toolbox does not handle array fields #29601

qgib opened this issue Apr 8, 2019 · 12 comments
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Feedback Waiting on the submitter for answers Processing Relating to QGIS Processing framework or individual Processing algorithms stale Uh oh! Seems this work is abandoned, and the PR is about to close.

Comments

@qgib
Copy link
Contributor

qgib commented Apr 8, 2019 •
edited
Loading

Author Name: Cory Albrecht (@CoryAlbrecht)
Original Redmine Issue: 21786
Affected QGIS version: 3.6.1
Redmine category:processing/core

So I just did "fix geometries" on my PostGiS layer that has array fields, when I deleted the shapes from it and copied the new features back. When I went to save that layer, nothing would save. All I got was simple message log error line saying that arrays had to start with {, and no PostGIS errors.

My PostGIS layer has several fields that are arrays, so I did not know which one it was referring to. Eventually I realised that the fix geometries tool had converted all array fields to simple string fields, so a PostGIS array like '{en,"Kingdom of Bavaria"}' became the literal string "{en, "Kingdom of Bavaria"}". When the shapes were copied back to the PostGIS layer, QGIS was still seeing them as strings, not as arrays, and apparently converting them improperly when trying to create the SQL to update the PostGIS layer. I assume the problem was with creating SQL because there were no PostGIS errors, just the ambiguous error about needing the { for an array.

Based on other bugs I have filed having to do with how QGIS handles array fields, it seems to me that whatever redesign of the internals of how a layer and it's attributes are stored in memory, that redesign seems to be faulty at the core as it communicates wrong information to the higher level functions that do things like run the processing tools, like displaying the feature attributes form (arrays are converted to strings, but truncated, #28691), like when trying to update PostGIS layers (nulls getting passed as empty strings, #29277), and now this.
@qgib
Copy link
Contributor Author

qgib commented Apr 8, 2019

Author Name: Giovanni Manghi (@gioman)

Is this a problem of the specific tool in the subject, or a general one of any tool in the Processing toolbox?

  • status_id was changed from Open to Feedback

@qgib
Copy link
Contributor Author

qgib commented Apr 10, 2019

Author Name: Cory Albrecht (@CoryAlbrecht)

Giovanni Manghi wrote:

Is this a problem of the specific tool in the subject, or a general one of any tool in the Processing toolbox?

The specific tool in the subject.

@qgib
Copy link
Contributor Author

qgib commented Apr 10, 2019

Author Name: Giovanni Manghi (@gioman)

  • crashes_corrupts_data was changed from 1 to 0
  • priority_id was changed from High to Normal
  • status_id was changed from Feedback to Open
  • subject was changed from Processing toolbox fix geometries does not handle array fields to Processing toolbox "fix geometries" does not handle array fields

@qgib qgib added Bug Either a bug report, or a bug fix. Let's hope for the latter! Processing Relating to QGIS Processing framework or individual Processing algorithms labels May 25, 2019
@CoryAlbrecht
Copy link

This still happens. As a result, there is nothing in the created layer for the fixed geometries.

I just tried the Check validity tool, and it has a similar problem where it does not add any features to the valid and invalid layers it creates, but it creates the errors points layer that shows where the invalidities are.

Array data has been a persistent problem since the switch from 2.x to 3.x.

@CoryAlbrecht
Copy link 

QGIS version: 3.17.0-Master
QGIS code revision: 5deda1f456
Qt version: 5.12.8
GDAL version: 3.0.4
GEOS version: 3.8.0-CAPI-1.13.1 
PROJ version: Rel. 6.3.1, February 10th, 2020
PDAL version: 2.0.1 (git-version: Release)
Processing algorithm…
Algorithm 'Check validity' starting…
Input parameters:
{ 'ERROR_OUTPUT' : 'TEMPORARY_OUTPUT', 'IGNORE_RING_SELF_INTERSECTION' : False, 'INPUT_LAYER' : 'postgres://dbname=\'Alternate History\' host=pg1.db.cory.albrecht.name port=5432 sslmode=require authcfg=3sn22ks key=\'feature_uuid\' srid=4326 type=MultiPolygon checkPrimaryKeyUnicity=\'1\' table=\"Balance of Power\".\"timeline_level1\" (geom)', 'INVALID_OUTPUT' : 'TEMPORARY_OUTPUT', 'METHOD' : 2, 'VALID_OUTPUT' : 'TEMPORARY_OUTPUT' }

Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "alternate_name": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "info_url": Could not convert value "" to target type
Feature could not be written to Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255: Could not store attribute "full_name": Could not convert value "" to target type
Execution completed in 2.17 seconds
Results:
{'ERROR_COUNT': 0,
'ERROR_OUTPUT': 'Error_output_5fb4612d_5c60_4fc3_96e2_6f099661e65a',
'INVALID_COUNT': 0,
'INVALID_OUTPUT': 'Invalid_output_e59d0bfe_645c_41b6_94c1_2b5975ebc5cc',
'VALID_COUNT': 29,
'VALID_OUTPUT': 'Valid_output_7836038e_77f5_4bf4_b8c7_900a07e88255'}

Loading resulting layers
Algorithm 'Check validity' finished

@gioman
Copy link
Contributor

gioman commented Dec 28, 2020

Array data has been a persistent problem since the switch from 2.x to 3.x.

@CoryAlbrecht does not seems to be a issue of just the "fix geometries" tool, but rather a general one, correct?

@FelisPimeja
Copy link
Contributor

FelisPimeja commented Dec 28, 2020 •
edited
Loading

Array data has been a persistent problem since the switch from 2.x to 3.x.

@CoryAlbrecht does not seems to be a issue of just the "fix geometries" tool, but rather a general one, correct?

@gioman , Correct. That's a general one.

@gioman gioman changed the title Processing toolbox "fix geometries" does not handle array fields Processing toolbox does not handle array fields Dec 28, 2020
@CoryAlbrecht CoryAlbrecht mentioned this issue Jan 2, 2021
Closed
@CoryAlbrecht
Copy link

@gioman

Are these upstream tools, or are they part of QGIS's code? A lot of the validation tools are unusable for me because they cannot handle array fields. For example, when using tools like Menu→Vector→Geometry Tools→Check Validity…, The valid and invalid layers don't get filled because of array fields causing errors. Occasionally I'll get some features in the valid layer, but never any ion the invalid layer even when errors records do get placed in that memory layer.

At the very least, could array fields simply be passed as string values using some format, like the PostgreSQL one of { a, b, c… } for example, so that the processing tools work properly?

QGIS version: 3.21.0-Master
QGIS code revision: 5faa2fedf1
Qt version: 5.12.8
Python version: 3.8.10
GDAL version: 3.0.4
GEOS version: 3.8.0-CAPI-1.13.1 
PROJ version: Rel. 6.3.1, February 10th, 2020
Processing algorithm…
Algorithm 'Check validity' starting…
Input parameters:
{ 'ERROR_OUTPUT' : 'TEMPORARY_OUTPUT', 'IGNORE_RING_SELF_INTERSECTION' : False, 'INPUT_LAYER' : 'postgres://dbname=\'Alternate History\' host=pg1.db.cory.albrecht.name port=5432 sslmode=require authcfg=c866l6b key=\'feature_uuid\' srid=4326 type=MultiPolygon checkPrimaryKeyUnicity=\'1\' table=\"Balance of Power\".\"timeline_level1\" (geom)', 'INVALID_OUTPUT' : 'TEMPORARY_OUTPUT', 'METHOD' : 2, 'VALID_OUTPUT' : 'TEMPORARY_OUTPUT' }

Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Feature could not be written to Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94: Could not store attribute "full_name": Could not convert value "" to target type
Execution completed in 1.63 seconds
Results:
{'ERROR_COUNT': 0,
'ERROR_OUTPUT': 'Error_output_8ca04644_b2a8_4a69_bc8c_70f0cbfe6978',
'INVALID_COUNT': 0,
'INVALID_OUTPUT': 'Invalid_output_30e556a8_f15e_476a_9e08_19983845cbad',
'VALID_COUNT': 145,
'VALID_OUTPUT': 'Valid_output_62d46484_1d6b_4625_bf3f_00fdb8d2ce94'}

Loading resulting layers
Algorithm 'Check validity' finished

It makes it very difficult for me to clean up any issues with bad geometries on my part when trying to make the trasinc tool work. #29531

@nyalldawson
Copy link
Collaborator

Can you share a small postgis sql dump which can be used to reproduce this issue?

@nyalldawson nyalldawson added the Feedback Waiting on the submitter for answers label Sep 12, 2021
@aourednik
Copy link

I encounter this issue also. "Fix geometries" from Processing Toolboc generates errors when a file contains an array field. Error reporterd: Could not convert value "" to target type
Result: only features with NULL values in an array field are kept.

@github-actions
Copy link

github-actions bot commented Oct 8, 2021

The QGIS project highly values your report and would love to see it addressed. However, this issue has been left in feedback mode for the last 14 days and is being automatically marked as "stale".
If you would like to continue with this issue, please provide any missing information or answer any open questions. If you could resolve the issue yourself meanwhile, please leave a note for future readers with the same problem and close the issue.
In case you should have any uncertainty, please leave a comment and we will be happy to help you proceed with this issue.
If there is no further activity on this issue, it will be closed in a week.

@github-actions github-actions bot added the stale Uh oh! Seems this work is abandoned, and the PR is about to close. label Oct 8, 2021
@github-actions
Copy link

github-actions bot commented Nov 5, 2021

While we hate to see this happen, this issue has been automatically closed because it has not had any activity in the last 42 days despite being marked as feedback. If this issue should be reconsidered, please follow the guidelines in the previous comment and reopen this issue.
Or, if you have any further questions, there are also further support channels that can help you.

@github-actions github-actions bot closed this as completed Nov 5, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
Bug Either a bug report, or a bug fix. Let's hope for the latter! Feedback Waiting on the submitter for answers Processing Relating to QGIS Processing framework or individual Processing algorithms stale Uh oh! Seems this work is abandoned, and the PR is about to close.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
6 participants
@FelisPimeja @nyalldawson @gioman @aourednik @CoryAlbrecht @qgib