[Qgis-user] error running processing algorithm in Python action

[McDonaldR]

Hi List

I have a Python action that executes some SQL on selected features.  It works perfectly in my QGIS project.  If someone else opens the QGIS project they get an error from the action.  We both have the same connection to the database with the same name and with the same permissions on the tables.

Error on line 12 of script:
Traceback (most recent call last):
  File "", line 12, in
  File "C:/PROGRA~1/QGIS3~1.4/apps/qgis-ltr/./python/plugins\processing\tools\general.py", line 105, in run
    return Processing.runAlgorithm(algOrName, parameters, onFinish, feedback, context)
  File "C:/PROGRA~1/QGIS3~1.4/apps/qgis-ltr/./python/plugins\processing\core\Processing.py", line 183, in runAlgorithm
    raise QgsProcessingException(msg)
_core.QgsProcessingException: There were errors executing the algorithm.
Python version:
3.7.0 (v3.7.0:1bf9cc5093, Jun 27 2018, 04:59:51) [MSC v.1914 64 bit (AMD64)]

QGIS version:
3.4.5-Madeira 'Madeira', 89ee6f6e23

Python script. Line 12 is the processing.run() :

from qgis.PyQt import QtWidgets
from qgis.core import Qgis
from qgis.utils import iface
import processing

layer = QgsProject.instance().mapLayer('boq_locations_d3e2b1bd_e1fc_4ca8_83f2_e0bb738d2146')
if layer.selectedFeatureCount():
    ids = layer.selectedFeatureIds()
    for id in ids:
        sql_query = "TRUNCATE parks.boc_task_to_add;"
        print(sql_query)
        processing.run("qgis:postgisexecutesql", {'DATABASE':editor at postgiswork', 'SQL':sql_query})
        sql_query = "INSERT INTO parks.boc_task_to_add (task_no, task_desc, task_unit, task_freq) SELECT t.task_no::numeric, t.task_desc, t.task_unit, t.task_freq FROM parks.boc_tasks t, parks.boq_locations s WHERE t.task_ref = s.task_ref AND s.gid = " + str(id)
        print(sql_query)
        processing.run("qgis:postgisexecutesql", {'DATABASE':'editor @postgiswork', 'SQL':sql_query})
        iface.messageBar().pushMessage("Done!", "Copied tasks for feature: " + str(id), level=Qgis.Info, duration=1)
else:
    iface.messageBar().pushMessage("Hey!", " Please select a polygon to copy tasks from first.", level=Qgis.Warning, duration=5)

Any idea why the action will work on my machine but not on someone else's QGIS?  The only difference between machines is QGIS versions 3.4.4, 3.4.5 and 3.4.12.

Thanks

Ross



Ross McDonald | Geo-evangelist | Angus Council, Digital Enablement and IT | Angus House, Orchardbank Business Park, Sylvie Way, Forfar DD8 1AT | t: 01307 49 22 39


This message is strictly confidential. If you have received this in error, please inform the sender and remove it from your system. If received in error you may not copy, print, forward or use it or any attachment in any way. This message is not capable of creating a legal contract or a binding representation and does not represent the views of Angus Council. Emails may be monitored for security and network management reasons. Messages containing inappropriate content may be intercepted. Angus Council does not accept any liability for any harm that may be caused to the recipient system or data on it by this message or any attachment.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20191101/bd3031c1/attachment.html>