I'm trying to sort a shapefile by one of its attributes using "Execute SQL", in the QGIS Graphical Modeler.

Using a vector as input is working fine, but when I use a layer generated by an algorithm I have this error message : "virtual: Cannot find layer OUTPUT_shp20180419141642572".

Can someone help me with this ?

To sum-up : here is my problem

  • 1
    As per the help center it is OK to try and reproduce software problems in a Q&A here, but if you think this is a bug then be sure to submit it to the QGIS development team. Please post a link to the bug report here.
    – underdark
    Commented Apr 19, 2018 at 20:28
  • 1
    @underdark here is the ticket: issues.qgis.org/issues/16129#change-95647 It is set as fixed, but the problem still exist in QGIS 3.4.1 and the nightly build version
    – PieterB
    Commented Nov 26, 2018 at 13:16
  • 1
    What if you change "input1" in your SQL to the id of the Mean algorithm? So I mean, maybe you should not use the same SQL codes.
    – pnz1337
    Commented Dec 2, 2018 at 23:13
  • @pnz it's a bug in the algorithm. See the ticket mensioned above
    – PieterB
    Commented Dec 5, 2018 at 14:33

1 Answer 1


This is a known issue: Bug report #16129 Processing : execute sql alg does not work with input2 ... inputN parameters

  • Is there a substitute tool that works in Graphical modeller?
    – Selma
    Commented Sep 28, 2023 at 6:45

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.