I have a shape file layer that won't load into the SpatiaLite database and it gives Error 7. It also won't run functions that work in other layers and works fine without the @parent or if I remove the filter.

> aggregate ( 'Mainland_Address_079da3c1_0048_4cf5_ba0d_e89a4d130688',
>              'concatenate', 
>              to_string("CIVICNUM"),
>              filter:=intersects( $geometry, geometry(@parent) ) , 
>              concatenator:=' ,')

I can't figure out what is wrong with it. Unfortunately I can't share it because it has sensitive information. But I can share the Information and Source Fields. My project is using EPSG:4326. What is the issue with the layer? Information Source Fields

Edit: Error 7 Picture

Error 7

Edit: Table picture


  • Is there more information provided in the error message, or does it only say "error 7"? Have you tried to look up what "error 7" means? Please edit this information into your question.
    – csk
    Apr 22, 2019 at 17:40
  • I've looked into Error 7 and found a few items that were 2 years old but didn't seem related anymore as the issues were fixed. I also noticed it created a table for the level but there isn't any informative. It is just a blank table. See next picture attached.
    – Andrew
    Apr 22, 2019 at 19:42


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Browse other questions tagged or ask your own question.